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_TAX_PVT dependencies on INL_TAX_LINES

Line 42: DELETE FROM inl_tax_lines tl

38: p_procedure_name => l_proc_name,
39: p_debug_info => l_debug_info
40: );
41:
42: DELETE FROM inl_tax_lines tl
43: WHERE tl.ship_header_id = P_ship_Header_Id
44: OR (tl.ship_header_id is null
45: AND EXISTS (SELECT 1
46: FROM inl_associations assoc

Line 48: AND assoc.from_parent_table_name = 'INL_TAX_LINES'

44: OR (tl.ship_header_id is null
45: AND EXISTS (SELECT 1
46: FROM inl_associations assoc
47: WHERE assoc.ship_header_id = P_ship_Header_Id
48: AND assoc.from_parent_table_name = 'INL_TAX_LINES'
49: AND assoc.from_parent_table_id = tl.tax_line_id)
50: AND NOT EXISTS (SELECT 1
51: FROM inl_associations assoc, inl_ship_headers sh
52: WHERE assoc.ship_header_id <> P_ship_Header_Id

Line 55: AND from_parent_table_name = 'INL_TAX_LINES'

51: FROM inl_associations assoc, inl_ship_headers sh
52: WHERE assoc.ship_header_id <> P_ship_Header_Id
53: AND assoc.ship_header_id = sh.ship_header_id
54: AND sh.ship_status_code = 'COMPLETED'
55: AND from_parent_table_name = 'INL_TAX_LINES'
56: AND from_parent_table_id = tl.tax_line_id))
57: ;
58:
59: --Deleting all association records from Taxes

Line 68: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'

64: p_debug_info => l_debug_info
65: );
66:
67: DELETE FROM inl_associations assoc
68: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
69: AND NOT EXISTS (SELECT 1
70: FROM inl_tax_lines tl
71: WHERE assoc.from_parent_table_id = tl.tax_line_id)
72: ;

Line 70: FROM inl_tax_lines tl

66:
67: DELETE FROM inl_associations assoc
68: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
69: AND NOT EXISTS (SELECT 1
70: FROM inl_tax_lines tl
71: WHERE assoc.from_parent_table_id = tl.tax_line_id)
72: ;
73: -- Standard End of Procedure/Function Logging
74: INL_LOGGING_PVT.Log_EndProc (

Line 393: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'

389: assoc.to_parent_table_id,
390: tl.source_parent_table_id
391: FROM inl_adj_tax_lines_v tl,
392: inl_associations assoc
393: WHERE assoc.from_parent_table_name = 'INL_TAX_LINES'
394: AND assoc.from_parent_table_id = tl.tax_line_id
395: AND assoc.to_parent_table_name = 'INL_SHIP_LINES'
396: AND tl.ship_header_id = p_ship_header_id
397: AND tl.source_parent_table_name = 'ZX_LINES'

Line 769: --Insert IN INL_TAX_LINES getting ID from sequence

765: p_debug_info => l_debug_info
766: );
767:
768: FOR i IN l_tax_ln_tbl.FIRST..l_tax_ln_tbl.LAST LOOP
769: --Insert IN INL_TAX_LINES getting ID from sequence
770: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';
771: INL_LOGGING_PVT.Log_Statement (
772: p_module_name => g_module_name,
773: p_procedure_name => l_api_name,

Line 770: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';

766: );
767:
768: FOR i IN l_tax_ln_tbl.FIRST..l_tax_ln_tbl.LAST LOOP
769: --Insert IN INL_TAX_LINES getting ID from sequence
770: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';
771: INL_LOGGING_PVT.Log_Statement (
772: p_module_name => g_module_name,
773: p_procedure_name => l_api_name,
774: p_debug_info => l_debug_info

Line 777: SELECT inl_tax_lines_s.NEXTVAL

773: p_procedure_name => l_api_name,
774: p_debug_info => l_debug_info
775: );
776:
777: SELECT inl_tax_lines_s.NEXTVAL
778: INTO l_tax_line_id
779: FROM DUAL;
780:
781: SELECT NVL(MAX(tl.tax_line_num),0)+1

Line 783: FROM inl_tax_lines tl

779: FROM DUAL;
780:
781: SELECT NVL(MAX(tl.tax_line_num),0)+1
782: INTO l_tax_line_num
783: FROM inl_tax_lines tl
784: WHERE tl.ship_header_id = l_tax_ln_tbl(i).ship_header_id
785: ;
786:
787: --Inserting record in INL_TAX_LINES

Line 787: --Inserting record in INL_TAX_LINES

783: FROM inl_tax_lines tl
784: WHERE tl.ship_header_id = l_tax_ln_tbl(i).ship_header_id
785: ;
786:
787: --Inserting record in INL_TAX_LINES
788: l_debug_info := 'Inserting record in INL_TAX_LINES';
789: INL_LOGGING_PVT.Log_Statement (
790: p_module_name => g_module_name,
791: p_procedure_name => l_api_name,

Line 788: l_debug_info := 'Inserting record in INL_TAX_LINES';

784: WHERE tl.ship_header_id = l_tax_ln_tbl(i).ship_header_id
785: ;
786:
787: --Inserting record in INL_TAX_LINES
788: l_debug_info := 'Inserting record in INL_TAX_LINES';
789: INL_LOGGING_PVT.Log_Statement (
790: p_module_name => g_module_name,
791: p_procedure_name => l_api_name,
792: p_debug_info => l_debug_info

Line 796: INTO inl_tax_lines (

792: p_debug_info => l_debug_info
793: );
794:
795: INSERT
796: INTO inl_tax_lines (
797: tax_line_id , /* 01 */
798: tax_line_num , /* 02 */
799: tax_code , /* 03 */
800: ship_header_id , /* 04 */

Line 865: 'INL_TAX_LINES' , /* 03 */

861: )
862: VALUES (
863: inl_associations_s.NEXTVAL , /* 01 */
864: l_tax_ln_tbl(i).ship_header_id , /* 02 */
865: 'INL_TAX_LINES' , /* 03 */
866: l_tax_line_id , /* 04 */
867: l_tax_ln_tbl(i).to_parent_table_name , /* 05 */
868: l_tax_ln_tbl(i).to_parent_table_id , /* 06 */
869: 'VALUE' , /* 07 */

Line 1749: -- INL_tax_lines and from INL_associations

1745: -- Type : Private
1746: --
1747: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1748: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1749: -- INL_tax_lines and from INL_associations
1750: -- INS will insert in INL_tax_lines all lines from zx_lines
1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1752: --
1753: -- Pre-reqs : None

Line 1750: -- INS will insert in INL_tax_lines all lines from zx_lines

1746: --
1747: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1748: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1749: -- INL_tax_lines and from INL_associations
1750: -- INS will insert in INL_tax_lines all lines from zx_lines
1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1752: --
1753: -- Pre-reqs : None
1754: --

Line 1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.

1747: -- Function : It makes adjusts (Insert, Delete or Both) in tax_line table.
1748: -- For a given Ship_Header_Id DEL will remove all rows from this shipment of the
1749: -- INL_tax_lines and from INL_associations
1750: -- INS will insert in INL_tax_lines all lines from zx_lines
1751: -- If the zx_line has recover amount two lines will be generated in INL_tax_lines.
1752: --
1753: -- Pre-reqs : None
1754: --
1755: -- Parameters :

Line 1801: ,inl_tax_lines_s.NEXTVAL tax_line_id_s

1797: ,zl.last_update_login
1798: ,DECODE(lv.source, 'SHIP_LINE' ,'INL_SHIP_LINES'
1799: , 'CHARGE' ,'INL_CHARGE_LINES') source
1800: ,oh.ship_TYPE_ID
1801: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1802: FROM zx_lines zl
1803: ,inl_ebtax_lines_v lv
1804: ,inl_ship_headers oh
1805: WHERE zl.application_id = 9004

Line 1842: INSERT INTO inl_tax_lines (

1838: p_debug_info => l_debug_info
1839: );
1840: -----------------------------------------------------------------
1841: -- It will insert in LCM tax Table the information from eBTax tax Table
1842: INSERT INTO inl_tax_lines (
1843: tax_line_id
1844: ,tax_line_num
1845: ,tax_code
1846: ,ship_header_id

Line 1910: ,'INL_TAX_LINES' /* 03 */

1906: ,last_update_login) /* 13 */
1907: VALUES(
1908: inl_associations_s.NEXTVAL /* 01 */
1909: ,curTax.trx_id /* 02 */
1910: ,'INL_TAX_LINES' /* 03 */
1911: ,curTax.tax_line_id_s /* 04 */
1912: ,curTax.source /* 05 */
1913: ,curTax.trx_line_id /* 06 */
1914: ,l_allocation_basis /* 07 */

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

2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;
2283:
2284: -----------------------------------------------------------------
2285: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';
2286: -- logging message
2287: INL_LOGGING_PVT.Log_Statement (
2288: p_module_name => g_module_name,
2289: p_procedure_name => l_api_name,

Line 2292: -- It will answer the updates done in zx_lines in INL_tax_lines

2288: p_module_name => g_module_name,
2289: p_procedure_name => l_api_name,
2290: p_debug_info => l_debug_info);
2291: -----------------------------------------------------------------
2292: -- It will answer the updates done in zx_lines in INL_tax_lines
2293: Adjust_Tax_Lines(p_ship_header_id, l_return_status);
2294: -- If any errors happen abort API.
2295: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2296: RAISE FND_API.G_EXC_ERROR;