APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_OP_INSTANCE_S

Line 501: SELECT WMS_OP_INSTANCE_S.NEXTVAL

497: END IF;
498:
499: END IF;/*Activity Inbound*/
500:
501: SELECT WMS_OP_INSTANCE_S.NEXTVAL
502: INTO l_op_plan_instance_rec.op_plan_instance_id
503: FROM dual;
504:
505: l_op_plan_instance_rec.operation_plan_id := l_operation_plan_id;

Line 5861: SELECT WMS_OP_INSTANCE_S.NEXTVAL

5857: --l_wopi_source_task_idsplit_rec.status := l_wopi_orig_rec.status;
5858:
5859: l_progress := 160;
5860: --use sequence to generate op_plan_instance_id
5861: SELECT WMS_OP_INSTANCE_S.NEXTVAL
5862: INTO l_wopi_split_rec.op_plan_instance_id
5863: FROM dual;
5864: l_progress := 170;
5865: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table

Line 6193: SELECT wms_op_instance_s.NEXTVAL

6189:
6190: l_wooi_new_rec.op_plan_instance_id := l_wopi_split_rec.op_plan_instance_id;
6191: l_progress := 210;
6192: --Call wms_op_operation_instances table handler to insert the record
6193: SELECT wms_op_instance_s.NEXTVAL
6194: INTO l_wooi_new_rec.operation_instance_id
6195: FROM dual;
6196: l_progress := 220;
6197: