The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
ELSIF p_attr_id = g_last_updated_by THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_updated_by;
ELSIF p_attr_id = g_last_update_date THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_date;
ELSIF p_attr_id = g_last_update_login THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_last_update_login;
ELSIF p_attr_id = g_program_update_date THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := inv_trolin_util.g_program_update_date;
IF NOT inv_globals.equal(p_trolin_rec.last_updated_by, p_old_trolin_rec.last_updated_by) THEN
NULL;
IF NOT inv_globals.equal(p_trolin_rec.last_update_date, p_old_trolin_rec.last_update_date) THEN
NULL;
IF NOT inv_globals.equal(p_trolin_rec.last_update_login, p_old_trolin_rec.last_update_login) THEN
NULL;
IF NOT inv_globals.equal(p_trolin_rec.program_update_date, p_old_trolin_rec.program_update_date) THEN
NULL;
IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
l_trolin_rec.last_updated_by := p_old_trolin_rec.last_updated_by;
IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
l_trolin_rec.last_update_date := p_old_trolin_rec.last_update_date;
IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
l_trolin_rec.last_update_login := p_old_trolin_rec.last_update_login;
IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
l_trolin_rec.program_update_date := p_old_trolin_rec.program_update_date;
IF l_trolin_rec.last_updated_by = fnd_api.g_miss_num THEN
l_trolin_rec.last_updated_by := NULL;
IF l_trolin_rec.last_update_date = fnd_api.g_miss_date THEN
l_trolin_rec.last_update_date := NULL;
IF l_trolin_rec.last_update_login = fnd_api.g_miss_num THEN
l_trolin_rec.last_update_login := NULL;
IF l_trolin_rec.program_update_date = fnd_api.g_miss_date THEN
l_trolin_rec.program_update_date := NULL;
PROCEDURE update_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
l_tran_source_typ_id NUMBER := 0;
/* bug7115229 The transaction source type id is updated from 5 to 13. Because of which the select available inventory form is not
showing the source details for the move order of type backflush transfer correctly. So iam putting a condition here before
updation of the transation source type id. If the txn source id corresponds to a batch, then the corresponding move order cannot
have a source type of inventory (13). It should retain its transaction source type id as job or schedule (5). This fix is
relevant only to OPM batches. */
IF p_trolin_rec.transaction_source_type_id IS NOT NULL THEN
BEGIN
SELECT 1
INTO l_batch_exists
FROM dual
WHERE EXISTS (SELECT gmd.line_no
FROM gme_material_details gmd,mtl_txn_request_lines mtrl
WHERE gmd.material_detail_id=p_trolin_rec.txn_source_line_id
AND mtrl.organization_id=p_trolin_rec.organization_id
AND mtrl.txn_source_id=p_trolin_rec.txn_source_id
AND mtrl.inventory_item_id=p_trolin_rec.inventory_item_id
AND gmd.material_detail_id=mtrl.txn_source_line_id
AND mtrl.transaction_source_type_id=5);
UPDATE mtl_txn_request_lines
SET attribute1 = p_trolin_rec.attribute1
, attribute10 = p_trolin_rec.attribute10
, attribute11 = p_trolin_rec.attribute11
, attribute12 = p_trolin_rec.attribute12
, attribute13 = p_trolin_rec.attribute13
, attribute14 = p_trolin_rec.attribute14
, attribute15 = p_trolin_rec.attribute15
, attribute2 = p_trolin_rec.attribute2
, attribute3 = p_trolin_rec.attribute3
, attribute4 = p_trolin_rec.attribute4
, attribute5 = p_trolin_rec.attribute5
, attribute6 = p_trolin_rec.attribute6
, attribute7 = p_trolin_rec.attribute7
, attribute8 = p_trolin_rec.attribute8
, attribute9 = p_trolin_rec.attribute9
, attribute_category = p_trolin_rec.attribute_category
, created_by = p_trolin_rec.created_by
, creation_date = p_trolin_rec.creation_date
, date_required = p_trolin_rec.date_required
, from_locator_id = p_trolin_rec.from_locator_id
, from_subinventory_code = p_trolin_rec.from_subinventory_code
, from_subinventory_id = p_trolin_rec.from_subinventory_id
, header_id = p_trolin_rec.header_id
, inventory_item_id = p_trolin_rec.inventory_item_id
-- , last_updated_by = p_trolin_rec.last_updated_by
-- , last_update_date = p_trolin_rec.last_update_date
-- , last_update_login = p_trolin_rec.last_update_login
, last_update_date = SYSDATE --Bug 15837987
, last_updated_by = FND_PROFILE.VALUE('USER_ID')
, last_update_login = FND_PROFILE.VALUE('LOGIN_ID')
, line_id = p_trolin_rec.line_id
, line_number = p_trolin_rec.line_number
, line_status = p_trolin_rec.line_status
, lot_number = p_trolin_rec.lot_number
, organization_id = p_trolin_rec.organization_id
, program_application_id = p_trolin_rec.program_application_id
, program_id = p_trolin_rec.program_id
, program_update_date = p_trolin_rec.program_update_date
, project_id = p_trolin_rec.project_id
, quantity = p_trolin_rec.quantity
, quantity_delivered = p_trolin_rec.quantity_delivered
, quantity_detailed = p_trolin_rec.quantity_detailed
, reason_id = p_trolin_rec.reason_id
, REFERENCE = p_trolin_rec.REFERENCE
, reference_id = p_trolin_rec.reference_id
, reference_type_code = p_trolin_rec.reference_type_code
, request_id = p_trolin_rec.request_id
, revision = p_trolin_rec.revision
, serial_number_end = p_trolin_rec.serial_number_end
, serial_number_start = p_trolin_rec.serial_number_start
, status_date = p_trolin_rec.status_date
, task_id = p_trolin_rec.task_id
, to_account_id = p_trolin_rec.to_account_id
, to_locator_id = p_trolin_rec.to_locator_id
, to_subinventory_code = p_trolin_rec.to_subinventory_code
, to_subinventory_id = p_trolin_rec.to_subinventory_id
, transaction_header_id = p_trolin_rec.transaction_header_id
, uom_code = p_trolin_rec.uom_code
, transaction_type_id = p_trolin_rec.transaction_type_id
, transaction_source_type_id = l_tran_source_typ_id --bug7115229
, txn_source_id = p_trolin_rec.txn_source_id
, txn_source_line_id = p_trolin_rec.txn_source_line_id
, txn_source_line_detail_id = p_trolin_rec.txn_source_line_detail_id
, to_organization_id = p_trolin_rec.to_organization_id
, primary_quantity = p_trolin_rec.primary_quantity
, pick_strategy_id = p_trolin_rec.pick_strategy_id
, put_away_strategy_id = p_trolin_rec.put_away_strategy_id
, unit_number = p_trolin_rec.unit_number
, ship_to_location_id = p_trolin_rec.ship_to_location_id
, from_cost_group_id = p_trolin_rec.from_cost_group_id
, to_cost_group_id = p_trolin_rec.to_cost_group_id
, lpn_id = p_trolin_rec.lpn_id
, to_lpn_id = p_trolin_rec.to_lpn_id
, inspection_status = p_trolin_rec.inspection_status
, pick_methodology_id = p_trolin_rec.pick_methodology_id
, container_item_id = p_trolin_rec.container_item_id
, carton_grouping_id = p_trolin_rec.carton_grouping_id
, wms_process_flag = p_trolin_rec.wms_process_flag
, pick_slip_number = p_trolin_rec.pick_slip_number
, pick_slip_date = p_trolin_rec.pick_slip_date
, ship_set_id = p_trolin_rec.ship_set_id
, ship_model_id = p_trolin_rec.ship_model_id
, model_quantity = p_trolin_rec.model_quantity
, required_quantity = p_trolin_rec.required_quantity
--INVCONV BEGIN
, secondary_quantity = p_trolin_rec.secondary_quantity
, secondary_quantity_delivered = p_trolin_rec.secondary_quantity_delivered
, secondary_quantity_detailed = p_trolin_rec.secondary_quantity_detailed
, secondary_uom_code = p_trolin_rec.secondary_uom
, secondary_required_quantity = p_trolin_rec.secondary_required_quantity
, grade_code = p_trolin_rec.grade_code
--INVCONV END;
fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
END update_row;
PROCEDURE update_row_status(p_line_id IN NUMBER, p_status IN NUMBER) IS
l_trolin_rec inv_move_order_pub.trolin_rec_type;
l_trolin_rec.last_update_date := SYSDATE;
l_trolin_rec.last_updated_by := fnd_global.user_id;
l_trolin_rec.last_update_login := fnd_global.login_id;
inv_trolin_util.update_row(l_trolin_rec);
fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
END update_row_status;
PROCEDURE insert_row(p_trolin_rec IN inv_move_order_pub.trolin_rec_type) IS
BEGIN
INSERT INTO mtl_txn_request_lines
(
attribute1
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute_category
, created_by
, creation_date
, date_required
, from_locator_id
, from_subinventory_code
, from_subinventory_id
, header_id
, inventory_item_id
, last_updated_by
, last_update_date
, last_update_login
, line_id
, line_number
, line_status
, lot_number
, organization_id
, program_application_id
, program_id
, program_update_date
, project_id
, quantity
, quantity_delivered
, quantity_detailed
, reason_id
, REFERENCE
, reference_id
, reference_type_code
, request_id
, revision
, serial_number_end
, serial_number_start
, status_date
, task_id
, to_account_id
, to_locator_id
, to_subinventory_code
, to_subinventory_id
, transaction_header_id
, uom_code
, transaction_type_id
, transaction_source_type_id
, txn_source_id
, txn_source_line_id
, txn_source_line_detail_id
, to_organization_id
, primary_quantity
, pick_strategy_id
, put_away_strategy_id
, unit_number
, ship_to_location_id
, from_cost_group_id
, to_cost_group_id
, lpn_id
, to_lpn_id
, inspection_status
, pick_methodology_id
, container_item_id
, carton_grouping_id
, wms_process_flag
, pick_slip_number
, pick_slip_date
, ship_set_id
, ship_model_id
, model_quantity
, required_quantity
--INVCONV BEGIN
, secondary_quantity
, secondary_quantity_delivered
, secondary_quantity_detailed
, secondary_uom_code
, secondary_required_quantity
, grade_code
--INVCONV END;
, p_trolin_rec.last_updated_by
, p_trolin_rec.last_update_date
, p_trolin_rec.last_update_login
, p_trolin_rec.line_id
, p_trolin_rec.line_number
, p_trolin_rec.line_status
, p_trolin_rec.lot_number
, p_trolin_rec.organization_id
, p_trolin_rec.program_application_id
, p_trolin_rec.program_id
, p_trolin_rec.program_update_date
, p_trolin_rec.project_id
, p_trolin_rec.quantity
, p_trolin_rec.quantity_delivered
, p_trolin_rec.quantity_detailed
, p_trolin_rec.reason_id
, p_trolin_rec.REFERENCE
, p_trolin_rec.reference_id
, p_trolin_rec.reference_type_code
, p_trolin_rec.request_id
, p_trolin_rec.revision
, p_trolin_rec.serial_number_end
, p_trolin_rec.serial_number_start
, p_trolin_rec.status_date
, p_trolin_rec.task_id
, p_trolin_rec.to_account_id
, p_trolin_rec.to_locator_id
, p_trolin_rec.to_subinventory_code
, p_trolin_rec.to_subinventory_id
, p_trolin_rec.transaction_header_id
, p_trolin_rec.uom_code
, p_trolin_rec.transaction_type_id
, p_trolin_rec.transaction_source_type_id
, p_trolin_rec.txn_source_id
, p_trolin_rec.txn_source_line_id
, p_trolin_rec.txn_source_line_detail_id
, p_trolin_rec.to_organization_id
, p_trolin_rec.primary_quantity
, p_trolin_rec.pick_strategy_id
, p_trolin_rec.put_away_strategy_id
, p_trolin_rec.unit_number
, p_trolin_rec.ship_to_location_id
, p_trolin_rec.from_cost_group_id
, p_trolin_rec.to_cost_group_id
, p_trolin_rec.lpn_id
, p_trolin_rec.to_lpn_id
, p_trolin_rec.inspection_status
, p_trolin_rec.pick_methodology_id
, p_trolin_rec.container_item_id
, p_trolin_rec.carton_grouping_id
, p_trolin_rec.wms_process_flag
, p_trolin_rec.pick_slip_number
, p_trolin_rec.pick_slip_date
, p_trolin_rec.ship_set_id
, p_trolin_rec.ship_model_id
, p_trolin_rec.model_quantity
, p_trolin_rec.required_quantity
--INVCONV BEGIN
, p_trolin_rec.secondary_quantity
, p_trolin_rec.secondary_quantity_delivered
, p_trolin_rec.secondary_quantity_detailed
, p_trolin_rec.secondary_uom
, p_trolin_rec.secondary_required_quantity
, p_trolin_rec.grade_code
--INVCONV END;
fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
END insert_row;
PROCEDURE delete_row(p_line_id IN NUMBER) IS
BEGIN
DELETE FROM mtl_txn_request_lines
WHERE line_id = p_line_id;
fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
END delete_row;
SELECT attribute1
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute_category
, created_by
, creation_date
, date_required
, from_locator_id
, from_subinventory_code
, from_subinventory_id
, header_id
, inventory_item_id
, last_updated_by
, last_update_date
, last_update_login
, line_id
, line_number
, line_status
, lot_number
, organization_id
, program_application_id
, program_id
, program_update_date
, project_id
, quantity
, quantity_delivered
, quantity_detailed
, reason_id
, REFERENCE
, reference_id
, reference_type_code
, request_id
, revision
, serial_number_end
, serial_number_start
, status_date
, task_id
, to_account_id
, to_locator_id
, to_subinventory_code
, to_subinventory_id
, transaction_header_id
, uom_code
, transaction_type_id
, transaction_source_type_id
, txn_source_id
, txn_source_line_id
, txn_source_line_detail_id
, to_organization_id
, primary_quantity
, pick_strategy_id
, put_away_strategy_id
, unit_number
, ship_to_location_id
, from_cost_group_id
, to_cost_group_id
, lpn_id
, to_lpn_id
, inspection_status
, pick_methodology_id
, container_item_id
, carton_grouping_id
, wms_process_flag
, pick_slip_number
, pick_slip_date
, ship_set_id
, ship_model_id
, model_quantity
, required_quantity
--INVCONV BEGIN
, secondary_quantity
, secondary_quantity_delivered
, secondary_quantity_detailed
, secondary_uom_code
, grade_code
, secondary_required_quantity
--INVCONV END;
SELECT attribute1
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute_category
, created_by
, creation_date
, date_required
, from_locator_id
, from_subinventory_code
, from_subinventory_id
, header_id
, inventory_item_id
, last_updated_by
, last_update_date
, last_update_login
, line_id
, line_number
, line_status
, lot_number
, organization_id
, program_application_id
, program_id
, program_update_date
, project_id
, quantity
, quantity_delivered
, quantity_detailed
, reason_id
, REFERENCE
, reference_id
, reference_type_code
, request_id
, revision
, serial_number_end
, serial_number_start
, status_date
, task_id
, to_account_id
, to_locator_id
, to_subinventory_code
, to_subinventory_id
, transaction_header_id
, uom_code
, transaction_type_id
, transaction_source_type_id
, txn_source_id
, txn_source_line_id
, txn_source_line_detail_id
, to_organization_id
, primary_quantity
, pick_strategy_id
, put_away_strategy_id
, unit_number
, ship_to_location_id
, from_cost_group_id
, to_cost_group_id
, lpn_id
, to_lpn_id
, inspection_status
, pick_methodology_id
, container_item_id
, carton_grouping_id
, wms_process_flag
, pick_slip_number
, pick_slip_date
, ship_set_id
, ship_model_id
, model_quantity
, required_quantity
--INVCONV BEGIN
, secondary_quantity
, secondary_quantity_delivered
, secondary_quantity_detailed
, secondary_uom_code
, grade_code
, secondary_required_quantity
--INVCONV END;
l_trolin_rec.last_updated_by := l_implicit_rec.last_updated_by;
l_trolin_rec.last_update_date := l_implicit_rec.last_update_date;
l_trolin_rec.last_update_login := l_implicit_rec.last_update_login;
l_trolin_rec.program_update_date := l_implicit_rec.program_update_date;
l_trolin_rec.last_updated_by := l_implicit_rec.last_updated_by;
l_trolin_rec.last_update_date := l_implicit_rec.last_update_date;
l_trolin_rec.last_update_login := l_implicit_rec.last_update_login;
l_trolin_rec.program_update_date := l_implicit_rec.program_update_date;
SELECT attribute1
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute_category
, created_by
, creation_date
, date_required
, from_locator_id
, from_subinventory_code
, from_subinventory_id
, header_id
, inventory_item_id
, last_updated_by
, last_update_date
, last_update_login
, line_id
, line_number
, line_status
, lot_number
, organization_id
, program_application_id
, program_id
, program_update_date
, project_id
, quantity
, quantity_delivered
, quantity_detailed
, reason_id
, REFERENCE
, reference_id
, reference_type_code
, request_id
, revision
, serial_number_end
, serial_number_start
, status_date
, task_id
, to_account_id
, to_locator_id
, to_subinventory_code
, to_subinventory_id
, transaction_header_id
, uom_code
, transaction_type_id
, transaction_source_type_id
, txn_source_id
, txn_source_line_id
, txn_source_line_detail_id
, to_organization_id
, primary_quantity
, pick_strategy_id
, put_away_strategy_id
, unit_number
, ship_to_location_id
, from_cost_group_id
, to_cost_group_id
, lpn_id
, to_lpn_id
, inspection_status
, pick_methodology_id
, container_item_id
, carton_grouping_id
, wms_process_flag
, pick_slip_number
, pick_slip_date
, ship_set_id
, ship_model_id
, model_quantity
, required_quantity
--INVCONV BEGIN
, secondary_quantity
, secondary_quantity_delivered
, secondary_quantity_detailed
, uom_code
, grade_code
, secondary_required_quantity
--INVCONV END
INTO l_trolin_rec.attribute1
, l_trolin_rec.attribute10
, l_trolin_rec.attribute11
, l_trolin_rec.attribute12
, l_trolin_rec.attribute13
, l_trolin_rec.attribute14
, l_trolin_rec.attribute15
, l_trolin_rec.attribute2
, l_trolin_rec.attribute3
, l_trolin_rec.attribute4
, l_trolin_rec.attribute5
, l_trolin_rec.attribute6
, l_trolin_rec.attribute7
, l_trolin_rec.attribute8
, l_trolin_rec.attribute9
, l_trolin_rec.attribute_category
, l_trolin_rec.created_by
, l_trolin_rec.creation_date
, l_trolin_rec.date_required
, l_trolin_rec.from_locator_id
, l_trolin_rec.from_subinventory_code
, l_trolin_rec.from_subinventory_id
, l_trolin_rec.header_id
, l_trolin_rec.inventory_item_id
, l_trolin_rec.last_updated_by
, l_trolin_rec.last_update_date
, l_trolin_rec.last_update_login
, l_trolin_rec.line_id
, l_trolin_rec.line_number
, l_trolin_rec.line_status
, l_trolin_rec.lot_number
, l_trolin_rec.organization_id
, l_trolin_rec.program_application_id
, l_trolin_rec.program_id
, l_trolin_rec.program_update_date
, l_trolin_rec.project_id
, l_trolin_rec.quantity
, l_trolin_rec.quantity_delivered
, l_trolin_rec.quantity_detailed
, l_trolin_rec.reason_id
, l_trolin_rec.REFERENCE
, l_trolin_rec.reference_id
, l_trolin_rec.reference_type_code
, l_trolin_rec.request_id
, l_trolin_rec.revision
, l_trolin_rec.serial_number_end
, l_trolin_rec.serial_number_start
, l_trolin_rec.status_date
, l_trolin_rec.task_id
, l_trolin_rec.to_account_id
, l_trolin_rec.to_locator_id
, l_trolin_rec.to_subinventory_code
, l_trolin_rec.to_subinventory_id
, l_trolin_rec.transaction_header_id
, l_trolin_rec.uom_code
, l_trolin_rec.transaction_type_id
, l_trolin_rec.transaction_source_type_id
, l_trolin_rec.txn_source_id
, l_trolin_rec.txn_source_line_id
, l_trolin_rec.txn_source_line_detail_id
, l_trolin_rec.to_organization_id
, l_trolin_rec.primary_quantity
, l_trolin_rec.pick_strategy_id
, l_trolin_rec.put_away_strategy_id
, l_trolin_rec.unit_number
, l_trolin_rec.ship_to_location_id
, l_trolin_rec.from_cost_group_id
, l_trolin_rec.to_cost_group_id
, l_trolin_rec.lpn_id
, l_trolin_rec.to_lpn_id
, l_trolin_rec.inspection_status
, l_trolin_rec.pick_methodology_id
, l_trolin_rec.container_item_id
, l_trolin_rec.carton_grouping_id
, l_trolin_rec.wms_process_flag
, l_trolin_rec.pick_slip_number
, l_trolin_rec.pick_slip_date
, l_trolin_rec.ship_set_id
, l_trolin_rec.ship_model_id
, l_trolin_rec.model_quantity
, l_trolin_rec.required_quantity
--INVCONV BEGIN
, l_trolin_rec.secondary_quantity
, l_trolin_rec.secondary_quantity_delivered
, l_trolin_rec.secondary_quantity_detailed
, l_trolin_rec.uom_code
, l_trolin_rec.grade_code
, l_trolin_rec.secondary_required_quantity
--INVCONV END
FROM mtl_txn_request_lines
WHERE line_id = p_trolin_rec.line_id
FOR UPDATE NOWAIT;
AND (inv_globals.equal(p_trolin_rec.last_updated_by, l_trolin_rec.last_updated_by)
OR (p_trolin_rec.last_updated_by = fnd_api.g_miss_num
AND l_trolin_rec.last_updated_by IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.last_update_date, l_trolin_rec.last_update_date)
OR (p_trolin_rec.last_update_date = fnd_api.g_miss_date
AND l_trolin_rec.last_update_date IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.last_update_login, l_trolin_rec.last_update_login)
OR (p_trolin_rec.last_update_login = fnd_api.g_miss_num
AND l_trolin_rec.last_update_login IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.line_id, l_trolin_rec.line_id)
OR (p_trolin_rec.line_id = fnd_api.g_miss_num
AND l_trolin_rec.line_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.line_number, l_trolin_rec.line_number)
OR (p_trolin_rec.line_number = fnd_api.g_miss_num
AND l_trolin_rec.line_number IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.line_status, l_trolin_rec.line_status)
OR (p_trolin_rec.line_status = fnd_api.g_miss_num
AND l_trolin_rec.line_status IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.lot_number, l_trolin_rec.lot_number)
OR (p_trolin_rec.lot_number = fnd_api.g_miss_char
AND l_trolin_rec.lot_number IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.organization_id, l_trolin_rec.organization_id)
OR (p_trolin_rec.organization_id = fnd_api.g_miss_num
AND l_trolin_rec.organization_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.program_application_id, l_trolin_rec.program_application_id)
OR (p_trolin_rec.program_application_id = fnd_api.g_miss_num
AND l_trolin_rec.program_application_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.program_id, l_trolin_rec.program_id)
OR (p_trolin_rec.program_id = fnd_api.g_miss_num
AND l_trolin_rec.program_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.program_update_date, l_trolin_rec.program_update_date)
OR (p_trolin_rec.program_update_date = fnd_api.g_miss_date
AND l_trolin_rec.program_update_date IS NOT NULL
)
)
AND (inv_globals.equal(p_trolin_rec.project_id, l_trolin_rec.project_id)
OR (p_trolin_rec.project_id = fnd_api.g_miss_num
AND l_trolin_rec.project_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.quantity, l_trolin_rec.quantity)
OR (p_trolin_rec.quantity = fnd_api.g_miss_num
AND l_trolin_rec.quantity IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.quantity_delivered, l_trolin_rec.quantity_delivered)
OR (p_trolin_rec.quantity_delivered = fnd_api.g_miss_num
AND l_trolin_rec.quantity_delivered IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.quantity_detailed, l_trolin_rec.quantity_detailed)
OR (p_trolin_rec.quantity_detailed = fnd_api.g_miss_num
AND l_trolin_rec.quantity_detailed IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.reason_id, l_trolin_rec.reason_id)
OR (p_trolin_rec.reason_id = fnd_api.g_miss_num
AND l_trolin_rec.reason_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.REFERENCE, l_trolin_rec.REFERENCE)
OR (p_trolin_rec.REFERENCE = fnd_api.g_miss_char
AND l_trolin_rec.REFERENCE IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.reference_id, l_trolin_rec.reference_id)
OR (p_trolin_rec.reference_id = fnd_api.g_miss_num
AND l_trolin_rec.reference_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.reference_type_code, l_trolin_rec.reference_type_code)
OR (l_trolin_rec.reference_type_code = fnd_api.g_miss_num
AND l_trolin_rec.reference_type_code IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.request_id, l_trolin_rec.request_id)
OR (p_trolin_rec.request_id = fnd_api.g_miss_num
AND l_trolin_rec.request_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.revision, l_trolin_rec.revision)
OR (p_trolin_rec.revision = fnd_api.g_miss_char
AND l_trolin_rec.revision IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.serial_number_end, l_trolin_rec.serial_number_end)
OR (p_trolin_rec.serial_number_end = fnd_api.g_miss_char
AND l_trolin_rec.serial_number_end IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.serial_number_start, l_trolin_rec.serial_number_start)
OR (p_trolin_rec.serial_number_start = fnd_api.g_miss_char
AND l_trolin_rec.serial_number_start IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.status_date, l_trolin_rec.status_date)
OR (p_trolin_rec.status_date = fnd_api.g_miss_date
AND l_trolin_rec.status_date IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.task_id, l_trolin_rec.task_id)
OR (p_trolin_rec.task_id = fnd_api.g_miss_num
AND l_trolin_rec.task_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_account_id, l_trolin_rec.to_account_id)
OR (p_trolin_rec.to_account_id = fnd_api.g_miss_num
AND l_trolin_rec.to_account_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_locator_id, l_trolin_rec.to_locator_id)
OR (p_trolin_rec.to_locator_id = fnd_api.g_miss_num
AND l_trolin_rec.to_locator_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_subinventory_code, l_trolin_rec.to_subinventory_code)
OR (p_trolin_rec.to_subinventory_code = fnd_api.g_miss_char
AND l_trolin_rec.to_subinventory_code IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_subinventory_id, l_trolin_rec.to_subinventory_id)
OR (p_trolin_rec.to_subinventory_id = fnd_api.g_miss_num
AND l_trolin_rec.to_subinventory_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.transaction_header_id, l_trolin_rec.transaction_header_id)
OR (p_trolin_rec.transaction_header_id = fnd_api.g_miss_num
AND l_trolin_rec.transaction_header_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.uom_code, l_trolin_rec.uom_code)
OR (p_trolin_rec.uom_code = fnd_api.g_miss_char
AND p_trolin_rec.uom_code IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.transaction_type_id, l_trolin_rec.transaction_type_id)
OR (p_trolin_rec.transaction_type_id = fnd_api.g_miss_num
AND l_trolin_rec.transaction_type_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.transaction_source_type_id, l_trolin_rec.transaction_source_type_id)
OR (p_trolin_rec.transaction_source_type_id = fnd_api.g_miss_num
AND l_trolin_rec.transaction_source_type_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.txn_source_id, l_trolin_rec.txn_source_id)
OR (p_trolin_rec.txn_source_id = fnd_api.g_miss_num
AND l_trolin_rec.txn_source_id IS NULL
)
)
AND inv_globals.equal(p_trolin_rec.txn_source_line_id, l_trolin_rec.txn_source_line_id)
AND (inv_globals.equal(p_trolin_rec.txn_source_line_detail_id, l_trolin_rec.txn_source_line_detail_id)
OR (p_trolin_rec.txn_source_line_detail_id = fnd_api.g_miss_num
AND l_trolin_rec.txn_source_line_detail_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.primary_quantity, l_trolin_rec.primary_quantity)
OR (p_trolin_rec.primary_quantity = fnd_api.g_miss_num
AND l_trolin_rec.primary_quantity IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_organization_id, l_trolin_rec.to_organization_id)
OR (p_trolin_rec.to_organization_id = fnd_api.g_miss_num
AND l_trolin_rec.to_organization_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.pick_strategy_id, l_trolin_rec.pick_strategy_id)
OR (p_trolin_rec.pick_strategy_id = fnd_api.g_miss_num
AND l_trolin_rec.pick_strategy_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.put_away_strategy_id, l_trolin_rec.put_away_strategy_id)
OR (p_trolin_rec.put_away_strategy_id = fnd_api.g_miss_num
AND l_trolin_rec.put_away_strategy_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.unit_number, l_trolin_rec.unit_number)
OR (p_trolin_rec.unit_number = fnd_api.g_miss_char
AND l_trolin_rec.unit_number IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.ship_to_location_id, l_trolin_rec.ship_to_location_id)
OR (p_trolin_rec.ship_to_location_id = fnd_api.g_miss_num
AND l_trolin_rec.ship_to_location_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.from_cost_group_id, l_trolin_rec.from_cost_group_id)
OR (p_trolin_rec.from_cost_group_id = fnd_api.g_miss_num
AND l_trolin_rec.to_cost_group_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_cost_group_id, l_trolin_rec.to_cost_group_id)
OR (p_trolin_rec.to_cost_group_id = fnd_api.g_miss_num
AND l_trolin_rec.to_cost_group_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.lpn_id, l_trolin_rec.lpn_id)
OR (p_trolin_rec.lpn_id = fnd_api.g_miss_num
AND l_trolin_rec.lpn_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.to_lpn_id, l_trolin_rec.to_lpn_id)
OR (p_trolin_rec.to_lpn_id = fnd_api.g_miss_num
AND l_trolin_rec.to_lpn_id IS NULL
)
)
AND inv_globals.equal(p_trolin_rec.inspection_status, l_trolin_rec.inspection_status)
AND (inv_globals.equal(p_trolin_rec.pick_methodology_id, l_trolin_rec.pick_methodology_id)
OR (p_trolin_rec.pick_methodology_id = fnd_api.g_miss_num
AND l_trolin_rec.pick_methodology_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.container_item_id, l_trolin_rec.container_item_id)
OR (p_trolin_rec.container_item_id = fnd_api.g_miss_num
AND l_trolin_rec.container_item_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.carton_grouping_id, l_trolin_rec.carton_grouping_id)
OR (p_trolin_rec.carton_grouping_id = fnd_api.g_miss_num
AND l_trolin_rec.carton_grouping_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.wms_process_flag, l_trolin_rec.wms_process_flag)
OR (p_trolin_rec.wms_process_flag = fnd_api.g_miss_char
AND l_trolin_rec.wms_process_flag IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.pick_slip_number, l_trolin_rec.pick_slip_number)
OR (p_trolin_rec.pick_slip_number = fnd_api.g_miss_num
AND l_trolin_rec.pick_slip_number IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.pick_slip_date, l_trolin_rec.pick_slip_date)
OR (p_trolin_rec.pick_slip_date = fnd_api.g_miss_date
AND l_trolin_rec.pick_slip_date IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.ship_set_id, l_trolin_rec.ship_set_id)
OR (p_trolin_rec.ship_set_id = fnd_api.g_miss_num
AND l_trolin_rec.ship_set_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.ship_model_id, l_trolin_rec.ship_model_id)
OR (p_trolin_rec.ship_model_id = fnd_api.g_miss_num
AND l_trolin_rec.ship_model_id IS NULL
)
)
AND (inv_globals.equal(p_trolin_rec.model_quantity, l_trolin_rec.model_quantity)
OR (p_trolin_rec.model_quantity = fnd_api.g_miss_num
AND l_trolin_rec.model_quantity IS NULL
)
) THEN
-- Row has not changed. Set out parameter.
x_trolin_rec := l_trolin_rec;
fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
PROCEDURE insert_mo_lines_bulk(p_new_trolin_tbl IN inv_move_order_pub.trolin_new_tbl_type
,x_return_status IN OUT NOCOPY VARCHAR2) IS
BEGIN
FORALL i IN 1 .. p_new_trolin_tbl.COUNT
insert into mtl_txn_request_lines
values p_new_trolin_tbl(i);
END insert_mo_lines_bulk;