APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on INV_MATERIAL_STATUS_PUB

Line 26: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

22: l_wms_org BOOLEAN;
23: l_sub_type NUMBER;
24: l_locator_status NUMBER;
25: l_loc_type NUMBER;
26: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
27: l_picking_order NUMBER;
28: -- Bug 9572628
29: l_physical_loc_id NUMBER;
30: l_phys_loc_segs VARCHAR2(1000);

Line 126: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;

122: l_status_rec.organization_id := p_org_id;
123: l_status_rec.inventory_item_id := NULL;
124: l_status_rec.lot_number := NULL;
125: l_status_rec.serial_number := NULL;
126: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
127: l_status_rec.status_id := l_locator_status;
128: l_status_rec.zone_code := p_sub_code;
129: l_status_rec.locator_id := p_locator_id;
130: l_status_rec.creation_date := SYSDATE;

Line 1196: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; -- bug# 1695432

1192: l_return_status VARCHAR2(10);
1193: l_msg_count NUMBER;
1194: l_msg_data VARCHAR2(20);
1195: l_label_status VARCHAR2(20);
1196: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; -- bug# 1695432
1197: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1198: BEGIN
1199: x_result := 'S';
1200: l_validity_check := 'passed';

Line 1310: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;

1306: l_status_rec.organization_id := p_org_id;
1307: l_status_rec.inventory_item_id := NULL;
1308: l_status_rec.lot_number := NULL;
1309: l_status_rec.serial_number := NULL;
1310: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
1311: l_status_rec.status_id := l_sub_default_status;
1312: l_status_rec.zone_code := p_sub_code;
1313: l_status_rec.locator_id := x_location_id;
1314: l_status_rec.creation_date := SYSDATE;

Line 3866: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

3862: l_return_status VARCHAR2(10);
3863: l_msg_count NUMBER;
3864: l_msg_data VARCHAR2(20);
3865: l_label_status VARCHAR2(20);
3866: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
3867: l_required VARCHAR2(1) := 'N';
3868: l_project_id NUMBER;
3869: l_task_id NUMBER;
3870: l_picking_order NUMBER;