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

8253: p_var_value => sql%rowcount
8254: );
8255:
8256: -- Table
8257: l_debug_info := 'Delete from inl_charge_lines';
8258: INL_LOGGING_PVT.Log_Statement(
8259: p_module_name => g_module_name,
8260: p_procedure_name => l_program_name,
8261: p_debug_info => l_debug_info) ;

Line 8264: FROM inl_charge_lines cl

8260: p_procedure_name => l_program_name,
8261: p_debug_info => l_debug_info) ;
8262:
8263: DELETE
8264: FROM inl_charge_lines cl
8265: WHERE --Bug#9279355
8266: (
8267: EXISTS (
8268: SELECT 1

Line 8270: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'

8266: (
8267: EXISTS (
8268: SELECT 1
8269: FROM inl_associations assoc
8270: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
8271: AND (assoc.from_parent_table_id = cl.charge_line_id
8272: OR assoc.from_parent_table_id = cl.parent_charge_line_id)
8273: AND assoc.ship_header_id = p_ship_header_id
8274: )

Line 8279: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'

8275: AND
8276: NOT EXISTS (
8277: SELECT 1
8278: FROM inl_associations assoc
8279: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
8280: AND (assoc.from_parent_table_id = cl.charge_line_id
8281: OR assoc.from_parent_table_id = cl.parent_charge_line_id)
8282: AND assoc.ship_header_id <> p_ship_header_id
8283: )

Line 10036: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN

10032: SELECT ship_header_id
10033: INTO x_ship_header_id
10034: FROM inl_ship_line_groups
10035: WHERE ship_line_group_id = x_new_to_parent_table_id;
10036: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
10037: l_ship_header_id_tab.DELETE;
10038: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
10039: INTO l_ship_header_id_tab
10040: FROM inl_charge_lines c,

Line 10040: FROM inl_charge_lines c,

10036: ELSIF x_new_to_parent_table_name = 'INL_CHARGE_LINES' THEN
10037: l_ship_header_id_tab.DELETE;
10038: SELECT DISTINCT(a.ship_header_id) BULK COLLECT
10039: INTO l_ship_header_id_tab
10040: FROM inl_charge_lines c,
10041: inl_associations a
10042: WHERE c.charge_line_id = x_new_to_parent_table_id
10043: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
10044: AND a.from_parent_table_id = c.charge_line_id;

Line 10043: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

10039: INTO l_ship_header_id_tab
10040: FROM inl_charge_lines c,
10041: inl_associations a
10042: WHERE c.charge_line_id = x_new_to_parent_table_id
10043: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
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;

Line 12534: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

12530: rcv_transactions rt
12531: WHERE
12532: rt.transaction_id = p_to_parent_table_id
12533: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id
12534: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12535: AND (
12536: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12537: AND a.to_parent_table_id = sl.ship_header_id)
12538: OR

Line 12552: inl_charge_lines cl1

12548: (
12549: SELECT
12550: cl1.charge_line_id
12551: FROM
12552: inl_charge_lines cl1
12553: WHERE
12554: CONNECT_BY_ISLEAF = 1
12555: START WITH cl1.charge_line_id = a.from_parent_table_id
12556: CONNECT BY PRIOR cl1.charge_line_id = cl1.parent_charge_line_id

Line 12598: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

12594: inl_associations a,
12595: inl_ship_lines_all sl
12596: WHERE
12597: sl.ship_line_id = p_to_parent_table_id
12598: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12599: AND (
12600: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12601: AND a.to_parent_table_id = sl.ship_header_id)
12602: OR

Line 13179: 'INL_CHARGE_LINES',

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

Line 13221: ELSIF p_to_parent_table_name = 'INL_CHARGE_LINES' THEN

13217: WHERE ship_line_group_id = p_to_parent_table_id;
13218: IF p_match_type_code = 'CHARGE' THEN
13219: l_matchTpCdOk := 'Y';
13220: END IF;
13221: ELSIF p_to_parent_table_name = 'INL_CHARGE_LINES' THEN
13222: l_INT_importedOk := 'Y';
13223: l_ship_header_id_tab.DELETE;
13224: SELECT DISTINCT(a.ship_header_id)
13225: BULK COLLECT INTO l_ship_header_id_tab

Line 13226: FROM inl_charge_lines c,

13222: l_INT_importedOk := 'Y';
13223: l_ship_header_id_tab.DELETE;
13224: SELECT DISTINCT(a.ship_header_id)
13225: BULK COLLECT INTO l_ship_header_id_tab
13226: FROM inl_charge_lines c,
13227: inl_associations a
13228: WHERE c.charge_line_id = p_to_parent_table_id
13229: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
13230: AND a.from_parent_table_id = c.charge_line_id;

Line 13229: AND a.from_parent_table_name = 'INL_CHARGE_LINES'

13225: BULK COLLECT INTO l_ship_header_id_tab
13226: FROM inl_charge_lines c,
13227: inl_associations a
13228: WHERE c.charge_line_id = p_to_parent_table_id
13229: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
13230: AND a.from_parent_table_id = c.charge_line_id;
13231: IF NVL(l_ship_header_id_tab.COUNT, 0) = 1 THEN
13232: l_ship_header_id := l_ship_header_id_tab(1) ;
13233: END IF;