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.CST_SLA_UPDATE_PKG dependencies on FND_CONCURRENT

Line 90: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', X_errbuf);

86: l_stmt_num := 20;
87:
88: --Set the Concurrent Request as Error, depending upon the parameter
89: IF X_reqerror THEN
90: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', X_errbuf);
91: END IF;
92:
93: ELSE --Hot Patch
94:

Line 156: l_sub_reqtab fnd_concurrent.requests_tab_type;

152: l_inv_req_id number;
153: l_wip_req_id number;
154: l_rcv_req_id number;
155:
156: l_sub_reqtab fnd_concurrent.requests_tab_type;
157: l_req_status boolean := TRUE;
158: l_subreq_wait boolean := TRUE;
159:
160: l_reqid_count number;

Line 191: FROM fnd_concurrent_requests fcr,

187: l_reqid_count := 0;
188:
189: SELECT min(fcr.request_id)
190: into l_reqid_count
191: FROM fnd_concurrent_requests fcr,
192: fnd_concurrent_programs fcp
193: WHERE fcp.concurrent_program_name IN ('CSTSLAUM')
194: AND fcp.application_id = 702
195: AND fcr.concurrent_program_id = fcp.concurrent_program_id

Line 192: fnd_concurrent_programs fcp

188:
189: SELECT min(fcr.request_id)
190: into l_reqid_count
191: FROM fnd_concurrent_requests fcr,
192: fnd_concurrent_programs fcp
193: WHERE fcp.concurrent_program_name IN ('CSTSLAUM')
194: AND fcp.application_id = 702
195: AND fcr.concurrent_program_id = fcp.concurrent_program_id
196: AND fcr.program_application_id = fcp.application_id

Line 282: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(1).request_id,

278: dbms_lock.sleep(100); --Sleep for 100 seconds
279:
280: IF X_Application_Id = 401 THEN
281: l_sub_reqtab(1).request_id := l_inv_req_id;
282: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(1).request_id,
283: phase => l_sub_reqtab(1).phase,
284: status => l_sub_reqtab(1).status,
285: dev_phase => l_sub_reqtab(1).dev_phase,
286: dev_status => l_sub_reqtab(1).dev_status,

Line 289: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(2).request_id,

285: dev_phase => l_sub_reqtab(1).dev_phase,
286: dev_status => l_sub_reqtab(1).dev_status,
287: message => l_sub_reqtab(1).message);
288: l_sub_reqtab(2).request_id := l_wip_req_id;
289: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(2).request_id,
290: phase => l_sub_reqtab(2).phase,
291: status => l_sub_reqtab(2).status,
292: dev_phase => l_sub_reqtab(2).dev_phase,
293: dev_status => l_sub_reqtab(2).dev_status,

Line 299: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(1).request_id,

295:
296:
297: ELSIF X_Application_Id = 201 THEN
298: l_sub_reqtab(1).request_id := l_rcv_req_id;
299: l_req_status := fnd_concurrent.get_request_status(request_id => l_sub_reqtab(1).request_id,
300: phase => l_sub_reqtab(1).phase,
301: status => l_sub_reqtab(1).status,
302: dev_phase => l_sub_reqtab(1).dev_phase,
303: dev_status => l_sub_reqtab(1).dev_status,

Line 429: l_sub_reqtab fnd_concurrent.requests_tab_type;

425: l_inv_req_id number;
426: l_wip_req_id number;
427: l_rcv_req_id number;
428:
429: l_sub_reqtab fnd_concurrent.requests_tab_type;
430: req_data varchar2(10);
431: submit_req boolean;
432:
433: l_prg_appid number;

Line 479: FROM fnd_concurrent_requests fcr,

475: l_reqid_count := 0;
476:
477: SELECT min(fcr.request_id)
478: into l_reqid_count
479: FROM fnd_concurrent_requests fcr,
480: fnd_concurrent_programs fcp
481: WHERE fcp.concurrent_program_name = l_program_name
482: AND fcp.application_id = l_prg_appid
483: AND fcr.concurrent_program_id = fcp.concurrent_program_id

Line 480: fnd_concurrent_programs fcp

476:
477: SELECT min(fcr.request_id)
478: into l_reqid_count
479: FROM fnd_concurrent_requests fcr,
480: fnd_concurrent_programs fcp
481: WHERE fcp.concurrent_program_name = l_program_name
482: AND fcp.application_id = l_prg_appid
483: AND fcr.concurrent_program_id = fcp.concurrent_program_id
484: AND fcr.program_application_id = fcp.application_id

Line 584: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

580: --
581: -- restart case
582: --
583: l_stmt_num :=50;
584: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
585: x_retcode := FND_API.G_RET_STS_SUCCESS;
586:
587: for i IN 1..l_sub_reqtab.COUNT()
588: loop

Line 689: l_sub_reqtab fnd_concurrent.requests_tab_type;

685:
686: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_INV_MGR';
687: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
688:
689: l_sub_reqtab fnd_concurrent.requests_tab_type;
690: req_data varchar2(10);
691: submit_req boolean;
692:
693: l_stmt_num number;

Line 799: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

795: end if;
796:
797: l_stmt_num :=30;
798:
799: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
800:
801: for i IN 1..l_sub_reqtab.COUNT() loop
802: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> INV Worker [CSTUINVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
803: end loop;

Line 824: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

820: --
821: -- restart case
822: --
823: l_stmt_num :=40;
824: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
825:
826: x_retcode := FND_API.G_RET_STS_SUCCESS;
827: for i IN 1..l_sub_reqtab.COUNT()
828: loop

Line 928: l_sub_reqtab fnd_concurrent.requests_tab_type;

924:
925: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_WIP_MGR';
926: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
927:
928: l_sub_reqtab fnd_concurrent.requests_tab_type;
929: req_data varchar2(10);
930: submit_req boolean;
931:
932: l_stmt_num number;

Line 1038: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

1034: end if;
1035:
1036: l_stmt_num :=30;
1037:
1038: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1039:
1040: for i IN 1..l_sub_reqtab.COUNT() loop
1041: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> WIP Worker [CSTUWIPW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
1042: end loop;

Line 1062: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

1058: --
1059: -- restart case
1060: --
1061: l_stmt_num :=40;
1062: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1063:
1064: x_retcode := FND_API.G_RET_STS_SUCCESS;
1065: for i IN 1..l_sub_reqtab.COUNT()
1066: loop

Line 1166: l_sub_reqtab fnd_concurrent.requests_tab_type;

1162:
1163: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_SLA_UPDATE_PKG.Update_Proc_RCV_MGR';
1164: l_Log CONSTANT BOOLEAN := fnd_log.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1165:
1166: l_sub_reqtab fnd_concurrent.requests_tab_type;
1167: req_data varchar2(10);
1168: submit_req boolean;
1169:
1170: l_stmt_num number;

Line 1276: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

1272: end if;
1273:
1274: l_stmt_num :=30;
1275:
1276: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1277:
1278: for i IN 1..l_sub_reqtab.COUNT() loop
1279: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')||'> RCV Worker [CSTURCVW] '||RPAD(i,2)||' - '||l_sub_reqtab(i).request_id);
1280: end loop;

Line 1300: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);

1296: --
1297: -- restart case
1298: --
1299: l_stmt_num :=40;
1300: l_sub_reqtab := fnd_concurrent.get_sub_requests(gRequestId);
1301:
1302: x_retcode := FND_API.G_RET_STS_SUCCESS;
1303: for i IN 1..l_sub_reqtab.COUNT()
1304: loop