DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on INV_MATERIAL_STATUS_PUB

Line 494: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

490: l_chkflg NUMBER;
491: l_val BOOLEAN;
492: cnt number;
493: -- Material Status Record type declaration
494: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
495: --Table to hold locator DFF Attributes
496: l_inv_attributes_tbl char_tbl;
497: -- Bug# 4903036: Subinventory type, 1 = Storage, 2 = Receiving
498: l_subinventory_type NUMBER;

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

1163: l_status_rec.organization_id := l_organization_id;
1164: l_status_rec.inventory_item_id := NULL;
1165: l_status_rec.lot_number := NULL;
1166: l_status_rec.serial_number := NULL;
1167: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
1168: l_status_rec.status_id := l_status_id;
1169: l_status_rec.zone_code := p_subinventory_code;
1170: l_status_rec.locator_id := x_inventory_location_id;
1171: l_status_rec.creation_date := SYSDATE;

Line 1372: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

1368: l_chkflg NUMBER;
1369: l_val BOOLEAN;
1370: L_RETURN_STATUS VARCHAR2(1);
1371: -- Material Status Record type declaration
1372: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
1373: --Table to hold locator DFF Attributes
1374: l_inv_attributes_tbl char_tbl;
1375: cnt number;
1376: -- Bug# 4903036: Subinventory type, 1 = Storage, 2 = Receiving

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

1963: l_status_rec.organization_id := l_organization_id;
1964: l_status_rec.inventory_item_id := NULL;
1965: l_status_rec.lot_number := NULL;
1966: l_status_rec.serial_number := NULL;
1967: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
1968: l_status_rec.status_id := p_status_id;
1969: l_status_rec.zone_code := l_subinventory_code;
1970: l_status_rec.locator_id := l_inventory_location_id;
1971: l_status_rec.creation_date := SYSDATE;