DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_MATERIAL_STATUS_PUB

Line 419: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

415: l_column_idx BINARY_INTEGER := 44;
416: l_return_status VARCHAR2(1);
417: l_msg_data VARCHAR2(2000);
418: l_msg_count NUMBER;
419: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
420: l_status_id NUMBER := NULL;
421: l_lot_status_enabled VARCHAR2(1);
422: l_default_lot_status_id NUMBER := NULL;
423: l_serial_status_enabled VARCHAR2(1);

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

1257: x_return_status := fnd_api.g_ret_sts_success;
1258:
1259: -- insert into the status history table for bug 1870120
1260: IF (l_status_id IS NOT NULL) THEN
1261: l_status_rec.update_method := inv_material_status_pub.g_update_method_auto;
1262: l_status_rec.organization_id := p_organization_id;
1263: l_status_rec.inventory_item_id := p_inventory_item_id;
1264: l_status_rec.serial_number := p_serial_number;
1265: l_status_rec.status_id := l_status_id;