DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_ENTITIES

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

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,
6985: p_operation_seq_num NUMBER,

Line 7272: FROM wip_entities

7268: -- Get the WIP entity type for the WIP supply
7269: BEGIN
7270: SELECT entity_type
7271: INTO l_wip_entity_type
7272: FROM wip_entities
7273: WHERE wip_entity_id = l_supply_header_id
7274: AND organization_id = l_organization_id;
7275: EXCEPTION
7276: WHEN OTHERS THEN