DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on FND_CONCURRENT_REQUESTS

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