APPS.INL_INTERFACE_PVT dependencies on INL_TAX_LINES

Line 2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,

2169:
2170: -- Utility name : Delete_Ship
2171: -- Type : Private
2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,
2173: -- inl_allocations, inl_tax_lines, inl_charge_lines,
2174: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
2175: -- Pre-reqs : None
2176: -- Parameters :
2177: -- IN : p_ship_header_id IN NUMBER

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

2214:
2215: DELETE FROM inl.inl_allocations
2216: WHERE ship_header_id = p_ship_header_id;
2217:
2218: l_debug_info := 'Delete from inl_tax_lines';
2219: INL_LOGGING_PVT.Log_Statement(
2220: p_module_name => g_module_name,
2221: p_procedure_name => l_proc_name,
2222: p_debug_info => l_debug_info

Line 2225: DELETE FROM inl.inl_tax_lines

2221: p_procedure_name => l_proc_name,
2222: p_debug_info => l_debug_info
2223: ) ;
2224:
2225: DELETE FROM inl.inl_tax_lines
2226: WHERE ship_header_id = p_ship_header_id;
2227:
2228: l_debug_info := 'Delete from inl_charge_lines';
2229: INL_LOGGING_PVT.Log_Statement(

Line 3899: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN

3895: AND a.from_parent_table_id = c.charge_line_id;
3896: IF NVL(l_ship_header_id_tab.LAST, 0) = 1 THEN
3897: x_ship_header_id := l_ship_header_id_tab(1) ;
3898: END IF;
3899: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN
3900: SELECT ship_header_id
3901: INTO x_ship_header_id
3902: FROM inl_tax_lines
3903: WHERE tax_line_id = x_new_to_parent_table_id;

Line 3902: FROM inl_tax_lines

3898: END IF;
3899: ELSIF x_new_to_parent_table_name = 'INL_TAX_LINES' THEN
3900: SELECT ship_header_id
3901: INTO x_ship_header_id
3902: FROM inl_tax_lines
3903: WHERE tax_line_id = x_new_to_parent_table_id;
3904: ELSE -- In case of correction, the table is out of LCM limit
3905: SELECT ship_header_id
3906: INTO x_ship_header_id

Line 6294: 'INL_TAX_LINES',

6290: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
6291: 'INL_SHIP_LINES',
6292: 'INL_SHIP_LINE_GROUPS',
6293: 'INL_CHARGE_LINES',
6294: 'INL_TAX_LINES',
6295: 'RCV_TRANSACTIONS'
6296: )
6297: OR (p_transaction_type = 'CREATE'
6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',

Line 6350: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN

6346: END IF;
6347: IF p_match_type_code IN('CHARGE', 'TAX') THEN
6348: l_matchTpCdOk := 'Y';
6349: END IF;
6350: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN
6351: l_INT_importedOk := 'Y';
6352: SELECT ship_header_id
6353: INTO l_ship_header_id
6354: FROM inl_tax_lines

Line 6354: FROM inl_tax_lines

6350: ELSIF p_to_parent_table_name = 'INL_TAX_LINES' THEN
6351: l_INT_importedOk := 'Y';
6352: SELECT ship_header_id
6353: INTO l_ship_header_id
6354: FROM inl_tax_lines
6355: WHERE tax_line_id = p_to_parent_table_id;
6356: IF p_match_type_code IN('TAX') THEN
6357: l_matchTpCdOk := 'Y';
6358: END IF;