eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SET dependencies on FND_REQUEST_SET_STAGES

Line 235: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

231: stage number */
232: FUNCTION request_set_stage_id_f(set_appl_id number,
233: set_id varchar2,
234: stage varchar2) return number is
235: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
236: BEGIN
237: SELECT request_set_stage_id
238: INTO stage_id
239: FROM fnd_request_set_stages

Line 239: FROM fnd_request_set_stages

235: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
236: BEGIN
237: SELECT request_set_stage_id
238: INTO stage_id
239: FROM fnd_request_set_stages
240: WHERE set_application_id = set_appl_id
241: AND request_set_id = set_id
242: AND stage = stage_name;
243:

Line 501: from fnd_request_set_stages

497: /* Get a concurrent program ID from the source set/stage */
498: if (stage_id is not null) then /* source is STAGE */
499: select concurrent_program_id
500: into prog_id
501: from fnd_request_set_stages
502: where set_application_id = set_appl_id
503: and request_set_id = set_id
504: and request_set_stage_id = stage_id;
505:

Line 897: stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;

893: := created_by_f;
894: set_appl_id fnd_application.application_id%TYPE;
895: set_id fnd_request_sets.request_set_id%TYPE;
896: print_style_name fnd_printer_styles.printer_style_name%TYPE;
897: stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
898: dummy varchar2(1);
899: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
900: outcome_meaning varchar2(1);
901: function_id number := null;

Line 936: select fnd_request_set_stages_s.nextval

932:
933: set_appl_id := application_id_f(set_application);
934: set_id := request_set_id_f(set_appl_id, request_set);
935:
936: select fnd_request_set_stages_s.nextval
937: into stage_id
938: from sys.dual;
939:
940: if (upper(incompatibilities_allowed) = 'Y') then

Line 958: insert into fnd_request_set_stages

954: else
955: program_id := null;
956: end if;
957:
958: insert into fnd_request_set_stages
959: (set_application_id, request_set_id, request_set_stage_id,
960: stage_name,
961: last_update_date, last_updated_by, creation_date,
962: created_by, last_update_login,

Line 977: insert into FND_REQUEST_SET_STAGES_TL (

973: upper(critical), 'C', function_id, function_appl_id,
974: display_sequence);
975:
976: -- insert rows for each installed language into the tl table
977: insert into FND_REQUEST_SET_STAGES_TL (
978: set_application_id, request_set_id, request_set_stage_id,
979: creation_date, created_by, last_update_date,
980: last_updated_by, last_update_login, user_stage_name,
981: description, language, source_lang

Line 1035: from_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;

1031: last_updated_by fnd_request_groups.last_updated_by%TYPE
1032: := last_updated_by_f;
1033: set_appl_id fnd_application.application_id%TYPE;
1034: set_id fnd_request_sets.request_set_id%TYPE;
1035: from_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
1036: to_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
1037: dummy varchar2(1);
1038: BEGIN
1039: message_init;

Line 1036: to_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;

1032: := last_updated_by_f;
1033: set_appl_id fnd_application.application_id%TYPE;
1034: set_id fnd_request_sets.request_set_id%TYPE;
1035: from_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
1036: to_stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
1037: dummy varchar2(1);
1038: BEGIN
1039: message_init;
1040:

Line 1056: update fnd_request_set_stages

1052: to_stage_id := null;
1053: end if;
1054:
1055: if (success = 'Y') then
1056: update fnd_request_set_stages
1057: set success_link = to_stage_id
1058: where set_application_id = set_appl_id
1059: and request_set_id = set_id
1060: and request_set_stage_id = from_stage_id;

Line 1064: update fnd_request_set_stages

1060: and request_set_stage_id = from_stage_id;
1061: end if;
1062:
1063: if (warning = 'Y') then
1064: update fnd_request_set_stages
1065: set warning_link = to_stage_id
1066: where set_application_id = set_appl_id
1067: and request_set_id = set_id
1068: and request_set_stage_id = from_stage_id;

Line 1072: update fnd_request_set_stages

1068: and request_set_stage_id = from_stage_id;
1069: end if;
1070:
1071: if (error = 'Y') then
1072: update fnd_request_set_stages
1073: set error_link = to_stage_id
1074: where set_application_id = set_appl_id
1075: and request_set_id = set_id
1076: and request_set_stage_id = from_stage_id;

Line 1124: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

1120: := created_by_f;
1121: set_appl_id fnd_application.application_id%TYPE;
1122: program_appl_id fnd_application.application_id%TYPE;
1123: set_id fnd_request_sets.request_set_id%TYPE;
1124: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1125: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1126: print_style_name fnd_printer_styles.printer_style_name%TYPE;
1127: dummy varchar2(1);
1128: BEGIN

Line 1224: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

1220: stage IN VARCHAR2)
1221: is
1222: set_appl_id fnd_application.application_id%TYPE;
1223: set_id fnd_request_sets.request_set_id%TYPE;
1224: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1225: program_short_name fnd_concurrent_programs.concurrent_program_name%TYPE;
1226: BEGIN
1227: message_init;
1228:

Line 1258: fnd_request_set_stages r

1254: begin
1255: select concurrent_program_name
1256: into program_short_name
1257: from fnd_concurrent_programs p,
1258: fnd_request_set_stages r
1259: where r.set_application_id = set_appl_id
1260: and r.request_set_id = set_id
1261: and r.request_set_stage_id = stage_id
1262: and r.set_application_id = p.application_id

Line 1279: delete from fnd_request_set_stages_tl

1275: and request_set_id = set_id
1276: and request_set_stage_id = stage_id;
1277:
1278: -- Delete translations
1279: delete from fnd_request_set_stages_tl
1280: where set_application_id = set_appl_id
1281: and request_set_id = set_id
1282: and request_set_stage_id = stage_id;
1283:

Line 1285: delete from fnd_request_set_stages

1281: and request_set_id = set_id
1282: and request_set_stage_id = stage_id;
1283:
1284: -- Delete stage
1285: delete from fnd_request_set_stages
1286: where set_application_id = set_appl_id
1287: and request_set_id = set_id
1288: and request_set_stage_id = stage_id;
1289:

Line 1291: update fnd_request_set_stages

1287: and request_set_id = set_id
1288: and request_set_stage_id = stage_id;
1289:
1290: -- Update links
1291: update fnd_request_set_stages
1292: set success_link = null
1293: where set_application_id = set_appl_id
1294: and request_set_id = set_id
1295: and success_link = stage_id;

Line 1297: update fnd_request_set_stages

1293: where set_application_id = set_appl_id
1294: and request_set_id = set_id
1295: and success_link = stage_id;
1296:
1297: update fnd_request_set_stages
1298: set warning_link = null
1299: where set_application_id = set_appl_id
1300: and request_set_id = set_id
1301: and warning_link = stage_id;

Line 1303: update fnd_request_set_stages

1299: where set_application_id = set_appl_id
1300: and request_set_id = set_id
1301: and warning_link = stage_id;
1302:
1303: update fnd_request_set_stages
1304: set error_link = null
1305: where set_application_id = set_appl_id
1306: and request_set_id = set_id
1307: and error_link = stage_id;

Line 1337: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

1333: is
1334: set_appl_id fnd_application.application_id%TYPE;
1335: program_appl_id fnd_application.application_id%TYPE;
1336: set_id fnd_request_sets.request_set_id%TYPE;
1337: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1338: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1339: BEGIN
1340: message_init;
1341:

Line 1428: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

1424: := created_by_f;
1425: set_appl_id fnd_application.application_id%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

Line 1690: fnd_request_set_stages.request_set_stage_id%TYPE;

1686: is
1687: set_id
1688: fnd_request_sets.request_set_id%TYPE;
1689: stage_id
1690: fnd_request_set_stages.request_set_stage_id%TYPE;
1691: program_appl_id
1692: fnd_application.application_id%TYPE;
1693: set_appl_id
1694: fnd_application.application_id%TYPE;

Line 1776: from fnd_request_set_stages

1772: fnd_concurrent_programs.concurrent_program_name%TYPE;
1773:
1774: cursor c (set_appl_id number, set_id number) is
1775: select request_set_stage_id
1776: from fnd_request_set_stages
1777: where request_set_id = set_id
1778: and set_application_id = set_appl_id;
1779: BEGIN
1780: message_init;

Line 1843: fnd_request_set_stages r

1839: begin
1840: select concurrent_program_name
1841: into program_short_name
1842: from fnd_concurrent_programs p,
1843: fnd_request_set_stages r
1844: where r.set_application_id = set_application_id
1845: and r.request_set_id = set_id
1846: and r.request_set_stage_id = rec.request_set_stage_id
1847: and r.set_application_id = p.application_id

Line 1863: DELETE FROM fnd_request_set_stages_tl

1859: DELETE from fnd_stage_fn_parameter_values
1860: where set_application_id = set_appl_id
1861: and request_set_id = set_id;
1862:
1863: DELETE FROM fnd_request_set_stages_tl
1864: WHERE set_application_id = set_appl_id
1865: AND request_set_id = set_id;
1866:
1867: DELETE FROM fnd_request_set_stages

Line 1867: DELETE FROM fnd_request_set_stages

1863: DELETE FROM fnd_request_set_stages_tl
1864: WHERE set_application_id = set_appl_id
1865: AND request_set_id = set_id;
1866:
1867: DELETE FROM fnd_request_set_stages
1868: WHERE set_application_id = set_appl_id
1869: AND request_set_id = set_id;
1870:
1871: -- Remove the set

Line 2154: from fnd_request_set_stages f

2150: set_id := request_set_id_f(set_appl_id, request_set);
2151:
2152: select 'y'
2153: into dummy
2154: from fnd_request_set_stages f
2155: where set_application_id = set_appl_id
2156: and request_set_id = set_id
2157: and f.stage_name = stage;
2158:

Line 2192: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

2188:
2189: set_appl_id fnd_application.application_id%TYPE;
2190: program_appl_id fnd_application.application_id%TYPE;
2191: set_id fnd_request_sets.request_set_id%TYPE;
2192: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
2193: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2194: dummy varchar2(1);
2195:
2196: BEGIN

Line 2249: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;

2245: parameter IN VARCHAR2)
2246: RETURN BOOLEAN is
2247:
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);

Line 2517: from fnd_request_set_stages

2513: select 'x' into dummy
2514: from sys.dual
2515: where not exists
2516: (select 1
2517: from fnd_request_set_stages
2518: where function_application_id = exec_application_id
2519: and function_id = exec_id);
2520: EXCEPTION
2521: when no_data_found then

Line 2932: from fnd_request_set_stages s, fnd_stage_fn_parameters_vl p

2928:
2929: begin
2930: select s.function_id, s.function_application_id, p.parameter_id
2931: into fn_id, fn_appl_id, param_id
2932: from fnd_request_set_stages s, fnd_stage_fn_parameters_vl p
2933: where s.request_set_id = set_id
2934: and s.set_application_id = set_appl_id
2935: and s.request_set_stage_id = stage_id
2936: and s.function_id = p.function_id

Line 3016: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages

3012: pos2 := instr(req_data, ',', pos + 1, 1);
3013: error_stage_id := to_number(substr(req_data, pos + 1, pos2 - pos -1));
3014: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS
3015: where REQUEST_SET_ID = rset_id AND application_id = appl_id;
3016: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
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;