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 198: inl_tax_lines tl

194: tl.tax_line_id inl_tax_line_id,
195: tl.tax_line_num inl_tax_line_num
196: FROM inl_ship_lines sl,
197: zx_lines zl,
198: inl_tax_lines tl
199: WHERE sl.ship_header_id = p_ship_header_id
200: AND sl.ship_line_src_type_code = 'PO'
201: AND sl.ship_line_source_id = zl.trx_line_id
202: AND zl.application_id = 201

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

417:
418: FOR i IN l_tax_ln_tbl.FIRST..l_tax_ln_tbl.LAST LOOP
419: IF l_tax_ln_tbl(i).tax_line_id IS NULL THEN
420:
421: --Insert IN INL_TAX_LINES getting ID from sequence
422: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';
423: INL_LOGGING_PVT.Log_Statement (
424: p_module_name => g_module_name,
425: p_procedure_name => l_api_name,

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

418: FOR i IN l_tax_ln_tbl.FIRST..l_tax_ln_tbl.LAST LOOP
419: IF l_tax_ln_tbl(i).tax_line_id IS NULL THEN
420:
421: --Insert IN INL_TAX_LINES getting ID from sequence
422: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';
423: INL_LOGGING_PVT.Log_Statement (
424: p_module_name => g_module_name,
425: p_procedure_name => l_api_name,
426: p_debug_info => l_debug_info

Line 429: SELECT inl_tax_lines_s.NEXTVAL

425: p_procedure_name => l_api_name,
426: p_debug_info => l_debug_info
427: );
428:
429: SELECT inl_tax_lines_s.NEXTVAL
430: INTO l_tax_ln_tbl(i).tax_line_id
431: FROM DUAL
432: ;
433: IF l_tax_ln_tbl(i).tax_line_num IS NULL THEN

Line 436: FROM inl_tax_lines tl

432: ;
433: IF l_tax_ln_tbl(i).tax_line_num IS NULL THEN
434: SELECT NVL(MAX(tl.tax_line_num),0)+1
435: INTO l_tax_ln_tbl(i).tax_line_num
436: FROM inl_tax_lines tl
437: WHERE tl.ship_header_id = l_tax_ln_tbl(i).ship_header_id
438: ;
439: END IF;
440:

Line 441: --Inserting record in INL_TAX_LINES

437: WHERE tl.ship_header_id = l_tax_ln_tbl(i).ship_header_id
438: ;
439: END IF;
440:
441: --Inserting record in INL_TAX_LINES
442: l_debug_info := 'Inserting record in INL_TAX_LINES';
443: INL_LOGGING_PVT.Log_Statement (
444: p_module_name => g_module_name,
445: p_procedure_name => l_api_name,

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

438: ;
439: END IF;
440:
441: --Inserting record in INL_TAX_LINES
442: l_debug_info := 'Inserting record in INL_TAX_LINES';
443: INL_LOGGING_PVT.Log_Statement (
444: p_module_name => g_module_name,
445: p_procedure_name => l_api_name,
446: p_debug_info => l_debug_info

Line 450: INTO inl_tax_lines (

446: p_debug_info => l_debug_info
447: );
448:
449: INSERT
450: INTO inl_tax_lines (
451: tax_line_id , /* 01 */
452: tax_line_num , /* 02 */
453: tax_code , /* 03 */
454: ship_header_id , /* 04 */

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

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 */
526: l_tax_ln_tbl(i).to_parent_table_id , /* 06 */
527: 'VALUE' , /* 07 */

Line 536: --Updating record in INL_TAX_LINES

532: SYSDATE , /* 12 */
533: fnd_global.login_id /* 13 */
534: );
535: ELSE
536: --Updating record in INL_TAX_LINES
537: l_debug_info := 'Updating record in INL_TAX_LINES';
538: INL_LOGGING_PVT.Log_Statement (
539: p_module_name => g_module_name,
540: p_procedure_name => l_api_name,

Line 537: l_debug_info := 'Updating record in INL_TAX_LINES';

533: fnd_global.login_id /* 13 */
534: );
535: ELSE
536: --Updating record in INL_TAX_LINES
537: l_debug_info := 'Updating record in INL_TAX_LINES';
538: INL_LOGGING_PVT.Log_Statement (
539: p_module_name => g_module_name,
540: p_procedure_name => l_api_name,
541: p_debug_info => l_debug_info

Line 543: UPDATE inl_tax_lines

539: p_module_name => g_module_name,
540: p_procedure_name => l_api_name,
541: p_debug_info => l_debug_info
542: );
543: UPDATE inl_tax_lines
544: SET tax_amt = l_tax_ln_tbl(i).tax_amt ,
545: nrec_tax_amt = l_tax_ln_tbl(i).nrec_tax_amt ,
546: currency_code = l_tax_ln_tbl(i).currency_code ,
547: currency_conversion_type= l_tax_ln_tbl(i).currency_conversion_type,

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 1431: -- INS will insert in INL_tax_lines all lines from zx_lines

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
1435: --

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

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
1435: --
1436: -- Parameters :

Line 1472: AND from_parent_table_name = 'INL_TAX_LINES';

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:
1474: DELETE FROM inl_tax_lines tl
1475: WHERE ship_header_id = P_ship_Header_Id
1476: AND EXISTS (SELECT 1

Line 1474: DELETE FROM inl_tax_lines tl

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:
1474: DELETE FROM inl_tax_lines tl
1475: WHERE ship_header_id = P_ship_Header_Id
1476: AND EXISTS (SELECT 1
1477: FROM inl_ebtax_lines_v ebV
1478: ,zx_lines zl

Line 1484: -- if action needed is in ('INS','ALL') Insert in INL_tax_lines lines from zx_lines

1480: AND tl.source_parent_table_name = 'ZX_LINES'
1481: AND tl.source_parent_table_id = zl.tax_line_id
1482: AND ebv.ship_line_id = zl.trx_line_id );
1483: END IF;
1484: -- if action needed is in ('INS','ALL') Insert in INL_tax_lines lines from zx_lines
1485: IF p_oper IN ('INS','ALL') THEN
1486: FOR curTax in (SELECT zl.tax_line_id
1487: ,zl.tax_line_number
1488: ,zl.tax_code

Line 1506: ,inl_tax_lines_s.NEXTVAL tax_line_id_s

1502: ,zl.last_update_login
1503: ,DECODE(lv.source, 'SHIP_LINE' ,'INL_SHIP_LINES'
1504: , 'CHARGE' ,'INL_CHARGE_LINES') source
1505: ,oh.ship_TYPE_ID
1506: ,inl_tax_lines_s.NEXTVAL tax_line_id_s
1507: FROM zx_lines zl
1508: ,inl_ebtax_lines_v lv
1509: ,inl_ship_headers oh
1510: WHERE zl.application_id = 9004

Line 1542: INSERT INTO inl_tax_lines (

1538: p_procedure_name => l_procedure_name,
1539: p_debug_info => l_debug_info);
1540: -----------------------------------------------------------------
1541: -- It will insert in LCM tax Table the information from eBTax tax Table
1542: INSERT INTO inl_tax_lines (
1543: tax_line_id
1544: ,tax_line_num
1545: ,tax_code
1546: ,ship_header_id

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

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 */
1612: ,curTax.trx_line_id /* 06 */
1613: ,l_allocation_basis /* 07 */

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);

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

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);
1953: -----------------------------------------------------------------
1954: -- It will answer the updates done in zx_lines in INL_tax_lines
1955: Adjust_Tax_Lines('INS', p_ship_header_id, l_return_status);
1956: -- If any errors happen abort API.
1957: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;