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_RESERVATION_PVT dependencies on INV_RESERVATION_PVT

Line 1: PACKAGE BODY inv_reservation_pvt AS

1: PACKAGE BODY inv_reservation_pvt AS
2: /* $Header: INVRSV3B.pls 120.83.12020000.9 2013/03/13 12:07:59 avrose ship $*/
3: --
4: g_pkg_name CONSTANT VARCHAR2(30) := 'Inv_reservation_pvt';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: INVRSV3B.pls 120.83.12020000.9 2013/03/13 12:07:59 avrose ship $';

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'Inv_reservation_pvt';

1: PACKAGE BODY inv_reservation_pvt AS
2: /* $Header: INVRSV3B.pls 120.83.12020000.9 2013/03/13 12:07:59 avrose ship $*/
3: --
4: g_pkg_name CONSTANT VARCHAR2(30) := 'Inv_reservation_pvt';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: INVRSV3B.pls 120.83.12020000.9 2013/03/13 12:07:59 avrose ship $';
6:
7: --
8: TYPE query_cur_ref_type IS REF CURSOR;

Line 26: inv_log_util.TRACE(p_message, 'INV_RESERVATION_PVT', p_level);

22: --Bug: 3559328: Performance bug fix.The fnd call happens everytime
23: -- debug_print is called.
24: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
25: BEGIN
26: inv_log_util.TRACE(p_message, 'INV_RESERVATION_PVT', p_level);
27: END debug_print;
28:
29: --
30: PROCEDURE print_rsv_rec(p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type) IS

Line 7882: inv_reservation_pvt.query_reservation

7878: END IF;
7879: l_rsv_rec := p_query_input;
7880: -- First call the query reservations to get all the reservation
7881: -- records.
7882: inv_reservation_pvt.query_reservation
7883: (p_api_version_number => 1.0,
7884: p_init_msg_lst => fnd_api.g_false,
7885: x_return_status => l_return_status,
7886: x_msg_count => x_msg_count,

Line 8205: inv_reservation_pvt.convert_quantity

8201: END IF;
8202:
8203: l_progress :=50;
8204:
8205: inv_reservation_pvt.convert_quantity
8206: (x_return_status => l_return_status,
8207: px_rsv_rec => l_rsv_rec
8208: );
8209:

Line 8238: inv_reservation_pvt.query_reservation

8234: END IF;
8235:
8236: l_progress := 70;
8237:
8238: inv_reservation_pvt.query_reservation
8239: (p_api_version_number => 1.0,
8240: p_init_msg_lst => fnd_api.g_false,
8241: x_return_status => l_return_status,
8242: x_msg_count => x_msg_count,

Line 8307: inv_reservation_pvt.print_rsv_rec (p_rsv_rec);

8303: RAISE fnd_api.g_exc_error;
8304: END IF;
8305:
8306: IF l_debug=1 THEN
8307: inv_reservation_pvt.print_rsv_rec (p_rsv_rec);
8308: END IF;
8309:
8310: l_progress := 90;
8311:

Line 8313: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));

8309:
8310: l_progress := 90;
8311:
8312: FOR i IN 1..l_mtl_reservation_tbl_count LOOP
8313: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));
8314:
8315: --If the queried reservation record is staged or has a lot number stamped or is
8316: -- revision controlled or has an LPN Id stamped or has a different SubInventory
8317: l_progress := 100;

Line 8342: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));

8338:
8339: IF l_debug=1 THEN
8340:
8341: debug_print('Reservation record that needs to be updated');
8342: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));
8343:
8344: END IF;
8345:
8346: l_progress := 120;

Line 8382: inv_reservation_pvt.update_reservation

8378: debug_print('Calling update reservations to update reservation record');
8379:
8380: END IF;
8381:
8382: inv_reservation_pvt.update_reservation
8383: (p_api_version_number => 1.0,
8384: p_init_msg_lst => fnd_api.g_false,
8385: x_return_status => l_return_status,
8386: x_msg_count => x_msg_count,

Line 9834: inv_reservation_pvt.update_reservation

9830: debug_print('Calling the overloaded procedure update_reservation');
9831: END IF;
9832:
9833: -- INVCONV Upgrade call to incorporate secondary_quantity_reserved
9834: inv_reservation_pvt.update_reservation
9835: (p_api_version_number => 1.0,
9836: p_init_msg_lst => fnd_api.g_false,
9837: x_return_status => l_return_status,
9838: x_msg_count => x_msg_count,

Line 13018: inv_reservation_pvt.transfer_reservation

13014: IF l_debug=1 THEN
13015: debug_print('Calling the overloaded procedure transfer_reservation');
13016: END IF;
13017:
13018: inv_reservation_pvt.transfer_reservation
13019: (p_api_version_number => 1.0,
13020: p_init_msg_lst => p_init_msg_lst,
13021: x_return_status => l_return_status,
13022: x_msg_count => x_msg_count,

Line 17710: INV_RESERVATION_PVT.Transfer_Reservation (

17706: l_xfr_rsv.reservation_quantity := NULL;
17707: l_xfr_rsv.reservation_id := NULL;
17708:
17709: l_progress := 'Call to Transfer_Reservation';
17710: INV_RESERVATION_PVT.Transfer_Reservation (
17711: p_api_version_number => 1.0
17712: , p_init_msg_lst => fnd_api.g_false
17713: , x_return_status => x_return_status
17714: , x_msg_count => x_msg_count

Line 18412: Inv_Reservation_Pvt.transfer_reservation

18408: l_to_serial_number_tab(1).Serial_Number := p_to_serial_number;
18409: l_to_serial_number_tab(1).inventory_item_id := p_inventory_item_id;
18410: --Call Reservation Transafer API
18411:
18412: Inv_Reservation_Pvt.transfer_reservation
18413: (
18414: p_api_version_number => p_api_version_number ,
18415: p_init_msg_lst => p_init_msg_lst,
18416: x_return_status => l_return_status,

Line 18673: inv_reservation_pvt.transfer_reservation(

18669: debug_print('calling transfer_reservations');
18670: debug_print('original rec rsv id = ' || l_original_rsv_rec.reservation_id);
18671: END IF;
18672:
18673: inv_reservation_pvt.transfer_reservation(
18674: p_api_version_number => 1.0
18675: , p_init_msg_lst => fnd_api.g_false
18676: , x_return_status => l_return_status
18677: , x_msg_count => l_msg_count

Line 18743: END inv_reservation_pvt;

18739: END transfer_serial_rsv_in_LPN;
18740:
18741: /*** End R12 ***/
18742:
18743: END inv_reservation_pvt;
18744: