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 532: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type

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

Line 533: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type

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

Line 536: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

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

Line 540: l_trolin_rec inv_move_order_pub.trolin_rec_type;

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

Line 541: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

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

Line 946: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type

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

Line 947: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type

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

Line 948: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type

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

Line 949: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

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

Line 950: , x_old_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

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

Line 954: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

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

Line 956: l_tmp_trohdr_rec inv_move_order_pub.trohdr_rec_type;

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

Line 957: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;

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

Line 958: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

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

Line 1103: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type

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

Line 1104: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type

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

Line 1105: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type

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

Line 1107: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

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

Line 1108: , x_old_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

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

Line 1113: l_trolin_rec inv_move_order_pub.trolin_rec_type;

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

Line 1115: l_tmp_trolin_rec inv_move_order_pub.trolin_rec_type;

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

Line 1116: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;

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

Line 1117: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

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

Line 1118: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

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

Line 1119: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

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

Line 1129: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

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

Line 1191: l_old_trolin_rec := inv_move_order_pub.g_miss_trolin_rec;

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

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

1684: , p_control_rec IN inv_globals.control_rec_type := inv_globals.g_miss_control_rec
1685: , x_return_status OUT NOCOPY VARCHAR2
1686: , x_msg_count OUT NOCOPY NUMBER
1687: , x_msg_data OUT NOCOPY VARCHAR2
1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl

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

1685: , x_return_status OUT NOCOPY VARCHAR2
1686: , x_msg_count OUT NOCOPY NUMBER
1687: , x_msg_data OUT NOCOPY VARCHAR2
1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl

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

1686: , x_msg_count OUT NOCOPY NUMBER
1687: , x_msg_data OUT NOCOPY VARCHAR2
1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

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

1687: , x_msg_data OUT NOCOPY VARCHAR2
1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

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

1688: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1696: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130

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

1689: , p_trohdr_val_rec IN inv_move_order_pub.trohdr_val_rec_type := inv_move_order_pub.g_miss_trohdr_val_rec
1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1696: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1697: ) IS

Line 1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1690: , p_old_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1696: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1697: ) IS
1698: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1691: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1692: , p_trolin_val_tbl IN inv_move_order_pub.trolin_val_tbl_type := inv_move_order_pub.g_miss_trolin_val_tbl
1693: , p_old_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1694: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1695: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1696: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
1697: ) IS
1698: l_api_version_number CONSTANT NUMBER := 1.0;
1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';

Line 1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;

1698: l_api_version_number CONSTANT NUMBER := 1.0;
1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1700: l_return_status VARCHAR2(1);
1701: l_control_rec inv_globals.control_rec_type;
1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

Line 1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;

1699: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transfer_Order';
1700: l_return_status VARCHAR2(1);
1701: l_control_rec inv_globals.control_rec_type;
1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1700: l_return_status VARCHAR2(1);
1701: l_control_rec inv_globals.control_rec_type;
1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1708: l_debug number;

Line 1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1701: l_control_rec inv_globals.control_rec_type;
1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1708: l_debug number;
1709: BEGIN

Line 1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;

1702: l_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_trohdr_rec;
1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1708: l_debug number;
1709: BEGIN
1710: -- Standard call to check for call compatibility

Line 1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1703: l_old_trohdr_rec inv_move_order_pub.trohdr_rec_type := p_old_trohdr_rec;
1704: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1705: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1706: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1707: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1708: l_debug number;
1709: BEGIN
1710: -- Standard call to check for call compatibility
1711: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

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

1867: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1868: , x_return_status OUT NOCOPY VARCHAR2
1869: , x_msg_count OUT NOCOPY NUMBER
1870: , x_msg_data OUT NOCOPY VARCHAR2
1871: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1872: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1873: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1874: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1875: ) IS

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

1868: , x_return_status OUT NOCOPY VARCHAR2
1869: , x_msg_count OUT NOCOPY NUMBER
1870: , x_msg_data OUT NOCOPY VARCHAR2
1871: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1872: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1873: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1874: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1875: ) IS
1876: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1873: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1869: , x_msg_count OUT NOCOPY NUMBER
1870: , x_msg_data OUT NOCOPY VARCHAR2
1871: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1872: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1873: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1874: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1875: ) IS
1876: l_api_version_number CONSTANT NUMBER := 1.0;
1877: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';

Line 1874: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1870: , x_msg_data OUT NOCOPY VARCHAR2
1871: , p_trohdr_rec IN inv_move_order_pub.trohdr_rec_type := inv_move_order_pub.g_miss_trohdr_rec
1872: , p_trolin_tbl IN inv_move_order_pub.trolin_tbl_type := inv_move_order_pub.g_miss_trolin_tbl
1873: , x_trohdr_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1874: , x_trolin_tbl IN OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1875: ) IS
1876: l_api_version_number CONSTANT NUMBER := 1.0;
1877: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';
1878: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1879: l_trolin_rec inv_move_order_pub.trolin_rec_type;

1875: ) IS
1876: l_api_version_number CONSTANT NUMBER := 1.0;
1877: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Transfer_Order';
1878: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1879: l_trolin_rec inv_move_order_pub.trolin_rec_type;
1880: BEGIN
1881: -- Standard call to check for call compatibility
1882: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1883: RAISE fnd_api.g_exc_unexpected_error;

Line 1973: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type

1969: , x_return_status OUT NOCOPY VARCHAR2
1970: , x_msg_count OUT NOCOPY NUMBER
1971: , x_msg_data OUT NOCOPY VARCHAR2
1972: , p_header_id IN NUMBER
1973: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1974: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1975: ) IS
1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';

Line 1974: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type

1970: , x_msg_count OUT NOCOPY NUMBER
1971: , x_msg_data OUT NOCOPY VARCHAR2
1972: , p_header_id IN NUMBER
1973: , x_trohdr_rec OUT NOCOPY inv_move_order_pub.trohdr_rec_type
1974: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1975: ) IS
1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1978: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

Line 1978: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

1974: , x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
1975: ) IS
1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1978: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1979: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1980: BEGIN
1981: -- Standard call to check for call compatibility
1982: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

Line 1979: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

1975: ) IS
1976: l_api_version_number CONSTANT NUMBER := 1.0;
1977: l_api_name CONSTANT VARCHAR2(30) := 'Get_Transfer_Order';
1978: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
1979: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1980: BEGIN
1981: -- Standard call to check for call compatibility
1982: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1983: RAISE fnd_api.g_exc_unexpected_error;

Line 2468: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2464: l_return_status VARCHAR2(1);
2465: l_msg_count NUMBER;
2466: l_msg_data VARCHAR2(2000);
2467: l_error_code NUMBER;
2468: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2469: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2470: l_mmtt_count NUMBER;
2471: l_reservation_id NUMBER;
2472: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

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

6227: l_msg_data VARCHAR2(240);
6228: l_msg_count NUMBER;
6229: l_debug number;
6230: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
6231: l_trolin_rec inv_move_order_pub.trolin_rec_type; -- Bug 5059984
6232: BEGIN
6233: x_return_status := FND_API.G_RET_STS_SUCCESS;
6234:
6235: -- Use cache to get value for l_debug