DBA Data[Home] [Help]

APPS.MSC_ATP_24X7 dependencies on MRP_ATP_SCHEDULE_TEMP_S

Line 243: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

239:
240: -- CTO Re-arch, need to get session_id and pass to Get_Records_Post_Collections
241: -- Get Session ID
242: begin
243: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
244: into l_session_id
245: from dual;
246: exception
247: when others then

Line 435: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

431:
432: -- CTO Re-arch, need to get session_id and pass to Get_Records_Post_Collections
433: -- Get Session ID
434: begin
435: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
436: into l_session_id
437: from dual;
438: exception
439: when others then

Line 558: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL

554: l_session_id := -1;
555:
556: -- Get Session ID
557: begin
558: select MRP_ATP_SCHEDULE_TEMP_S.NEXTVAL
559: into l_session_id
560: from dual;
561: exception
562: when others then