DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on INV_MATERIAL_STATUS_PUB

Line 442: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

438: l_chkflg NUMBER;
439: l_val BOOLEAN;
440: cnt number;
441: -- Material Status Record type declaration
442: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
443: --Table to hold locator DFF Attributes
444: l_inv_attributes_tbl char_tbl;
445: -- Bug# 4903036: Subinventory type, 1 = Storage, 2 = Receiving
446: l_subinventory_type NUMBER;

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

1077: l_status_rec.organization_id := l_organization_id;
1078: l_status_rec.inventory_item_id := NULL;
1079: l_status_rec.lot_number := NULL;
1080: l_status_rec.serial_number := NULL;
1081: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
1082: l_status_rec.status_id := l_status_id;
1083: l_status_rec.zone_code := p_subinventory_code;
1084: l_status_rec.locator_id := x_inventory_location_id;
1085: l_status_rec.creation_date := SYSDATE;

Line 1287: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

1283: l_chkflg NUMBER;
1284: l_val BOOLEAN;
1285: L_RETURN_STATUS VARCHAR2(1);
1286: -- Material Status Record type declaration
1287: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
1288: --Table to hold locator DFF Attributes
1289: l_inv_attributes_tbl char_tbl;
1290: cnt number;
1291: -- Bug# 4903036: Subinventory type, 1 = Storage, 2 = Receiving

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

1867: l_status_rec.organization_id := l_organization_id;
1868: l_status_rec.inventory_item_id := NULL;
1869: l_status_rec.lot_number := NULL;
1870: l_status_rec.serial_number := NULL;
1871: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
1872: l_status_rec.status_id := p_status_id;
1873: l_status_rec.zone_code := l_subinventory_code;
1874: l_status_rec.locator_id := l_inventory_location_id;
1875: l_status_rec.creation_date := SYSDATE;