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_PROGRAM_SERIAL

Line 998: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;

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:
1002: check_notnull(program_short_name);

Line 1045: INSERT INTO fnd_concurrent_program_serial(running_concurrent_program_id,

1041: OR (application_id = to_run_application_id_i
1042: AND concurrent_program_id = to_run_concurrent_program_id_i));
1043:
1044:
1045: INSERT INTO fnd_concurrent_program_serial(running_concurrent_program_id,
1046: running_application_id,
1047: running_type,
1048: to_run_concurrent_program_id,
1049: to_run_application_id,

Line 1076: INTO fnd_concurrent_program_serial(running_concurrent_program_id,

1072: OR
1073: (application_id_i <> to_run_application_id_i)) THEN
1074: BEGIN
1075: INSERT
1076: INTO fnd_concurrent_program_serial(running_concurrent_program_id,
1077: running_application_id,
1078: running_type,
1079: to_run_concurrent_program_id,
1080: to_run_application_id,

Line 1576: DELETE fnd_concurrent_program_serial

1572: end if;
1573:
1574: -- Delete the program's incompatibilities
1575:
1576: DELETE fnd_concurrent_program_serial
1577: WHERE running_concurrent_program_id = program_id
1578: AND running_application_id = program_application_id;
1579:
1580: DELETE fnd_concurrent_program_serial

Line 1580: DELETE fnd_concurrent_program_serial

1576: DELETE fnd_concurrent_program_serial
1577: WHERE running_concurrent_program_id = program_id
1578: AND running_application_id = program_application_id;
1579:
1580: DELETE fnd_concurrent_program_serial
1581: WHERE to_run_concurrent_program_id = program_id
1582: AND to_run_application_id = program_application_id;
1583:
1584: -- Finally, delete the program

Line 1865: scope_code_i fnd_concurrent_program_serial.to_run_type%TYPE;

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

Line 1885: delete from fnd_concurrent_program_serial

1881:
1882: to_run_concurrent_program_id_i :=
1883: concurrent_program_id_f(to_run_application_id_i, inc_prog_short_name);
1884:
1885: delete from fnd_concurrent_program_serial
1886: where to_run_application_id = to_run_application_id_i
1887: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
1888: and running_application_id = application_id_i
1889: and running_concurrent_program_id = concurrent_program_id_i;

Line 1891: delete from fnd_concurrent_program_serial

1887: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
1888: and running_application_id = application_id_i
1889: and running_concurrent_program_id = concurrent_program_id_i;
1890:
1891: delete from fnd_concurrent_program_serial
1892: where to_run_application_id = application_id_i
1893: and to_run_concurrent_program_id = concurrent_program_id_i
1894: and running_application_id = to_run_application_id_i
1895: and running_concurrent_program_id = to_run_concurrent_program_id_i;

Line 1905: from fnd_concurrent_program_serial

1901: WHERE application_id = application_id_i
1902: AND concurrent_program_id = concurrent_program_id_i
1903: AND NOT EXISTS
1904: (select 'x'
1905: from fnd_concurrent_program_serial
1906: where running_application_id = application_id_i
1907: and running_concurrent_program_id =
1908: concurrent_program_id_i);
1909: EXCEPTION

Line 1920: from fnd_concurrent_program_serial

1916: WHERE application_id = to_run_application_id_i
1917: AND concurrent_program_id = to_run_concurrent_program_id_i
1918: AND NOT EXISTS
1919: (select 'x'
1920: from fnd_concurrent_program_serial
1921: where running_application_id = to_run_application_id_i
1922: and running_concurrent_program_id =
1923: to_run_concurrent_program_id_i);
1924: EXCEPTION

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

Line 2130: from fnd_concurrent_program_serial

2126: concurrent_program_id_f(to_run_application_id_i, inc_prog_short_name);
2127:
2128: select 'Y'
2129: into dummy
2130: from fnd_concurrent_program_serial
2131: where to_run_application_id = to_run_application_id_i
2132: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
2133: and running_application_id = application_id_i
2134: and running_concurrent_program_id = concurrent_program_id_i;