APPS.FND_SET dependencies on FND_REQUEST_SET_PROGRAMS

Line 1183: insert into fnd_request_set_programs

1179: concurrent_program_id_f(program_appl_id, program);
1180: set_id := request_set_id_f(set_appl_id, request_set);
1181: stage_id := request_set_stage_id_f(set_appl_id, set_id, stage);
1182:
1183: insert into fnd_request_set_programs
1184: (set_application_id, request_set_id, request_set_program_id,
1185: request_set_stage_id,
1186: sequence, last_update_date, last_updated_by,
1187: creation_date, created_by, last_update_login,

Line 1192: (set_appl_id, set_id, fnd_request_set_programs_s.nextval,

1188: program_application_id, concurrent_program_id,
1189: number_of_copies, save_output_flag,
1190: printer, print_style, critical)
1191: values
1192: (set_appl_id, set_id, fnd_request_set_programs_s.nextval,
1193: stage_id,
1194: program_sequence, last_update_date, last_updated_by,
1195: creation_date, created_by, last_update_login,
1196: program_appl_id, program_id,

Line 1242: from fnd_request_set_programs p

1238: delete from fnd_request_set_program_args
1239: where (application_id, request_set_id, request_set_program_id) in
1240: (select p.set_application_id, p.request_set_id,
1241: p.request_set_program_id
1242: from fnd_request_set_programs p
1243: where p.set_application_id = set_appl_id
1244: and p.request_set_id = set_id
1245: and p.request_set_stage_id = stage_id);
1246:

Line 1248: delete from fnd_request_set_programs

1244: and p.request_set_id = set_id
1245: and p.request_set_stage_id = stage_id);
1246:
1247: -- Delete member programs
1248: delete from fnd_request_set_programs
1249: where set_application_id = set_appl_id
1250: and request_set_id = set_id
1251: and request_set_stage_id = stage_id;
1252:

Line 1360: from fnd_request_set_programs p

1356: delete from fnd_request_set_program_args
1357: where (application_id, request_set_id, request_set_program_id) in
1358: (select p.set_application_id, p.request_set_id,
1359: p.request_set_program_id
1360: from fnd_request_set_programs p
1361: where p.set_application_id = set_appl_id
1362: and p.request_set_id = set_id
1363: and p.program_application_id = program_appl_id
1364: and p.concurrent_program_id = program_id

Line 1368: delete from fnd_request_set_programs

1364: and p.concurrent_program_id = program_id
1365: and p.request_set_stage_id = stage_id
1366: and p.sequence = program_sequence);
1367:
1368: delete from fnd_request_set_programs
1369: where set_application_id = set_appl_id
1370: and request_set_id = set_id
1371: and program_application_id = program_appl_id
1372: and concurrent_program_id = program_id

Line 1431: set_program_id fnd_request_set_programs.request_set_program_id%TYPE;

1427: set_id fnd_request_sets.request_set_id%TYPE;
1428: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1429: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1430: default_type_code fnd_request_set_program_args.default_type%TYPE;
1431: set_program_id fnd_request_set_programs.request_set_program_id%TYPE;
1432: appl_column_name
1433: fnd_descr_flex_column_usages.application_column_name%TYPE;
1434:
1435: BEGIN

Line 1461: from fnd_request_set_programs

1457:
1458: BEGIN
1459: select request_set_program_id
1460: into set_program_id
1461: from fnd_request_set_programs
1462: where request_set_id = set_id
1463: and set_application_id = set_appl_id
1464: and concurrent_program_id = program_id
1465: and program_application_id = program_appl_id

Line 1716: from fnd_request_set_programs s,

1712:
1713: BEGIN
1714: select request_set_program_id
1715: into set_program_id
1716: from fnd_request_set_programs s,
1717: fnd_concurrent_programs p
1718: where p.concurrent_program_name = program
1719: and p.application_id = program_appl_id
1720: and p.concurrent_program_id = s.concurrent_program_id

Line 1833: DELETE FROM fnd_request_set_programs

1829: AND request_set_id = set_id;
1830:
1831: -- Remove member programs
1832:
1833: DELETE FROM fnd_request_set_programs
1834: WHERE set_application_id = set_appl_id
1835: AND request_set_id = set_id;
1836:
1837: -- Delete stage master programs (if any)

Line 2207: from fnd_request_set_programs

2203: stage_id := request_set_stage_id_f(set_appl_id, set_id, stage);
2204:
2205: select 'y'
2206: into dummy
2207: from fnd_request_set_programs
2208: where set_application_id = set_appl_id
2209: and request_set_id = set_id
2210: and request_set_stage_id = stage_id
2211: and program_application_id = program_appl_id

Line 2266: from fnd_request_set_programs s,

2262: stage_id := request_set_stage_id_f(set_appl_id, set_id, stage);
2263:
2264: select request_set_program_id
2265: into set_program_id
2266: from fnd_request_set_programs s,
2267: fnd_concurrent_programs p
2268: where p.concurrent_program_name = program
2269: and p.application_id = program_appl_id
2270: and p.concurrent_program_id = s.concurrent_program_id

Line 3021: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs

3017: WHERE request_set_id = rset_id AND set_application_id = appl_id;
3018: IF( tmpDate > rset_last_updated_date) THEN
3019: rset_last_updated_date := tmpDate;
3020: END IF;
3021: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs
3022: WHERE request_set_id = rset_id AND set_application_id = appl_id;
3023: IF( tmpDate > rset_last_updated_date) THEN
3024: rset_last_updated_date := tmpDate;
3025: END IF;

Line 3048: SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id

3044: and error_stage_id = to_number(fcr2.argument3)
3045: and r.request_set_program_id IS NOT NULL
3046: AND r.request_set_program_id NOT IN
3047: (
3048: SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id
3049: AND REQUEST_SET_ID = rset_id AND REQUEST_SET_STAGE_ID = error_stage_id
3050: );
3051: if( tmp_number <> 0)then
3052: return false ;