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_APPLICATION

Line 149: RETURN fnd_application.application_id%TYPE

145: /* ------------------------------------------------------------ */
146:
147: /* get the application id, given the name (or short name) */
148: FUNCTION application_id_f(application_name_in IN VARCHAR2)
149: RETURN fnd_application.application_id%TYPE
150: IS
151: application_id_ret fnd_application.application_id%TYPE;
152: BEGIN
153: IF(application_name_in IS NULL) THEN

Line 151: application_id_ret fnd_application.application_id%TYPE;

147: /* get the application id, given the name (or short name) */
148: FUNCTION application_id_f(application_name_in IN VARCHAR2)
149: RETURN fnd_application.application_id%TYPE
150: IS
151: application_id_ret fnd_application.application_id%TYPE;
152: BEGIN
153: IF(application_name_in IS NULL) THEN
154: message('A null application_name was specified.');
155: RAISE bad_parameter;

Line 160: FROM fnd_application

156: END IF;
157:
158: SELECT application_id
159: INTO application_id_ret
160: FROM fnd_application
161: WHERE application_short_name = application_name_in;
162: RETURN application_id_ret;
163: EXCEPTION
164: when NO_DATA_FOUND then

Line 600: application_id_i fnd_application.application_id%TYPE;

596: creation_date fnd_flex_value_sets.creation_date%TYPE
597: := creation_date_f;
598: created_by fnd_flex_value_sets.created_by%TYPE
599: := created_by_f;
600: application_id_i fnd_application.application_id%TYPE;
601: concurrent_program_id_i
602: fnd_concurrent_programs.concurrent_program_id%TYPE;
603: to_run_concurrent_program_id_i
604: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 605: to_run_application_id_i fnd_application.application_id%TYPE;

601: concurrent_program_id_i
602: fnd_concurrent_programs.concurrent_program_id%TYPE;
603: to_run_concurrent_program_id_i
604: fnd_concurrent_programs.concurrent_program_id%TYPE;
605: to_run_application_id_i fnd_application.application_id%TYPE;
606: set_id number;
607: stage_id number;
608: BEGIN
609: message_init;

Line 765: set_appl_id fnd_application.application_id%TYPE;

761: creation_date fnd_request_groups.creation_date%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:

Line 894: set_appl_id fnd_application.application_id%TYPE;

890: creation_date fnd_request_groups.creation_date%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);

Line 1033: set_appl_id fnd_application.application_id%TYPE;

1029: last_update_date fnd_request_groups.last_update_date%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);

Line 1121: set_appl_id fnd_application.application_id%TYPE;

1117: creation_date fnd_request_groups.creation_date%TYPE
1118: := creation_date_f;
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;

Line 1122: program_appl_id fnd_application.application_id%TYPE;

1118: := creation_date_f;
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;

Line 1222: set_appl_id fnd_application.application_id%TYPE;

1218: PROCEDURE remove_stage(request_set IN VARCHAR2,
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

Line 1334: set_appl_id fnd_application.application_id%TYPE;

1330: set_application IN VARCHAR2,
1331: stage IN VARCHAR2,
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;

Line 1335: program_appl_id fnd_application.application_id%TYPE;

1331: stage IN VARCHAR2,
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

Line 1425: set_appl_id fnd_application.application_id%TYPE;

1421: creation_date fnd_request_groups.creation_date%TYPE
1422: := creation_date_f;
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;

Line 1426: program_appl_id fnd_application.application_id%TYPE;

1422: := creation_date_f;
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;

Line 1563: fnd_application.application_id%TYPE;

1559: := creation_date_f;
1560: created_by fnd_request_groups.created_by%TYPE
1561: := created_by_f;
1562: set_application_id
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;

Line 1565: fnd_application.application_id%TYPE;

1561: := created_by_f;
1562: set_application_id
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;

Line 1632: fnd_application.application_id%TYPE;

1628: request_group IN VARCHAR2,
1629: group_application IN VARCHAR2)
1630: is
1631: set_application_id
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;

Line 1634: fnd_application.application_id%TYPE;

1630: is
1631: set_application_id
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;

Line 1692: fnd_application.application_id%TYPE;

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;
1695: set_program_id
1696: fnd_request_set_program_args.request_set_program_id%TYPE;

Line 1694: fnd_application.application_id%TYPE;

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;
1695: set_program_id
1696: fnd_request_set_program_args.request_set_program_id%TYPE;
1697: BEGIN
1698: message_init;

Line 1768: fnd_application.application_id%TYPE;

1764: --
1765: PROCEDURE delete_set(request_set IN VARCHAR2,
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;

Line 1912: application_id_i fnd_application.application_id%TYPE;

1908: inc_request_set IN VARCHAR2 DEFAULT NULL,
1909: inc_set_application IN VARCHAR2 DEFAULT NULL,
1910: inc_stage IN VARCHAR2 DEFAULT NULL)
1911: IS
1912: application_id_i fnd_application.application_id%TYPE;
1913: concurrent_program_id_i
1914: fnd_concurrent_programs.concurrent_program_id%TYPE;
1915: to_run_concurrent_program_id_i
1916: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 1917: to_run_application_id_i fnd_application.application_id%TYPE;

1913: concurrent_program_id_i
1914: fnd_concurrent_programs.concurrent_program_id%TYPE;
1915: to_run_concurrent_program_id_i
1916: fnd_concurrent_programs.concurrent_program_id%TYPE;
1917: to_run_application_id_i fnd_application.application_id%TYPE;
1918: dummy varchar2(1);
1919: set_id number;
1920: stage_id number;
1921: BEGIN

Line 2033: application_id_i fnd_application.application_id%TYPE;

2029: inc_set_application IN VARCHAR2 DEFAULT NULL,
2030: inc_stage IN VARCHAR2 DEFAULT NULL)
2031: return boolean is
2032:
2033: application_id_i fnd_application.application_id%TYPE;
2034: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2035: to_run_concurrent_program_id_i
2036: fnd_concurrent_programs.concurrent_program_id%TYPE;
2037: to_run_application_id_i fnd_application.application_id%TYPE;

Line 2037: to_run_application_id_i fnd_application.application_id%TYPE;

2033: application_id_i fnd_application.application_id%TYPE;
2034: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2035: to_run_concurrent_program_id_i
2036: fnd_concurrent_programs.concurrent_program_id%TYPE;
2037: to_run_application_id_i fnd_application.application_id%TYPE;
2038: dummy varchar2(1);
2039: set_id number;
2040: stage_id number;
2041:

Line 2106: set_application_id fnd_application.application_id%TYPE;

2102: --
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;

Line 2142: set_appl_id fnd_application.application_id%TYPE;

2138: request_set IN VARCHAR2,
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

Line 2189: set_appl_id fnd_application.application_id%TYPE;

2185: stage IN VARCHAR2,
2186: program_sequence IN NUMBER)
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;

Line 2190: program_appl_id fnd_application.application_id%TYPE;

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

Line 2250: program_appl_id fnd_application.application_id%TYPE;

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);
2254:

Line 2251: set_appl_id fnd_application.application_id%TYPE;

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);
2254:
2255: BEGIN

Line 2322: set_application_id fnd_application.application_id%TYPE;

2318: request_group IN VARCHAR2,
2319: group_application IN VARCHAR2)
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);

Line 2323: group_application_id fnd_application.application_id%TYPE;

2319: group_application IN VARCHAR2)
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:

Line 2450: exec_application_id fnd_application.application_id%TYPE;

2446: -- application - Application short name of the function.
2447: --
2448: FUNCTION function_exists(function_short_name IN VARCHAR2,
2449: application IN VARCHAR2) RETURN BOOLEAN is
2450: exec_application_id fnd_application.application_id%TYPE;
2451: dummy varchar2(1);
2452:
2453: begin
2454: message_init;

Line 2485: fnd_application.application_id%TYPE;

2481: --
2482: PROCEDURE delete_function(function_short_name IN VARCHAR2,
2483: application IN VARCHAR2) is
2484: exec_application_id
2485: fnd_application.application_id%TYPE;
2486: exec_id
2487: fnd_executables.executable_id%TYPE;
2488: dummy varchar2(1);
2489:

Line 2563: fn_application_id fnd_application.application_id%TYPE;

2559: function_application IN VARCHAR2,
2560: request_group IN VARCHAR2,
2561: group_application IN VARCHAR2)
2562: RETURN BOOLEAN is
2563: fn_application_id fnd_application.application_id%TYPE;
2564: group_application_id fnd_application.application_id%TYPE;
2565: fn_id number;
2566: group_id fnd_request_groups.request_group_id%TYPE;
2567: dummy varchar2(1);

Line 2564: group_application_id fnd_application.application_id%TYPE;

2560: request_group IN VARCHAR2,
2561: group_application IN VARCHAR2)
2562: RETURN BOOLEAN is
2563: fn_application_id fnd_application.application_id%TYPE;
2564: group_application_id fnd_application.application_id%TYPE;
2565: fn_id number;
2566: group_id fnd_request_groups.request_group_id%TYPE;
2567: dummy varchar2(1);
2568:

Line 2621: fnd_application.application_id%TYPE;

2617: := creation_date_f;
2618: created_by fnd_request_groups.created_by%TYPE
2619: := created_by_f;
2620: fn_application_id
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;

Line 2623: fnd_application.application_id%TYPE;

2619: := created_by_f;
2620: fn_application_id
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;

Line 2686: fnd_application.application_id%TYPE;

2682: function_application IN VARCHAR2,
2683: request_group IN VARCHAR2,
2684: group_application IN VARCHAR2) is
2685: fn_application_id
2686: fnd_application.application_id%TYPE;
2687: group_application_id
2688: fnd_application.application_id%TYPE;
2689: fn_id number;
2690: group_id

Line 2688: fnd_application.application_id%TYPE;

2684: group_application IN VARCHAR2) is
2685: fn_application_id
2686: fnd_application.application_id%TYPE;
2687: group_application_id
2688: fnd_application.application_id%TYPE;
2689: fn_id number;
2690: group_id
2691: fnd_request_groups.request_group_id%TYPE;
2692: begin

Line 2745: fn_appl_id fnd_application.application_id%TYPE;

2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;
2745: fn_appl_id fnd_application.application_id%TYPE;
2746: fn_id number;
2747: param_id number;
2748: begin
2749: message_init;

Line 2800: fn_appl_id fnd_application.application_id%TYPE;

2796: FUNCTION function_parameter_exists(function_short_name IN VARCHAR2,
2797: application IN VARCHAR2,
2798: parameter IN VARCHAR2)
2799: RETURN BOOLEAN is
2800: fn_appl_id fnd_application.application_id%TYPE;
2801: fn_id number;
2802: dummy varchar2(1);
2803:
2804: begin

Line 2839: fn_appl_id fnd_application.application_id%TYPE;

2835: --
2836: PROCEDURE delete_function_parameter(function_short_name IN VARCHAR2,
2837: application IN VARCHAR2,
2838: parameter IN VARCHAR2) is
2839: fn_appl_id fnd_application.application_id%TYPE;
2840: fn_id number;
2841: param_id number;
2842: dummy varchar2(1);
2843: