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 5736: SELECT WMS_OP_INSTANCE_S.NEXTVAL

5732: --l_wopi_source_task_idsplit_rec.status := l_wopi_orig_rec.status;
5733:
5734: l_progress := 160;
5735: --use sequence to generate op_plan_instance_id
5736: SELECT WMS_OP_INSTANCE_S.NEXTVAL
5737: INTO l_wopi_split_rec.op_plan_instance_id
5738: FROM dual;
5739: l_progress := 170;
5740: --call wms_op_plan_instance table handler to insert l_wopi_split_rec INTO the table

Line 6063: SELECT wms_op_instance_s.NEXTVAL

6059:
6060: l_wooi_new_rec.op_plan_instance_id := l_wopi_split_rec.op_plan_instance_id;
6061: l_progress := 210;
6062: --Call wms_op_operation_instances table handler to insert the record
6063: SELECT wms_op_instance_s.NEXTVAL
6064: INTO l_wooi_new_rec.operation_instance_id
6065: FROM dual;
6066: l_progress := 220;
6067: