1. result := FND_REQUEST.SET_MODE(TRUE); ( Require from DB trigger )

2. result := FND_REQUEST.SET_OPTIONS('NO'); (Optional)

3. result := FND_REQUEST.SET_PRINT_OPTIONS('printer_name',null,no_copies,TRUE,'N'); (optional)

4. FND_PROFILE.PUT('RESP_ID',v_resp_id); ( Required)

5. FND_PROFILE.PUT('RESP_APPL_ID',v_appl_id); (Required)

6. FND_PROFILE.PUT('USER_ID,user_id) ; ( Required)

7. FND_REQUEST.SUBMIT_REQUEST ('Appl_name'......); ( Required)

Query only GUI Forms

To make a form query only register do the following :
- Register the form.
- Register the form function and set the parameter QUERY_ONLY="YES".
- Add that form function to a custom menu.
- Associate the custom menu to a custom responsibility.

Return to : Oracle Database, SQL, Application, Programming Tips