APPS.INL_INTERFACE_PVT dependencies on INL_TAX_LINES

Line 8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,

8095:
8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted
8103: -- Pre-reqs : None

Line 8215: l_debug_info := 'Delete from inl_tax_lines';

8211: p_var_value => sql%rowcount
8212: );
8213:
8214: -- Table
8215: l_debug_info := 'Delete from inl_tax_lines';
8216: INL_LOGGING_PVT.Log_Statement(
8217: p_module_name => g_module_name,
8218: p_procedure_name => l_program_name,
8219: p_debug_info => l_debug_info) ;

Line 8221: DELETE FROM inl_tax_lines tl

8217: p_module_name => g_module_name,
8218: p_procedure_name => l_program_name,
8219: p_debug_info => l_debug_info) ;
8220:
8221: DELETE FROM inl_tax_lines tl
8222: WHERE
8223: tl.ship_header_id = p_ship_header_id
8224: OR --Bug#9279355
8225: tl.ship_header_id IS NULL

Line 8231: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'

8227: (
8228: EXISTS (
8229: SELECT 1
8230: FROM inl_associations assoc
8231: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
8232: AND (assoc.from_parent_table_id = tl.tax_line_id
8233: OR assoc.from_parent_table_id = tl.parent_tax_line_id)
8234: AND assoc.ship_header_id = p_ship_header_id
8235: )

Line 8240: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'

8236: AND
8237: NOT EXISTS (
8238: SELECT 1
8239: FROM inl_associations assoc
8240: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
8241: AND (assoc.from_parent_table_id = tl.tax_line_id
8242: OR assoc.from_parent_table_id = tl.parent_tax_line_id)
8243: AND assoc.ship_header_id <> p_ship_header_id
8244: )

Line 10048: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN

10044: AND a.from_parent_table_id = c.charge_line_id;
10045: IF NVL(l_ship_header_id_tab.COUNT, 0) = 1 THEN
10046: x_ship_header_id := l_ship_header_id_tab(1) ;
10047: END IF;
10048: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN
10049: SELECT ship_header_id
10050: INTO x_ship_header_id
10051: FROM inl_tax_lines
10052: WHERE tax_line_id = x_new_to_parent_table_id;

Line 10051: FROM inl_tax_lines

10047: END IF;
10048: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN
10049: SELECT ship_header_id
10050: INTO x_ship_header_id
10051: FROM inl_tax_lines
10052: WHERE tax_line_id = x_new_to_parent_table_id;
10053: ELSE -- In case of correction, the table is out of LCM limit
10054: SELECT ship_header_id
10055: INTO x_ship_header_id

Line 13180: 'INL_TAX_LINES',

13176: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
13177: 'INL_SHIP_LINES',
13178: 'INL_SHIP_LINE_GROUPS',
13179: 'INL_CHARGE_LINES',
13180: 'INL_TAX_LINES',
13181: 'RCV_TRANSACTIONS'
13182: )
13183: OR (p_transaction_type = 'CREATE'
13184: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',

Line 13237: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN

13233: END IF;
13234: IF p_match_type_code IN('CHARGE', 'TAX') THEN
13235: l_matchTpCdOk := 'Y';
13236: END IF;
13237: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN
13238: l_INT_importedOk := 'Y';
13239: SELECT ship_header_id
13240: INTO l_ship_header_id
13241: FROM inl_tax_lines

Line 13241: FROM inl_tax_lines

13237: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN
13238: l_INT_importedOk := 'Y';
13239: SELECT ship_header_id
13240: INTO l_ship_header_id
13241: FROM inl_tax_lines
13242: WHERE tax_line_id = p_to_parent_table_id;
13243: IF p_match_type_code IN('TAX') THEN
13244: l_matchTpCdOk := 'Y';
13245: END IF;