DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WIP_ENTITIES

Line 101: TYPE entity_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;

97: TYPE uom_tab IS TABLE OF MTL_UNITS_OF_MEASURE_TL.UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE lot_tab IS TABLE OF MTL_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99: TYPE rev_tab IS TABLE OF MTL_ITEM_REVISIONS.REVISION%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE entity_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
102: TYPE line_tab IS TABLE OF WIP_LINES.LINE_CODE%TYPE INDEX BY BINARY_INTEGER;
103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;
104: TYPE schedule_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
105:

Line 104: TYPE schedule_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;

100:
101: TYPE entity_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
102: TYPE line_tab IS TABLE OF WIP_LINES.LINE_CODE%TYPE INDEX BY BINARY_INTEGER;
103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;
104: TYPE schedule_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
105:
106: TYPE ser_num_tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE ser_mark_tab IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 1652: l_job WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;

1648: l_wip_start_date_count NUMBER := 0;
1649: l_wip_schedule_count NUMBER := 0;
1650: l_wip_assembly_count NUMBER := 0;
1651:
1652: l_job WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
1653: l_line WIP_LINES.LINE_CODE%TYPE;
1654: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;
1655: l_operation_seq_num NUMBER;
1656: l_wip_entity_type NUMBER;

Line 1658: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;

1654: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;
1655: l_operation_seq_num NUMBER;
1656: l_wip_entity_type NUMBER;
1657: l_start_date DATE;
1658: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
1659: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1660: l_wip_entity_id NUMBER;
1661:
1662: l_crossdock_type NUMBER;