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 884: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

880: x_total_rsv IN OUT NOCOPY NUMBER ,
881: x_total_rsv2 IN OUT NOCOPY NUMBER ,
882: x_return_status IN OUT NOCOPY VARCHAR2)
883: IS
884: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
885: l_size NUMBER ;
886: l_return_status VARCHAR2(1);
887:
888: l_msg_count NUMBER;

Line 994: x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type,

990: p_lock_records IN VARCHAR2,
991: p_cancel_order_mode IN NUMBER,
992: p_direction_flag IN VARCHAR2 ,
993: p_delivery_detail_id IN NUMBER,
994: x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type,
995: x_mtl_reservation_tbl_count OUT NOCOPY NUMBER,
996: x_return_status OUT NOCOPY VARCHAR2)
997:
998: IS

Line 999: l_rsv inv_reservation_global.mtl_reservation_rec_type;

995: x_mtl_reservation_tbl_count OUT NOCOPY NUMBER,
996: x_return_status OUT NOCOPY VARCHAR2)
997:
998: IS
999: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1000: l_msg_count NUMBER;
1001: l_msg_data VARCHAR2(2000);
1002: l_error_text VARCHAR2(6000);
1003: l_error_code NUMBER;

Line 1062: l_sort_by_req_date := inv_reservation_global.g_query_no_sort ;

1058: l_rsv.demand_source_line_id := p_source_line_id;
1059: l_rsv.organization_id := p_organization_id;
1060: l_rsv.demand_source_line_detail := p_delivery_detail_id; -- X-dock
1061:
1062: l_sort_by_req_date := inv_reservation_global.g_query_no_sort ;
1063:
1064: if p_direction_flag = 'L' then
1065: -- The following statment is commented because we ideally need this code , but
1066: -- we cannot since it will mean we have to include INV's patch .

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

1064: if p_direction_flag = 'L' then
1065: -- The following statment is commented because we ideally need this code , but
1066: -- we cannot since it will mean we have to include INV's patch .
1067: -- When front-porting to newer releases , please use this statment instead of the following hard-coding.
1068: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_desc ;
1069: l_sort_by_req_date := 5 ;
1070: elsif p_direction_flag = 'F' then
1071: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_asc ;
1072: l_sort_by_req_date := 4 ;

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

1067: -- When front-porting to newer releases , please use this statment instead of the following hard-coding.
1068: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_desc ;
1069: l_sort_by_req_date := 5 ;
1070: elsif p_direction_flag = 'F' then
1071: -- l_sort_by_req_date := inv_reservation_global.g_query_req_date_inv_asc ;
1072: l_sort_by_req_date := 4 ;
1073: end if ;
1074: --
1075: -- Debug Statements

Line 1155: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1151: END QUERY_RESERVATIONS;
1152:
1153: -- This is a wrapper on inv_reservation_pub.delete_reservation
1154: PROCEDURE delete_reservation (
1155: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1156: x_return_status OUT NOCOPY VARCHAR2)
1157: IS
1158: l_msg_count NUMBER;
1159: l_msg_data VARCHAR2(2000);

Line 1161: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1157: IS
1158: l_msg_count NUMBER;
1159: l_msg_data VARCHAR2(2000);
1160: l_error_text VARCHAR2(6000);
1161: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1162: delete_reservation_failed EXCEPTION;
1163:
1164: --
1165: l_debug_on BOOLEAN;

Line 1268: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1264:
1265: -- This is a wrapper on inv_reservation_pub.create_reservation
1266: -- HW OPMCONV Pass Qty2 in order to call the correct INV_create_reservation
1267: PROCEDURE create_reservation (
1268: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1269: p_qty2 IN NUMBER default NULL,
1270: x_reservation_id OUT NOCOPY NUMBER,
1271: x_qty_reserved OUT NOCOPY NUMBER,
1272: x_return_status OUT NOCOPY VARCHAR2)

Line 1279: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1275:
1276: l_msg_count NUMBER;
1277: l_msg_data VARCHAR2(2000);
1278: l_error_text VARCHAR2(6000);
1279: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1280:
1281: -- HW OPMCONV - Added variable
1282: X_SECONDARY_QTY_RESERVED NUMBER;
1283:

Line 1439: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,

1435:
1436:
1437: -- This is a wrapper on inv_reservation_pub.update_reservation
1438: PROCEDURE update_reservation (
1439: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1440: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1441: x_return_status OUT NOCOPY VARCHAR2)
1442:
1443: IS

Line 1440: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,

1436:
1437: -- This is a wrapper on inv_reservation_pub.update_reservation
1438: PROCEDURE update_reservation (
1439: p_query_input IN inv_reservation_global.mtl_reservation_rec_type,
1440: p_new_resv_rec IN inv_reservation_global.mtl_reservation_rec_type,
1441: x_return_status OUT NOCOPY VARCHAR2)
1442:
1443: IS
1444:

Line 1448: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

1444:
1445: l_msg_count NUMBER;
1446: l_msg_data VARCHAR2(2000);
1447: l_error_text VARCHAR2(6000);
1448: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
1449:
1450: update_reservation_failed EXCEPTION;
1451:
1452: --

Line 1634: p_rsv IN inv_reservation_global.mtl_reservation_rec_type

1630: -- 3012297 (for OPM - adding delivery_detail_id parameter)
1631: FUNCTION check_inv_info (
1632: p_delivery_detail_split_rec IN DeliveryDetailInvRecType,
1633: p_delivery_detail_id IN NUMBER default NULL,
1634: p_rsv IN inv_reservation_global.mtl_reservation_rec_type
1635: ) return BOOLEAN IS
1636:
1637: --
1638: l_debug_on BOOLEAN;

Line 1786: l_rsv inv_reservation_global.mtl_reservation_rec_type;

1782: p_cancellation_quantity2 IN NUMBER,
1783: x_return_status OUT NOCOPY VARCHAR2)
1784: IS
1785:
1786: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1787: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1788: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1789: l_size NUMBER;
1790: l_msg_count NUMBER;

Line 1787: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

1783: x_return_status OUT NOCOPY VARCHAR2)
1784: IS
1785:
1786: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1787: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1788: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1789: l_size NUMBER;
1790: l_msg_count NUMBER;
1791: l_msg_data VARCHAR2(240);

Line 1788: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

1784: IS
1785:
1786: l_rsv inv_reservation_global.mtl_reservation_rec_type;
1787: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
1788: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
1789: l_size NUMBER;
1790: l_msg_count NUMBER;
1791: l_msg_data VARCHAR2(240);
1792: l_cancelled_reservation_qty NUMBER;

Line 2111: l_rsv inv_reservation_global.mtl_reservation_rec_type;

2107: l_nonstaged_rsv_qty NUMBER;
2108: l_nonstaged_rsv_qty2 NUMBER;
2109: -- Bug 2595657
2110:
2111: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2112: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2113: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2114: l_size NUMBER;
2115: l_msg_count NUMBER;

Line 2112: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

2108: l_nonstaged_rsv_qty2 NUMBER;
2109: -- Bug 2595657
2110:
2111: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2112: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2113: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2114: l_size NUMBER;
2115: l_msg_count NUMBER;
2116: l_msg_data VARCHAR2(240);

Line 2113: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

2109: -- Bug 2595657
2110:
2111: l_rsv inv_reservation_global.mtl_reservation_rec_type;
2112: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2113: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
2114: l_size NUMBER;
2115: l_msg_count NUMBER;
2116: l_msg_data VARCHAR2(240);
2117: l_cancelled_reservation_qty NUMBER;

Line 2725: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,

2721: -- COMMENT : p_rsv.demand_source_line_detail is required for X-dock lines
2722: -- Functionality added in R12
2723: -- Added parameter p_shipped_flag for bug 10105817
2724: PROCEDURE Reservation_split_action (
2725: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,
2726: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,
2727: p_staged IN VARCHAR2,
2728: p_released_status IN VARCHAR2,
2729: p_split_quantity IN OUT NOCOPY NUMBER,

Line 2726: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,

2722: -- Functionality added in R12
2723: -- Added parameter p_shipped_flag for bug 10105817
2724: PROCEDURE Reservation_split_action (
2725: p_rsv IN inv_reservation_global.mtl_reservation_rec_type,
2726: p_rsv_new IN inv_reservation_global.mtl_reservation_rec_type,
2727: p_staged IN VARCHAR2,
2728: p_released_status IN VARCHAR2,
2729: p_split_quantity IN OUT NOCOPY NUMBER,
2730: p_split_quantity2 IN OUT NOCOPY NUMBER,

Line 2755: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

2751:
2752: l_detailed_quantity NUMBER;
2753: l_detailed_quantity2 NUMBER;
2754:
2755: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2756: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
2757:
2758: transfer_split_failed EXCEPTION;
2759: l_validation_flag VARCHAR2(1);

Line 2756: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;

2752: l_detailed_quantity NUMBER;
2753: l_detailed_quantity2 NUMBER;
2754:
2755: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
2756: l_dummy_sn INV_RESERVATION_GLOBAL.serial_number_tbl_type;
2757:
2758: transfer_split_failed EXCEPTION;
2759: l_validation_flag VARCHAR2(1);
2760: --

Line 3190: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

3186: l_temp_transaction_quantity NUMBER;
3187: l_temp_transaction_quantity2 NUMBER;
3188: -- bug # 9410461: End
3189:
3190: l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
3191: l_msg_count NUMBER;
3192: l_msg_data VARCHAR2(240);
3193: l_rsv_id NUMBER;
3194: l_status VARCHAR2(1);

Line 3195: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

3191: l_msg_count NUMBER;
3192: l_msg_data VARCHAR2(240);
3193: l_rsv_id NUMBER;
3194: l_status VARCHAR2(1);
3195: l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
3196: l_size NUMBER;
3197: l_staged_flag VARCHAR2(1);
3198: -- HW OPMCONV. Removed OPM local variables
3199: