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

Line 33: l_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

29:
30:
31: FUNCTION is_reservation_allowed
32: (
33: l_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
34: )
35: RETURN NUMBER
36: IS
37: l_default_org_status_id NUMBER;

Line 225: ( p_mtl_reservation IN OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type ,

221: -- In order to pick the exact match or closest match, we need
222: -- to sort the output rsv table in the above manner
223:
224: PROCEDURE Sort_Reservation
225: ( p_mtl_reservation IN OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type ,
226: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,
227: x_return_status OUT NOCOPY VARCHAR2 ,
228: x_msg_count OUT NOCOPY NUMBER ,
229: x_msg_data OUT NOCOPY VARCHAR2

Line 226: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,

222: -- to sort the output rsv table in the above manner
223:
224: PROCEDURE Sort_Reservation
225: ( p_mtl_reservation IN OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type ,
226: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,
227: x_return_status OUT NOCOPY VARCHAR2 ,
228: x_msg_count OUT NOCOPY NUMBER ,
229: x_msg_data OUT NOCOPY VARCHAR2
230: )

Line 232: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

228: x_msg_count OUT NOCOPY NUMBER ,
229: x_msg_data OUT NOCOPY VARCHAR2
230: )
231: IS
232: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
233: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
234: l_rsv_index NUMBER := 0;
235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
236: l_debug NUMBER;

Line 233: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

229: x_msg_data OUT NOCOPY VARCHAR2
230: )
231: IS
232: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
233: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
234: l_rsv_index NUMBER := 0;
235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
236: l_debug NUMBER;
237:

Line 400: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,

396: -- Description
397: -- Used to get the atr for the sku passed in rsv rec
398:
399: PROCEDURE Get_atr
400: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,
401: x_atr OUT NOCOPY NUMBER ,
402: x_return_status OUT NOCOPY VARCHAR2 ,
403: x_msg_count OUT NOCOPY NUMBER ,
404: x_msg_data OUT NOCOPY VARCHAR2

Line 407: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

403: x_msg_count OUT NOCOPY NUMBER ,
404: x_msg_data OUT NOCOPY VARCHAR2
405: )
406: IS
407: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
408: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
409: l_rsv_index NUMBER := 0;
410: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
411: l_debug NUMBER;

Line 408: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

404: x_msg_data OUT NOCOPY VARCHAR2
405: )
406: IS
407: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
408: x_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
409: l_rsv_index NUMBER := 0;
410: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
411: l_debug NUMBER;
412: l_rev_control BOOLEAN;

Line 438: IF INV_CACHE.item_rec.revision_qty_control_code = inv_reservation_global.g_revision_control_yes THEN

434: IF (l_debug = 1) THEN
435: debug_print('Inside Get atr ');
436: END IF;
437:
438: IF INV_CACHE.item_rec.revision_qty_control_code = inv_reservation_global.g_revision_control_yes THEN
439: l_rev_control := TRUE;
440: ELSE
441: l_rev_control := FALSE;
442: END IF;

Line 444: IF INV_CACHE.item_rec.lot_control_code = inv_reservation_global.g_lot_control_yes THEN

440: ELSE
441: l_rev_control := FALSE;
442: END IF;
443:
444: IF INV_CACHE.item_rec.lot_control_code = inv_reservation_global.g_lot_control_yes THEN
445: l_lot_control := TRUE;
446: ELSE
447: l_lot_control := FALSE;
448: END IF;

Line 450: IF INV_CACHE.item_rec.serial_number_control_code <> inv_reservation_global.g_serial_control_predefined THEN

446: ELSE
447: l_lot_control := FALSE;
448: END IF;
449:
450: IF INV_CACHE.item_rec.serial_number_control_code <> inv_reservation_global.g_serial_control_predefined THEN
451: l_ser_control := TRUE;
452: ELSE
453: l_ser_control := FALSE;
454: END IF;

Line 614: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,

610:
611: PROCEDURE Process_Reservation
612: ( p_api_version_number IN NUMBER ,
613: p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false ,
614: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,
615: p_serial_number IN inv_reservation_global.serial_number_tbl_type ,
616: p_rsv_status IN VARCHAR2,
617: x_return_status OUT NOCOPY VARCHAR2 ,
618: x_msg_count OUT NOCOPY NUMBER ,

Line 615: p_serial_number IN inv_reservation_global.serial_number_tbl_type ,

611: PROCEDURE Process_Reservation
612: ( p_api_version_number IN NUMBER ,
613: p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false ,
614: p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type ,
615: p_serial_number IN inv_reservation_global.serial_number_tbl_type ,
616: p_rsv_status IN VARCHAR2,
617: x_return_status OUT NOCOPY VARCHAR2 ,
618: x_msg_count OUT NOCOPY NUMBER ,
619: x_msg_data OUT NOCOPY VARCHAR2

Line 626: l_query_input inv_reservation_global.mtl_reservation_rec_type;

622:
623: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
624: l_msg_count NUMBER;
625: l_msg_data VARCHAR2(2000);
626: l_query_input inv_reservation_global.mtl_reservation_rec_type;
627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;

623: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
624: l_msg_count NUMBER;
625: l_msg_data VARCHAR2(2000);
626: l_query_input inv_reservation_global.mtl_reservation_rec_type;
627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;

Line 628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;

624: l_msg_count NUMBER;
625: l_msg_data VARCHAR2(2000);
626: l_query_input inv_reservation_global.mtl_reservation_rec_type;
627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;

625: l_msg_data VARCHAR2(2000);
626: l_query_input inv_reservation_global.mtl_reservation_rec_type;
627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;

Line 630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

626: l_query_input inv_reservation_global.mtl_reservation_rec_type;
627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;

Line 631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;

627: l_query_det_rsv inv_reservation_global.mtl_reservation_rec_type;
628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

Line 632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

628: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type;
629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;

Line 633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;

629: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type;
630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;

Line 634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;

630: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

631: l_rsv_rec1 inv_reservation_global.mtl_reservation_rec_type;
632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;

632: l_create_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;
640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;

Line 637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;

633: l_mtl_reservation_staged inv_reservation_global.mtl_reservation_rec_type;
634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;
640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;
641: l_mtl_rsv_non_staged_count NUMBER := 0;

Line 638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

634: l_mtl_reservation_det_qty inv_reservation_global.mtl_reservation_rec_type;
635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;
640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;
641: l_mtl_rsv_non_staged_count NUMBER := 0;
642: l_mtl_rsv_detailed_count NUMBER := 0;

Line 639: l_serial_number inv_reservation_global.serial_number_tbl_type;

635: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;
640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;
641: l_mtl_rsv_non_staged_count NUMBER := 0;
642: l_mtl_rsv_detailed_count NUMBER := 0;
643: l_mtl_reservation_count NUMBER := 0;

Line 640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;

636: l_mtl_reservation_non_staged inv_reservation_global.mtl_reservation_tbl_type;
637: l_mtl_reservation_detailed inv_reservation_global.mtl_reservation_tbl_type;
638: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
639: l_serial_number inv_reservation_global.serial_number_tbl_type;
640: l_serial_number1 inv_reservation_global.serial_number_tbl_type;
641: l_mtl_rsv_non_staged_count NUMBER := 0;
642: l_mtl_rsv_detailed_count NUMBER := 0;
643: l_mtl_reservation_count NUMBER := 0;
644: l_error_code NUMBER;

Line 729: l_query_input.supply_source_type_id := inv_reservation_global.g_source_type_inv;

725: l_query_input.demand_source_line_id := l_rsv_rec.demand_source_line_id;
726: l_query_input.demand_source_header_id := l_rsv_rec.demand_source_header_id;
727: l_query_input.inventory_item_Id := l_rsv_rec.inventory_item_Id;
728: l_query_input.organization_id := l_rsv_rec.organization_id;
729: l_query_input.supply_source_type_id := inv_reservation_global.g_source_type_inv;
730: l_query_input.demand_source_type_id := l_rsv_rec.demand_source_type_id;
731:
732:
733: IF (l_debug = 1) THEN

Line 1087: l_create_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

1083: l_create_rsv_rec.secondary_reservation_quantity := l_rsv_rec.secondary_reservation_quantity;
1084: l_create_rsv_rec.autodetail_group_id := NULL;
1085: l_create_rsv_rec.external_source_code := NULL;
1086: l_create_rsv_rec.external_source_line_id := NULL;
1087: l_create_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
1088: l_create_rsv_rec.supply_source_header_id := NULL;
1089: l_create_rsv_rec.supply_source_line_id := NULL;
1090: l_create_rsv_rec.supply_source_name := NULL;
1091: l_create_rsv_rec.supply_source_line_detail := NULL;