APPS.FND_PROGRAM dependencies on FND_REQUEST_SETS

Line 1462: set_id fnd_request_sets.request_set_id%TYPE;

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

Line 1503: FROM fnd_request_sets

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

Line 1528: DELETE FROM fnd_request_sets_tl

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

Line 1532: DELETE FROM fnd_request_sets

1528: DELETE FROM fnd_request_sets_tl
1529: WHERE application_id = program_application_id
1530: AND REQUEST_SET_ID = set_id;
1531:
1532: DELETE FROM fnd_request_sets
1533: WHERE application_id = program_application_id
1534: AND request_set_id = set_id;
1535:
1536: exception