DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WMS_CATCH_WEIGHT_PVT

Line 3020: wms_catch_weight_pvt.get_ont_pricing_qty_source(

3016: ORDER BY lot_number;
3017: BEGIN
3018: -- Check if pricing is tracked by secondary qty
3019: l_pricing_ind :=
3020: wms_catch_weight_pvt.get_ont_pricing_qty_source(
3021: p_api_version => 1.0
3022: , x_return_status => ret_status
3023: , x_msg_count => ret_msgcnt
3024: , x_msg_data => ret_msgdata

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

3035: -- retrieve corresponding lot numbers
3036: FOR lottmp_rec IN lottmp_cur LOOP
3037: l_lotfound := TRUE;
3038:
3039: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3040: IF (l_prev_lot <> lottmp_rec.lot_number) THEN
3041: l_prev_lot := lottmp_rec.lot_number;
3042: wms_catch_weight_pvt.show_ct_wt_for_split(
3043: x_return_status => ret_status

Line 3042: wms_catch_weight_pvt.show_ct_wt_for_split(

3038:
3039: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3040: IF (l_prev_lot <> lottmp_rec.lot_number) THEN
3041: l_prev_lot := lottmp_rec.lot_number;
3042: wms_catch_weight_pvt.show_ct_wt_for_split(
3043: x_return_status => ret_status
3044: , x_msg_data => ret_msgcnt
3045: , x_msg_count => ret_msgdata
3046: , p_org_id => p_org_id

Line 3067: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3063: END IF;
3064:
3065: IF (l_valid_sec_qty_split <> 1) THEN
3066: --Clear the secondary quantity fields for the from LPN
3067: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3068: p_api_version => 1.0
3069: , x_return_status => ret_status
3070: , x_msg_count => ret_msgcnt
3071: , x_msg_data => ret_msgdata

Line 3093: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3089: RAISE fnd_api.g_exc_unexpected_error;
3090: END IF;
3091:
3092: --Clear the secondary quantity fields for the to LPN
3093: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3094: p_api_version => 1.0
3095: , x_return_status => ret_status
3096: , x_msg_count => ret_msgcnt
3097: , x_msg_data => ret_msgdata

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

3152: );
3153: END LOOP;
3154:
3155: IF (NOT l_lotfound) THEN
3156: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3157: wms_catch_weight_pvt.show_ct_wt_for_split(
3158: x_return_status => ret_status
3159: , x_msg_data => ret_msgcnt
3160: , x_msg_count => ret_msgdata

Line 3157: wms_catch_weight_pvt.show_ct_wt_for_split(

3153: END LOOP;
3154:
3155: IF (NOT l_lotfound) THEN
3156: IF (l_pricing_ind = wms_catch_weight_pvt.g_price_secondary) THEN
3157: wms_catch_weight_pvt.show_ct_wt_for_split(
3158: x_return_status => ret_status
3159: , x_msg_data => ret_msgcnt
3160: , x_msg_count => ret_msgdata
3161: , p_org_id => p_org_id

Line 3186: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3182: IF (l_valid_sec_qty_split <> 1) THEN
3183: l_secondary_trx_quantity := NULL;
3184: l_secondary_uom_code := NULL;
3185: --Clear the secondary quantity fields for the from LPN
3186: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3187: p_api_version => 1.0
3188: , x_return_status => ret_status
3189: , x_msg_count => ret_msgcnt
3190: , x_msg_data => ret_msgdata

Line 3211: wms_catch_weight_pvt.update_lpn_secondary_quantity(

3207: RAISE fnd_api.g_exc_unexpected_error;
3208: END IF;
3209:
3210: --Clear the secondary quantity fields for the to LPN
3211: wms_catch_weight_pvt.update_lpn_secondary_quantity(
3212: p_api_version => 1.0
3213: , x_return_status => ret_status
3214: , x_msg_count => ret_msgcnt
3215: , x_msg_data => ret_msgdata