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 257: From Fnd_Concurrent_Requests

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

Line 291: From Fnd_Concurrent_Requests R,

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

Line 649: update fnd_concurrent_requests_remote

645: l_status := do_set_status_autonomous.status;
646:
647: if ( interim ) then
648: if(upper(status) = 'W') then
649: update fnd_concurrent_requests_remote
650: set interim_status_code = 'W',
651: req_information = substrb(message,1,240)
652: where request_id = l_request_id;
653: else

Line 654: update fnd_concurrent_requests_remote

650: set interim_status_code = 'W',
651: req_information = substrb(message,1,240)
652: where request_id = l_request_id;
653: else
654: update fnd_concurrent_requests_remote
655: set interim_status_code = l_status,
656: completion_text = substrb(message, 1, 240)
657: where request_id = l_request_id;
658: end if;

Line 661: update fnd_concurrent_requests_remote

657: where request_id = l_request_id;
658: end if;
659:
660: else
661: update fnd_concurrent_requests_remote
662: set phase_code = 'C',
663: status_code = l_status,
664: completion_text = substrb(message, 1, 240)
665: where request_id = l_request_id;

Line 676: update fnd_concurrent_requests

672: else
673:
674: if ( interim ) then
675: if(upper(status) = 'W') then
676: update fnd_concurrent_requests
677: set interim_status_code = 'W',
678: req_information = substrb(message,1,240)
679: where request_id = do_set_status_autonomous.request_id;
680: --debug('updated req_information for request_id '|| do_set_status_autonomous.request_id);

Line 682: update fnd_concurrent_requests

678: req_information = substrb(message,1,240)
679: where request_id = do_set_status_autonomous.request_id;
680: --debug('updated req_information for request_id '|| do_set_status_autonomous.request_id);
681: else
682: update fnd_concurrent_requests
683: set interim_status_code = do_set_status_autonomous.status,
684: completion_text = substrb(message, 1, 240)
685: where request_id = do_set_status_autonomous.request_id;
686: --debug('updated completion_text for request_id '|| do_set_status_autonomous.request_id);

Line 690: update fnd_concurrent_requests

686: --debug('updated completion_text for request_id '|| do_set_status_autonomous.request_id);
687: end if;
688:
689: else
690: update fnd_concurrent_requests
691: set phase_code = 'C',
692: status_code = do_set_status_autonomous.status,
693: completion_text = substrb(message, 1, 240)
694: where request_id = do_set_status_autonomous.request_id;

Line 813: from fnd_concurrent_requests r

809: save_output_flag OUT NOCOPY varchar2) return boolean is
810: begin
811: select number_of_copies, print_style, printer, save_output_flag
812: into number_of_copies, print_style, printer, save_output_flag
813: from fnd_concurrent_requests r
814: where r.request_id = get_request_print_options.request_id;
815:
816: return TRUE;
817:

Line 848: from fnd_concurrent_requests r,

844: counter number := 0;
845: cursor c1 is
846: select p.number_of_copies, r.print_style,
847: p.arguments, r.save_output_flag
848: from fnd_concurrent_requests r,
849: fnd_conc_pp_actions p
850: where r.request_id = p.concurrent_request_id
851: and p.action_type = 1
852: and p.concurrent_request_id = get_request_print_options.request_id

Line 1069: update fnd_concurrent_requests_remote

1065: and s.sid = m.sid;
1066:
1067: l_request_id := fnd_global.conc_request_id;
1068:
1069: update fnd_concurrent_requests_remote
1070: set ORACLE_SESSION_ID = csid,
1071: ORACLE_PROCESS_ID = csspid,
1072: OS_PROCESS_ID = cspid,
1073: NLS_CodeSet = codeset

Line 1088: update fnd_concurrent_requests

1084: From V$Session S, V$Process P
1085: Where P.Addr = S.Paddr
1086: and S.AUDSID = userenv('SESSIONID');
1087:
1088: update fnd_concurrent_requests
1089: set ORACLE_SESSION_ID = csid,
1090: ORACLE_PROCESS_ID = csspid,
1091: OS_PROCESS_ID = cspid,
1092: NLS_CodeSet = codeset

Line 1110: FND_CONCURRENT_REQUESTS R

1106: multi_org_category, org_id, p.application_id
1107: into optmode, program_name, ptrace, rtrace, etstat, emethod,
1108: morg_cat, orgid, temp
1109: from FND_CONCURRENT_PROGRAMS P,
1110: FND_CONCURRENT_REQUESTS R
1111: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1112: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1113: And R.request_id = fnd_global.conc_request_id;
1114: exception

Line 1135: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R

1131: end if;
1132:
1133: Select plsql_log, plsql_out, plsql_dir
1134: Into plog, pout, pdir
1135: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1136: Where P.Concurrent_Process_ID = R.Controlling_Manager
1137: And R.Request_ID = fnd_global.conc_request_id;
1138:
1139: fnd_file.put_names(plog, pout, pdir);

Line 1158: from fnd_concurrent_requests r,

1154: 'Concurrent Request');
1155: begin
1156: select Q.RESOURCE_CONSUMER_GROUP
1157: into que_rcg
1158: from fnd_concurrent_requests r,
1159: fnd_concurrent_processes p,
1160: fnd_concurrent_queues q
1161: where R.request_id = fnd_global.conc_request_id
1162: and R.controlling_manager = P.concurrent_process_id

Line 1174: fnd_concurrent_requests R

1170: begin
1171: select p.RESOURCE_CONSUMER_GROUP
1172: into prg_rcg
1173: from fnd_concurrent_programs P,
1174: fnd_concurrent_requests R
1175: where R.request_id = fnd_global.conc_request_id
1176: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1177: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;
1178: exception

Line 1246: FND_CONCURRENT_REQUESTS R

1242: begin
1243: select P.Rollback_Segment
1244: into RBS
1245: from FND_CONCURRENT_PROGRAMS P,
1246: FND_CONCURRENT_REQUESTS R
1247: WHERE R.request_id = fnd_global.conc_request_id
1248: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1249: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;
1250:

Line 1466: -- Table FND_CONCURRENT.REQUESTS_TAB_TYPE.

1462: -- Arguments (input)
1463: -- request_id - Request Id for which sub-requests are required.
1464: --
1465: -- Returns:
1466: -- Table FND_CONCURRENT.REQUESTS_TAB_TYPE.
1467: --
1468:
1469: function get_sub_requests( p_request_id IN number)
1470: return requests_tab_type is

Line 1476: From Fnd_Concurrent_Requests R,

1472: Select Request_Id, Completion_Text,
1473: Phase.Lookup_Code p_lookup_code,
1474: Status.Lookup_Code s_lookup_code,
1475: Phase.Meaning p_meaning, Status.Meaning s_meaning
1476: From Fnd_Concurrent_Requests R,
1477: Fnd_Concurrent_programs P,
1478: Fnd_Lookups Phase,
1479: Fnd_Lookups Status
1480: Where

Line 1555: from fnd_concurrent_requests

1551: time_left number;
1552: parent_req_id number;
1553: cursor kidslist(parent_id number) is
1554: Select request_id
1555: from fnd_concurrent_requests
1556: where parent_request_id = parent_id;
1557:
1558: begin
1559: Select sysdate + (greatest(Max_Wait, 0)/86400)

Line 1571: from fnd_concurrent_requests

1567: if (parent_req_id = -1) then return TRUE; end if;
1568:
1569: LOOP
1570: Select count(*) into kount
1571: from fnd_concurrent_requests
1572: where parent_request_id = parent_req_id
1573: and phase_code <> 'C';
1574:
1575: if (kount = 0) AND (Recursive_Flag = 'Y') then -- check for kids

Line 1876: from fnd_concurrent_requests R

1872: ugly piece of coding where we decipher if we have a hit */
1873:
1874: select argument1, argument2, argument3
1875: into rarg1, rarg2, rarg3
1876: from fnd_concurrent_requests R
1877: where requestid = R.request_id;
1878:
1879: /* CASE positive : old style requests */
1880: if (rarg1 >= 0) then

Line 1966: from fnd_concurrent_requests R

1962: ugly piece of coding where we decipher if we have a hit */
1963:
1964: select argument1, argument2, argument3
1965: into rarg1, rarg2, rarg3
1966: from fnd_concurrent_requests R
1967: where requestid = R.request_id;
1968:
1969: /* CASE positive : old style requests */
1970: if ((rarg1 >= 0) and (rarg1 = que_id) and (rarg2 = app_id)) then

Line 2039: from fnd_concurrent_requests R, fnd_concurrent_programs P

2035: my_service_id number := service_id;
2036:
2037: Cursor C1 IS
2038: Select request_id
2039: from fnd_concurrent_requests R, fnd_concurrent_programs P
2040: where r.phase_code = 'P'
2041: and p.application_id = r.PROGRAM_APPLICATION_ID
2042: and p.concurrent_program_id = r.concurrent_program_id
2043: and p.queue_control_flag = 'Y'

Line 2094: from fnd_concurrent_requests R1,

2090: kount number := 0;
2091:
2092: Cursor C1 IS
2093: Select R2.request_id
2094: from fnd_concurrent_requests R1,
2095: fnd_concurrent_requests R2,
2096: fnd_concurrent_programs P1,
2097: fnd_concurrent_programs P2,
2098: fnd_concurrent_queues Q,

Line 2095: fnd_concurrent_requests R2,

2091:
2092: Cursor C1 IS
2093: Select R2.request_id
2094: from fnd_concurrent_requests R1,
2095: fnd_concurrent_requests R2,
2096: fnd_concurrent_programs P1,
2097: fnd_concurrent_programs P2,
2098: fnd_concurrent_queues Q,
2099: fnd_application A

Line 2256: from fnd_concurrent_requests

2252: select concurrent_program_id, program_application_id, phase_code,
2253: argument1, argument2, argument3, Decode(concurrent_program_id,
2254: 0,null, 1,'E', 3, null, 4, 'X', 5, 'E', 7, 'P', 8, null, null)
2255: into prog_id, r_app_id, r_phase, rarg1, rarg2, rarg3, goal_state
2256: from fnd_concurrent_requests
2257: where request_id = reqid;
2258: exception
2259: when others then
2260: return SCTL_REQ_NOT_FOUND;

Line 2295: from fnd_concurrent_requests

2291:
2292: /* have we run yet? */
2293: select decode(phase_code, 'C', 0, -1)
2294: into Done
2295: from fnd_concurrent_requests
2296: where request_id = reqid;
2297:
2298: if ((timesup > 0) and (Done = 0)) then
2299: return SCTL_TIMEOUT_NOT_C;

Line 2536: from fnd_concurrent_requests

2532: -- check this user got privilege to cancel request
2533: begin
2534: Select Requested_By
2535: into submitter
2536: from fnd_concurrent_requests
2537: where request_id = Cancel_Request.request_id;
2538: exception
2539: when no_data_found then
2540: raise request_missing;

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

2711: lmachine v$session.machine%type;
2712: position number;
2713: begin
2714:
2715: -- Select all the information needed for this request from fnd_concurrent_requests,
2716: -- using the fnd_cp_sql_requests table.
2717: -- A row should have been inserted earlier in usdspid, containing the current request id,
2718: -- machine name, and process id.
2719: -- By joining these tables with v$session, we can pull out all the information we need,

Line 2747: from fnd_concurrent_requests fcr,

2743: fcr.request_id, fcr.priority_request_id
2744: into session_id, userid, respid, respappid,
2745: secgrpid, siteid, loginid, cloginid,
2746: progappid, cprogid, creqid, cprireqid
2747: from fnd_concurrent_requests fcr,
2748: fnd_cp_sql_requests sr
2749: where fcr.phase_code = 'R'
2750: and fcr.status_code = 'R'
2751: and fcr.request_id = sr.request_id