DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WMS_CATCH_WEIGHT_PVT

Line 3283: wms_catch_weight_pvt.get_ont_pricing_qty_source(

3279: ORDER BY lot_number;
3280: BEGIN
3281: -- Check if pricing is tracked by secondary qty
3282: l_pricing_ind :=
3283: wms_catch_weight_pvt.get_ont_pricing_qty_source(
3284: p_api_version => 1.0
3285: , x_return_status => ret_status
3286: , x_msg_count => ret_msgcnt
3287: , x_msg_data => ret_msgdata

Line 3311: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN

3307: FOR lottmp_rec IN lottmp_cur LOOP
3308: l_lotfound := TRUE;
3309:
3310: IF l_tracking_quantity_ind = 'P' THEN -- 16493898
3311: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3312: IF (l_prev_lot <> lottmp_rec.lot_number) THEN
3313: l_prev_lot := lottmp_rec.lot_number;
3314: wms_catch_weight_pvt.show_ct_wt_for_split(
3315: x_return_status => ret_status

Line 3314: wms_catch_weight_pvt.show_ct_wt_for_split(

3310: IF l_tracking_quantity_ind = 'P' THEN -- 16493898
3311: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3312: IF (l_prev_lot <> lottmp_rec.lot_number) THEN
3313: l_prev_lot := lottmp_rec.lot_number;
3314: wms_catch_weight_pvt.show_ct_wt_for_split(
3315: x_return_status => ret_status
3316: , x_msg_data => ret_msgcnt
3317: , x_msg_count => ret_msgdata
3318: , p_org_id => p_org_id

Line 3339: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3335: END IF;
3336:
3337: IF (l_valid_sec_qty_split <> 1) THEN
3338: --Clear the secondary quantity fields for the from LPN
3339: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3340: p_api_version => 1.0
3341: , x_return_status => ret_status
3342: , x_msg_count => ret_msgcnt
3343: , x_msg_data => ret_msgdata

Line 3365: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3361: RAISE fnd_api.g_exc_unexpected_error;
3362: END IF;
3363:
3364: --Clear the secondary quantity fields for the to LPN
3365: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3366: p_api_version => 1.0
3367: , x_return_status => ret_status
3368: , x_msg_count => ret_msgcnt
3369: , x_msg_data => ret_msgdata

Line 3431: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN

3427:
3428: IF (NOT l_lotfound) THEN
3429:
3430: IF l_tracking_quantity_ind = 'P' THEN -- 16493898
3431: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3432: wms_catch_weight_pvt.show_ct_wt_for_split(
3433: x_return_status => ret_status
3434: , x_msg_data => ret_msgcnt
3435: , x_msg_count => ret_msgdata

Line 3432: wms_catch_weight_pvt.show_ct_wt_for_split(

3428: IF (NOT l_lotfound) THEN
3429:
3430: IF l_tracking_quantity_ind = 'P' THEN -- 16493898
3431: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3432: wms_catch_weight_pvt.show_ct_wt_for_split(
3433: x_return_status => ret_status
3434: , x_msg_data => ret_msgcnt
3435: , x_msg_count => ret_msgdata
3436: , p_org_id => p_org_id

Line 3461: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3457: IF (l_valid_sec_qty_split <> 1) THEN
3458: l_secondary_trx_quantity := NULL;
3459: l_secondary_uom_code := NULL;
3460: --Clear the secondary quantity fields for the from LPN
3461: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3462: p_api_version => 1.0
3463: , x_return_status => ret_status
3464: , x_msg_count => ret_msgcnt
3465: , x_msg_data => ret_msgdata

Line 3486: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3482: RAISE fnd_api.g_exc_unexpected_error;
3483: END IF;
3484:
3485: --Clear the secondary quantity fields for the to LPN
3486: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3487: p_api_version => 1.0
3488: , x_return_status => ret_status
3489: , x_msg_count => ret_msgcnt
3490: , x_msg_data => ret_msgdata