APPS.FND_SET dependencies on FND_REQUEST_SET_PROGRAM_ARGS

Line 1238: delete from fnd_request_set_program_args

1234: set_id := request_set_id_f(set_appl_id, request_set);
1235: stage_id := request_set_stage_id_f(set_appl_id, set_id, stage);
1236:
1237: -- Delete program args
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

Line 1356: delete from fnd_request_set_program_args

1352: concurrent_program_id_f(program_appl_id, program);
1353: set_id := request_set_id_f(set_appl_id, request_set);
1354: stage_id := request_set_stage_id_f(set_appl_id, set_id, stage);
1355:
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

Line 1430: default_type_code fnd_request_set_program_args.default_type%TYPE;

1426: program_appl_id fnd_application.application_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:

Line 1516: insert into fnd_request_set_program_args

1512: message('default type required when default value specified');
1513: raise bad_parameter;
1514: end if;
1515:
1516: insert into fnd_request_set_program_args
1517: (application_id, request_set_id, request_set_program_id,
1518: descriptive_flex_appl_id, descriptive_flexfield_name,
1519: application_column_name, last_update_date, last_updated_by,
1520: creation_date, created_by, last_update_login, display_flag,

Line 1696: fnd_request_set_program_args.request_set_program_id%TYPE;

1692: fnd_application.application_id%TYPE;
1693: set_appl_id
1694: fnd_application.application_id%TYPE;
1695: set_program_id
1696: fnd_request_set_program_args.request_set_program_id%TYPE;
1697: BEGIN
1698: message_init;
1699:
1700: check_notnull(program);

Line 1734: delete from fnd_request_set_program_args a

1730: to_char(program_sequence));
1731: RAISE bad_parameter;
1732: END;
1733:
1734: delete from fnd_request_set_program_args a
1735: where a.application_id = set_appl_id
1736: and a.request_set_id = set_id
1737: and a.request_set_program_id = set_program_id
1738: and (a.descriptive_flex_appl_id,

Line 1827: DELETE FROM fnd_request_set_program_args

1823: AND unit_application_id = set_appl_id;
1824:
1825: -- Remove member program arguments
1826:
1827: DELETE FROM fnd_request_set_program_args
1828: WHERE application_id = set_appl_id
1829: AND request_set_id = set_id;
1830:
1831: -- Remove member programs

Line 2252: set_program_id fnd_request_set_program_args.request_set_program_id%TYPE;

2248: set_id fnd_request_sets.request_set_id%TYPE;
2249: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
2250: program_appl_id fnd_application.application_id%TYPE;
2251: set_appl_id fnd_application.application_id%TYPE;
2252: set_program_id fnd_request_set_program_args.request_set_program_id%TYPE;
2253: dummy varchar2(1);
2254:
2255: BEGIN
2256: message_init;

Line 2279: from fnd_request_set_program_args a

2275: and s.sequence = program_sequence;
2276:
2277: select 'y'
2278: into dummy
2279: from fnd_request_set_program_args a
2280: where a.application_id = set_appl_id
2281: and a.request_set_id = set_id
2282: and a.request_set_program_id = set_program_id
2283: and (a.descriptive_flex_appl_id,