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_INTERFACE_PVT dependencies on INL_CHARGE_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 2228: l_debug_info := 'Delete from inl_charge_lines';

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(
2230: p_module_name => g_module_name,
2231: p_procedure_name => l_proc_name,
2232: p_debug_info => l_debug_info

Line 2235: FROM inl.inl_charge_lines cl

2231: p_procedure_name => l_proc_name,
2232: p_debug_info => l_debug_info
2233: ) ;
2234: DELETE
2235: FROM inl.inl_charge_lines cl
2236: WHERE cl.charge_line_id
2237: IN (
2238: SELECT assoc.from_parent_table_id
2239: FROM inl_associations assoc

Line 2240: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'

2236: WHERE cl.charge_line_id
2237: IN (
2238: SELECT assoc.from_parent_table_id
2239: FROM inl_associations assoc
2240: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
2241: AND assoc.ship_header_id = p_ship_header_id
2242: )
2243: ;
2244:

Line 3887: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN

3883: SELECT ship_header_id
3884: INTO x_ship_header_id
3885: FROM inl_ship_line_groups
3886: WHERE ship_line_group_id = x_new_to_parent_table_id;
3887: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
3888: l_ship_header_id_tab.DELETE;
3889: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
3890: INTO l_ship_header_id_tab
3891: FROM inl_charge_lines c,

Line 3891: FROM inl_charge_lines c,

3887: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
3888: l_ship_header_id_tab.DELETE;
3889: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
3890: INTO l_ship_header_id_tab
3891: FROM inl_charge_lines c,
3892: inl_associations a
3893: WHERE c.charge_line_id = x_new_to_parent_table_id
3894: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
3895: AND a.from_parent_table_id = c.charge_line_id;

Line 3894: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

3890: INTO l_ship_header_id_tab
3891: FROM inl_charge_lines c,
3892: inl_associations a
3893: WHERE c.charge_line_id = x_new_to_parent_table_id
3894: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
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;

Line 6293: 'INL_CHARGE_LINES',

6289:
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'

Line 6334: ELSIF p_to_parent_table_name = 'INL_CHARGE_LINES' THEN

6330: WHERE ship_line_group_id = p_to_parent_table_id;
6331: IF p_match_type_code = 'CHARGE' THEN
6332: l_matchTpCdOk := 'Y';
6333: END IF;
6334: ELSIF p_to_parent_table_name = 'INL_CHARGE_LINES' THEN
6335: l_INT_importedOk := 'Y';
6336: l_ship_header_id_tab.DELETE;
6337: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
6338: INTO l_ship_header_id_tab

Line 6339: FROM inl_charge_lines c,

6335: l_INT_importedOk := 'Y';
6336: l_ship_header_id_tab.DELETE;
6337: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
6338: INTO l_ship_header_id_tab
6339: FROM inl_charge_lines c,
6340: inl_associations a
6341: WHERE c.charge_line_id = p_to_parent_table_id
6342: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
6343: AND a.from_parent_table_id = c.charge_line_id;

Line 6342: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

6338: INTO l_ship_header_id_tab
6339: FROM inl_charge_lines c,
6340: inl_associations a
6341: WHERE c.charge_line_id = p_to_parent_table_id
6342: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
6343: AND a.from_parent_table_id = c.charge_line_id;
6344: IF NVL(l_ship_header_id_tab.LAST, 0) = 1 THEN
6345: l_ship_header_id := l_ship_header_id_tab(1) ;
6346: END IF;