74: itl.last_update_login,
75: ias.allocation_basis,
76: ias.allocation_uom_code
77: FROM inl_tax_lines itl,
78: inl_associations ias
79: WHERE ias.from_parent_table_name = 'INL_TAX_LINES'
80: AND ias.from_parent_table_id = p_from_parent_table_id
81: AND ias.to_parent_table_name = p_to_parent_table_name
82: AND ias.to_parent_table_id = p_current_to_parent_table_id
203: fnd_global.login_id);
204:
205: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
206: p_procedure_name => l_api_name,
207: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
208:
209: INSERT INTO inl_associations (association_id,
210: ship_header_id,
211: from_parent_table_name,
205: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
206: p_procedure_name => l_api_name,
207: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
208:
209: INSERT INTO inl_associations (association_id,
210: ship_header_id,
211: from_parent_table_name,
212: from_parent_table_id,
213: to_parent_table_name,
218: creation_date,
219: last_updated_by,
220: last_update_date,
221: last_update_login)
222: VALUES (inl_associations_s.NEXTVAL,
223: p_new_ship_header_id,
224: 'INL_TAX_LINES',
225: l_tax_line_id,
226: p_to_parent_table_name,
377: icl.last_update_login,
378: ias.allocation_basis,
379: ias.allocation_uom_code
380: FROM inl_charge_lines icl,
381: inl_associations ias
382: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
383: AND ias.from_parent_table_id = p_from_parent_table_id
384: AND ias.to_parent_table_name = p_to_parent_table_name
385: AND ias.to_parent_table_id = p_current_to_parent_table_id
548: fnd_global.login_id);
549:
550: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
551: p_procedure_name => l_api_name,
552: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
553:
554: INSERT INTO inl_associations (association_id,
555: ship_header_id,
556: from_parent_table_name,
550: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
551: p_procedure_name => l_api_name,
552: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
553:
554: INSERT INTO inl_associations (association_id,
555: ship_header_id,
556: from_parent_table_name,
557: from_parent_table_id,
558: to_parent_table_name,
563: creation_date,
564: last_updated_by,
565: last_update_date,
566: last_update_login)
567: VALUES (inl_associations_s.NEXTVAL,
568: p_new_ship_header_id,
569: 'INL_CHARGE_LINES',
570: l_charge_line_id,
571: p_to_parent_table_name,
983: BEGIN
984: SELECT from_parent_table_name,
985: from_parent_table_id
986: BULK COLLECT INTO l_from_association_tbl
987: FROM inl_associations
988: WHERE to_parent_table_name = 'INL_SHIP_LINES'
989: AND to_parent_table_id = ShipLines_List(i).ship_line_id
990: AND ship_header_id = ShipLines_List(i).ship_header_id;
991: EXCEPTION
1329: BEGIN
1330: SELECT from_parent_table_name,
1331: from_parent_table_id
1332: BULK COLLECT INTO l_from_association_tbl
1333: FROM inl_associations
1334: WHERE to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
1335: AND to_parent_table_id = LineGroups_List(i).ship_line_group_id
1336: AND ship_header_id = p_current_ship_header_id;
1337: EXCEPTION
1784: BEGIN
1785: SELECT from_parent_table_name,
1786: from_parent_table_id
1787: BULK COLLECT INTO l_from_association_tbl
1788: FROM inl_associations
1789: WHERE to_parent_table_name = 'INL_SHIP_HEADERS'
1790: AND to_parent_table_id = ShipHeaders_List(i).ship_header_id
1791: AND ship_header_id = ShipHeaders_List(i).ship_header_id;
1792: EXCEPTION