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_PROGRAM dependencies on FND_APPLICATION

Line 153: RETURN fnd_application.application_id%TYPE

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

Line 155: application_id_ret fnd_application.application_id%TYPE;

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

Line 164: FROM fnd_application

160: END IF;
161: /* Check the short name first. */
162: SELECT application_id
163: INTO application_id_ret
164: FROM fnd_application
165: WHERE application_short_name = application_name_in;
166: RETURN application_id_ret;
167: EXCEPTION
168: WHEN no_data_found THEN /* Try the translated name. */

Line 172: FROM fnd_application_tl

168: WHEN no_data_found THEN /* Try the translated name. */
169: BEGIN
170: SELECT application_id
171: INTO application_id_ret
172: FROM fnd_application_tl
173: WHERE application_name = application_name_in
174: AND rownum = 1;
175: RETURN application_id_ret;
176: EXCEPTION

Line 190: RETURN fnd_application.application_short_name%TYPE

186: * handle application_name and short_name parameters
187: * differently.
188: */
189: FUNCTION application_short_name_f(application_name_in IN VARCHAR2)
190: RETURN fnd_application.application_short_name%TYPE
191: IS
192: application_sn_ret fnd_application.application_short_name%TYPE;
193: BEGIN
194: IF(application_name_in IS NULL) THEN

Line 192: application_sn_ret fnd_application.application_short_name%TYPE;

188: */
189: FUNCTION application_short_name_f(application_name_in IN VARCHAR2)
190: RETURN fnd_application.application_short_name%TYPE
191: IS
192: application_sn_ret fnd_application.application_short_name%TYPE;
193: BEGIN
194: IF(application_name_in IS NULL) THEN
195: message('A null application_name was specified.');
196: RAISE bad_parameter;

Line 201: FROM fnd_application

197: END IF;
198: /* Check the short name first. */
199: SELECT application_short_name
200: INTO application_sn_ret
201: FROM fnd_application
202: WHERE application_short_name = application_name_in;
203: RETURN application_sn_ret;
204: EXCEPTION
205: WHEN no_data_found THEN /* Try the translated name. */

Line 209: FROM fnd_application_tl t,

205: WHEN no_data_found THEN /* Try the translated name. */
206: BEGIN
207: SELECT application_short_name
208: INTO application_sn_ret
209: FROM fnd_application_tl t,
210: fnd_application b
211: WHERE t.application_name = application_name_in
212: AND rownum = 1
213: AND t.application_id = b.application_id;

Line 210: fnd_application b

206: BEGIN
207: SELECT application_short_name
208: INTO application_sn_ret
209: FROM fnd_application_tl t,
210: fnd_application b
211: WHERE t.application_name = application_name_in
212: AND rownum = 1
213: AND t.application_id = b.application_id;
214: RETURN application_sn_ret;

Line 298: PROCEDURE check_srs(application_id_i IN fnd_application.application_id%TYPE,

294: END;
295:
296:
297:
298: PROCEDURE check_srs(application_id_i IN fnd_application.application_id%TYPE,
299: concurrent_pgm_name_in IN VARCHAR2)
300: IS
301: srs_flag_i fnd_concurrent_programs.srs_flag%TYPE;
302: /* make sure the program exists, and can support SRS */

Line 381: application_id_i fnd_application.application_id%TYPE;

377: IS
378: descriptive_flexfield_name_in
379: fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
380: form_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
381: application_id_i fnd_application.application_id%TYPE;
382: column_name VARCHAR2(100);
383: emc varchar2(1);
384: appl_short_name fnd_application.application_short_name%TYPE;
385: BEGIN

Line 384: appl_short_name fnd_application.application_short_name%TYPE;

380: form_prompt fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE;
381: application_id_i fnd_application.application_id%TYPE;
382: column_name VARCHAR2(100);
383: emc varchar2(1);
384: appl_short_name fnd_application.application_short_name%TYPE;
385: BEGIN
386: message_init;
387:
388: fnd_flex_dsc_api.set_session_mode(session_mode=>who_mode);

Line 609: application_id_i fnd_application.application_id%TYPE;

605: fnd_executables.execution_method_code%TYPE;
606: argument_method_code_i
607: fnd_concurrent_programs.argument_method_code%TYPE;
608: srs_flag_i VARCHAR2(1);
609: application_id_i fnd_application.application_id%TYPE;
610: concurrent_program_id_i
611: fnd_concurrent_programs.concurrent_program_id%TYPE;
612: type_application_id_i fnd_application.application_id%TYPE;
613: concurrent_class_id_i

Line 612: type_application_id_i fnd_application.application_id%TYPE;

608: srs_flag_i VARCHAR2(1);
609: application_id_i fnd_application.application_id%TYPE;
610: concurrent_program_id_i
611: fnd_concurrent_programs.concurrent_program_id%TYPE;
612: type_application_id_i fnd_application.application_id%TYPE;
613: concurrent_class_id_i
614: fnd_concurrent_request_class.request_class_id%TYPE;
615: executable_application_id_i fnd_application.application_id%TYPE;
616: executable_id_i fnd_executables.executable_id%TYPE;

Line 615: executable_application_id_i fnd_application.application_id%TYPE;

611: fnd_concurrent_programs.concurrent_program_id%TYPE;
612: type_application_id_i fnd_application.application_id%TYPE;
613: concurrent_class_id_i
614: fnd_concurrent_request_class.request_class_id%TYPE;
615: executable_application_id_i fnd_application.application_id%TYPE;
616: executable_id_i fnd_executables.executable_id%TYPE;
617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;

Line 620: appl_short_name fnd_application.application_short_name%TYPE;

616: executable_id_i fnd_executables.executable_id%TYPE;
617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;
620: appl_short_name fnd_application.application_short_name%TYPE;
621: mls_function_application_id_i fnd_application.application_id%TYPE;
622: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
623:
624: srs1_i VARCHAR2(1);

Line 621: mls_function_application_id_i fnd_application.application_id%TYPE;

617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;
620: appl_short_name fnd_application.application_short_name%TYPE;
621: mls_function_application_id_i fnd_application.application_id%TYPE;
622: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
623:
624: srs1_i VARCHAR2(1);
625: srs2_i VARCHAR2(1);

Line 989: application_id_i fnd_application.application_id%TYPE;

985: creation_date fnd_flex_value_sets.creation_date%TYPE
986: := creation_date_f;
987: created_by fnd_flex_value_sets.created_by%TYPE
988: := created_by_f;
989: application_id_i fnd_application.application_id%TYPE;
990: concurrent_program_id_i
991: fnd_concurrent_programs.concurrent_program_id%TYPE;
992: to_run_concurrent_program_id_i
993: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 994: to_run_application_id_i fnd_application.application_id%TYPE;

990: concurrent_program_id_i
991: fnd_concurrent_programs.concurrent_program_id%TYPE;
992: to_run_concurrent_program_id_i
993: fnd_concurrent_programs.concurrent_program_id%TYPE;
994: to_run_application_id_i fnd_application.application_id%TYPE;
995: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
996: BEGIN
997: message_init;
998:

Line 1279: group_application_id fnd_application.application_id%TYPE;

1275: creation_date fnd_request_groups.creation_date%TYPE
1276: := creation_date_f;
1277: created_by fnd_request_groups.created_by%TYPE
1278: := created_by_f;
1279: group_application_id fnd_application.application_id%TYPE;
1280: BEGIN
1281: message_init;
1282:
1283: check_notnull(request_group);

Line 1342: fnd_application.application_id%TYPE;

1338: := creation_date_f;
1339: created_by fnd_request_groups.created_by%TYPE
1340: := created_by_f;
1341: program_application_id
1342: fnd_application.application_id%TYPE;
1343: group_application_id
1344: fnd_application.application_id%TYPE;
1345: concurrent_program_id
1346: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 1344: fnd_application.application_id%TYPE;

1340: := created_by_f;
1341: program_application_id
1342: fnd_application.application_id%TYPE;
1343: group_application_id
1344: fnd_application.application_id%TYPE;
1345: concurrent_program_id
1346: fnd_concurrent_programs.concurrent_program_id%TYPE;
1347: group_id
1348: fnd_request_groups.request_group_id%TYPE;

Line 1411: fnd_application.application_id%TYPE;

1407: program_application IN VARCHAR2,
1408: request_group IN VARCHAR2,
1409: group_application IN VARCHAR2) is
1410: program_application_id
1411: fnd_application.application_id%TYPE;
1412: group_application_id
1413: fnd_application.application_id%TYPE;
1414: concurrent_program_id
1415: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 1413: fnd_application.application_id%TYPE;

1409: group_application IN VARCHAR2) is
1410: program_application_id
1411: fnd_application.application_id%TYPE;
1412: group_application_id
1413: fnd_application.application_id%TYPE;
1414: concurrent_program_id
1415: fnd_concurrent_programs.concurrent_program_id%TYPE;
1416: group_id
1417: fnd_request_groups.request_group_id%TYPE;

Line 1458: program_application_id fnd_application.application_id%TYPE;

1454: -- (e.g. 'Application Object Library')
1455: --
1456: PROCEDURE delete_program(program_short_name IN VARCHAR2,
1457: application IN VARCHAR2) is
1458: program_application_id fnd_application.application_id%TYPE;
1459: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1460: desc_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
1461: rs_flag fnd_concurrent_programs.request_set_flag%TYPE;
1462: set_id fnd_request_sets.request_set_id%TYPE;

Line 1463: prog_appl_short_name fnd_application.application_short_name%TYPE;

1459: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1460: desc_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
1461: rs_flag fnd_concurrent_programs.request_set_flag%TYPE;
1462: set_id fnd_request_sets.request_set_id%TYPE;
1463: prog_appl_short_name fnd_application.application_short_name%TYPE;
1464:
1465: cursor req_cursor(appl_id number, prog_id number) is
1466: select request_id
1467: from fnd_concurrent_requests

Line 1683: fnd_application.application_id%TYPE;

1679: application IN VARCHAR2,
1680: parameter IN VARCHAR2) is
1681:
1682: program_appl_id
1683: fnd_application.application_id%TYPE;
1684: program_id
1685: fnd_concurrent_programs.concurrent_program_id%TYPE;
1686: desc_flex_name
1687: fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;

Line 1688: prog_appl_short_name fnd_application.application_short_name%TYPE;

1684: program_id
1685: fnd_concurrent_programs.concurrent_program_id%TYPE;
1686: desc_flex_name
1687: fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
1688: prog_appl_short_name fnd_application.application_short_name%TYPE;
1689:
1690: BEGIN
1691: message_init;
1692:

Line 1749: fnd_application.application_id%TYPE;

1745: --
1746: PROCEDURE delete_executable(executable_short_name IN VARCHAR2,
1747: application IN VARCHAR2) is
1748: exec_application_id
1749: fnd_application.application_id%TYPE;
1750: exec_id
1751: fnd_executables.executable_id%TYPE;
1752: dummy varchar2(1);
1753:

Line 1815: fnd_application.application_id%TYPE;

1811: --
1812: PROCEDURE delete_group(request_group IN VARCHAR2,
1813: application IN VARCHAR2) is
1814: group_application_id
1815: fnd_application.application_id%TYPE;
1816: BEGIN
1817: message_init;
1818:
1819: check_notnull(request_group);

Line 1856: application_id_i fnd_application.application_id%TYPE;

1852: application IN VARCHAR2,
1853: inc_prog_short_name IN VARCHAR2,
1854: inc_prog_application IN VARCHAR2)
1855: IS
1856: application_id_i fnd_application.application_id%TYPE;
1857: concurrent_program_id_i
1858: fnd_concurrent_programs.concurrent_program_id%TYPE;
1859: to_run_concurrent_program_id_i
1860: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 1861: to_run_application_id_i fnd_application.application_id%TYPE;

1857: concurrent_program_id_i
1858: fnd_concurrent_programs.concurrent_program_id%TYPE;
1859: to_run_concurrent_program_id_i
1860: fnd_concurrent_programs.concurrent_program_id%TYPE;
1861: to_run_application_id_i fnd_application.application_id%TYPE;
1862: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
1863: dummy varchar2(1);
1864: BEGIN
1865: message_init;

Line 1955: application_id_p fnd_application.application_id%TYPE;

1951: := creation_date_f;
1952: created_by fnd_flex_value_sets.created_by%TYPE
1953: := created_by_f;
1954:
1955: application_id_p fnd_application.application_id%TYPE;
1956: concurrent_program_id_p
1957: fnd_concurrent_programs.concurrent_program_id%TYPE;
1958: temp_enabled_flag VARCHAR2(10);
1959:

Line 2022: program_application_id fnd_application.application_id%TYPE;

2018: -- application - Application short name of the program.
2019: --
2020: FUNCTION program_exists(program IN VARCHAR2,
2021: application IN VARCHAR2) RETURN BOOLEAN is
2022: program_application_id fnd_application.application_id%TYPE;
2023: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2024: BEGIN
2025: message_init;
2026:

Line 2055: program_appl_id fnd_application.application_id%TYPE;

2051: FUNCTION parameter_exists(program_short_name IN VARCHAR2,
2052: application IN VARCHAR2,
2053: parameter IN VARCHAR2) RETURN BOOLEAN is
2054:
2055: program_appl_id fnd_application.application_id%TYPE;
2056: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2057: desc_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2058: prog_appl_short_name fnd_application.application_short_name%TYPE;
2059: dummy varchar2(1);

Line 2058: prog_appl_short_name fnd_application.application_short_name%TYPE;

2054:
2055: program_appl_id fnd_application.application_id%TYPE;
2056: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2057: desc_flex_name fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
2058: prog_appl_short_name fnd_application.application_short_name%TYPE;
2059: dummy varchar2(1);
2060:
2061: BEGIN
2062: message_init;

Line 2105: application_id_i fnd_application.application_id%TYPE;

2101: inc_prog_short_name IN VARCHAR2,
2102: inc_prog_application IN VARCHAR2)
2103: RETURN BOOLEAN is
2104:
2105: application_id_i fnd_application.application_id%TYPE;
2106: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2107: to_run_concurrent_program_id_i
2108: fnd_concurrent_programs.concurrent_program_id%TYPE;
2109: to_run_application_id_i fnd_application.application_id%TYPE;

Line 2109: to_run_application_id_i fnd_application.application_id%TYPE;

2105: application_id_i fnd_application.application_id%TYPE;
2106: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2107: to_run_concurrent_program_id_i
2108: fnd_concurrent_programs.concurrent_program_id%TYPE;
2109: to_run_application_id_i fnd_application.application_id%TYPE;
2110: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
2111: dummy varchar2(1);
2112:
2113: BEGIN

Line 2156: exec_application_id fnd_application.application_id%TYPE;

2152: --
2153: FUNCTION executable_exists(executable_short_name IN VARCHAR2,
2154: application IN VARCHAR2) RETURN BOOLEAN is
2155:
2156: exec_application_id fnd_application.application_id%TYPE;
2157: dummy varchar2(1);
2158:
2159: BEGIN
2160: message_init;

Line 2193: group_application_id fnd_application.application_id%TYPE;

2189: --
2190: FUNCTION request_group_exists(request_group IN VARCHAR2,
2191: application IN VARCHAR2) RETURN BOOLEAN is
2192:
2193: group_application_id fnd_application.application_id%TYPE;
2194: dummy varchar2(1);
2195:
2196: BEGIN
2197: message_init;

Line 2234: program_application_id fnd_application.application_id%TYPE;

2230: program_application IN VARCHAR2,
2231: request_group IN VARCHAR2,
2232: group_application IN VARCHAR2) RETURN BOOLEAN is
2233:
2234: program_application_id fnd_application.application_id%TYPE;
2235: group_application_id fnd_application.application_id%TYPE;
2236: concurrent_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2237: group_id fnd_request_groups.request_group_id%TYPE;
2238: dummy varchar2(1);

Line 2235: group_application_id fnd_application.application_id%TYPE;

2231: request_group IN VARCHAR2,
2232: group_application IN VARCHAR2) RETURN BOOLEAN is
2233:
2234: program_application_id fnd_application.application_id%TYPE;
2235: group_application_id fnd_application.application_id%TYPE;
2236: concurrent_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2237: group_id fnd_request_groups.request_group_id%TYPE;
2238: dummy varchar2(1);
2239:

Line 2294: fnd_application.application_id%TYPE;

2290: := creation_date_f;
2291: created_by fnd_request_groups.created_by%TYPE
2292: := created_by_f;
2293: application_id
2294: fnd_application.application_id%TYPE;
2295: group_application_id
2296: fnd_application.application_id%TYPE;
2297: group_id
2298: fnd_request_groups.request_group_id%TYPE;

Line 2296: fnd_application.application_id%TYPE;

2292: := created_by_f;
2293: application_id
2294: fnd_application.application_id%TYPE;
2295: group_application_id
2296: fnd_application.application_id%TYPE;
2297: group_id
2298: fnd_request_groups.request_group_id%TYPE;
2299: BEGIN
2300: message_init;

Line 2355: fnd_application.application_id%TYPE;

2351: application_name IN VARCHAR2,
2352: request_group IN VARCHAR2,
2353: group_application IN VARCHAR2) is
2354: application_id
2355: fnd_application.application_id%TYPE;
2356: group_application_id
2357: fnd_application.application_id%TYPE;
2358: group_id
2359: fnd_request_groups.request_group_id%TYPE;

Line 2357: fnd_application.application_id%TYPE;

2353: group_application IN VARCHAR2) is
2354: application_id
2355: fnd_application.application_id%TYPE;
2356: group_application_id
2357: fnd_application.application_id%TYPE;
2358: group_id
2359: fnd_request_groups.request_group_id%TYPE;
2360: BEGIN
2361: message_init;

Line 2396: application_id fnd_application.application_id%TYPE;

2392: FUNCTION application_in_group(application_name IN VARCHAR2,
2393: request_group IN VARCHAR2,
2394: group_application IN VARCHAR2) RETURN BOOLEAN is
2395:
2396: application_id fnd_application.application_id%TYPE;
2397: group_application_id fnd_application.application_id%TYPE;
2398: group_id fnd_request_groups.request_group_id%TYPE;
2399: dummy varchar2(1);
2400:

Line 2397: group_application_id fnd_application.application_id%TYPE;

2393: request_group IN VARCHAR2,
2394: group_application IN VARCHAR2) RETURN BOOLEAN is
2395:
2396: application_id fnd_application.application_id%TYPE;
2397: group_application_id fnd_application.application_id%TYPE;
2398: group_id fnd_request_groups.request_group_id%TYPE;
2399: dummy varchar2(1);
2400:
2401: BEGIN