DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on INV_REPLENISH_DETAIL_PUB

Line 1: PACKAGE BODY inv_replenish_detail_pub AS

1: PACKAGE BODY inv_replenish_detail_pub AS
2: /* $Header: INVTOTXB.pls 120.11.12010000.2 2008/07/29 13:46:55 ptkumar ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Replenish_Detail_PUB';

2: /* $Header: INVTOTXB.pls 120.11.12010000.2 2008/07/29 13:46:55 ptkumar ship $ */
3:
4: -- Global constant holding the package name
5:
6: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_Replenish_Detail_PUB';
7: is_debug BOOLEAN := TRUE;
8: g_retain_ato_profile VARCHAR2(1) := fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS');
9:
10: -- Start of Comments

Line 399: inv_replenish_detail_pub.delete_details(

395: print_debug('calling delete details');
396: END IF;
397:
398: -- HW INVCONV - Pass secondary_qty
399: inv_replenish_detail_pub.delete_details(
400: p_transaction_temp_id => l_mold_tbl_temp(l_index).transaction_temp_id
401: , p_move_order_line_id => l_mold_tbl_temp(l_index).move_order_line_id
402: , p_reservation_id => l_mold_tbl_temp(l_index).reservation_id
403: , p_transaction_quantity => l_mold_tbl_temp(l_index).transaction_quantity

Line 2071: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');

2067:
2068: IF (l_debug = 1) THEN
2069: print_debug('OVPK: l_all_alloc = ' || l_all_alloc);
2070: print_debug('OVPK: l_other_alloc = l_all_alloc - l_this_alloc = ' || l_other_alloc);
2071: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');
2072: print_debug('OVPK: With the following params');
2073: print_debug('OVPK: l_mo_line_id = ' || l_mo_line_id);
2074: print_debug('OVPK: p_new_qty = ' || l_new_qty);
2075: END IF;

Line 2079: inv_replenish_detail_pub.check_shipping_tolerances(

2075: END IF;
2076:
2077: -- Call the shipping API to get l_max_quantity_allowed for this particular SO Line
2078: IF l_trx_source_line_id IS NOT NULL THEN
2079: inv_replenish_detail_pub.check_shipping_tolerances(
2080: x_return_status => l_return_status
2081: , x_msg_count => l_msg_count
2082: , x_msg_data => l_msg_data
2083: , x_allowed => l_allowed_flag

Line 2268: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty

2264: print_debug('OVPK: p_transaction_temp_id = ' || p_transaction_temp_id);
2265: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
2266: END IF;
2267:
2268: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2269: --to find out if overpicking is allowed
2270: --and if allowed,to what extent
2271: inv_replenish_detail_pub.get_overpick_qty(
2272: p_transaction_temp_id => p_transaction_temp_id

Line 2271: inv_replenish_detail_pub.get_overpick_qty(

2267:
2268: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2269: --to find out if overpicking is allowed
2270: --and if allowed,to what extent
2271: inv_replenish_detail_pub.get_overpick_qty(
2272: p_transaction_temp_id => p_transaction_temp_id
2273: , p_overpicked_qty => p_overpicked_qty
2274: , x_ovpk_allowed => l_ovpk_allowed
2275: , x_max_qty_allowed => l_max_qty_allowed

Line 2607: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty

2603: print_debug('OVPK: p_transaction_temp_id = ' || p_transaction_temp_id);
2604: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
2605: END IF;
2606:
2607: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2608: --to find out if overpicking is allowed
2609: --and if allowed,to what extent
2610: inv_replenish_detail_pub.get_overpick_qty(
2611: p_transaction_temp_id => p_transaction_temp_id

Line 2610: inv_replenish_detail_pub.get_overpick_qty(

2606:
2607: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty
2608: --to find out if overpicking is allowed
2609: --and if allowed,to what extent
2610: inv_replenish_detail_pub.get_overpick_qty(
2611: p_transaction_temp_id => p_transaction_temp_id
2612: , p_overpicked_qty => p_overpicked_qty
2613: , x_ovpk_allowed => l_ovpk_allowed
2614: , x_max_qty_allowed => l_max_qty_allowed

Line 2954: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');

2950:
2951: IF (l_debug = 1) THEN
2952: print_debug('OVPK: l_all_alloc = ' || l_all_alloc);
2953: print_debug('OVPK: l_other_alloc = l_all_alloc - l_this_alloc = ' || l_other_alloc);
2954: print_debug('OVPK: Calling inv_replenish_detail_pub.check_shipping_tolerances');
2955: print_debug('OVPK: With the following params');
2956: print_debug('OVPK: l_mo_line_id = ' || l_mo_line_id);
2957: print_debug('OVPK: p_new_qty = ' || l_new_qty);
2958: END IF;

Line 2962: inv_replenish_detail_pub.check_shipping_tolerances(

2958: END IF;
2959:
2960: -- Call the shipping API to get l_max_quantity_allowed for this particular SO Line
2961: IF l_trx_source_line_id IS NOT NULL THEN
2962: inv_replenish_detail_pub.check_shipping_tolerances(
2963: x_return_status => l_return_status
2964: , x_msg_count => l_msg_count
2965: , x_msg_data => l_msg_data
2966: , x_allowed => l_allowed_flag

Line 3148: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot

3144: print_debug('OVPK: p_overpicked_qty = ' || p_overpicked_qty);
3145: print_debug('OVPK: p_lot_num = ' || p_lot_num);
3146: END IF;
3147:
3148: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot
3149: --to find out if overpicking is allowed
3150: --and if allowed,to what extent
3151: inv_replenish_detail_pub.get_overpick_qty_lot(
3152: p_transaction_temp_id => p_transaction_temp_id

Line 3151: inv_replenish_detail_pub.get_overpick_qty_lot(

3147:
3148: --Call INV_Replenish_Detail_Pub.Get_Overpick_Qty_Lot
3149: --to find out if overpicking is allowed
3150: --and if allowed,to what extent
3151: inv_replenish_detail_pub.get_overpick_qty_lot(
3152: p_transaction_temp_id => p_transaction_temp_id
3153: , p_overpicked_qty => p_overpicked_qty
3154: , p_lot_num => p_lot_num
3155: , x_ovpk_allowed => l_ovpk_allowed

Line 3327: END inv_replenish_detail_pub;

3323: END IF;
3324: END check_overpick_lot;
3325:
3326: ---------------------------------------------------
3327: END inv_replenish_detail_pub;