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_CONCURRENT_PROGRAMS

Line 229: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

225:
226: /* Get a concurrent program ID given appl ID and short name */
227: FUNCTION concurrent_program_id_f(program_application_id number,
228: program_short_name varchar2) return number is
229: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
230: BEGIN
231: SELECT concurrent_program_id
232: INTO program_id
233: FROM fnd_concurrent_programs

Line 233: FROM fnd_concurrent_programs

229: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
230: BEGIN
231: SELECT concurrent_program_id
232: INTO program_id
233: FROM fnd_concurrent_programs
234: WHERE application_id = program_application_id
235: AND concurrent_program_name = program_short_name;
236:
237: RETURN program_id;

Line 304: srs_flag_i fnd_concurrent_programs.srs_flag%TYPE;

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 */
306: BEGIN
307: SELECT srs_flag
308: INTO srs_flag_i

Line 309: FROM fnd_concurrent_programs

305: /* make sure the program exists, and can support SRS */
306: BEGIN
307: SELECT srs_flag
308: INTO srs_flag_i
309: FROM fnd_concurrent_programs
310: WHERE concurrent_program_name = concurrent_pgm_name_in
311: AND application_id = application_id_i;
312: IF(srs_flag_i = 'N') THEN
313: message('SRS not enabled for: '||concurrent_pgm_name_in);

Line 417: from fnd_concurrent_programs

413:
414: BEGIN
415: select execution_method_code
416: into emc
417: from fnd_concurrent_programs
418: where application_id_i = application_id
419: and concurrent_program_name = program_short_name;
420: EXCEPTION
421: when no_data_found then

Line 502: UPDATE fnd_concurrent_programs

498:
499: END;
500:
501: IF cd_parameter = 'Y' THEN
502: UPDATE fnd_concurrent_programs
503: SET cd_parameter = parameter
504: WHERE application_id = application_id_i
505: AND concurrent_program_name = program_short_name;
506: END IF;

Line 610: fnd_concurrent_programs.argument_method_code%TYPE;

606: := created_by_f;
607: execution_method_code_i
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;

Line 614: fnd_concurrent_programs.concurrent_program_id%TYPE;

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
617: fnd_concurrent_request_class.request_class_id%TYPE;
618: executable_application_id_i fnd_application.application_id%TYPE;

Line 665: SELECT fnd_concurrent_programs_s.NEXTVAL /* get next cp id */

661:
662: srs1_i := upper(use_in_srs);
663: srs2_i := upper(allow_disabled_values);
664:
665: SELECT fnd_concurrent_programs_s.NEXTVAL /* get next cp id */
666: INTO concurrent_program_id_i
667: FROM sys.dual;
668:
669: application_id_i := application_id_f(application);

Line 856: INSERT INTO fnd_concurrent_programs(

852: END;
853:
854: end if;
855:
856: INSERT INTO fnd_concurrent_programs(
857: application_id, concurrent_program_id, concurrent_program_name,
858: last_update_date, last_updated_by,
859: creation_date, created_by, last_update_login,
860: executable_application_id, executable_id, execution_method_code,

Line 891: insert into FND_CONCURRENT_PROGRAMS_TL (

887: println('inserted into concurrent programs');
888:
889: -- insert rows for each installed language into the tl table */
890:
891: insert into FND_CONCURRENT_PROGRAMS_TL (
892: APPLICATION_ID, CONCURRENT_PROGRAM_ID, USER_CONCURRENT_PROGRAM_NAME,
893: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
894: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, DESCRIPTION,
895: LANGUAGE, SOURCE_LANG

Line 907: from FND_CONCURRENT_PROGRAMS_TL T

903: from FND_LANGUAGES L
904: where L.INSTALLED_FLAG in ('I', 'B')
905: and not exists
906: (select NULL
907: from FND_CONCURRENT_PROGRAMS_TL T
908: where T.APPLICATION_ID = application_id_i
909: and T.CONCURRENT_PROGRAM_ID = concurrent_program_id_i
910: and T.LANGUAGE = L.LANGUAGE_CODE);
911:

Line 994: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
997: to_run_application_id_i fnd_application.application_id%TYPE;
998: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;

Line 996: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1037: UPDATE fnd_concurrent_programs SET

1033: RAISE bad_parameter;
1034: END IF;
1035:
1036: /* update incompatibilies */
1037: UPDATE fnd_concurrent_programs SET
1038: queue_method_code = 'B'
1039: WHERE ((application_id = application_id_i
1040: AND concurrent_program_id = concurrent_program_id_i)
1041: OR (application_id = to_run_application_id_i

Line 1349: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1352: BEGIN
1353: message_init;

Line 1418: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1421: BEGIN
1422: message_init;

Line 1462: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1466: prog_appl_short_name fnd_application.application_short_name%TYPE;

Line 1464: rs_flag fnd_concurrent_programs.request_set_flag%TYPE;

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;
1466: prog_appl_short_name fnd_application.application_short_name%TYPE;
1467:
1468: cursor req_cursor(appl_id number, prog_id number) is

Line 1488: FROM fnd_concurrent_programs

1484:
1485: BEGIN
1486: SELECT concurrent_program_id, request_set_flag
1487: INTO program_id, rs_flag
1488: FROM fnd_concurrent_programs
1489: WHERE application_id = program_application_id
1490: AND concurrent_program_name = program_short_name;
1491: EXCEPTION
1492: WHEN no_data_found THEN

Line 1585: DELETE fnd_concurrent_programs_tl

1581: WHERE to_run_concurrent_program_id = program_id
1582: AND to_run_application_id = program_application_id;
1583:
1584: -- Finally, delete the program
1585: DELETE fnd_concurrent_programs_tl
1586: WHERE application_id = program_application_id
1587: AND concurrent_program_id = program_id;
1588:
1589: DELETE fnd_concurrent_programs

Line 1589: DELETE fnd_concurrent_programs

1585: DELETE fnd_concurrent_programs_tl
1586: WHERE application_id = program_application_id
1587: AND concurrent_program_id = program_id;
1588:
1589: DELETE fnd_concurrent_programs
1590: WHERE concurrent_program_id = program_id
1591: AND application_id = program_application_id;
1592:
1593: -- Delete flex.

Line 1688: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1691: prog_appl_short_name fnd_application.application_short_name%TYPE;
1692:

Line 1783: from fnd_concurrent_programs

1779: select 'x' into dummy
1780: from sys.dual
1781: where not exists
1782: (select 1
1783: from fnd_concurrent_programs
1784: where executable_application_id = exec_application_id
1785: and executable_id = exec_id);
1786: EXCEPTION
1787: when no_data_found then

Line 1861: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1864: to_run_application_id_i fnd_application.application_id%TYPE;
1865: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;

Line 1863: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1899: update fnd_concurrent_programs

1895: and running_concurrent_program_id = to_run_concurrent_program_id_i;
1896:
1897: /* update incompatibilies */
1898: BEGIN
1899: update fnd_concurrent_programs
1900: set queue_method_code = 'I'
1901: WHERE application_id = application_id_i
1902: AND concurrent_program_id = concurrent_program_id_i
1903: AND NOT EXISTS

Line 1914: update fnd_concurrent_programs

1910: when no_data_found then null;
1911: END;
1912:
1913: BEGIN
1914: update fnd_concurrent_programs
1915: set queue_method_code = 'I'
1916: WHERE application_id = to_run_application_id_i
1917: AND concurrent_program_id = to_run_concurrent_program_id_i
1918: AND NOT EXISTS

Line 1960: fnd_concurrent_programs.concurrent_program_id%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:
1963: BEGIN
1964:

Line 1982: FROM fnd_concurrent_programs

1978: /* Make sure the concurrent program exists */
1979: BEGIN
1980: SELECT concurrent_program_id
1981: INTO concurrent_program_id_p
1982: FROM fnd_concurrent_programs
1983: WHERE application_id = application_id_p
1984: AND concurrent_program_name = upper(short_name);
1985:
1986: EXCEPTION

Line 1996: UPDATE fnd_concurrent_programs

1992: RETURN;
1993: END;
1994:
1995: /* Now go and update the concurrent program table */
1996: UPDATE fnd_concurrent_programs
1997: SET enabled_flag = enabled,
1998: last_update_date = last_update_date_p,
1999: last_updated_by = last_updated_by_p,
2000: last_update_login = last_update_login_p

Line 2026: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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:
2030: program_application_id := application_id_f(application);

Line 2059: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 2109: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
2113: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;

Line 2111: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
2113: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
2114: dummy varchar2(1);
2115:

Line 2239: concurrent_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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:
2243: BEGIN

Line 2452: from fnd_concurrent_programs FCP, fnd_executables FE

2448: program_application_id := application_id_f(program_application);
2449:
2450: select NTRUE
2451: into retval
2452: from fnd_concurrent_programs FCP, fnd_executables FE
2453: where FCP.concurrent_program_name = program_short_name
2454: and FCP.application_id = program_application_id
2455: and FCP.mls_executable_app_id is not null
2456: and FCP.mls_executable_id is not null