APPS.INL_INTERFACE_PVT dependencies on INL_ASSOCIATIONS

Line 8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount

8094: END Validate_HdrTrxType;
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

Line 8230: FROM inl_associations assoc

8226: AND
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

Line 8239: FROM inl_associations assoc

8235: )
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

Line 8269: FROM inl_associations assoc

8265: WHERE --Bug#9279355
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

Line 8278: FROM inl_associations assoc

8274: )
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

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

8291: p_var_value => sql%rowcount
8292: );
8293:
8294: -- Table
8295: l_debug_info := 'Delete from inl_associations';
8296: INL_LOGGING_PVT.Log_Statement(
8297: p_module_name => g_module_name,
8298: p_procedure_name => l_program_name,
8299: p_debug_info => l_debug_info) ;

Line 8301: DELETE FROM inl_associations

8297: p_module_name => g_module_name,
8298: p_procedure_name => l_program_name,
8299: p_debug_info => l_debug_info) ;
8300:
8301: DELETE FROM inl_associations
8302: WHERE ship_header_id = p_ship_header_id;
8303:
8304: INL_LOGGING_PVT.Log_Variable(
8305: p_module_name => g_module_name,

Line 10041: inl_associations a

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

Line 10128: FROM inl_associations assoc2

10124:
10125: Cursor c_prorates_affctdByItem is
10126: --Bug#14044298 BEG
10127: SELECT DISTINCT assoc2.ship_header_id
10128: FROM inl_associations assoc2
10129: WHERE (assoc2.from_parent_table_name,assoc2.from_parent_table_id)
10130: IN (select assoc.from_parent_table_name,assoc.from_parent_table_id
10131: from inl_associations assoc
10132: WHERE assoc.to_parent_table_name = p_to_parent_table_name

Line 10131: from inl_associations assoc

10127: SELECT DISTINCT assoc2.ship_header_id
10128: FROM inl_associations assoc2
10129: WHERE (assoc2.from_parent_table_name,assoc2.from_parent_table_id)
10130: IN (select assoc.from_parent_table_name,assoc.from_parent_table_id
10131: from inl_associations assoc
10132: WHERE assoc.to_parent_table_name = p_to_parent_table_name
10133: AND assoc.to_parent_table_id = p_to_parent_table_id
10134: )
10135: ;

Line 10139: FROM inl_associations assoc2

10135: ;
10136:
10137: /*
10138: SELECT DISTINCT assoc2.ship_header_id
10139: FROM inl_associations assoc2
10140: WHERE CONNECT_BY_ISLEAF = 1
10141: START WITH (assoc2.from_parent_table_name,assoc2.from_parent_table_id)
10142: IN (select assoc.from_parent_table_name,assoc.from_parent_table_id
10143: from inl_associations assoc

Line 10143: from inl_associations assoc

10139: FROM inl_associations assoc2
10140: WHERE CONNECT_BY_ISLEAF = 1
10141: START WITH (assoc2.from_parent_table_name,assoc2.from_parent_table_id)
10142: IN (select assoc.from_parent_table_name,assoc.from_parent_table_id
10143: from inl_associations assoc
10144: WHERE assoc.to_parent_table_name = p_to_parent_table_name
10145: AND assoc.to_parent_table_id = p_to_parent_table_id
10146: )
10147: CONNECT BY PRIOR assoc2.from_parent_table_name = assoc2.to_parent_table_name

Line 12528: inl_associations a,

12524: INTO
12525: l_count_elc_ong
12526: FROM
12527: inl_adj_charge_lines_v cl,
12528: inl_associations a,
12529: inl_ship_lines_all sl,
12530: rcv_transactions rt
12531: WHERE
12532: rt.transaction_id = p_to_parent_table_id

Line 12594: inl_associations a,

12590: INTO
12591: l_count_elc_ong
12592: FROM
12593: inl_adj_charge_lines_v cl,
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'

Line 13227: inl_associations a

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