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 226: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 230: FROM fnd_concurrent_programs

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

Line 301: srs_flag_i fnd_concurrent_programs.srs_flag%TYPE;

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 */
303: BEGIN
304: SELECT srs_flag
305: INTO srs_flag_i

Line 306: FROM fnd_concurrent_programs

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

Line 414: from fnd_concurrent_programs

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

Line 499: UPDATE fnd_concurrent_programs

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

Line 607: fnd_concurrent_programs.argument_method_code%TYPE;

603: := created_by_f;
604: execution_method_code_i
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;

Line 611: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

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

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

Line 853: INSERT INTO fnd_concurrent_programs(

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

Line 888: insert into FND_CONCURRENT_PROGRAMS_TL (

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

Line 904: from FND_CONCURRENT_PROGRAMS_TL T

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

Line 991: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 993: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1034: UPDATE fnd_concurrent_programs SET

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

Line 1346: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1349: BEGIN
1350: message_init;

Line 1415: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
1418: BEGIN
1419: message_init;

Line 1459: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1461: rs_flag fnd_concurrent_programs.request_set_flag%TYPE;

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

Line 1485: FROM fnd_concurrent_programs

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

Line 1582: DELETE fnd_concurrent_programs_tl

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

Line 1586: DELETE fnd_concurrent_programs

1582: DELETE fnd_concurrent_programs_tl
1583: WHERE application_id = program_application_id
1584: AND concurrent_program_id = program_id;
1585:
1586: DELETE fnd_concurrent_programs
1587: WHERE concurrent_program_id = program_id
1588: AND application_id = program_application_id;
1589:
1590: -- Delete flex.

Line 1685: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1780: from fnd_concurrent_programs

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

Line 1858: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1860: fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 1896: update fnd_concurrent_programs

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

Line 1911: update fnd_concurrent_programs

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

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

Line 1979: FROM fnd_concurrent_programs

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

Line 1993: UPDATE fnd_concurrent_programs

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

Line 2023: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 2056: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 2106: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;

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

Line 2108: fnd_concurrent_programs.concurrent_program_id%TYPE;

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;
2110: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;
2111: dummy varchar2(1);
2112:

Line 2236: concurrent_program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

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