DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on INL_LANDEDCOST_PVT

Line 3649: inl_landedcost_pvt.Converted_Amt(

3645: NULL charge_line_type_id ,
3646: mat1.matched_qty ,
3647: mat1.matched_uom_code ,
3648: NVL(DECODE(mat1.matched_curr_code, mat2.matched_curr_code, mat2.matched_amt,
3649: inl_landedcost_pvt.Converted_Amt(
3650: mat2.matched_amt,
3651: mat2.matched_curr_code,
3652: mat1.matched_curr_code,
3653: mat1.matched_curr_conversion_type,

Line 3768: INL_LANDEDCOST_PVT.Converted_Qty(

3764:
3765: ELSE
3766: IF l_mat_uom_code_P <> x_matched_uom_code THEN
3767: x_matched_qty :=
3768: INL_LANDEDCOST_PVT.Converted_Qty(
3769: p_organization_id => l_org_id,
3770: p_inventory_item_id => l_inventory_item_id,
3771: p_qty => x_matched_qty,
3772: p_from_uom_code => x_matched_uom_code,

Line 3825: x_matched_amt := INL_LANDEDCOST_PVT.Converted_Amt(

3821: p_module_name => g_module_name,
3822: p_procedure_name => l_proc_name,
3823: p_debug_info => l_debug_info
3824: );
3825: x_matched_amt := INL_LANDEDCOST_PVT.Converted_Amt(
3826: p_amt => NVL(x_matched_amt, 0),
3827: p_from_currency_code => x_matched_curr_code,
3828: p_to_currency_code => l_mat_curr_code_P,
3829: p_currency_conversion_type => NVL(l_mat_curr_type_P,x_matched_curr_conversion_type),

Line 3842: x_nrec_tax_amt := inl_landedcost_pvt.Converted_Amt(

3838: p_procedure_name => l_proc_name,
3839: p_debug_info => l_debug_info
3840: );
3841:
3842: x_nrec_tax_amt := inl_landedcost_pvt.Converted_Amt(
3843: p_amt => NVL(x_nrec_tax_amt, 0),
3844: p_from_currency_code => x_matched_curr_code,
3845: p_to_currency_code => l_mat_curr_code_P,
3846: p_currency_conversion_type => NVL(l_mat_curr_type_P,x_matched_curr_conversion_type),

Line 5273: NVL(inl_landedcost_pvt.Converted_Qty(l_organization_id,

5269: ) ;
5270: BEGIN
5271: SELECT SUM(decode(m1.matched_uom_code,
5272: l_uom_code, m1.matched_qty,
5273: NVL(inl_landedcost_pvt.Converted_Qty(l_organization_id,
5274: l_inventory_item_id,
5275: m1.matched_qty,
5276: m1.matched_uom_code,
5277: l_uom_code

Line 5323: NVL(inl_landedcost_pvt.Converted_Qty( p_organization_id => l_organization_id,

5319: IF NVL(processed_matches_List(iMat).matched_qty, 0) <> 0 THEN
5320: l_matches := l_matches ||processed_matches_List(iMat) .match_id||', ';
5321: IF processed_matches_List(iMat).matched_uom_code <> l_UOM_code THEN
5322: l_actual_qty := NVL(l_actual_qty, 0) +
5323: NVL(inl_landedcost_pvt.Converted_Qty( p_organization_id => l_organization_id,
5324: p_inventory_item_id => l_inventory_item_id,
5325: p_qty => processed_matches_List(iMat) .matched_qty,
5326: p_from_uom_code => processed_matches_List(iMat) .matched_uom_code,
5327: P_to_uom_code => l_UOM_code), 0) ;

Line 5397: + NVL(inl_landedcost_pvt.Converted_Qty(

5393: OI_matches_UOM_code := OI_matches_List(iMat).matched_UOM_code;
5394: END IF;
5395: IF OI_matches_UOM_code <> l_UOM_code THEN
5396: l_actual_qty := NVL(l_actual_qty, 0)
5397: + NVL(inl_landedcost_pvt.Converted_Qty(
5398: p_organization_id => l_organization_id,
5399: p_inventory_item_id => l_inventory_item_id,
5400: p_qty => OI_matches_qty,
5401: p_from_uom_code => OI_matches_UOM_code,

Line 5425: l_match_qty := NVL(inl_landedcost_pvt.Converted_Qty(

5421:
5422: END LOOP;
5423: END IF;
5424: IF p_matched_uom_code <> l_UOM_code THEN
5425: l_match_qty := NVL(inl_landedcost_pvt.Converted_Qty(
5426: p_organization_id => l_organization_id,
5427: p_inventory_item_id => l_inventory_item_id,
5428: p_qty => p_matched_qty,
5429: p_from_uom_code => p_matched_uom_code,