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_SETS

Line 213: set_id fnd_request_sets.request_set_id%TYPE;

209:
210: /* Get a request set ID given appl ID and set short name */
211: FUNCTION request_set_id_f(set_application_id number,
212: request_set varchar2) return number is
213: set_id fnd_request_sets.request_set_id%TYPE;
214: BEGIN
215: SELECT request_set_id
216: INTO set_id
217: FROM fnd_request_sets

Line 217: FROM fnd_request_sets

213: set_id fnd_request_sets.request_set_id%TYPE;
214: BEGIN
215: SELECT request_set_id
216: INTO set_id
217: FROM fnd_request_sets
218: WHERE application_id = set_application_id
219: AND request_set_name = request_set;
220:
221: RETURN set_id;

Line 514: from fnd_request_sets

510:
511: else /* source is SET */
512: select concurrent_program_id
513: into prog_id
514: from fnd_request_sets
515: where application_id = set_appl_id
516: and request_set_id = set_id;
517:
518: if (prog_id is null) then

Line 766: set_id fnd_request_sets.request_set_id%TYPE;

762: := creation_date_f;
763: created_by fnd_request_groups.created_by%TYPE
764: := created_by_f;
765: set_appl_id fnd_application.application_id%TYPE;
766: set_id fnd_request_sets.request_set_id%TYPE;
767: owner_id fnd_user.user_id%TYPE;
768: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
769:
770: BEGIN

Line 786: select fnd_request_sets_s.nextval into set_id from sys.dual;

782:
783:
784: set_appl_id := application_id_f(application);
785:
786: select fnd_request_sets_s.nextval into set_id from sys.dual;
787:
788: if (owner is not null) then
789: BEGIN
790: select user_id

Line 812: insert into fnd_request_sets

808: lang=>language_code,
809: set_short_name => short_name);
810: end if;
811:
812: insert into fnd_request_sets
813: (application_id, request_set_id, request_set_name,
814: last_update_date, last_updated_by, creation_date,
815: created_by, last_update_login,
816: allow_constraints_flag, print_together_flag,

Line 827: insert into FND_REQUEST_SETS_TL (

823: upper(incompatibilities_allowed), upper(print_together), start_date,
824: end_date, program_id, owner_id);
825:
826: -- insert rows for each installed language into the tl table
827: insert into FND_REQUEST_SETS_TL (
828: application_id, request_set_id, creation_date,
829: created_by, last_update_date, last_updated_by,
830: last_update_login, user_request_set_name, description,
831: language, source_lang

Line 895: set_id fnd_request_sets.request_set_id%TYPE;

891: := creation_date_f;
892: created_by fnd_request_groups.created_by%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;

Line 943: from fnd_request_sets_vl

939:
940: if (upper(incompatibilities_allowed) = 'Y') then
941: select user_request_set_name
942: into set_name
943: from fnd_request_sets_vl
944: where request_set_id = set_id
945: and application_id = set_appl_id;
946:
947: program_id := create_program(request_set=>set_name,

Line 995: update fnd_request_sets

991: println('Added stage ' || name ||
992: ' to set ' || request_set || '.');
993:
994: if (start_stage = 'Y') then
995: update fnd_request_sets
996: set start_stage = stage_id
997: where request_set_id = set_id
998: and application_id = set_appl_id;
999: end if;

Line 1034: set_id fnd_request_sets.request_set_id%TYPE;

1030: := last_update_date_f;
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

Line 1123: set_id fnd_request_sets.request_set_id%TYPE;

1119: created_by fnd_request_groups.created_by%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);

Line 1223: set_id fnd_request_sets.request_set_id%TYPE;

1219: set_application IN VARCHAR2,
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;

Line 1336: set_id fnd_request_sets.request_set_id%TYPE;

1332: program_sequence IN NUMBER)
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;

Line 1427: set_id fnd_request_sets.request_set_id%TYPE;

1423: created_by fnd_request_groups.created_by%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;

Line 1567: fnd_request_sets.request_set_id%TYPE;

1563: fnd_application.application_id%TYPE;
1564: group_application_id
1565: fnd_application.application_id%TYPE;
1566: set_id
1567: fnd_request_sets.request_set_id%TYPE;
1568: group_id
1569: fnd_request_groups.request_group_id%TYPE;
1570: BEGIN
1571: message_init;

Line 1636: fnd_request_sets.request_set_id%TYPE;

1632: fnd_application.application_id%TYPE;
1633: group_application_id
1634: fnd_application.application_id%TYPE;
1635: set_id
1636: fnd_request_sets.request_set_id%TYPE;
1637: group_id
1638: fnd_request_groups.request_group_id%TYPE;
1639: BEGIN
1640: message_init;

Line 1688: fnd_request_sets.request_set_id%TYPE;

1684: program_sequence IN NUMBER,
1685: parameter IN VARCHAR2)
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;

Line 1770: fnd_request_sets.request_set_id%TYPE;

1766: application IN VARCHAR2) is
1767: set_appl_id
1768: fnd_application.application_id%TYPE;
1769: set_id
1770: fnd_request_sets.request_set_id%TYPE;
1771: program_short_name
1772: fnd_concurrent_programs.concurrent_program_name%TYPE;
1773:
1774: cursor c (set_appl_id number, set_id number) is

Line 1801: fnd_request_sets r

1797: BEGIN
1798: select concurrent_program_name
1799: into program_short_name
1800: from fnd_concurrent_programs p,
1801: fnd_request_sets r
1802: where r.application_id = set_appl_id
1803: and r.request_set_id = set_id
1804: and r.application_id = p.application_id
1805: and r.concurrent_program_id = p.concurrent_program_id;

Line 1873: DELETE FROM fnd_request_sets_tl

1869: AND request_set_id = set_id;
1870:
1871: -- Remove the set
1872:
1873: DELETE FROM fnd_request_sets_tl
1874: WHERE application_id = set_appl_id
1875: AND request_set_id = set_id;
1876:
1877: DELETE FROM fnd_request_sets

Line 1877: DELETE FROM fnd_request_sets

1873: DELETE FROM fnd_request_sets_tl
1874: WHERE application_id = set_appl_id
1875: AND request_set_id = set_id;
1876:
1877: DELETE FROM fnd_request_sets
1878: WHERE application_id = set_appl_id
1879: AND request_set_id = set_id;
1880:
1881: END delete_set;

Line 2107: set_id fnd_request_sets.request_set_id%TYPE;

2103: FUNCTION request_set_exists(request_set IN VARCHAR2,
2104: application IN VARCHAR2)
2105: RETURN BOOLEAN is
2106: set_application_id fnd_application.application_id%TYPE;
2107: set_id fnd_request_sets.request_set_id%TYPE;
2108:
2109: BEGIN
2110: message_init;
2111:

Line 2143: set_id fnd_request_sets.request_set_id%TYPE;

2139: set_application IN VARCHAR2)
2140: RETURN BOOLEAN is
2141:
2142: set_appl_id fnd_application.application_id%TYPE;
2143: set_id fnd_request_sets.request_set_id%TYPE;
2144: dummy varchar2(1);
2145:
2146: BEGIN
2147: message_init;

Line 2191: set_id fnd_request_sets.request_set_id%TYPE;

2187: RETURN BOOLEAN is
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:

Line 2248: set_id fnd_request_sets.request_set_id%TYPE;

2244: program_sequence IN NUMBER,
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;

Line 2324: set_id fnd_request_sets.request_set_id%TYPE;

2320: RETURN BOOLEAN is
2321:
2322: set_application_id fnd_application.application_id%TYPE;
2323: group_application_id fnd_application.application_id%TYPE;
2324: set_id fnd_request_sets.request_set_id%TYPE;
2325: group_id fnd_request_groups.request_group_id%TYPE;
2326: dummy varchar2(1);
2327:
2328: BEGIN

Line 2625: fnd_request_sets.request_set_id%TYPE;

2621: fnd_application.application_id%TYPE;
2622: group_application_id
2623: fnd_application.application_id%TYPE;
2624: fn_id
2625: fnd_request_sets.request_set_id%TYPE;
2626: group_id
2627: fnd_request_groups.request_group_id%TYPE;
2628: begin
2629: message_init;

Line 3014: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS

3010: BEGIN
3011: pos := instr(req_data, ',', 1, 1);
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