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_MOVE_ORDER_PUB

Line 535: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type

531: PROCEDURE update_troldt(
532: x_return_status OUT NOCOPY VARCHAR2
533: , x_msg_data OUT NOCOPY VARCHAR2
534: , x_msg_count OUT NOCOPY NUMBER
535: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
536: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type
537: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type
538: , p_move_order_type IN NUMBER
539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

Line 536: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type

532: x_return_status OUT NOCOPY VARCHAR2
533: , x_msg_data OUT NOCOPY VARCHAR2
534: , x_msg_count OUT NOCOPY NUMBER
535: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
536: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type
537: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type
538: , p_move_order_type IN NUMBER
539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130

Line 539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

535: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
536: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type
537: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type
538: , p_move_order_type IN NUMBER
539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
541: ) IS
542: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
543: l_trolin_rec inv_move_order_pub.trolin_rec_type;

Line 543: l_trolin_rec inv_move_order_pub.trolin_rec_type;

539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
541: ) IS
542: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
543: l_trolin_rec inv_move_order_pub.trolin_rec_type;
544: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
545: l_quantity_cancel NUMBER;
546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
547: l_mtl_reservation_count NUMBER;

Line 544: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
541: ) IS
542: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
543: l_trolin_rec inv_move_order_pub.trolin_rec_type;
544: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
545: l_quantity_cancel NUMBER;
546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
547: l_mtl_reservation_count NUMBER;
548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type

945:
946: PROCEDURE trohdr(
947: p_validation_level IN NUMBER
948: , p_control_rec IN inv_globals.control_rec_type
949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

Line 950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type

946: PROCEDURE trohdr(
947: p_validation_level IN NUMBER
948: , p_control_rec IN inv_globals.control_rec_type
949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS

Line 951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type

947: p_validation_level IN NUMBER
948: , p_control_rec IN inv_globals.control_rec_type
949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS
955: l_return_status VARCHAR2(1);

Line 952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

948: , p_control_rec IN inv_globals.control_rec_type
949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS
955: l_return_status VARCHAR2(1);
956: l_control_rec inv_globals.control_rec_type;

Line 953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

949: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
950: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type
951: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type
952: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS
955: l_return_status VARCHAR2(1);
956: l_control_rec inv_globals.control_rec_type;
957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

Line 957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

953: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
954: ) IS
955: l_return_status VARCHAR2(1);
956: l_control_rec inv_globals.control_rec_type;
957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
958: --Bug# 4554438, this var will be used to avoid NOCOPY issues
959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;
960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
961: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

Line 959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;

955: l_return_status VARCHAR2(1);
956: l_control_rec inv_globals.control_rec_type;
957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
958: --Bug# 4554438, this var will be used to avoid NOCOPY issues
959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;
960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
961: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
962:
963: BEGIN

Line 960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;

956: l_control_rec inv_globals.control_rec_type;
957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
958: --Bug# 4554438, this var will be used to avoid NOCOPY issues
959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;
960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
961: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
962:
963: BEGIN
964:

Line 961: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

957: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
958: --Bug# 4554438, this var will be used to avoid NOCOPY issues
959: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;
960: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
961: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
962:
963: BEGIN
964:
965:

Line 1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type

1102:
1103: PROCEDURE trolins(
1104: p_validation_level IN NUMBER
1105: , p_control_rec IN inv_globals.control_rec_type
1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER
1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

Line 1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type

1103: PROCEDURE trolins(
1104: p_validation_level IN NUMBER
1105: , p_control_rec IN inv_globals.control_rec_type
1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER
1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

Line 1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type

1104: p_validation_level IN NUMBER
1105: , p_control_rec IN inv_globals.control_rec_type
1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER
1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1112: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130

Line 1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1106: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER
1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1112: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1113: ) IS
1114: l_return_status VARCHAR2(1);

Line 1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1107: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type
1108: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type
1109: , p_move_order_type IN NUMBER
1110: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1111: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1112: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1113: ) IS
1114: l_return_status VARCHAR2(1);
1115: l_control_rec inv_globals.control_rec_type;

Line 1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1112: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1113: ) IS
1114: l_return_status VARCHAR2(1);
1115: l_control_rec inv_globals.control_rec_type;
1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;

1114: l_return_status VARCHAR2(1);
1115: l_control_rec inv_globals.control_rec_type;
1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;

1115: l_control_rec inv_globals.control_rec_type;
1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

Line 1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1116: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1124: l_quantity_cancel NUMBER;

Line 1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

1117: --Bug #4347016
1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1124: l_quantity_cancel NUMBER;
1125: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;

Line 1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1118: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;
1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1124: l_quantity_cancel NUMBER;
1125: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1126: l_mtl_reservation_count NUMBER;

Line 1132: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1129: l_msg_count NUMBER;
1130: l_msg_data VARCHAR2(2000);
1131: l_move_order_type NUMBER;
1132: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1133: l_failed_ship_set_id NUMBER := NULL;
1134: l_marked_failed_shipset BOOLEAN := FALSE;
1135: l_count NUMBER;
1136: l_current_ship_set_id NUMBER := NULL;

Line 1194: l_old_trolin_rec := inv_move_order_pub.g_miss_trolin_rec;

1190:
1191: IF l_old_trolin_tbl.EXISTS(i) THEN
1192: l_old_trolin_rec := l_old_trolin_tbl(i);
1193: ELSE
1194: l_old_trolin_rec := inv_move_order_pub.g_miss_trolin_rec;
1195: END IF;
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);

Line 1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

1697: , p_control_rec IN inv_globals.control_rec_type := inv_globals.g_miss_control_rec
1698: , x_return_status OUT NOCOPY VARCHAR2
1699: , x_msg_count OUT NOCOPY NUMBER
1700: , x_msg_data OUT NOCOPY VARCHAR2
1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl

Line 1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec

1698: , x_return_status OUT NOCOPY VARCHAR2
1699: , x_msg_count OUT NOCOPY NUMBER
1700: , x_msg_data OUT NOCOPY VARCHAR2
1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl

Line 1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

1699: , x_msg_count OUT NOCOPY NUMBER
1700: , x_msg_data OUT NOCOPY VARCHAR2
1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

Line 1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl

1700: , x_msg_data OUT NOCOPY VARCHAR2
1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

Line 1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl

1701: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1709: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130

Line 1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl

1702: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1709: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1710: ) IS

Line 1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1703: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1709: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1710: ) IS
1711: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1704: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1705: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1706: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1707: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1708: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1709: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1710: ) IS
1711: l_api_version_number CONSTANT NUMBER := 1.0;
1712: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';

Line 1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

1711: l_api_version_number CONSTANT NUMBER := 1.0;
1712: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1713: l_return_status VARCHAR2(1);
1714: l_control_rec inv_globals.control_rec_type;
1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

Line 1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;

1712: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1713: l_return_status VARCHAR2(1);
1714: l_control_rec inv_globals.control_rec_type;
1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1713: l_return_status VARCHAR2(1);
1714: l_control_rec inv_globals.control_rec_type;
1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1721: l_debug number;

Line 1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1714: l_control_rec inv_globals.control_rec_type;
1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1721: l_debug number;
1722: BEGIN

Line 1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

1715: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1721: l_debug number;
1722: BEGIN
1723: -- Standard call to check for call compatibility

Line 1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1716: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1717: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1718: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1719: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1720: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1721: l_debug number;
1722: BEGIN
1723: -- Standard call to check for call compatibility
1724: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

Line 1884: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec

1880: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1881: , x_return_status OUT NOCOPY VARCHAR2
1882: , x_msg_count OUT NOCOPY NUMBER
1883: , x_msg_data OUT NOCOPY VARCHAR2
1884: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1885: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1886: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1887: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1888: ) IS

Line 1885: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl

1881: , x_return_status OUT NOCOPY VARCHAR2
1882: , x_msg_count OUT NOCOPY NUMBER
1883: , x_msg_data OUT NOCOPY VARCHAR2
1884: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1885: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1886: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1887: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1888: ) IS
1889: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1886: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1882: , x_msg_count OUT NOCOPY NUMBER
1883: , x_msg_data OUT NOCOPY VARCHAR2
1884: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1885: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1886: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1887: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1888: ) IS
1889: l_api_version_number CONSTANT NUMBER := 1.0;
1890: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';

Line 1887: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1883: , x_msg_data OUT NOCOPY VARCHAR2
1884: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1885: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1886: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1887: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1888: ) IS
1889: l_api_version_number CONSTANT NUMBER := 1.0;
1890: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';
1891: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1892: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1888: ) IS
1889: l_api_version_number CONSTANT NUMBER := 1.0;
1890: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';
1891: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1892: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1893: BEGIN
1894: -- Standard call to check for call compatibility
1895: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1896: RAISE fnd_api.g_exc_unexpected_error;

Line 1986: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1982: , x_return_status OUT NOCOPY VARCHAR2
1983: , x_msg_count OUT NOCOPY NUMBER
1984: , x_msg_data OUT NOCOPY VARCHAR2
1985: , p_header_id IN NUMBER
1986: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1987: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1988: ) IS
1989: l_api_version_number CONSTANT NUMBER := 1.0;
1990: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';

Line 1987: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1983: , x_msg_count OUT NOCOPY NUMBER
1984: , x_msg_data OUT NOCOPY VARCHAR2
1985: , p_header_id IN NUMBER
1986: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1987: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1988: ) IS
1989: l_api_version_number CONSTANT NUMBER := 1.0;
1990: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1991: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

Line 1991: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1987: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1988: ) IS
1989: l_api_version_number CONSTANT NUMBER := 1.0;
1990: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1991: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1992: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1993: BEGIN
1994: -- Standard call to check for call compatibility
1995: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

Line 1992: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1988: ) IS
1989: l_api_version_number CONSTANT NUMBER := 1.0;
1990: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1991: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1992: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1993: BEGIN
1994: -- Standard call to check for call compatibility
1995: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1996: RAISE fnd_api.g_exc_unexpected_error;

Line 2481: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2477: l_return_status VARCHAR2(1);
2478: l_msg_count NUMBER;
2479: l_msg_data VARCHAR2(2000);
2480: l_error_code NUMBER;
2481: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2482: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2483: l_mmtt_count NUMBER;
2484: l_reservation_id NUMBER;
2485: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

Line 6664: l_trolin_rec inv_move_order_pub.trolin_rec_type; -- Bug 5059984

6660: l_msg_data VARCHAR2(240);
6661: l_msg_count NUMBER;
6662: l_debug number;
6663: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
6664: l_trolin_rec inv_move_order_pub.trolin_rec_type; -- Bug 5059984
6665: BEGIN
6666: x_return_status := FND_API.G_RET_STS_SUCCESS;
6667:
6668: -- Use cache to get value for l_debug