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 972: l_old_trohdr_rec := inv_trohdr_util.convert_miss_to_null(l_old_trohdr_rec);

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

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

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

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

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

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

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

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

1007: --Bug# 4554438.End
1008:
1009: IF p_validation_level > fnd_api.g_valid_level_none THEN
1010: -- Bug#2536932: Setting Missing elements of P_TROHDR_VAL_REC to NULL values.
1011: l_trohdr_val_rec := inv_trohdr_util.convert_miss_to_null(p_trohdr_val_rec);
1012: 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);
1013:
1014: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1015: RAISE fnd_api.g_exc_unexpected_error;

Line 1025: 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);

1021:
1022: -- Clear dependent attributes.
1023:
1024: IF l_control_rec.change_attributes THEN
1025: 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);
1026: END IF;
1027:
1028: -- Apply attribute changes
1029: IF l_control_rec.default_attributes

Line 1032: 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);

1028: -- Apply attribute changes
1029: IF l_control_rec.default_attributes
1030: OR l_control_rec.change_attributes THEN
1031: --debug('Apply Attr');
1032: 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);
1033: END IF;
1034:
1035: -- Entity level validation.
1036: IF l_control_rec.validate_entity THEN

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

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

Line 1061: inv_trohdr_util.update_row(l_trohdr_rec);

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

Line 1065: inv_trohdr_util.insert_row(l_trohdr_rec);

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

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

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

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

1892: SAVEPOINT lock_transfer_order_pvt;
1893:
1894: -- Lock trohdr
1895: IF p_trohdr_rec.operation = inv_globals.g_opr_lock THEN
1896: inv_trohdr_util.lock_row(p_trohdr_rec => p_trohdr_rec, x_trohdr_rec => x_trohdr_rec, x_return_status => l_return_status);
1897:
1898: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1899: RAISE fnd_api.g_exc_unexpected_error;
1900: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

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

1988: fnd_msg_pub.initialize;
1989: END IF;
1990:
1991: -- Get trohdr ( parent = trohdr )
1992: l_trohdr_rec := inv_trohdr_util.query_row(p_header_id => p_header_id);
1993: -- Get trolin ( parent = trohdr )
1994: --debug('TRO : in get_transfer_order '||to_char(p_header_id)||' '||to_char(l_trohdr_rec.header_id));
1995: l_trolin_tbl := inv_trolin_util.query_rows(p_header_id => l_trohdr_rec.header_id);
1996: -- Load out parameters