DBA Data[Home] [Help]

APPS.BIS_CONCURRENT_MANAGER_PVT dependencies on FND_CONCURRENT

Line 57: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;

53: )
54: IS
55:
56: l_request_id NUMBER;
57: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;
58: l_Param_Set_tbl BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;
59: l_phase VARCHAR2(32000);
60: l_status VARCHAR2(32000);
61: l_debug VARCHAR2(32000);

Line 89: l_request_status := FND_CONCURRENT.GET_REQUEST_STATUS

85: null;
86: END IF;
87:
88: FOR i IN 1..l_Concurrent_Request_tbl.COUNT LOOP
89: l_request_status := FND_CONCURRENT.GET_REQUEST_STATUS
90: ( request_id => l_Concurrent_Request_tbl(i).request_id
91: , phase => l_phase
92: , status => l_status
93: , dev_phase => l_dev_phase

Line 193: , x_Concurrent_Request_tbl OUT NOCOPY Fnd_Concurrent_Requests_Tbl

189:
190:
191: PROCEDURE Get_All_Requests
192: ( p_Param_Set_rec IN BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type
193: , x_Concurrent_Request_tbl OUT NOCOPY Fnd_Concurrent_Requests_Tbl
194: , x_return_status OUT NOCOPY VARCHAR2
195: )
196: IS
197:

Line 198: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;

194: , x_return_status OUT NOCOPY VARCHAR2
195: )
196: IS
197:
198: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;
199: l_Concurrent_Request_Rec Fnd_Concurrent_Requests%ROWTYPE;
200: l_target_level_rec bisbv_target_levels%ROWTYPE;
201: l_Concurrent_Program_ID NUMBER;
202: l_Application_ID NUMBER;

Line 199: l_Concurrent_Request_Rec Fnd_Concurrent_Requests%ROWTYPE;

195: )
196: IS
197:
198: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;
199: l_Concurrent_Request_Rec Fnd_Concurrent_Requests%ROWTYPE;
200: l_target_level_rec bisbv_target_levels%ROWTYPE;
201: l_Concurrent_Program_ID NUMBER;
202: l_Application_ID NUMBER;
203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;

Line 203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;

199: l_Concurrent_Request_Rec Fnd_Concurrent_Requests%ROWTYPE;
200: l_target_level_rec bisbv_target_levels%ROWTYPE;
201: l_Concurrent_Program_ID NUMBER;
202: l_Application_ID NUMBER;
203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;
204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;
205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;
206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code

Line 204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;

200: l_target_level_rec bisbv_target_levels%ROWTYPE;
201: l_Concurrent_Program_ID NUMBER;
202: l_Application_ID NUMBER;
203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;
204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;
205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;
206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code
208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;

Line 205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;

201: l_Concurrent_Program_ID NUMBER;
202: l_Application_ID NUMBER;
203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;
204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;
205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;
206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code
208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;
209: l_Resubmit_Interval_Type_Code

Line 206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;

202: l_Application_ID NUMBER;
203: l_request_ID Fnd_Concurrent_Requests.REQUEST_ID%TYPE;
204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;
205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;
206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code
208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;
209: l_Resubmit_Interval_Type_Code
210: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE;

Line 208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;

204: l_Resubmit_Time Fnd_Concurrent_Requests.RESUBMIT_TIME%TYPE;
205: l_Resubmit_End_Date Fnd_Concurrent_Requests.RESUBMIT_END_DATE%TYPE;
206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code
208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;
209: l_Resubmit_Interval_Type_Code
210: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE;
211:
212: l_count NUMBER := 0;

Line 210: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE;

206: l_Resubmit_Interval Fnd_Concurrent_Requests.RESUBMIT_INTERVAL%TYPE;
207: l_Resubmit_Interval_Unit_Code
208: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_UNIT_CODE%TYPE;
209: l_Resubmit_Interval_Type_Code
210: Fnd_Concurrent_Requests.RESUBMIT_INTERVAL_TYPE_CODE%TYPE;
211:
212: l_count NUMBER := 0;
213:
214: CURSOR cr_conc_req_tl IS

Line 216: FROM fnd_concurrent_requests

212: l_count NUMBER := 0;
213:
214: CURSOR cr_conc_req_tl IS
215: SELECT *
216: FROM fnd_concurrent_requests
217: WHERE Program_Application_ID = l_Application_ID
218: And Concurrent_Program_ID = l_Concurrent_Program_ID
219: and argument3 = p_param_set_rec.target_level_id
220: and argument5 = p_param_set_rec.plan_id

Line 245: FROM fnd_concurrent_requests

241: ;
242:
243: CURSOR cr_conc_req_meas IS
244: SELECT *
245: FROM fnd_concurrent_requests
246: WHERE Program_Application_ID = l_Application_ID
247: And Concurrent_Program_ID = l_Concurrent_Program_ID
248: and argument1 = p_param_set_rec.performance_measure_id
249: and (p_param_set_rec.TIME_DIMENSION_LEVEL_ID is null

Line 406: From Fnd_Concurrent_Programs P, Fnd_Application A

402: END IF;
403:
404: Select Concurrent_Program_ID, P.Application_ID
405: Into x_Concurrent_Program_ID, x_Application_ID
406: From Fnd_Concurrent_Programs P, Fnd_Application A
407: Where Concurrent_Program_Name = l_conc_program_name
408: And P.Application_ID = A.Application_ID
409: And A.Application_Short_Name
410: = BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;

Line 711: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;

707: , x_return_status OUT NOCOPY VARCHAR2
708: )
709: IS
710:
711: l_Concurrent_Request_tbl Fnd_Concurrent_Requests_tbl;
712: l_schedule_date VARCHAR2(32000) := NULL;
713: l_schedule_time VARCHAR2(32000) := NULL;
714: l_schedule_unit VARCHAR2(32000) := NULL;
715: l_schedule_freq VARCHAR2(32000) := NULL;

Line 746: l_request_status := FND_CONCURRENT.GET_REQUEST_STATUS

742: l_date_format := 'DD/MM/RRRR';
743: l_time_format := 'HH24:MI:SS';
744:
745: FOR i IN 1..l_Concurrent_Request_tbl.COUNT LOOP
746: l_request_status := FND_CONCURRENT.GET_REQUEST_STATUS
747: ( request_id => l_Concurrent_Request_tbl(i).request_id
748: , phase => l_phase
749: , status => l_status
750: , dev_phase => l_dev_phase