eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSFER_ORDER_PVT dependencies on INV_TROHDR_UTIL

Line 975: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);

971: -- Prepare record.
972: IF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
973: l_trohdr_rec.db_flag := fnd_api.g_false;
974: -- Set missing old record elements to NULL.
975: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
976: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_update
977: OR l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
978: l_trohdr_rec.db_flag := fnd_api.g_true;
979:

Line 982: l_old_trohdr_rec := inv_trohdr_util.query_row(p_header_id => l_trohdr_rec.header_id);

978: l_trohdr_rec.db_flag := fnd_api.g_true;
979:
980: -- Query Old if missing
981: IF l_old_trohdr_rec.header_id = fnd_api.g_miss_num THEN
982: l_old_trohdr_rec := inv_trohdr_util.query_row(p_header_id => l_trohdr_rec.header_id);
983: ELSE
984: -- Set missing old record elements to NULL.
985: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
986: END IF;

Line 985: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);

981: IF l_old_trohdr_rec.header_id = fnd_api.g_miss_num THEN
982: l_old_trohdr_rec := inv_trohdr_util.query_row(p_header_id => l_trohdr_rec.header_id);
983: ELSE
984: -- Set missing old record elements to NULL.
985: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
986: END IF;
987:
988: -- Complete new record from old
989: l_trohdr_rec := inv_trohdr_util.complete_record(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);

Line 989: l_trohdr_rec := inv_trohdr_util.complete_record(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);

985: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);
986: END IF;
987:
988: -- Complete new record from old
989: l_trohdr_rec := inv_trohdr_util.complete_record(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec);
990: END IF;
991:
992: --Bug 4756455 (11.5.10 bug 4755172 )
993: --Reverted change of Bug 4329971 here and removed the code

Line 1014: l_trohdr_val_rec := inv_trohdr_util.convert_miss_to_null(p_trohdr_val_rec);

1010: --Bug# 4554438.End
1011:
1012: IF p_validation_level > fnd_api.g_valid_level_none THEN
1013: -- Bug#2536932: Setting Missing elements of P_TROHDR_VAL_REC to NULL values.
1014: l_trohdr_val_rec := inv_trohdr_util.convert_miss_to_null(p_trohdr_val_rec);
1015: inv_validate_trohdr.ATTRIBUTES(x_return_status => l_return_status, p_trohdr_rec => l_trohdr_rec, p_trohdr_val_rec => l_trohdr_val_rec, p_old_trohdr_rec => l_old_trohdr_rec);
1016:
1017: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1018: RAISE fnd_api.g_exc_unexpected_error;

Line 1028: inv_trohdr_util.clear_dependent_attr(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec, x_trohdr_rec => l_trohdr_rec);

1024:
1025: -- Clear dependent attributes.
1026:
1027: IF l_control_rec.change_attributes THEN
1028: inv_trohdr_util.clear_dependent_attr(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec, x_trohdr_rec => l_trohdr_rec);
1029: END IF;
1030:
1031: -- Apply attribute changes
1032: IF l_control_rec.default_attributes

Line 1035: inv_trohdr_util.apply_attribute_changes(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec, x_trohdr_rec => l_trohdr_rec);

1031: -- Apply attribute changes
1032: IF l_control_rec.default_attributes
1033: OR l_control_rec.change_attributes THEN
1034: --debug('Apply Attr');
1035: inv_trohdr_util.apply_attribute_changes(p_trohdr_rec => l_trohdr_rec, p_old_trohdr_rec => l_old_trohdr_rec, x_trohdr_rec => l_trohdr_rec);
1036: END IF;
1037:
1038: -- Entity level validation.
1039: IF l_control_rec.validate_entity THEN

Line 1056: inv_trohdr_util.delete_row(p_header_id => l_trohdr_rec.header_id);

1052:
1053: -- Step 4. Write to DB
1054: IF l_control_rec.write_to_db THEN
1055: IF l_trohdr_rec.operation = inv_globals.g_opr_delete THEN
1056: inv_trohdr_util.delete_row(p_header_id => l_trohdr_rec.header_id);
1057: ELSE
1058: -- Get Who Information
1059: l_trohdr_rec.last_update_date := SYSDATE;
1060: l_trohdr_rec.last_updated_by := fnd_global.user_id;

Line 1064: inv_trohdr_util.update_row(l_trohdr_rec);

1060: l_trohdr_rec.last_updated_by := fnd_global.user_id;
1061: l_trohdr_rec.last_update_login := fnd_global.login_id;
1062:
1063: IF l_trohdr_rec.operation = inv_globals.g_opr_update THEN
1064: inv_trohdr_util.update_row(l_trohdr_rec);
1065: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1066: l_trohdr_rec.creation_date := SYSDATE;
1067: l_trohdr_rec.created_by := fnd_global.user_id;
1068: inv_trohdr_util.insert_row(l_trohdr_rec);

Line 1068: inv_trohdr_util.insert_row(l_trohdr_rec);

1064: inv_trohdr_util.update_row(l_trohdr_rec);
1065: ELSIF l_trohdr_rec.operation = inv_globals.g_opr_create THEN
1066: l_trohdr_rec.creation_date := SYSDATE;
1067: l_trohdr_rec.created_by := fnd_global.user_id;
1068: inv_trohdr_util.insert_row(l_trohdr_rec);
1069: END IF;
1070: END IF;
1071: END IF;
1072: END IF;

Line 1200: --l_trohdr_rec := inv_trohdr_util.query_row(l_trolin_tbl(I).header_id);

1196:
1197: -- Load API control record
1198: l_control_rec := inv_globals.init_control_rec(p_operation => l_trolin_rec.operation, p_control_rec => p_control_rec);
1199: -- load header information record
1200: --l_trohdr_rec := inv_trohdr_util.query_row(l_trolin_tbl(I).header_id);
1201: --l_move_order_type := l_trohdr_rec.move_order_type;
1202:
1203: -- Set record return status.
1204: l_trolin_rec.return_status := fnd_api.g_ret_sts_success;

Line 1909: inv_trohdr_util.lock_row(p_trohdr_rec => p_trohdr_rec, x_trohdr_rec => x_trohdr_rec, x_return_status => l_return_status);

1905: SAVEPOINT lock_transfer_order_pvt;
1906:
1907: -- Lock trohdr
1908: IF p_trohdr_rec.operation = inv_globals.g_opr_lock THEN
1909: inv_trohdr_util.lock_row(p_trohdr_rec => p_trohdr_rec, x_trohdr_rec => x_trohdr_rec, x_return_status => l_return_status);
1910:
1911: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1912: RAISE fnd_api.g_exc_unexpected_error;
1913: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 2005: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);

2001: fnd_msg_pub.initialize;
2002: END IF;
2003:
2004: -- Get trohdr ( parent = trohdr )
2005: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);
2006: -- Get trolin ( parent = trohdr )
2007: --debug('TRO : in get_transfer_order '||to_char(p_header_id)||' '||to_char(l_trohdr_rec.header_id));
2008: l_trolin_tbl := inv_trolin_util.query_rows(p_header_id => l_trohdr_rec.header_id);
2009: -- Load out parameters