DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_ENTITIES

Line 6806: -- We could also lock the wip_entities record but that is probably not necessary,

6802:
6803: -- Cursor to lock the WIP demand record.
6804: -- WIP backordered component demand MUST have a record in the table
6805: -- wip_requirement_operations. Thus, operation_seq_num should not be null.
6806: -- We could also lock the wip_entities record but that is probably not necessary,
6807: -- especially if the demand is a WIP Repetitive job. That might lock up the record
6808: -- unnecessarily for other repetitive jobs with the same wip_entity_id.
6809: CURSOR lock_wip_record(p_wip_entity_id NUMBER,
6810: p_operation_seq_num NUMBER,

Line 7097: FROM wip_entities

7093: -- Get the WIP entity type for the WIP supply
7094: BEGIN
7095: SELECT entity_type
7096: INTO l_wip_entity_type
7097: FROM wip_entities
7098: WHERE wip_entity_id = l_supply_header_id
7099: AND organization_id = l_organization_id;
7100: EXCEPTION
7101: WHEN OTHERS THEN