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 156: RETURN fnd_application.application_id%TYPE

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

Line 158: application_id_ret fnd_application.application_id%TYPE;

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

Line 167: FROM fnd_application

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

Line 175: FROM fnd_application_tl

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

Line 193: RETURN fnd_application.application_short_name%TYPE

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

Line 195: application_sn_ret fnd_application.application_short_name%TYPE;

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

Line 204: FROM fnd_application

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

Line 212: FROM fnd_application_tl t,

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

Line 213: fnd_application b

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

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

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

Line 384: application_id_i fnd_application.application_id%TYPE;

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

Line 387: appl_short_name fnd_application.application_short_name%TYPE;

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

Line 612: application_id_i fnd_application.application_id%TYPE;

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

Line 615: type_application_id_i fnd_application.application_id%TYPE;

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

Line 618: executable_application_id_i fnd_application.application_id%TYPE;

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

Line 623: appl_short_name fnd_application.application_short_name%TYPE;

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

Line 624: mls_function_application_id_i fnd_application.application_id%TYPE;

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

Line 992: application_id_i fnd_application.application_id%TYPE;

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

Line 997: to_run_application_id_i fnd_application.application_id%TYPE;

993: concurrent_program_id_i
994: fnd_concurrent_programs.concurrent_program_id%TYPE;
995: to_run_concurrent_program_id_i
996: fnd_concurrent_programs.concurrent_program_id%TYPE;
997: to_run_application_id_i fnd_application.application_id%TYPE;
998: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
999: BEGIN
1000: message_init;
1001:

Line 1282: group_application_id fnd_application.application_id%TYPE;

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

Line 1345: fnd_application.application_id%TYPE;

1341: := creation_date_f;
1342: created_by fnd_request_groups.created_by%TYPE
1343: := created_by_f;
1344: program_application_id
1345: fnd_application.application_id%TYPE;
1346: group_application_id
1347: fnd_application.application_id%TYPE;
1348: concurrent_program_id
1349: fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 1347: fnd_application.application_id%TYPE;

1343: := created_by_f;
1344: program_application_id
1345: fnd_application.application_id%TYPE;
1346: group_application_id
1347: fnd_application.application_id%TYPE;
1348: concurrent_program_id
1349: fnd_concurrent_programs.concurrent_program_id%TYPE;
1350: group_id
1351: fnd_request_groups.request_group_id%TYPE;

Line 1414: fnd_application.application_id%TYPE;

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

Line 1416: fnd_application.application_id%TYPE;

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

Line 1461: program_application_id fnd_application.application_id%TYPE;

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

Line 1466: prog_appl_short_name fnd_application.application_short_name%TYPE;

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

Line 1686: fnd_application.application_id%TYPE;

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

Line 1691: prog_appl_short_name fnd_application.application_short_name%TYPE;

1687: program_id
1688: fnd_concurrent_programs.concurrent_program_id%TYPE;
1689: desc_flex_name
1690: fnd_descriptive_flexs.descriptive_flexfield_name%TYPE;
1691: prog_appl_short_name fnd_application.application_short_name%TYPE;
1692:
1693: BEGIN
1694: message_init;
1695:

Line 1752: fnd_application.application_id%TYPE;

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

Line 1818: fnd_application.application_id%TYPE;

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

Line 1859: application_id_i fnd_application.application_id%TYPE;

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

Line 1864: to_run_application_id_i fnd_application.application_id%TYPE;

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

Line 1958: application_id_p fnd_application.application_id%TYPE;

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

Line 2025: program_application_id fnd_application.application_id%TYPE;

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

Line 2058: program_appl_id fnd_application.application_id%TYPE;

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

Line 2061: prog_appl_short_name fnd_application.application_short_name%TYPE;

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

Line 2108: application_id_i fnd_application.application_id%TYPE;

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

Line 2112: to_run_application_id_i fnd_application.application_id%TYPE;

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

Line 2159: exec_application_id fnd_application.application_id%TYPE;

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

Line 2196: group_application_id fnd_application.application_id%TYPE;

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

Line 2237: program_application_id fnd_application.application_id%TYPE;

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

Line 2238: group_application_id fnd_application.application_id%TYPE;

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

Line 2297: fnd_application.application_id%TYPE;

2293: := creation_date_f;
2294: created_by fnd_request_groups.created_by%TYPE
2295: := created_by_f;
2296: application_id
2297: fnd_application.application_id%TYPE;
2298: group_application_id
2299: fnd_application.application_id%TYPE;
2300: group_id
2301: fnd_request_groups.request_group_id%TYPE;

Line 2299: fnd_application.application_id%TYPE;

2295: := created_by_f;
2296: application_id
2297: fnd_application.application_id%TYPE;
2298: group_application_id
2299: fnd_application.application_id%TYPE;
2300: group_id
2301: fnd_request_groups.request_group_id%TYPE;
2302: BEGIN
2303: message_init;

Line 2358: fnd_application.application_id%TYPE;

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

Line 2360: fnd_application.application_id%TYPE;

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

Line 2399: application_id fnd_application.application_id%TYPE;

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

Line 2400: group_application_id fnd_application.application_id%TYPE;

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

Line 2442: program_application_id fnd_application.application_id%TYPE;

2438: --
2439: FUNCTION program_is_mls(program_short_name IN VARCHAR2,
2440: program_application IN VARCHAR2) RETURN NUMBER is
2441:
2442: program_application_id fnd_application.application_id%TYPE;
2443: retval number;
2444:
2445: BEGIN
2446: message_init;