DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 6980: -- wip_requirement_operations. Thus, operation_seq_num should not be null.

6976: FOR UPDATE NOWAIT;
6977:
6978: -- Cursor to lock the WIP demand record.
6979: -- WIP backordered component demand MUST have a record in the table
6980: -- wip_requirement_operations. Thus, operation_seq_num should not be null.
6981: -- We could also lock the wip_entities record but that is probably not necessary,
6982: -- especially if the demand is a WIP Repetitive job. That might lock up the record
6983: -- unnecessarily for other repetitive jobs with the same wip_entity_id.
6984: CURSOR lock_wip_record(p_wip_entity_id NUMBER,

Line 6988: FROM wip_requirement_operations

6984: CURSOR lock_wip_record(p_wip_entity_id NUMBER,
6985: p_operation_seq_num NUMBER,
6986: p_repetitive_schedule_id NUMBER) IS
6987: SELECT wip_entity_id
6988: FROM wip_requirement_operations
6989: WHERE inventory_item_id = l_inventory_item_id
6990: AND organization_id = l_organization_id
6991: AND wip_entity_id = p_wip_entity_id
6992: AND operation_seq_num = p_operation_seq_num