DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_MATERIAL_STATUS_PUB

Line 386: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

382: l_column_idx BINARY_INTEGER := 44;
383: l_return_status VARCHAR2(1);
384: l_msg_data VARCHAR2(2000);
385: l_msg_count NUMBER;
386: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
387: l_status_id NUMBER := NULL;
388: l_lot_status_enabled VARCHAR2(1);
389: l_default_lot_status_id NUMBER := NULL;
390: l_serial_status_enabled VARCHAR2(1);

Line 1227: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;

1223: x_return_status := fnd_api.g_ret_sts_success;
1224:
1225: -- insert into the status history table for bug 1870120
1226: IF (l_status_id IS NOT NULL) THEN
1227: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;
1228: l_status_rec.organization_id := p_organization_id;
1229: l_status_rec.inventory_item_id := p_inventory_item_id;
1230: l_status_rec.serial_number := p_serial_number;
1231: l_status_rec.status_id := l_status_id;