APPS.INL_TAX_PVT dependencies on INL_ASSOCIATIONS

Line 496: --Inserting record in INL_ASSOCIATIONS

492: fnd_global.user_id , /* 19 */
493: SYSDATE , /* 20 */
494: fnd_global.login_id /* 21 */
495: );
496: --Inserting record in INL_ASSOCIATIONS
497: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
498: INL_LOGGING_PVT.Log_Statement (
499: p_module_name => g_module_name,
500: p_procedure_name => l_api_name,

Line 497: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';

493: SYSDATE , /* 20 */
494: fnd_global.login_id /* 21 */
495: );
496: --Inserting record in INL_ASSOCIATIONS
497: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
498: INL_LOGGING_PVT.Log_Statement (
499: p_module_name => g_module_name,
500: p_procedure_name => l_api_name,
501: p_debug_info => l_debug_info

Line 505: INTO inl_associations (

501: p_debug_info => l_debug_info
502: );
503:
504: INSERT
505: INTO inl_associations (
506: association_id , /* 01 */
507: ship_header_id , /* 02 */
508: from_parent_table_name , /* 03 */
509: from_parent_table_id , /* 04 */

Line 521: inl_associations_s.NEXTVAL , /* 01 */

517: last_update_date , /* 12 */
518: last_update_login /* 13 */
519: )
520: VALUES (
521: inl_associations_s.NEXTVAL , /* 01 */
522: l_tax_ln_tbl(i).ship_header_id , /* 02 */
523: 'INL_TAX_LINES' , /* 03 */
524: l_tax_ln_tbl(i).tax_line_id , /* 04 */
525: l_tax_ln_tbl(i).to_parent_table_name , /* 05 */

Line 1430: -- INL_tax_lines and from INL_associations

1426: -- Type : Private
1427: --
1428: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1429: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1430: -- INL_tax_lines and from INL_associations
1431: -- INS will insert in INL_tax_lines all lines from zx_lines
1432: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1433: --
1434: -- Pre-reqs : None

Line 1469: DELETE FROM inl_associations

1465: -- logging message
1466: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1467: p_procedure_name => l_procedure_name,
1468: p_debug_info => l_debug_info);
1469: DELETE FROM inl_associations
1470: WHERE ship_header_id = P_ship_Header_Id
1471: AND to_parent_table_name IN ('INL_SHIP_LINES', 'INL_CHARGE_LINES')
1472: AND from_parent_table_name = 'INL_TAX_LINES';
1473:

Line 1592: INSERT INTO inl_associations (

1588: p_procedure_name => l_procedure_name,
1589: p_debug_info => l_debug_info);
1590: -----------------------------------------------------------------
1591: -- It will create the association of new tax line with the correspondent component
1592: INSERT INTO inl_associations (
1593: association_id /* 01 */
1594: ,ship_header_id /* 02 */
1595: ,from_parent_table_name /* 03 */
1596: ,from_parent_table_id /* 04 */

Line 1607: inl_associations_s.NEXTVAL /* 01 */

1603: ,last_updated_by /* 11 */
1604: ,last_update_date /* 12 */
1605: ,last_update_login) /* 13 */
1606: VALUES(
1607: inl_associations_s.NEXTVAL /* 01 */
1608: ,curTax.trx_id /* 02 */
1609: ,'INL_TAX_LINES' /* 03 */
1610: ,curTax.tax_line_id_s /* 04 */
1611: ,curTax.source /* 05 */

Line 1632: FROM inl_associations assoc

1628: SET tax_already_calculated_flag = 'Y',
1629: last_updated_by = fnd_global.user_id,
1630: last_update_date = SYSDATE
1631: WHERE NVL(parent_charge_line_id,charge_line_id) IN (SELECT assoc.from_parent_table_id
1632: FROM inl_associations assoc
1633: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
1634: AND assoc.ship_header_id = p_ship_header_id);
1635: END IF;
1636: -- logging message

Line 1765: l_debug_info := 'Step 1: Deleting tax records from INL_ASSOCIATIONS and INL_TAX_LINES';

1761: FROM zx_evnt_cls_mappings
1762: WHERE application_id = 9004
1763: AND ROWNUM = 1;
1764: -----------------------------------------------------------------
1765: l_debug_info := 'Step 1: Deleting tax records from INL_ASSOCIATIONS and INL_TAX_LINES';
1766: -- logging message
1767: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1768: p_procedure_name => l_api_name,
1769: p_debug_info => l_debug_info);

Line 1948: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';

1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:
1947: -----------------------------------------------------------------
1948: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';
1949: -- logging message
1950: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1951: p_procedure_name => l_api_name,
1952: p_debug_info => l_debug_info);