APPS.WMS_LMS_UTILS dependencies on FND_CONCURRENT_REQUESTS

Line 1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1110: select ARGUMENT2,ARGUMENT3,
1111: ARGUMENT4,ARGUMENT5
1112: into l_argument2,l_argument3,
1113: l_argument4,l_argument5
1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1115: and request_id = (select Max(Request_ID)
1116: From Fnd_Concurrent_Requests
1117: Where Concurrent_Program_ID = p_concurrent_program_id
1118: AND PHASE_CODE = 'C' and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746

Line 1116: From Fnd_Concurrent_Requests

1112: into l_argument2,l_argument3,
1113: l_argument4,l_argument5
1114: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1115: and request_id = (select Max(Request_ID)
1116: From Fnd_Concurrent_Requests
1117: Where Concurrent_Program_ID = p_concurrent_program_id
1118: AND PHASE_CODE = 'C' and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1119:
1120: IF g_debug=1 THEN

Line 1181: from fnd_concurrent_requests

1177:
1178: l_next_scheduled_date:= NULL;
1179:
1180: select min(requested_start_date) into l_next_scheduled_date
1181: from fnd_concurrent_requests
1182: where concurrent_program_id = p_concurrent_program_id
1183: and program_application_id = p_application_id
1184: and phase_code = 'P'
1185: and STATUS_CODE IN ( 'I','Q')

Line 1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1227:
1228:
1229: select actual_completion_date
1230: into l_actual_completion_date
1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1232: and request_id = (select Max(Request_ID)
1233: From Fnd_Concurrent_Requests
1234: Where Concurrent_Program_ID = p_concurrent_program_id
1235: AND PHASE_CODE = 'C'

Line 1233: From Fnd_Concurrent_Requests

1229: select actual_completion_date
1230: into l_actual_completion_date
1231: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1232: and request_id = (select Max(Request_ID)
1233: From Fnd_Concurrent_Requests
1234: Where Concurrent_Program_ID = p_concurrent_program_id
1235: AND PHASE_CODE = 'C'
1236: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1237:

Line 1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)

1273:
1274:
1275: select actual_completion_date
1276: into l_actual_completion_date
1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1278: and request_id = (select Max(Request_ID)
1279: From Fnd_Concurrent_Requests
1280: Where Concurrent_Program_ID = p_concurrent_program_id
1281: AND PHASE_CODE = 'C'

Line 1279: From Fnd_Concurrent_Requests

1275: select actual_completion_date
1276: into l_actual_completion_date
1277: from fnd_concurrent_requests where argument1 = to_char(p_org_id)
1278: and request_id = (select Max(Request_ID)
1279: From Fnd_Concurrent_Requests
1280: Where Concurrent_Program_ID = p_concurrent_program_id
1281: AND PHASE_CODE = 'C'
1282: AND STATUS_CODE = 'C'
1283: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746

Line 1321: from fnd_concurrent_requests fcr, fnd_lookups fl

1317:
1318:
1319: select fl.meaning
1320: into l_last_run_status
1321: from fnd_concurrent_requests fcr, fnd_lookups fl
1322: where argument1 = to_char(p_org_id)
1323: and fl.lookup_code = fcr.status_code
1324: and fl.Lookup_type = 'CP_STATUS_CODE'
1325: and request_id = (select Max(Request_ID)

Line 1326: from Fnd_Concurrent_Requests

1322: where argument1 = to_char(p_org_id)
1323: and fl.lookup_code = fcr.status_code
1324: and fl.Lookup_type = 'CP_STATUS_CODE'
1325: and request_id = (select Max(Request_ID)
1326: from Fnd_Concurrent_Requests
1327: where Concurrent_Program_ID = p_concurrent_program_id
1328: AND PHASE_CODE = 'C'
1329: and argument1 = to_char(p_org_id)); -- added this condition for bug 5478746
1330: