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_ASSOCIATIONS

Line 2172: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations,

2168: END Validate_ShipLinImport;
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 :

Line 2239: FROM inl_associations assoc

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
2240: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
2241: AND assoc.ship_header_id = p_ship_header_id
2242: )
2243: ;

Line 2245: l_debug_info := 'Delete from inl_associations';

2241: AND assoc.ship_header_id = p_ship_header_id
2242: )
2243: ;
2244:
2245: l_debug_info := 'Delete from inl_associations';
2246: INL_LOGGING_PVT.Log_Statement(
2247: p_module_name => g_module_name,
2248: p_procedure_name => l_proc_name,
2249: p_debug_info => l_debug_info

Line 2251: DELETE FROM inl.inl_associations

2247: p_module_name => g_module_name,
2248: p_procedure_name => l_proc_name,
2249: p_debug_info => l_debug_info
2250: ) ;
2251: DELETE FROM inl.inl_associations
2252: WHERE ship_header_id = p_ship_header_id;
2253:
2254: l_debug_info := 'Delete from inl_ship_lines_all';
2255: INL_LOGGING_PVT.Log_Statement(

Line 3892: inl_associations a

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;
3896: IF NVL(l_ship_header_id_tab.LAST, 0) = 1 THEN

Line 6340: inl_associations a

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;
6344: IF NVL(l_ship_header_id_tab.LAST, 0) = 1 THEN