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_CONCURRENT dependencies on FND_CONCURRENT_REQUESTS

Line 255: From Fnd_Concurrent_Requests

251: --
252: begin
253: Select Max(Request_ID)
254: Into Req_ID
255: From Fnd_Concurrent_Requests
256: Where Program_Application_ID = Prog_Appl_ID
257: And Concurrent_Program_ID = Program_ID;
258: --
259: -- If No rows returned, then return message saying there are no

Line 289: From Fnd_Concurrent_Requests R,

285: Phase.Meaning, Status.Meaning
286: Into req_phase, req_status, comptext,
287: phase_code, status_code,
288: phasem, statusm
289: From Fnd_Concurrent_Requests R,
290: Fnd_Concurrent_programs P,
291: Fnd_Lookups Phase,
292: Fnd_Lookups Status
293: Where

Line 638: update fnd_concurrent_requests

634: PRAGMA AUTONOMOUS_TRANSACTION;
635: begin
636: if ( interim ) then
637: if(upper(status) = 'W') then
638: update fnd_concurrent_requests
639: set interim_status_code = 'W',
640: req_information = substrb(message,1,240)
641: where request_id = set_status_autonomous.request_id;
642: --debug('updated req_information for request_id '|| set_status_autonomous.request_id);

Line 644: update fnd_concurrent_requests

640: req_information = substrb(message,1,240)
641: where request_id = set_status_autonomous.request_id;
642: --debug('updated req_information for request_id '|| set_status_autonomous.request_id);
643: else
644: update fnd_concurrent_requests
645: set interim_status_code = set_status_autonomous.status,
646: completion_text = substrb(message, 1, 240)
647: where request_id = set_status_autonomous.request_id;
648: --debug('updated completion_text for request_id '|| set_status_autonomous.request_id);

Line 652: update fnd_concurrent_requests

648: --debug('updated completion_text for request_id '|| set_status_autonomous.request_id);
649: end if;
650:
651: else
652: update fnd_concurrent_requests
653: set phase_code = 'C',
654: status_code = set_status_autonomous.status,
655: completion_text = substrb(message, 1, 240)
656: where request_id = set_status_autonomous.request_id;

Line 744: from fnd_concurrent_requests r

740: save_output_flag OUT NOCOPY varchar2) return boolean is
741: begin
742: select number_of_copies, print_style, printer, save_output_flag
743: into number_of_copies, print_style, printer, save_output_flag
744: from fnd_concurrent_requests r
745: where r.request_id = get_request_print_options.request_id;
746:
747: return TRUE;
748:

Line 779: from fnd_concurrent_requests r,

775: counter number := 0;
776: cursor c1 is
777: select p.number_of_copies, r.print_style,
778: p.arguments, r.save_output_flag
779: from fnd_concurrent_requests r,
780: fnd_conc_pp_actions p
781: where r.request_id = p.concurrent_request_id
782: and p.action_type = 1
783: and p.concurrent_request_id = get_request_print_options.request_id

Line 989: update fnd_concurrent_requests

985: From V$Session S, V$Process P
986: Where P.Addr = S.Paddr
987: and S.AUDSID = userenv('SESSIONID');
988:
989: update fnd_concurrent_requests
990: set ORACLE_SESSION_ID = csid,
991: ORACLE_PROCESS_ID = csspid,
992: OS_PROCESS_ID = cspid,
993: NLS_CodeSet = codeset

Line 1010: FND_CONCURRENT_REQUESTS R

1006: multi_org_category, org_id
1007: into optmode, program_name, ptrace, rtrace, etstat, emethod,
1008: morg_cat, orgid
1009: from FND_CONCURRENT_PROGRAMS P,
1010: FND_CONCURRENT_REQUESTS R
1011: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1012: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1013: And R.request_id = fnd_global.conc_request_id;
1014: exception

Line 1030: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R

1026: end if;
1027:
1028: Select plsql_log, plsql_out, plsql_dir
1029: Into plog, pout, pdir
1030: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1031: Where P.Concurrent_Process_ID = R.Controlling_Manager
1032: And R.Request_ID = fnd_global.conc_request_id;
1033:
1034: fnd_file.put_names(plog, pout, pdir);

Line 1053: from fnd_concurrent_requests r,

1049: 'Concurrent Request');
1050: begin
1051: select Q.RESOURCE_CONSUMER_GROUP
1052: into que_rcg
1053: from fnd_concurrent_requests r,
1054: fnd_concurrent_processes p,
1055: fnd_concurrent_queues q
1056: where R.request_id = fnd_global.conc_request_id
1057: and R.controlling_manager = P.concurrent_process_id

Line 1069: fnd_concurrent_requests R

1065: begin
1066: select p.RESOURCE_CONSUMER_GROUP
1067: into prg_rcg
1068: from fnd_concurrent_programs P,
1069: fnd_concurrent_requests R
1070: where R.request_id = fnd_global.conc_request_id
1071: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1072: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;
1073: exception

Line 1137: FND_CONCURRENT_REQUESTS R

1133: begin
1134: select P.Rollback_Segment
1135: into RBS
1136: from FND_CONCURRENT_PROGRAMS P,
1137: FND_CONCURRENT_REQUESTS R
1138: WHERE R.request_id = fnd_global.conc_request_id
1139: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1140: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;
1141:

Line 1357: -- Table FND_CONCURRENT.REQUESTS_TAB_TYPE.

1353: -- Arguments (input)
1354: -- request_id - Request Id for which sub-requests are required.
1355: --
1356: -- Returns:
1357: -- Table FND_CONCURRENT.REQUESTS_TAB_TYPE.
1358: --
1359:
1360: function get_sub_requests( p_request_id IN number)
1361: return requests_tab_type is

Line 1367: From Fnd_Concurrent_Requests R,

1363: Select Request_Id, Completion_Text,
1364: Phase.Lookup_Code p_lookup_code,
1365: Status.Lookup_Code s_lookup_code,
1366: Phase.Meaning p_meaning, Status.Meaning s_meaning
1367: From Fnd_Concurrent_Requests R,
1368: Fnd_Concurrent_programs P,
1369: Fnd_Lookups Phase,
1370: Fnd_Lookups Status
1371: Where

Line 1446: from fnd_concurrent_requests

1442: time_left number;
1443: parent_req_id number;
1444: cursor kidslist(parent_id number) is
1445: Select request_id
1446: from fnd_concurrent_requests
1447: where parent_request_id = parent_id;
1448:
1449: begin
1450: Select sysdate + (greatest(Max_Wait, 0)/86400)

Line 1462: from fnd_concurrent_requests

1458: if (parent_req_id = -1) then return TRUE; end if;
1459:
1460: LOOP
1461: Select count(*) into kount
1462: from fnd_concurrent_requests
1463: where parent_request_id = parent_req_id
1464: and phase_code <> 'C';
1465:
1466: if (kount = 0) AND (Recursive_Flag = 'Y') then -- check for kids

Line 1767: from fnd_concurrent_requests R

1763: ugly piece of coding where we decipher if we have a hit */
1764:
1765: select argument1, argument2, argument3
1766: into rarg1, rarg2, rarg3
1767: from fnd_concurrent_requests R
1768: where requestid = R.request_id;
1769:
1770: /* CASE positive : old style requests */
1771: if (rarg1 >= 0) then

Line 1857: from fnd_concurrent_requests R

1853: ugly piece of coding where we decipher if we have a hit */
1854:
1855: select argument1, argument2, argument3
1856: into rarg1, rarg2, rarg3
1857: from fnd_concurrent_requests R
1858: where requestid = R.request_id;
1859:
1860: /* CASE positive : old style requests */
1861: if ((rarg1 >= 0) and (rarg1 = que_id) and (rarg2 = app_id)) then

Line 1930: from fnd_concurrent_requests R, fnd_concurrent_programs P

1926: my_service_id number := service_id;
1927:
1928: Cursor C1 IS
1929: Select request_id
1930: from fnd_concurrent_requests R, fnd_concurrent_programs P
1931: where r.phase_code = 'P'
1932: and p.application_id = r.PROGRAM_APPLICATION_ID
1933: and p.concurrent_program_id = r.concurrent_program_id
1934: and p.queue_control_flag = 'Y'

Line 1985: from fnd_concurrent_requests R1,

1981: kount number := 0;
1982:
1983: Cursor C1 IS
1984: Select R2.request_id
1985: from fnd_concurrent_requests R1,
1986: fnd_concurrent_requests R2,
1987: fnd_concurrent_programs P1,
1988: fnd_concurrent_programs P2,
1989: fnd_concurrent_queues Q,

Line 1986: fnd_concurrent_requests R2,

1982:
1983: Cursor C1 IS
1984: Select R2.request_id
1985: from fnd_concurrent_requests R1,
1986: fnd_concurrent_requests R2,
1987: fnd_concurrent_programs P1,
1988: fnd_concurrent_programs P2,
1989: fnd_concurrent_queues Q,
1990: fnd_application A

Line 2147: from fnd_concurrent_requests

2143: select concurrent_program_id, program_application_id, phase_code,
2144: argument1, argument2, argument3, Decode(concurrent_program_id,
2145: 0,null, 1,'E', 3, null, 4, 'X', 5, 'E', 7, 'P', 8, null, null)
2146: into prog_id, r_app_id, r_phase, rarg1, rarg2, rarg3, goal_state
2147: from fnd_concurrent_requests
2148: where request_id = reqid;
2149: exception
2150: when others then
2151: return SCTL_REQ_NOT_FOUND;

Line 2186: from fnd_concurrent_requests

2182:
2183: /* have we run yet? */
2184: select decode(phase_code, 'C', 0, -1)
2185: into Done
2186: from fnd_concurrent_requests
2187: where request_id = reqid;
2188:
2189: if ((timesup > 0) and (Done = 0)) then
2190: return SCTL_TIMEOUT_NOT_C;

Line 2427: from fnd_concurrent_requests

2423: -- check this user got privilege to cancel request
2424: begin
2425: Select Requested_By
2426: into submitter
2427: from fnd_concurrent_requests
2428: where request_id = Cancel_Request.request_id;
2429: exception
2430: when no_data_found then
2431: raise request_missing;

Line 2606: -- Select all the information needed for this request from fnd_concurrent_requests,

2602: lmachine v$session.machine%type;
2603: position number;
2604: begin
2605:
2606: -- Select all the information needed for this request from fnd_concurrent_requests,
2607: -- using the fnd_cp_sql_requests table.
2608: -- A row should have been inserted earlier in usdspid, containing the current request id,
2609: -- machine name, and process id.
2610: -- By joining these tables with v$session, we can pull out all the information we need,

Line 2638: from fnd_concurrent_requests fcr,

2634: fcr.request_id, fcr.priority_request_id
2635: into session_id, userid, respid, respappid,
2636: secgrpid, siteid, loginid, cloginid,
2637: progappid, cprogid, creqid, cprireqid
2638: from fnd_concurrent_requests fcr,
2639: fnd_cp_sql_requests sr
2640: where fcr.phase_code = 'R'
2641: and fcr.status_code = 'R'
2642: and fcr.request_id = sr.request_id