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

Line 103: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

99:
100:
101: -- Returns TRUE if RSV record is valid, FALSE otherwise
102: FUNCTION rsv_record_valid
103: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
104: ) RETURN BOOLEAN IS
105:
106: l_api_name VARCHAR2(30);
107: l_debug NUMBER;

Line 171: = inv_reservation_global.g_source_type_oe

167: -- Test with sales order / internal order that is not Booked }}
168: --
169: -- Ensure that sales order / internal order is booked
170: IF p_rsv_rec.demand_source_type_id
171: = inv_reservation_global.g_source_type_oe
172: OR
173: p_rsv_rec.demand_source_type_id
174: = inv_reservation_global.g_source_type_internal_ord
175: THEN

Line 174: = inv_reservation_global.g_source_type_internal_ord

170: IF p_rsv_rec.demand_source_type_id
171: = inv_reservation_global.g_source_type_oe
172: OR
173: p_rsv_rec.demand_source_type_id
174: = inv_reservation_global.g_source_type_internal_ord
175: THEN
176: OPEN c_chk_order_stat (p_rsv_rec.demand_source_line_id);
177: FETCH c_chk_order_stat INTO l_dummy;
178:

Line 209: NOT IN ( inv_reservation_global.g_source_type_oe

205: -- Material in Receiving }}
206: --
207: -- Check demand and supply source types
208: IF (p_rsv_rec.demand_source_type_id
209: NOT IN ( inv_reservation_global.g_source_type_oe
210: , inv_reservation_global.g_source_type_internal_ord
211: )
212: OR
213: p_rsv_rec.supply_source_type_id

Line 210: , inv_reservation_global.g_source_type_internal_ord

206: --
207: -- Check demand and supply source types
208: IF (p_rsv_rec.demand_source_type_id
209: NOT IN ( inv_reservation_global.g_source_type_oe
210: , inv_reservation_global.g_source_type_internal_ord
211: )
212: OR
213: p_rsv_rec.supply_source_type_id
214: NOT IN ( inv_reservation_global.g_source_type_po

Line 214: NOT IN ( inv_reservation_global.g_source_type_po

210: , inv_reservation_global.g_source_type_internal_ord
211: )
212: OR
213: p_rsv_rec.supply_source_type_id
214: NOT IN ( inv_reservation_global.g_source_type_po
215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit

Line 215: , inv_reservation_global.g_source_type_wip

211: )
212: OR
213: p_rsv_rec.supply_source_type_id
214: NOT IN ( inv_reservation_global.g_source_type_po
215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit
219: , inv_reservation_global.g_source_type_rcv

Line 216: , inv_reservation_global.g_source_type_internal_req

212: OR
213: p_rsv_rec.supply_source_type_id
214: NOT IN ( inv_reservation_global.g_source_type_po
215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit
219: , inv_reservation_global.g_source_type_rcv
220: )

Line 217: , inv_reservation_global.g_source_type_asn

213: p_rsv_rec.supply_source_type_id
214: NOT IN ( inv_reservation_global.g_source_type_po
215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit
219: , inv_reservation_global.g_source_type_rcv
220: )
221: )

Line 218: , inv_reservation_global.g_source_type_intransit

214: NOT IN ( inv_reservation_global.g_source_type_po
215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit
219: , inv_reservation_global.g_source_type_rcv
220: )
221: )
222: THEN

Line 219: , inv_reservation_global.g_source_type_rcv

215: , inv_reservation_global.g_source_type_wip
216: , inv_reservation_global.g_source_type_internal_req
217: , inv_reservation_global.g_source_type_asn
218: , inv_reservation_global.g_source_type_intransit
219: , inv_reservation_global.g_source_type_rcv
220: )
221: )
222: THEN
223: IF l_debug = 1 THEN

Line 258: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

254:
255:
256: PROCEDURE process_delivery_detail
257: ( x_return_status OUT NOCOPY VARCHAR2
258: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
259: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
260: , p_action_code IN VARCHAR2
261: ) IS
262:

Line 259: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

255:
256: PROCEDURE process_delivery_detail
257: ( x_return_status OUT NOCOPY VARCHAR2
258: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
259: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
260: , p_action_code IN VARCHAR2
261: ) IS
262:
263: l_api_name VARCHAR2(30);

Line 590: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

586:
587:
588: PROCEDURE create_crossdock_reservation
589: ( x_return_status OUT NOCOPY VARCHAR2
590: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
591: ) IS
592:
593: l_api_name VARCHAR2(30);
594: l_debug NUMBER;

Line 632: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

628:
629:
630: PROCEDURE update_crossdock_reservation
631: ( x_return_status OUT NOCOPY VARCHAR2
632: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: ) IS
635:
636: l_api_name VARCHAR2(30);

Line 633: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

629:
630: PROCEDURE update_crossdock_reservation
631: ( x_return_status OUT NOCOPY VARCHAR2
632: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: ) IS
635:
636: l_api_name VARCHAR2(30);
637: l_debug NUMBER;

Line 806: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

802:
803:
804: PROCEDURE transfer_crossdock_reservation
805: ( x_return_status OUT NOCOPY VARCHAR2
806: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
807: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
808: ) IS
809:
810: l_api_name VARCHAR2(30);

Line 807: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

803:
804: PROCEDURE transfer_crossdock_reservation
805: ( x_return_status OUT NOCOPY VARCHAR2
806: , p_orig_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
807: , p_new_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
808: ) IS
809:
810: l_api_name VARCHAR2(30);
811: l_debug NUMBER;

Line 852: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

848:
849:
850: PROCEDURE delete_crossdock_reservation
851: ( x_return_status OUT NOCOPY VARCHAR2
852: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
853: ) IS
854:
855: l_api_name VARCHAR2(30);
856: l_debug NUMBER;

Line 861: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

857: l_msg_count NUMBER;
858: l_msg_data VARCHAR2(2000);
859: l_api_return_status VARCHAR2(1);
860:
861: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
862:
863: BEGIN
864: x_return_status := fnd_api.g_ret_sts_success;
865: l_api_name := 'delete_crossdock_reservation';

Line 971: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

967:
968:
969: PROCEDURE relieve_crossdock_reservation
970: ( x_return_status OUT NOCOPY VARCHAR2
971: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
972: ) IS
973:
974: l_api_name VARCHAR2(30);
975: l_debug NUMBER;

Line 980: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

976: l_msg_count NUMBER;
977: l_msg_data VARCHAR2(2000);
978: l_api_return_status VARCHAR2(1);
979:
980: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
981:
982: BEGIN
983: x_return_status := fnd_api.g_ret_sts_success;
984: l_api_name := 'relieve_crossdock_reservation';