DBA Data[Home] [Help]

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.59.12010000.3 2008/09/30 07:31:41 kkesavar ship $*/
3: --
4: g_pkg_name CONSTANT VARCHAR2(30) := 'Inv_reservation_pvt';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: INVRSV3B.pls 120.59.12010000.3 2008/09/30 07:31:41 kkesavar ship $';

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

1: PACKAGE BODY inv_reservation_pvt AS
2: /* $Header: INVRSV3B.pls 120.59.12010000.3 2008/09/30 07:31:41 kkesavar ship $*/
3: --
4: g_pkg_name CONSTANT VARCHAR2(30) := 'Inv_reservation_pvt';
5: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: INVRSV3B.pls 120.59.12010000.3 2008/09/30 07:31:41 kkesavar ship $';
6:
7: --
8: TYPE query_cur_ref_type IS REF CURSOR;

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

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

Line 7495: inv_reservation_pvt.query_reservation

7491: END IF;
7492: l_rsv_rec := p_query_input;
7493: -- First call the query reservations to get all the reservation
7494: -- records.
7495: inv_reservation_pvt.query_reservation
7496: (p_api_version_number => 1.0,
7497: p_init_msg_lst => fnd_api.g_false,
7498: x_return_status => l_return_status,
7499: x_msg_count => x_msg_count,

Line 7788: inv_reservation_pvt.convert_quantity

7784: END IF;
7785:
7786: l_progress :=50;
7787:
7788: inv_reservation_pvt.convert_quantity
7789: (x_return_status => l_return_status,
7790: px_rsv_rec => l_rsv_rec
7791: );
7792:

Line 7821: inv_reservation_pvt.query_reservation

7817: END IF;
7818:
7819: l_progress := 70;
7820:
7821: inv_reservation_pvt.query_reservation
7822: (p_api_version_number => 1.0,
7823: p_init_msg_lst => fnd_api.g_false,
7824: x_return_status => l_return_status,
7825: x_msg_count => x_msg_count,

Line 7890: inv_reservation_pvt.print_rsv_rec (p_rsv_rec);

7886: RAISE fnd_api.g_exc_error;
7887: END IF;
7888:
7889: IF l_debug=1 THEN
7890: inv_reservation_pvt.print_rsv_rec (p_rsv_rec);
7891: END IF;
7892:
7893: l_progress := 90;
7894:

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

7892:
7893: l_progress := 90;
7894:
7895: FOR i IN 1..l_mtl_reservation_tbl_count LOOP
7896: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));
7897:
7898: --If the queried reservation record is staged or has a lot number stamped or is
7899: -- revision controlled or has an LPN Id stamped or has a different SubInventory
7900: l_progress := 100;

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

7921:
7922: IF l_debug=1 THEN
7923:
7924: debug_print('Reservation record that needs to be updated');
7925: inv_reservation_pvt.print_rsv_rec (l_mtl_reservation_tbl(i));
7926:
7927: END IF;
7928:
7929: l_progress := 120;

Line 7965: inv_reservation_pvt.update_reservation

7961: debug_print('Calling update reservations to update reservation record');
7962:
7963: END IF;
7964:
7965: inv_reservation_pvt.update_reservation
7966: (p_api_version_number => 1.0,
7967: p_init_msg_lst => fnd_api.g_false,
7968: x_return_status => l_return_status,
7969: x_msg_count => x_msg_count,

Line 9274: inv_reservation_pvt.update_reservation

9270: debug_print('Calling the overloaded procedure update_reservation');
9271: END IF;
9272:
9273: -- INVCONV Upgrade call to incorporate secondary_quantity_reserved
9274: inv_reservation_pvt.update_reservation
9275: (p_api_version_number => 1.0,
9276: p_init_msg_lst => fnd_api.g_false,
9277: x_return_status => l_return_status,
9278: x_msg_count => x_msg_count,

Line 12247: inv_reservation_pvt.transfer_reservation

12243: IF l_debug=1 THEN
12244: debug_print('Calling the overloaded procedure transfer_reservation');
12245: END IF;
12246:
12247: inv_reservation_pvt.transfer_reservation
12248: (p_api_version_number => 1.0,
12249: p_init_msg_lst => p_init_msg_lst,
12250: x_return_status => l_return_status,
12251: x_msg_count => x_msg_count,

Line 16544: INV_RESERVATION_PVT.Transfer_Reservation (

16540: l_xfr_rsv.reservation_quantity := NULL;
16541: l_xfr_rsv.reservation_id := NULL;
16542:
16543: l_progress := 'Call to Transfer_Reservation';
16544: INV_RESERVATION_PVT.Transfer_Reservation (
16545: p_api_version_number => 1.0
16546: , p_init_msg_lst => fnd_api.g_false
16547: , x_return_status => x_return_status
16548: , x_msg_count => x_msg_count

Line 17244: Inv_Reservation_Pvt.transfer_reservation

17240: l_to_serial_number_tab(1).Serial_Number := p_to_serial_number;
17241: l_to_serial_number_tab(1).inventory_item_id := p_inventory_item_id;
17242: --Call Reservation Transafer API
17243:
17244: Inv_Reservation_Pvt.transfer_reservation
17245: (
17246: p_api_version_number => p_api_version_number ,
17247: p_init_msg_lst => p_init_msg_lst,
17248: x_return_status => l_return_status,

Line 17505: inv_reservation_pvt.transfer_reservation(

17501: debug_print('calling transfer_reservations');
17502: debug_print('original rec rsv id = ' || l_original_rsv_rec.reservation_id);
17503: END IF;
17504:
17505: inv_reservation_pvt.transfer_reservation(
17506: p_api_version_number => 1.0
17507: , p_init_msg_lst => fnd_api.g_false
17508: , x_return_status => l_return_status
17509: , x_msg_count => l_msg_count

Line 17575: END inv_reservation_pvt;

17571: END transfer_serial_rsv_in_LPN;
17572:
17573: /*** End R12 ***/
17574:
17575: END inv_reservation_pvt;
17576: