APPS.FND_PROGRAM dependencies on FND_REQUEST_SETS

Line 1465: set_id fnd_request_sets.request_set_id%TYPE;

1461: program_application_id fnd_application.application_id%TYPE;
1462: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1463: desc_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
1464: rs_flag fnd_concurrent_programs.request_set_flag%TYPE;
1465: set_id fnd_request_sets.request_set_id%TYPE;
1466: prog_appl_short_name fnd_application.application_short_name%TYPE;
1467:
1468: cursor req_cursor(appl_id number, prog_id number) is
1469: select request_id

Line 1506: FROM fnd_request_sets

1502: BEGIN
1503:
1504: SELECT request_set_id
1505: INTO set_id
1506: FROM fnd_request_sets
1507: WHERE application_id = program_application_id
1508: AND concurrent_program_id = program_id;
1509:
1510: -- Remove set from request groups

Line 1531: DELETE FROM fnd_request_sets_tl

1527: AND request_set_id = set_id;
1528:
1529: -- Remove the set
1530:
1531: DELETE FROM fnd_request_sets_tl
1532: WHERE application_id = program_application_id
1533: AND REQUEST_SET_ID = set_id;
1534:
1535: DELETE FROM fnd_request_sets

Line 1535: DELETE FROM fnd_request_sets

1531: DELETE FROM fnd_request_sets_tl
1532: WHERE application_id = program_application_id
1533: AND REQUEST_SET_ID = set_id;
1534:
1535: DELETE FROM fnd_request_sets
1536: WHERE application_id = program_application_id
1537: AND request_set_id = set_id;
1538:
1539: exception