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_EXPRESS_PICK_PUB dependencies on INV_RESERVATION_GLOBAL

Line 27: ,p_reservation_rec INV_reservation_global.mtl_reservation_rec_type)

23:
24: -- This function returns TRUE if the reservation passed in is detailed
25: -- False otherwise.
26: FUNCTION check_detailed_rsv(p_mo_line_rec INV_Move_Order_PUB.TROLIN_REC_TYPE
27: ,p_reservation_rec INV_reservation_global.mtl_reservation_rec_type)
28: RETURN BOOLEAN IS
29:
30: l_detailed BOOLEAN;
31: BEGIN

Line 104: ,p_reservations_tbl IN inv_reservation_global.mtl_reservation_tbl_type

100: ,x_msg_data OUT NOCOPY VARCHAR2
101: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
102: ,p_grouping_rule_id IN NUMBER
103: ,p_allow_partial_pick IN VARCHAR2
104: ,p_reservations_tbl IN inv_reservation_global.mtl_reservation_tbl_type
105: ,p_pick_release_status_tbl OUT NOCOPY inv_express_pick_pub.p_pick_release_status_tbl
106: ) IS
107:
108: /*CURSOR c_rsv_rec (p_demand_source_type_id NUMBER

Line 169: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;

165: order by primary_reservation_quantity;
166: Commented out for 3237610*/
167:
168:
169: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
170: l_rsv_rec_ret_tbl inv_reservation_global.mtl_reservation_tbl_type ;
171: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
172: l_rsv_rec_param inv_reservation_global.mtl_reservation_rec_type; --Added for bug3237610
173: l_return_status VARCHAR2(1);

Line 170: l_rsv_rec_ret_tbl inv_reservation_global.mtl_reservation_tbl_type ;

166: Commented out for 3237610*/
167:
168:
169: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
170: l_rsv_rec_ret_tbl inv_reservation_global.mtl_reservation_tbl_type ;
171: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
172: l_rsv_rec_param inv_reservation_global.mtl_reservation_rec_type; --Added for bug3237610
173: l_return_status VARCHAR2(1);
174: l_loop_index NUMBER;

Line 171: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

167:
168:
169: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
170: l_rsv_rec_ret_tbl inv_reservation_global.mtl_reservation_tbl_type ;
171: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
172: l_rsv_rec_param inv_reservation_global.mtl_reservation_rec_type; --Added for bug3237610
173: l_return_status VARCHAR2(1);
174: l_loop_index NUMBER;
175: l_loop_status NUMBER;

Line 172: l_rsv_rec_param inv_reservation_global.mtl_reservation_rec_type; --Added for bug3237610

168:
169: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
170: l_rsv_rec_ret_tbl inv_reservation_global.mtl_reservation_tbl_type ;
171: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
172: l_rsv_rec_param inv_reservation_global.mtl_reservation_rec_type; --Added for bug3237610
173: l_return_status VARCHAR2(1);
174: l_loop_index NUMBER;
175: l_loop_status NUMBER;
176: l_line_index NUMBER;

Line 558: ,p_Reservation_tbl IN inv_reservation_global.mtl_reservation_tbl_type

554: END PICK_RELEASE;
555:
556:
557: PROCEDURE STAGE_DD_RSV(P_mo_line_REC IN INV_Move_Order_PUB.Trolin_Rec_Type
558: ,p_Reservation_tbl IN inv_reservation_global.mtl_reservation_tbl_type
559: ,p_pick_release_status_tbl IN OUT NOCOPY INV_EXPRESS_PICK_PUB.p_pick_release_status_tbl
560: , x_return_status OUT NOCOPY VARCHAR2
561: , x_msg_count OUT NOCOPY NUMBER
562: , x_msg_data OUT NOCOPY VARCHAR2) IS

Line 583: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;

579: );
580: TYPE inv_staged_rsv_id_tbl is TABLE of inv_staged_rsv_id_rec
581: INDEX BY BINARY_INTEGER;
582: L_API_NAME VARCHAR2(20):='STAGED_DD_RSV';
583: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
584: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
585: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
587: l_orig_delivery_detail_id NUMBER;

Line 584: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

580: TYPE inv_staged_rsv_id_tbl is TABLE of inv_staged_rsv_id_rec
581: INDEX BY BINARY_INTEGER;
582: L_API_NAME VARCHAR2(20):='STAGED_DD_RSV';
583: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
584: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
585: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
587: l_orig_delivery_detail_id NUMBER;
588: l_staged_rsv_id_tbl inv_staged_rsv_id_tbl;

Line 585: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

581: INDEX BY BINARY_INTEGER;
582: L_API_NAME VARCHAR2(20):='STAGED_DD_RSV';
583: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
584: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
585: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
587: l_orig_delivery_detail_id NUMBER;
588: l_staged_rsv_id_tbl inv_staged_rsv_id_tbl;
589: l_shipping_attr wsh_interface.changedattributetabtype;

Line 586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

582: L_API_NAME VARCHAR2(20):='STAGED_DD_RSV';
583: l_rsv_rec_tbl inv_reservation_global.mtl_reservation_tbl_type ;
584: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
585: l_original_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
587: l_orig_delivery_detail_id NUMBER;
588: l_staged_rsv_id_tbl inv_staged_rsv_id_tbl;
589: l_shipping_attr wsh_interface.changedattributetabtype;
590: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

Line 590: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

586: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
587: l_orig_delivery_detail_id NUMBER;
588: l_staged_rsv_id_tbl inv_staged_rsv_id_tbl;
589: l_shipping_attr wsh_interface.changedattributetabtype;
590: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
591:
592: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
593: l_rsv_index NUMBER :=0; --Split rsv counter
594: l_remain_dd_qty NUMBER :=0;

Line 597: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

593: l_rsv_index NUMBER :=0; --Split rsv counter
594: l_remain_dd_qty NUMBER :=0;
595: l_new_dd_id NUMBER;
596: l_qty2 NUMBER;
597: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
598: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type ;
599: l_mtl_reservation_count NUMBER;
600:
601: l_temp_index NUMBER :=0;

Line 598: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type ;

594: l_remain_dd_qty NUMBER :=0;
595: l_new_dd_id NUMBER;
596: l_qty2 NUMBER;
597: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
598: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type ;
599: l_mtl_reservation_count NUMBER;
600:
601: l_temp_index NUMBER :=0;
602: l_delivery_detail_id NUMBER;

Line 618: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

614: L_MSG_DATA VARCHAR2(100);
615: L_ERROR_CODE VARCHAR2(100);
616: l_index NUMBER;
617: l_res_index NUMBER; --Split wdd counter
618: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
619: l_last_rsv BOOLEAN:=false;
620: l_rsv_last_index NUMBER:=0;
621:
622: l_serial_number_control_code NUMBER:=0;