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 2273: l_job WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;

2269: l_wip_start_date_count NUMBER := 0;
2270: l_wip_schedule_count NUMBER := 0;
2271: l_wip_assembly_count NUMBER := 0;
2272:
2273: l_job WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
2274: l_line WIP_LINES.LINE_CODE%TYPE;
2275: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;
2276: l_operation_seq_num NUMBER;
2277: l_wip_entity_type NUMBER;

Line 2279: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;

2275: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;
2276: l_operation_seq_num NUMBER;
2277: l_wip_entity_type NUMBER;
2278: l_start_date DATE;
2279: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
2280: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2281: l_wip_entity_id NUMBER;
2282:
2283: l_crossdock_type NUMBER;