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.

[Home] [Help]

APPS.INL_LANDEDCOST_PVT dependencies on INL_ALLOCATIONS

Line 949: -- taxes should also generate lines in INL_ALLOCATIONS.

945: -- Type : Private
946: -- Function :
947: --
948: -- Amounts from Landed Cost Shipment Lines as well as amounts from charges and
949: -- taxes should also generate lines in INL_ALLOCATIONS.
950: --
951: -- Landed Cost Shipment Lines that belong to components that are associated to others
952: -- should generate allocations with LANDED_COST_FLAG = N.
953: --

Line 1169: l_debug_info := 'Inserting into inl_allocations';

1165: p_procedure_name => l_procedure_name,
1166: p_var_name => l_debug_info,
1167: p_var_value => TO_CHAR(l_factor));
1168:
1169: l_debug_info := 'Inserting into inl_allocations';
1170: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1171: p_procedure_name => l_procedure_name,
1172: p_debug_info => l_debug_info);
1173:

Line 1212: l_debug_info := 'Inserting into inl_allocations';

1208: CLOSE assoc;
1209:
1210: IF l_count = 0 THEN
1211:
1212: l_debug_info := 'Inserting into inl_allocations';
1213: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1214: p_procedure_name => l_procedure_name,
1215: p_debug_info => l_debug_info);
1216:

Line 1229: INSERT INTO inl_allocations

1225: p_procedure_name => l_procedure_name,
1226: p_var_name => l_debug_info,
1227: p_var_value => TO_CHAR(p_amount));
1228:
1229: INSERT INTO inl_allocations
1230: (allocation_id,
1231: ship_header_id,
1232: association_id,
1233: ship_line_id,

Line 1247: (inl_allocations_s.NEXTVAL,

1243: last_updated_by,
1244: last_update_date,
1245: last_update_login)
1246: VALUES
1247: (inl_allocations_s.NEXTVAL,
1248: p_ship_header_id,
1249: p_association_id,
1250: p_ship_line_id,
1251: l_from_component_name,

Line 1815: FROM inl_allocations

1811: ship_header_id,
1812: association_id,
1813: ship_line_id,
1814: adjustment_num
1815: FROM inl_allocations
1816: WHERE adjustment_num = p_adjustment_num
1817: AND ship_header_id = p_ship_header_id
1818: ORDER BY allocation_id;
1819: rec_updalloc updalloc%ROWTYPE;

Line 1846: l_debug_info := 'Updating inl_allocations with parent_allocation_id';

1842: LOOP
1843: FETCH updalloc INTO rec_updalloc;
1844: EXIT WHEN updalloc%NOTFOUND;
1845:
1846: l_debug_info := 'Updating inl_allocations with parent_allocation_id';
1847: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1848: p_procedure_name => l_procedure_name,
1849: p_debug_info => l_debug_info);
1850:

Line 1851: UPDATE inl_allocations a1

1847: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1848: p_procedure_name => l_procedure_name,
1849: p_debug_info => l_debug_info);
1850:
1851: UPDATE inl_allocations a1
1852: SET a1.parent_allocation_id = (SELECT MIN(a2.allocation_id)
1853: FROM inl_allocations a2
1854: WHERE a2.ship_header_id = rec_updalloc.ship_header_id
1855: AND NVL(a2.association_id,0) = NVL(rec_updalloc.association_id,0)

Line 1853: FROM inl_allocations a2

1849: p_debug_info => l_debug_info);
1850:
1851: UPDATE inl_allocations a1
1852: SET a1.parent_allocation_id = (SELECT MIN(a2.allocation_id)
1853: FROM inl_allocations a2
1854: WHERE a2.ship_header_id = rec_updalloc.ship_header_id
1855: AND NVL(a2.association_id,0) = NVL(rec_updalloc.association_id,0)
1856: AND (a2.ship_line_id = rec_updalloc.ship_line_id
1857: OR a2.ship_line_id = (SELECT a.parent_ship_line_id

Line 1861: AND NOT EXISTS (SELECT 'X' FROM inl_allocations a1

1857: OR a2.ship_line_id = (SELECT a.parent_ship_line_id
1858: FROM inl_ship_lines a
1859: WHERE a.ship_line_id = rec_updalloc.ship_line_id))
1860: AND a2.adjustment_num = 0
1861: AND NOT EXISTS (SELECT 'X' FROM inl_allocations a1
1862: -- bug #7674125
1863: WHERE NVL(a1.parent_allocation_id,0) = NVL(a2.allocation_id,0)
1864: AND a1.ship_header_id = a2.ship_header_id
1865: AND NVL(a1.association_id,0) = NVL(a2.association_id,0)

Line 2140: DELETE FROM INL_allocations

2136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2137: p_procedure_name => l_api_name,
2138: p_debug_info => l_debug_info);
2139:
2140: DELETE FROM INL_allocations
2141: WHERE ship_header_id = p_ship_header_id
2142: AND adjustment_num = l_adjustment_num
2143: AND ((p_calc_scope_code = 3 AND from_parent_table_name = 'INL_TAX_LINES') OR
2144: (p_calc_scope_code = 2 AND from_parent_table_name = 'INL_CHARGE_LINES') OR

Line 2380: inl_allocations al

2376: SELECT SUM(NVL(al.allocation_amt,0))
2377: INTO l_inclusive_tax_amt
2378: FROM inl_tax_lines t,
2379: inl_adj_associations_v assoc,
2380: inl_allocations al
2381: WHERE t.tax_amt_included_flag = 'Y'
2382: AND t.tax_line_id = assoc.from_parent_table_id
2383: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
2384: AND assoc.association_id = al.association_id