eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_SHIPMENT_PVT dependencies on INL_LANDEDCOST_PVT

Line 1412: l_debug_info := 'If necessary, it converts the qty (INL_landedcost_pvt.Converted_Qty).';

1408: p_procedure_name => l_program_name,
1409: p_var_name => 'p_primary_uom_code',
1410: p_var_value => p_primary_uom_code
1411: ) ;
1412: l_debug_info := 'If necessary, it converts the qty (INL_landedcost_pvt.Converted_Qty).';
1413: INL_LOGGING_PVT.Log_Statement (
1414: p_module_name => g_module_name,
1415: p_procedure_name => l_program_name,
1416: p_debug_info => l_debug_info ) ;

Line 1419: x_available_quantity := INL_LANDEDCOST_PVT.converted_qty (

1415: p_procedure_name => l_program_name,
1416: p_debug_info => l_debug_info ) ;
1417: -- Convert to Primary Qty when Unit of Measure is different
1418: IF x_uom_code <> p_primary_uom_code THEN
1419: x_available_quantity := INL_LANDEDCOST_PVT.converted_qty (
1420: p_organization_id => p_inv_org_id,
1421: p_inventory_item_id => p_inventory_item_id,
1422: p_qty => x_available_quantity,
1423: p_from_uom_code => x_uom_code,

Line 1425: x_tolerable_quantity := INL_LANDEDCOST_PVT.converted_qty (

1421: p_inventory_item_id => p_inventory_item_id,
1422: p_qty => x_available_quantity,
1423: p_from_uom_code => x_uom_code,
1424: p_to_uom_code => p_primary_uom_code);
1425: x_tolerable_quantity := INL_LANDEDCOST_PVT.converted_qty (
1426: p_organization_id => p_inv_org_id,
1427: p_inventory_item_id => p_inventory_item_id,
1428: p_qty => x_tolerable_quantity,
1429: p_from_uom_code => x_uom_code,

Line 1440: l_msg_tolerable_qty := INL_LANDEDCOST_PVT.converted_qty (

1436: FROM mtl_units_of_measure_vl mum
1437: WHERE mum.uom_code = p_txn_uom_code;
1438: -- Since Primary and Transaction UOM are different, convert to Transaction UOM.
1439: IF p_txn_uom_code <> p_primary_uom_code THEN
1440: l_msg_tolerable_qty := INL_LANDEDCOST_PVT.converted_qty (
1441: p_organization_id => p_inv_org_id,
1442: p_inventory_item_id => p_inventory_item_id,
1443: p_qty => x_tolerable_quantity,
1444: p_from_uom_code => x_uom_code,

Line 1917: l_po_qty := INL_LANDEDCOST_PVT.Converted_Qty(

1913: IF p_primary_uom_code <> l_po_UOM_code THEN --BUG#7670307
1914: -- Bug #11710754
1915: /*
1916: l_amount := l_po_converted_price * l_po_qty;
1917: l_po_qty := INL_LANDEDCOST_PVT.Converted_Qty(
1918: p_organization_id => p_organization_id,
1919: p_inventory_item_id => l_inventory_item_id,
1920: p_qty => l_po_qty,
1921: p_from_uom_code => l_po_UOM_code,

Line 1927: l_po_converted_price := INL_LANDEDCOST_PVT.Converted_Price(

1923: );
1924: l_po_converted_price := l_amount / l_po_qty;
1925: */
1926:
1927: l_po_converted_price := INL_LANDEDCOST_PVT.Converted_Price(
1928: p_unit_price => l_po_converted_price,
1929: p_organization_id => p_organization_id,
1930: p_inventory_item_id => l_inventory_item_id,
1931: p_from_uom_code => l_po_uom_code,

Line 2139: l_pri_unit_price := INL_LANDEDCOST_PVT.Converted_Price(

2135: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
2136: p_procedure_name => l_program_name,
2137: p_debug_info => l_debug_info);
2138:
2139: l_pri_unit_price := INL_LANDEDCOST_PVT.Converted_Price(
2140: p_unit_price => p_new_txn_unit_price,
2141: p_organization_id => p_organization_id,
2142: p_inventory_item_id => p_inventory_item_id,
2143: p_from_uom_code => p_txn_uom_code,

Line 5284: inl_landedcost_pvt.Converted_Amt (

5280: mat.match_id ,
5281: DECODE (pc_to_currency_code,
5282: mat.matched_curr_code,
5283: mat.matched_amt,
5284: inl_landedcost_pvt.Converted_Amt (
5285: mat.matched_amt,
5286: mat.matched_curr_code,
5287: pc_to_currency_code,
5288: pc_to_curr_conversion_type,

Line 5654: l_net_rcv_txn_qty := INL_LANDEDCOST_PVT.Converted_Qty (

5650: p_var_name => 'l_net_rcv_txn_qty',
5651: p_var_value => l_net_rcv_txn_qty
5652: );
5653: -- Bug #7849658
5654: l_net_rcv_txn_qty := INL_LANDEDCOST_PVT.Converted_Qty (
5655: p_organization_id => l_inv_org_id,
5656: p_inventory_item_id => l_sl_inv_item_id,
5657: p_qty => l_net_rcv_txn_qty,
5658: p_from_uom_code => l_rt_uom_code,

Line 5703: l_shipl_unit_price := inl_landedcost_pvt.Converted_Amt (

5699: ELSIF l_current_curr_conv_type IS NULL AND l_ship_line_curr_conv_type = 'User' THEN --BUG#8468830
5700: -- else if currency conversion rate is in ship line: multiply
5701: l_shipl_unit_price := l_ori_unit_price * l_ship_line_curr_conv_rate;
5702: ELSE
5703: l_shipl_unit_price := inl_landedcost_pvt.Converted_Amt (
5704: l_ori_unit_price,
5705: l_ship_line_curr_code,
5706: l_current_curr_code,
5707: nvl(l_current_curr_conv_type,l_ship_line_curr_conv_type), --BUG#8468830

Line 5838: l_primary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

5834: l_primary_unit_price := l_final_price;
5835: ELSE
5836: l_final_qty := l_matched_qty;
5837: -- Getting Primary Quantity and Primary Unit Price
5838: l_primary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
5839: p_organization_id => l_inv_org_id,
5840: p_inventory_item_id => l_sl_inv_item_id,
5841: p_qty => l_final_qty,
5842: p_from_uom_code => l_matched_uom_code,

Line 5920: l_primary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

5916: l_matched_uom_code := l_txn_uom_code; --BUG#7674121
5917: END IF;
5918: -- Verifying if UOM conversion are required
5919: IF l_primary_uom_code <> l_matched_uom_code THEN --BUG#7674121
5920: l_primary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
5921: p_organization_id => l_inv_org_id,
5922: p_inventory_item_id => l_sl_inv_item_id,
5923: p_qty => l_final_qty,
5924: p_from_uom_code => l_matched_uom_code,

Line 5940: l_secondary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

5936: ) ;
5937: -- BUG 8924795
5938: IF l_secondary_uom_code IS NOT NULL THEN
5939:
5940: l_secondary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
5941: p_organization_id => l_inv_org_id,
5942: p_inventory_item_id => l_sl_inv_item_id,
5943: p_qty => l_primary_qty,
5944: p_from_uom_code => l_primary_uom_code,

Line 8240: l_garb := inl_landedcost_pvt.Converted_Amt (

8236:
8237: --BUG#8468830
8238: IF p_func_currency_code <> l_matched_curr_code THEN
8239: IF l_matched_curr_conversion_type <> 'User' THEN -- Bug #10102991
8240: l_garb := inl_landedcost_pvt.Converted_Amt (
8241: 1,
8242: l_matched_curr_code,
8243: p_func_currency_code,
8244: l_matched_curr_conversion_type,

Line 8506: (SELECT SUM(INL_LANDEDCOST_PVT.Converted_Amt( NVL(a.matched_amt,0),

8502: -- the min is one of the lines that alread exists in prior calculation
8503: m.from_parent_table_id ,
8504: m.to_parent_table_name ,
8505: m.to_parent_table_id ,
8506: (SELECT SUM(INL_LANDEDCOST_PVT.Converted_Amt( NVL(a.matched_amt,0),
8507: a.matched_curr_code,
8508: ma.matched_curr_code,
8509: ma.matched_curr_conversion_type,
8510: ma.matched_curr_conversion_date))

Line 8810: l_garb := inl_landedcost_pvt.Converted_Amt (

8806:
8807: --BUG#8468830
8808: IF p_func_currency_code <> l_matched_curr_code THEN
8809: IF l_matched_curr_conversion_type <> 'User' THEN -- Bug #10102991
8810: l_garb := inl_landedcost_pvt.Converted_Amt (
8811: 1,
8812: l_matched_curr_code,
8813: p_func_currency_code,
8814: l_matched_curr_conversion_type,

Line 9177: l_garb := inl_landedcost_pvt.Converted_Amt (

9173:
9174: --BUG#8468830
9175: IF p_func_currency_code <> l_matched_curr_code THEN
9176: IF l_matched_curr_conversion_type <> 'User' THEN -- Bug #10102991
9177: l_garb := inl_landedcost_pvt.Converted_Amt (
9178: 1,
9179: l_matched_curr_code,
9180: p_func_currency_code,
9181: l_matched_curr_conversion_type,

Line 9347: (SELECT SUM(INL_LANDEDCOST_PVT.Converted_Amt( NVL(a.matched_amt,0),

9343: p_procedure_name => l_api_name,
9344: p_debug_info => l_debug_info
9345: ) ;
9346: SELECT
9347: (SELECT SUM(INL_LANDEDCOST_PVT.Converted_Amt( NVL(a.matched_amt,0),
9348: a.matched_curr_code,
9349: ma.matched_curr_code,
9350: ma.matched_curr_conversion_type,
9351: ma.matched_curr_conversion_date))

Line 9554: l_garb := inl_landedcost_pvt.Converted_Amt (

9550: ) ;
9551:
9552: --BUG#8468830
9553: IF p_func_currency_code <> l_TxLn_Assoc.currency_code THEN
9554: l_garb := inl_landedcost_pvt.Converted_Amt (
9555: 1,
9556: l_TxLn_Assoc.currency_code,
9557: p_func_currency_code,
9558: l_TxLn_Assoc.currency_conversion_type,

Line 10430: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',

10426:
10427: INL_LOGGING_PVT.Log_APICallIn (
10428: p_module_name => g_module_name,
10429: p_procedure_name => l_api_name,
10430: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',
10431: p_in_param_name1 => 'p_organization_id',
10432: p_in_param_value1 => p_organization_id,
10433: p_in_param_name2 => 'p_inventory_item_id',
10434: p_in_param_value2 => p_inventory_item_id,

Line 10452: x_1ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

10448: p_in_param_value9 => NULL,
10449: p_in_param_name10 => NULL,
10450: p_in_param_value10 => NULL) ;
10451:
10452: x_1ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
10453: p_organization_id => p_organization_id,
10454: p_inventory_item_id => p_inventory_item_id,
10455: p_qty => p_qty,
10456: p_from_uom_code => p_uom_code,

Line 10610: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',

10606: ) ;
10607: INL_LOGGING_PVT.Log_APICallIn (
10608: p_module_name => g_module_name,
10609: p_procedure_name => l_api_name,
10610: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',
10611: p_in_param_name1 => 'p_organization_id',
10612: p_in_param_value1 => p_organization_id,
10613: p_in_param_name2 => 'p_inventory_item_id',
10614: p_in_param_value2 => p_inventory_item_id,

Line 10631: x_2ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

10627: p_in_param_name9 => NULL,
10628: p_in_param_value9 => NULL,
10629: p_in_param_name10 => NULL,
10630: p_in_param_value10 => NULL) ;
10631: x_2ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
10632: p_organization_id => p_organization_id,
10633: p_inventory_item_id => p_inventory_item_id,
10634: p_qty => p_qty,
10635: p_from_uom_code => p_uom_code,

Line 10884: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',

10880: ) ;
10881: INL_LOGGING_PVT.Log_APICallIn (
10882: p_module_name => g_module_name,
10883: p_procedure_name => l_api_name,
10884: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',
10885: p_in_param_name1 => 'p_organization_id',
10886: p_in_param_value1 => p_organization_id,
10887: p_in_param_name2 => 'p_inventory_item_id',
10888: p_in_param_value2 => p_inventory_item_id,

Line 10905: x_1ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

10901: p_in_param_name9 => NULL,
10902: p_in_param_value9 => NULL,
10903: p_in_param_name10 => NULL,
10904: p_in_param_value10 => NULL) ;
10905: x_1ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
10906: p_organization_id => p_organization_id,
10907: p_inventory_item_id => p_inventory_item_id,
10908: p_qty => p_qty,
10909: p_from_uom_code => p_uom_code,

Line 10930: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',

10926: ) ;
10927: INL_LOGGING_PVT.Log_APICallIn (
10928: p_module_name => g_module_name,
10929: p_procedure_name => l_api_name,
10930: p_call_api_name => 'INL_LANDEDCOST_PVT.Converted_Qty',
10931: p_in_param_name1 => 'p_organization_id',
10932: p_in_param_value1 => p_organization_id,
10933: p_in_param_name2 => 'p_inventory_item_id',
10934: p_in_param_value2 => p_inventory_item_id,

Line 10951: x_2ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (

10947: p_in_param_name9 => NULL,
10948: p_in_param_value9 => NULL,
10949: p_in_param_name10 => NULL,
10950: p_in_param_value10 => NULL) ;
10951: x_2ary_qty := INL_LANDEDCOST_PVT.Converted_Qty (
10952: p_organization_id => p_organization_id,
10953: p_inventory_item_id => p_inventory_item_id,
10954: p_qty => p_qty,
10955: p_from_uom_code => p_uom_code,

Line 12221: l_debug_info := 'Run INL_LANDEDCOST_PVT.Run_Calculation';

12217: p_var_value => l_max_allocation_id);
12218:
12219: --Bug#10032820
12220:
12221: l_debug_info := 'Run INL_LANDEDCOST_PVT.Run_Calculation';
12222: INL_LOGGING_PVT.Log_Statement (
12223: p_module_name => g_module_name,
12224: p_procedure_name => l_api_name,
12225: p_debug_info => l_debug_info) ;

Line 12227: INL_LANDEDCOST_PVT.Run_Calculation (

12223: p_module_name => g_module_name,
12224: p_procedure_name => l_api_name,
12225: p_debug_info => l_debug_info) ;
12226:
12227: INL_LANDEDCOST_PVT.Run_Calculation (
12228: p_api_version => 1.0,
12229: p_init_msg_list => L_FND_FALSE,
12230: p_commit => L_FND_FALSE,
12231: p_validation_level => L_FND_VALID_LEVEL_FULL,