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.WSH_USA_INV_PVT dependencies on INV_RESERVATION_GLOBAL

Line 11: p_rsv IN inv_reservation_global.mtl_reservation_rec_type

7: -- declare the private function (Bug3012297)
8: FUNCTION check_inv_info (
9: p_delivery_detail_split_rec IN DeliveryDetailInvRecType,
10: p_delivery_detail_id IN NUMBER default NULL,
11: p_rsv IN inv_reservation_global.mtl_reservation_rec_type
12: ) return BOOLEAN;
13:
14:
15: /**

Line 871: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

867: x_total_rsv IN OUT NOCOPY NUMBER ,
868: x_total_rsv2 IN OUT NOCOPY NUMBER ,
869: x_return_status IN OUT NOCOPY VARCHAR2)
870: IS
871: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
872: l_size NUMBER ;
873: l_return_status VARCHAR2(1);
874:
875: l_msg_count NUMBER;

Line 981: x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type,

977: p_lock_records IN VARCHAR2,
978: p_cancel_order_mode IN NUMBER,
979: p_direction_flag IN VARCHAR2 ,
980: p_delivery_detail_id IN NUMBER,
981: x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type,
982: x_mtl_reservation_tbl_count OUT NOCOPY NUMBER,
983: x_return_status OUT NOCOPY VARCHAR2)
984:
985: IS

Line 986: l_rsv inv_reservation_global.mtl_reservation_rec_type;

982: x_mtl_reservation_tbl_count OUT NOCOPY NUMBER,
983: x_return_status OUT NOCOPY VARCHAR2)
984:
985: IS
986: l_rsv inv_reservation_global.mtl_reservation_rec_type;
987: l_msg_count NUMBER;
988: l_msg_data VARCHAR2(2000);
989: l_error_text VARCHAR2(6000);
990: l_error_code NUMBER;

Line 1049: l_sort_by_req_date := inv_reservation_global.g_query_no_sort ;

1045: l_rsv.demand_source_line_id := p_source_line_id;
1046: l_rsv.organization_id := p_organization_id;
1047: l_rsv.demand_source_line_detail := p_delivery_detail_id; -- X-dock
1048:
1049: l_sort_by_req_date := inv_reservation_global.g_query_no_sort ;
1050:
1051: if p_direction_flag = 'L' then
1052: -- The following statment is commented because we ideally need this code , but
1053: -- we cannot since it will mean we have to include INV's patch .

Line 1055: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_desc ;

1051: if p_direction_flag = 'L' then
1052: -- The following statment is commented because we ideally need this code , but
1053: -- we cannot since it will mean we have to include INV's patch .
1054: -- When front-porting to newer releases , please use this statment instead of the following hard-coding.
1055: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_desc ;
1056: l_sort_by_req_date := 5 ;
1057: elsif p_direction_flag = 'F' then
1058: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_asc ;
1059: l_sort_by_req_date := 4 ;

Line 1058: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_asc ;

1054: -- When front-porting to newer releases , please use this statment instead of the following hard-coding.
1055: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_desc ;
1056: l_sort_by_req_date := 5 ;
1057: elsif p_direction_flag = 'F' then
1058: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_asc ;
1059: l_sort_by_req_date := 4 ;
1060: end if ;
1061: --
1062: -- Debug Statements

Line 1142: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1138: END QUERY_RESERVATIONS;
1139:
1140: -- This is a wrapper on inv_reservation_pub.delete_reservation
1141: PROCEDURE delete_reservation (
1142: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1143: x_return_status OUT NOCOPY VARCHAR2)
1144: IS
1145: l_msg_count NUMBER;
1146: l_msg_data VARCHAR2(2000);

Line 1148: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1144: IS
1145: l_msg_count NUMBER;
1146: l_msg_data VARCHAR2(2000);
1147: l_error_text VARCHAR2(6000);
1148: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1149: delete_reservation_failed EXCEPTION;
1150:
1151: --
1152: l_debug_on BOOLEAN;

Line 1255: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1251:
1252: -- This is a wrapper on inv_reservation_pub.create_reservation
1253: -- HW OPMCONV Pass Qty2 in order to call the correct INV_create_reservation
1254: PROCEDURE create_reservation (
1255: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1256: p_qty2 IN NUMBER default NULL,
1257: x_reservation_id OUT NOCOPY NUMBER,
1258: x_qty_reserved OUT NOCOPY NUMBER,
1259: x_return_status OUT NOCOPY VARCHAR2)

Line 1266: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1262:
1263: l_msg_count NUMBER;
1264: l_msg_data VARCHAR2(2000);
1265: l_error_text VARCHAR2(6000);
1266: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1267:
1268: -- HW OPMCONV - Added variable
1269: X_SECONDARY_QTY_RESERVED NUMBER;
1270:

Line 1426: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1422:
1423:
1424: -- This is a wrapper on inv_reservation_pub.update_reservation
1425: PROCEDURE update_reservation (
1426: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1427: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1428: x_return_status OUT NOCOPY VARCHAR2)
1429:
1430: IS

Line 1427: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,

1423:
1424: -- This is a wrapper on inv_reservation_pub.update_reservation
1425: PROCEDURE update_reservation (
1426: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1427: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1428: x_return_status OUT NOCOPY VARCHAR2)
1429:
1430: IS
1431:

Line 1435: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1431:
1432: l_msg_count NUMBER;
1433: l_msg_data VARCHAR2(2000);
1434: l_error_text VARCHAR2(6000);
1435: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1436:
1437: update_reservation_failed EXCEPTION;
1438:
1439: --

Line 1621: p_rsv IN inv_reservation_global.mtl_reservation_rec_type

1617: -- 3012297 (for OPM - adding delivery_detail_id parameter)
1618: FUNCTION check_inv_info (
1619: p_delivery_detail_split_rec IN DeliveryDetailInvRecType,
1620: p_delivery_detail_id IN NUMBER default NULL,
1621: p_rsv IN inv_reservation_global.mtl_reservation_rec_type
1622: ) return BOOLEAN IS
1623:
1624: --
1625: l_debug_on BOOLEAN;

Line 1773: l_rsv inv_reservation_global.mtl_reservation_rec_type;

1769: p_cancellation_quantity2 IN NUMBER,
1770: x_return_status OUT NOCOPY VARCHAR2)
1771: IS
1772:
1773: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1774: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1775: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1776: l_size NUMBER;
1777: l_msg_count NUMBER;

Line 1774: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

1770: x_return_status OUT NOCOPY VARCHAR2)
1771: IS
1772:
1773: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1774: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1775: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1776: l_size NUMBER;
1777: l_msg_count NUMBER;
1778: l_msg_data VARCHAR2(240);

Line 1775: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

1771: IS
1772:
1773: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1774: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1775: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1776: l_size NUMBER;
1777: l_msg_count NUMBER;
1778: l_msg_data VARCHAR2(240);
1779: l_cancelled_reservation_qty NUMBER;

Line 2098: l_rsv inv_reservation_global.mtl_reservation_rec_type;

2094: l_nonstaged_rsv_qty NUMBER;
2095: l_nonstaged_rsv_qty2 NUMBER;
2096: -- Bug 2595657
2097:
2098: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2099: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2100: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2101: l_size NUMBER;
2102: l_msg_count NUMBER;

Line 2099: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

2095: l_nonstaged_rsv_qty2 NUMBER;
2096: -- Bug 2595657
2097:
2098: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2099: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2100: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2101: l_size NUMBER;
2102: l_msg_count NUMBER;
2103: l_msg_data VARCHAR2(240);

Line 2100: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

2096: -- Bug 2595657
2097:
2098: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2099: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2100: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2101: l_size NUMBER;
2102: l_msg_count NUMBER;
2103: l_msg_data VARCHAR2(240);
2104: l_cancelled_reservation_qty NUMBER;

Line 2564: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,

2560: -- or inv_reservation_pub.transfer_reservation as required
2561: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2562: -- Functionality added in R12
2563: PROCEDURE Reservation_split_action (
2564: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,
2565: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,
2566: p_staged IN VARCHAR2,
2567: p_released_status IN VARCHAR2,
2568: p_split_quantity IN OUT NOCOPY NUMBER,

Line 2565: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,

2561: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2562: -- Functionality added in R12
2563: PROCEDURE Reservation_split_action (
2564: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,
2565: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,
2566: p_staged IN VARCHAR2,
2567: p_released_status IN VARCHAR2,
2568: p_split_quantity IN OUT NOCOPY NUMBER,
2569: p_split_quantity2 IN OUT NOCOPY NUMBER,

Line 2587: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

2583:
2584: l_detailed_quantity NUMBER;
2585: l_detailed_quantity2 NUMBER;
2586:
2587: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2588: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
2589:
2590: transfer_split_failed EXCEPTION;
2591: --

Line 2588: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

2584: l_detailed_quantity NUMBER;
2585: l_detailed_quantity2 NUMBER;
2586:
2587: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2588: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
2589:
2590: transfer_split_failed EXCEPTION;
2591: --
2592: l_debug_on BOOLEAN;

Line 2908: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

2904: p_direction_flag IN VARCHAR2 default 'U',
2905: x_return_status OUT NOCOPY VARCHAR2)
2906: IS
2907:
2908: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2909: l_msg_count NUMBER;
2910: l_msg_data VARCHAR2(240);
2911: l_rsv_id NUMBER;
2912: l_status VARCHAR2(1);

Line 2913: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

2909: l_msg_count NUMBER;
2910: l_msg_data VARCHAR2(240);
2911: l_rsv_id NUMBER;
2912: l_status VARCHAR2(1);
2913: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2914: l_size NUMBER;
2915: l_staged_flag VARCHAR2(1);
2916: -- HW OPMCONV. Removed OPM local variables
2917: