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.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TAX_SOURCES

Line 411: FROM okl_tax_sources

407:
408: -- Cursors
409: CURSOR l_k_serialized_and_alc(p_chr_id IN NUMBER) IS
410: SELECT '1'
411: FROM okl_tax_sources
412: WHERE khr_id = p_chr_id
413: AND entity_code = G_ASSETS_ENTITY_CODE
414: AND event_class_code = G_ALC_EVENT_CODE
415: AND alc_serialized_yn IN ('Y', 'L')

Line 488: | okl_tax_sources_pub.update_tax_sources()

Line 767: -- get the primary key of okl_tax_sources

763: AND trx_level_type = G_TRX_LEVEL_TYPE
764: AND entity_code = cp_entity_code
765: AND event_class_code = cp_event_class_code;
766:
767: -- get the primary key of okl_tax_sources
768: CURSOR l_taxsourceid_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER) IS
769: SELECT id
770: FROM okl_tax_sources
771: WHERE trx_id = cp_trx_id

Line 770: FROM okl_tax_sources

766:
767: -- get the primary key of okl_tax_sources
768: CURSOR l_taxsourceid_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER) IS
769: SELECT id
770: FROM okl_tax_sources
771: WHERE trx_id = cp_trx_id
772: AND trx_line_id = cp_trx_line_id;
773:
774: BEGIN

Line 987: | okl_tax_sources_pub.update_tax_sources()

Line 1026: FROM okl_tax_sources

1022:
1023: -- Cursors
1024: CURSOR l_taxablelines_ser_csr(cp_kle_id IN NUMBER, cp_sty_id IN NUMBER) IS
1025: SELECT id
1026: FROM okl_tax_sources
1027: WHERE kle_id = cp_kle_id
1028: AND sty_id = cp_sty_id
1029: AND tax_call_type_code = G_UPFRONT_TAX
1030: AND tax_line_status_code = G_ACTIVE_STATUS

Line 1036: FROM okl_tax_sources

1032: AND event_class_code = G_BOOKING_EVENT_CLASS_CODE;
1033:
1034: CURSOR l_alc_total_tax_ser_csr(cp_kle_id IN NUMBER, cp_sty_id IN NUMBER) IS
1035: SELECT SUM(total_tax)
1036: FROM okl_tax_sources
1037: WHERE kle_id = cp_kle_id
1038: AND sty_id = cp_sty_id
1039: AND tax_call_type_code = G_UPFRONT_TAX
1040: AND tax_line_status_code = G_ACTIVE_STATUS

Line 1046: FROM okl_tax_sources

1042: AND event_class_code = G_BOOKING_EVENT_CLASS_CODE;
1043:
1044: CURSOR l_alc_total_line_amt_ser_csr(cp_kle_id IN NUMBER, cp_sty_id IN NUMBER) IS
1045: SELECT SUM(assessable_value)
1046: FROM okl_tax_sources
1047: WHERE kle_id = cp_kle_id
1048: AND sty_id = cp_sty_id
1049: AND tax_call_type_code = G_UPFRONT_TAX
1050: AND tax_line_status_code = G_ACTIVE_STATUS

Line 1056: FROM okl_tax_sources

1052: AND event_class_code = G_BOOKING_EVENT_CLASS_CODE;
1053:
1054: CURSOR l_fetch_stream_types_csr(cp_kle_id IN NUMBER) IS
1055: SELECT DISTINCT sty_id
1056: FROM okl_tax_sources
1057: WHERE kle_id = cp_kle_id
1058: AND tax_call_type_code = G_UPFRONT_TAX
1059: AND tax_line_status_code = G_ACTIVE_STATUS
1060: AND entity_code = G_CONTRACTS_ENTITY_CODE

Line 1077: -- and store in alc_serialized_total_tax column of okl_tax_sources

1073: 'p_asset_id :'||p_asset_id);
1074: END IF;
1075:
1076: -- Get the modified tax lines from tax sources, sum up the total tax amount
1077: -- and store in alc_serialized_total_tax column of okl_tax_sources
1078: i := 1;
1079:
1080: IF (p_serialized_asset = 'Y') THEN
1081: FOR l_fetch_stream_types_rec IN l_fetch_stream_types_csr(p_asset_id) LOOP

Line 1118: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');

1114:
1115: IF (l_txsv_tbl.COUNT > 0) THEN
1116: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
1117: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.populate_ser_split_total_tax',
1118: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1119: END IF;
1120:
1121: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1122: ,p_init_msg_list => p_init_msg_list

Line 1121: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

1117: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.populate_ser_split_total_tax',
1118: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1119: END IF;
1120:
1121: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1122: ,p_init_msg_list => p_init_msg_list
1123: ,x_return_status => l_return_status
1124: ,x_msg_count => x_msg_count
1125: ,x_msg_data => x_msg_data

Line 1245: | okl_tax_sources_pub.update_tax_sources()

Line 1284: FROM okl_tax_sources

1280:
1281: -- Cursors
1282: CURSOR l_taxablelines_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER) IS
1283: SELECT id
1284: FROM okl_tax_sources
1285: WHERE trx_id IN (SELECT id
1286: FROM okl_trx_assets
1287: WHERE req_asset_id = cp_request_id)
1288: AND kle_id = cp_kle_id

Line 1296: FROM okl_tax_sources

1292: AND event_class_code = G_ALC_EVENT_CODE;
1293:
1294: CURSOR l_taxablelines_ser_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER, cp_sty_id IN NUMBER) IS
1295: SELECT id
1296: FROM okl_tax_sources
1297: WHERE trx_id IN (SELECT id
1298: FROM okl_trx_assets
1299: WHERE req_asset_id = cp_request_id)
1300: AND kle_id = cp_kle_id

Line 1309: FROM okl_tax_sources

1305: AND event_class_code = G_ALC_EVENT_CODE;
1306:
1307: CURSOR l_alc_total_tax_ser_csr(cp_request_id IN NUMBER, cp_kle_id IN NUMBER, cp_sty_id IN NUMBER) IS
1308: SELECT SUM(total_tax)
1309: FROM okl_tax_sources
1310: WHERE trx_id IN (SELECT id
1311: FROM okl_trx_assets
1312: WHERE req_asset_id = cp_request_id)
1313: AND kle_id = cp_kle_id

Line 1322: FROM okl_tax_sources

1318: AND event_class_code = G_ALC_EVENT_CODE;
1319:
1320: CURSOR l_alc_total_tax_csr(cp_request_id IN NUMBER) IS
1321: SELECT SUM(total_tax)
1322: FROM okl_tax_sources
1323: WHERE trx_id IN (SELECT id
1324: FROM okl_trx_assets
1325: WHERE req_asset_id = cp_request_id)
1326: AND tax_call_type_code = G_UPFRONT_TAX

Line 1333: FROM okl_tax_sources

1329: AND event_class_code = G_ALC_EVENT_CODE;
1330:
1331: CURSOR l_fetch_stream_types_csr(cp_kle_id IN NUMBER, cp_request_id IN NUMBER) IS
1332: SELECT DISTINCT sty_id
1333: FROM okl_tax_sources
1334: WHERE trx_id IN (SELECT id
1335: FROM okl_trx_assets
1336: WHERE req_asset_id = cp_request_id)
1337: AND kle_id = cp_kle_id

Line 1359: -- and store in alc_serialized_total_tax column of okl_tax_sources

1355: 'p_request_id :'||p_request_id);
1356: END IF;
1357:
1358: -- Get the modified tax lines from tax sources, sum up the total tax amount
1359: -- and store in alc_serialized_total_tax column of okl_tax_sources
1360: i := 1;
1361: IF (p_serialized_asset = 'Y') THEN
1362: FOR l_fetch_stream_types_rec IN l_fetch_stream_types_csr(cp_kle_id => p_asset_id,
1363: cp_request_id => p_request_id) LOOP

Line 1415: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');

1411:
1412: IF (l_txsv_tbl.COUNT > 0) THEN
1413: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.populate_alc_total_tax',
1415: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1416: END IF;
1417:
1418: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1419: ,p_init_msg_list => p_init_msg_list

Line 1418: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

1414: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.populate_alc_total_tax',
1415: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1416: END IF;
1417:
1418: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1419: ,p_init_msg_list => p_init_msg_list
1420: ,x_return_status => l_return_status
1421: ,x_msg_count => x_msg_count
1422: ,x_msg_data => x_msg_data

Line 1549: | okl_tax_sources_pub.update_tax_sources()

Line 1589: FROM okl_tax_sources

1585: -- Cursors
1586: CURSOR l_taxablelines_rbk_csr(cp_trx_id IN NUMBER) IS
1587: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
1588: trx_level_type
1589: FROM okl_tax_sources
1590: WHERE trx_id = cp_trx_id
1591: AND tax_call_type_code = G_UPFRONT_TAX
1592: AND tax_line_status_code = G_INACTIVE_STATUS
1593: AND adjusted_doc_trx_id IS NOT NULL;

Line 1598: FROM okl_tax_sources

1594:
1595: CURSOR l_taxablelines_csr(cp_trx_id IN NUMBER) IS
1596: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
1597: trx_level_type
1598: FROM okl_tax_sources
1599: WHERE trx_id = cp_trx_id
1600: AND tax_call_type_code = G_UPFRONT_TAX
1601: AND tax_line_status_code = G_ACTIVE_STATUS;
1602:

Line 1606: FROM okl_tax_sources

1602:
1603: CURSOR l_taxablelines_txs_csr(cp_trx_id IN NUMBER) IS
1604: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
1605: trx_level_type
1606: FROM okl_tax_sources
1607: WHERE trx_id = cp_trx_id
1608: AND tax_call_type_code = G_TAX_SCHEDULE
1609: AND tax_line_status_code = G_ACTIVE_STATUS;
1610:

Line 1614: FROM okl_tax_sources

1610:
1611: CURSOR l_taxablelines_bill_csr(cp_trx_id IN NUMBER) IS
1612: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
1613: trx_level_type
1614: FROM okl_tax_sources
1615: WHERE trx_id = cp_trx_id
1616: AND tax_call_type_code = G_INVOICE_TAX
1617: AND tax_line_status_code = G_ACTIVE_STATUS;
1618:

Line 1648: FROM okl_tax_sources

1644:
1645: CURSOR l_taxablelines_alc_ser_csr(cp_trx_id IN NUMBER) IS
1646: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
1647: trx_level_type
1648: FROM okl_tax_sources
1649: WHERE trx_id = cp_trx_id
1650: AND tax_call_type_code = G_UPFRONT_TAX
1651: AND tax_line_status_code = G_INACTIVE_STATUS;
1652:

Line 1675: -- and store in total_tax column of okl_tax_sources

1671: IF p_source_trx_name = 'Estimated Billing' THEN
1672: FOR l_taxablelines_bill_rec IN l_taxablelines_bill_csr(cp_trx_id => p_source_trx_id) LOOP
1673:
1674: -- Get the modified tax lines from zx_detail_tax_lines_gt, sum up the total tax amount
1675: -- and store in total_tax column of okl_tax_sources
1676: OPEN l_totaltax_quote_csr(cp_trx_id => p_source_trx_id,
1677: cp_trx_line_id => l_taxablelines_bill_rec.trx_line_id,
1678: cp_application_id => l_taxablelines_bill_rec.application_id,
1679: cp_event_class_code => l_taxablelines_bill_rec.event_class_code,

Line 1700: -- and store in total_tax column of okl_tax_sources

1696:
1697: ELSIF p_source_trx_name = 'Rebook' THEN
1698:
1699: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1700: -- and store in total_tax column of okl_tax_sources
1701: FOR l_taxablelines_rbk_rec IN l_taxablelines_rbk_csr(cp_trx_id => p_source_trx_id) LOOP
1702: OPEN l_zxlinestotaltax_csr(cp_trx_id => p_source_trx_id,
1703: cp_trx_line_id => l_taxablelines_rbk_rec.trx_line_id,
1704: cp_application_id => l_taxablelines_rbk_rec.application_id,

Line 1725: -- and store in total_tax column of okl_tax_sources

1721:
1722: ELSIF (p_source_trx_name = 'Asset Relocation' AND p_serialized_asset = 'Y') THEN
1723:
1724: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1725: -- and store in total_tax column of okl_tax_sources
1726: FOR l_taxablelines_alc_ser_rec IN l_taxablelines_alc_ser_csr(cp_trx_id => p_source_trx_id) LOOP
1727: OPEN l_zxlinestotaltax_csr(cp_trx_id => p_source_trx_id,
1728: cp_trx_line_id => l_taxablelines_alc_ser_rec.trx_line_id,
1729: cp_application_id => l_taxablelines_alc_ser_rec.application_id,

Line 1749: -- and store in total_tax column of okl_tax_sources

1745:
1746: ELSIF (p_source_trx_name = 'Tax Schedule') THEN
1747:
1748: -- Get the modified tax lines from zx_lines_det_factors, sum up the total tax amount
1749: -- and store in total_tax column of okl_tax_sources
1750: FOR l_taxablelines_txs_rec IN l_taxablelines_txs_csr(cp_trx_id => p_source_trx_id) LOOP
1751: OPEN l_totaltax_quote_csr(cp_trx_id => p_source_trx_id,
1752: cp_trx_line_id => l_taxablelines_txs_rec.trx_line_id,
1753: cp_application_id => l_taxablelines_txs_rec.application_id,

Line 1772: -- and store in total_tax column of okl_tax_sources

1768:
1769: ELSE
1770:
1771: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1772: -- and store in total_tax column of okl_tax_sources
1773: FOR l_taxablelines_rec IN l_taxablelines_csr(cp_trx_id => p_source_trx_id) LOOP
1774:
1775: IF p_source_trx_name = 'Sales Quote' THEN
1776: OPEN l_totaltax_quote_csr(cp_trx_id => p_source_trx_id,

Line 1816: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');

1812:
1813: IF (l_txsv_tbl.COUNT > 0) THEN
1814: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
1815: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.update_tax_sources_total',
1816: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1817: END IF;
1818:
1819: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1820: ,p_init_msg_list => p_init_msg_list

Line 1819: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

1815: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.update_tax_sources_total',
1816: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for all Lines in Tax Sources');
1817: END IF;
1818:
1819: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
1820: ,p_init_msg_list => p_init_msg_list
1821: ,x_return_status => l_return_status
1822: ,x_msg_count => x_msg_count
1823: ,x_msg_data => x_msg_data

Line 2006: FROM okl_tax_sources

2002: -- Cursors
2003: CURSOR l_taxablelines_csr(cp_trx_id IN NUMBER) IS
2004: SELECT id, trx_line_id,application_id, event_class_code, entity_code,
2005: trx_level_type
2006: FROM okl_tax_sources
2007: WHERE trx_id = cp_trx_id
2008: AND tax_call_type_code = G_UPFRONT_TAX
2009: AND tax_line_status_code = G_ACTIVE_STATUS;
2010:

Line 2038: 'Calling okl_tax_sources_pub.update_tax_sources for making Tax Sources Reportable');

2034:
2035: IF (l_txsv_tbl.COUNT > 0) THEN
2036: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
2037: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.make_tax_sources_reportable',
2038: 'Calling okl_tax_sources_pub.update_tax_sources for making Tax Sources Reportable');
2039: END IF;
2040:
2041: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
2042: ,p_init_msg_list => p_init_msg_list

Line 2041: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

2037: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.make_tax_sources_reportable',
2038: 'Calling okl_tax_sources_pub.update_tax_sources for making Tax Sources Reportable');
2039: END IF;
2040:
2041: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
2042: ,p_init_msg_list => p_init_msg_list
2043: ,x_return_status => l_return_status
2044: ,x_msg_count => x_msg_count
2045: ,x_msg_data => x_msg_data

Line 2569: | OKL_TAX_SOURCES_PUB.update_tax_sources()

2565: | CALLED FROM calculate_sales_tax()
2566: |
2567: |
2568: | CALLS PROCEDURES/FUNCTIONS
2569: | OKL_TAX_SOURCES_PUB.update_tax_sources()
2570: |
2571: |
2572: | PARAMETERS
2573: | p_source_trx_id -- Source transaction ID

Line 2615: TYPE tax_sources_tbl_type IS TABLE OF OKL_TAX_SOURCES%ROWTYPE INDEX BY BINARY_INTEGER;

2611: i NUMBER;
2612: l_fetch_size NUMBER := 10000;
2613: l_reverse BOOLEAN := FALSE;
2614:
2615: TYPE tax_sources_tbl_type IS TABLE OF OKL_TAX_SOURCES%ROWTYPE INDEX BY BINARY_INTEGER;
2616: TYPE tax_src_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2617:
2618: l_newtaxsourcesrev_tbl tax_sources_tbl_type;
2619: l_tax_src_tbl tax_src_tbl_type;

Line 2641: FROM okl_tax_sources

2637: bill_to_party_site_id, bill_to_location_id, bill_to_party_id,
2638: ship_to_cust_acct_site_use_id, bill_to_cust_acct_site_use_id,
2639: trx_currency_code, currency_conversion_date, currency_conversion_rate,
2640: currency_conversion_type
2641: FROM okl_tax_sources
2642: WHERE khr_id = cp_khr_id
2643: AND tax_call_type_code = G_UPFRONT_TAX
2644: AND tax_line_status_code = G_ACTIVE_STATUS;
2645:

Line 2845: UPDATE okl_tax_sources SET tax_line_status_code = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);

2841: -- No Change needed for previous booking tax lines in eBTax
2842: IF l_tax_src_tbl.COUNT > 0 THEN
2843: BEGIN
2844: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
2845: UPDATE okl_tax_sources SET tax_line_status_code = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
2846: EXCEPTION
2847: WHEN OTHERS THEN
2848: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
2849: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 2854: p_token1_value => 'OKL_TAX_SOURCES',

2850: OKL_API.set_message(
2851: p_app_name => 'OKL',
2852: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
2853: p_token1 => 'TABLE_NAME',
2854: p_token1_value => 'OKL_TAX_SOURCES',
2855: p_token2 => 'ERROR_CODE',
2856: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
2857: p_token3 => 'ITERATION',
2858: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 2871: -- bulk insert into okl_tax_sources -- start

2867: 'Inactivated the previous active upfront tax lines ' );
2868: END IF;
2869: -- Inactivate the previous ACTIVE tax lines - end
2870:
2871: -- bulk insert into okl_tax_sources -- start
2872: BEGIN
2873: IF l_newtaxsourcesrev_tbl.COUNT > 0 THEN
2874: FORALL indx in l_newtaxsourcesrev_tbl.FIRST..l_newtaxsourcesrev_tbl.LAST
2875: -- SAVE EXCEPTIONS

Line 2876: INSERT INTO okl_tax_sources VALUES l_newtaxsourcesrev_tbl(indx);

2872: BEGIN
2873: IF l_newtaxsourcesrev_tbl.COUNT > 0 THEN
2874: FORALL indx in l_newtaxsourcesrev_tbl.FIRST..l_newtaxsourcesrev_tbl.LAST
2875: -- SAVE EXCEPTIONS
2876: INSERT INTO okl_tax_sources VALUES l_newtaxsourcesrev_tbl(indx);
2877: END IF;
2878: EXCEPTION
2879: WHEN OTHERS THEN
2880: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 2885: p_token1_value => 'OKL_TAX_SOURCES',

2881: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
2882: OKL_API.set_message(p_app_name => 'OKL',
2883: p_msg_name => 'OKL_TX_TRX_INS_ERR',
2884: p_token1 => 'TABLE_NAME',
2885: p_token1_value => 'OKL_TAX_SOURCES',
2886: p_token2 => 'ERROR_CODE',
2887: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
2888: p_token3 => 'ITERATION',
2889: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 2894: -- bulk insert into okl_tax_sources -- end

2890: END LOOP;
2891: RAISE OKL_API.G_EXCEPTION_ERROR;
2892: END IF;
2893: END;
2894: -- bulk insert into okl_tax_sources -- end
2895:
2896: -- At this point, the latest active upfront tax sources are the ones
2897: -- corresponding to 'Reverse' transaction. If user queries the booking tax
2898: -- (contract booking page) at this point, UI will display the tax corresponding

Line 2941: -- zx_lines and update total_tax on okl_tax_sources

2937: RAISE OKL_API.G_EXCEPTION_ERROR;
2938: END IF;
2939:
2940: -- Get the total tax amount corresponding to 'Reverse' transaction from
2941: -- zx_lines and update total_tax on okl_tax_sources
2942: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
2943: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_contract_reversal_tax.',
2944: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
2945: END IF;

Line 6063: -- populate okl_tax_sources pl/sql table

6059: lx_pc_code := G_PC_CODE;
6060: lx_tax_classification_code := G_TAX_CLASS_CODE;
6061: END IF;
6062:
6063: -- populate okl_tax_sources pl/sql table
6064: px_tax_sources_tbl(p_tax_call_cnt).id := get_seq_id;
6065: px_tax_sources_tbl(p_tax_call_cnt).khr_id := p_tax_src_params_rec.khr_id;
6066: px_tax_sources_tbl(p_tax_call_cnt).kle_id := p_tax_src_params_rec.kle_id;
6067: px_tax_sources_tbl(p_tax_call_cnt).sty_id := p_tax_src_params_rec.sty_id;

Line 8128: | in okl_tax_sources. There won't be aby tax lines

8124: | Date Author Description of Changes
8125: | 08-APR-05 SECHAWLA Created
8126: | 22-APR-08 SECHAWLA 6975983 Do not error out if there is no tax in eBTax for
8127: | the Billed stream elements. Create taxable line
8128: | in okl_tax_sources. There won't be aby tax lines
8129: | in okl_tax_trx_details.
8130: |
8131: *=======================================================================*/
8132: PROCEDURE process_tax_schedule_tax(

Line 8698: -- okl_tax_sources/okl_tax_trx_detials. Insert these tax lines back into tax

8694: -- billed (under old/new solution) If so, insert already calculated tax
8695: -- lines into tax sources and tax trx details with trx type of
8696: -- 'Tax Schedule' If Billed under new solution, then tax would have been
8697: -- calculated under 'Billing' transaction type and tax lines inserted into
8698: -- okl_tax_sources/okl_tax_trx_detials. Insert these tax lines back into tax
8699: -- sources/tax trx details with transaction type of 'Tax Schedule'
8700:
8701: l_bill_ts_tx_src_cnt := 0;
8702: l_bill_ts_tx_src_tbl.DELETE;

Line 8960: 'before Insert into okl_tax_sources ');

8956: -- all the data for the billed stream elements
8957:
8958: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
8959: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
8960: 'before Insert into okl_tax_sources ');
8961: END IF;
8962:
8963: ---- Insert into okl_tax_sources begin -----
8964: BEGIN

Line 8963: ---- Insert into okl_tax_sources begin -----

8959: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
8960: 'before Insert into okl_tax_sources ');
8961: END IF;
8962:
8963: ---- Insert into okl_tax_sources begin -----
8964: BEGIN
8965: IF l_tax_sources_tbl.COUNT > 0 THEN
8966: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
8967: -- SAVE EXCEPTIONS

Line 8968: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);

8964: BEGIN
8965: IF l_tax_sources_tbl.COUNT > 0 THEN
8966: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
8967: -- SAVE EXCEPTIONS
8968: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
8969: END IF;
8970: EXCEPTION
8971: WHEN OTHERS THEN
8972: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 8977: p_token1_value => 'OKL_TAX_SOURCES',

8973: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
8974: OKL_API.set_message(p_app_name => 'OKL',
8975: p_msg_name => 'OKL_TX_TRX_INS_ERR',
8976: p_token1 => 'TABLE_NAME',
8977: p_token1_value => 'OKL_TAX_SOURCES',
8978: p_token2 => 'ERROR_CODE',
8979: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
8980: p_token3 => 'ITERATION',
8981: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 8986: ---- Insert into okl_tax_sources end -----

8982: END LOOP;
8983: RAISE OKL_API.G_EXCEPTION_ERROR;
8984: END IF;
8985: END;
8986: ---- Insert into okl_tax_sources end -----
8987:
8988: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
8989: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
8990: 'before Insert into okl_tax_trx_details ');

Line 9568: 'before Insert into okl_tax_sources ');

9564: CLOSE c_k_unbilled_streams_csr;
9565:
9566: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
9567: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9568: 'before Insert into okl_tax_sources ');
9569: END IF;
9570:
9571: ---- Insert into okl_tax_sources begin -----
9572: BEGIN

Line 9571: ---- Insert into okl_tax_sources begin -----

9567: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9568: 'before Insert into okl_tax_sources ');
9569: END IF;
9570:
9571: ---- Insert into okl_tax_sources begin -----
9572: BEGIN
9573: IF l_tax_sources_tbl.COUNT > 0 THEN
9574: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
9575: -- SAVE EXCEPTIONS

Line 9576: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);

9572: BEGIN
9573: IF l_tax_sources_tbl.COUNT > 0 THEN
9574: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
9575: -- SAVE EXCEPTIONS
9576: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
9577: END IF;
9578: EXCEPTION
9579: WHEN OTHERS THEN
9580: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 9585: p_token1_value => 'OKL_TAX_SOURCES',

9581: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
9582: OKL_API.set_message(p_app_name => 'OKL',
9583: p_msg_name => 'OKL_TX_TRX_INS_ERR',
9584: p_token1 => 'TABLE_NAME',
9585: p_token1_value => 'OKL_TAX_SOURCES',
9586: p_token2 => 'ERROR_CODE',
9587: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9588: p_token3 => 'ITERATION',
9589: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 9594: ---- Insert into okl_tax_sources end -----

9590: END LOOP;
9591: RAISE OKL_API.G_EXCEPTION_ERROR;
9592: END IF;
9593: END;
9594: ---- Insert into okl_tax_sources end -----
9595:
9596: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
9597: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9598: 'lx_line_params_tbl.COUNT '||lx_line_params_tbl.COUNT);

Line 9958: FROM okl_tax_sources

9954:
9955: -- get the previous tax source transaction for this quote
9956: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS
9957: SELECT id
9958: FROM okl_tax_sources
9959: WHERE trx_id = cp_trx_id;
9960:
9961: -- get the previous tax trx details
9962: CURSOR l_prevtaxtrxdet_csr(cp_txs_id IN NUMBER) IS

Line 10185: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsrc_tbl(i);

10181: END IF;
10182:
10183: BEGIN
10184: FORALL i IN l_prevtaxsrc_tbl.FIRST..l_prevtaxsrc_tbl.LAST
10185: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsrc_tbl(i);
10186: EXCEPTION
10187: WHEN OTHERS THEN
10188: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
10189: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 10194: p_token1_value => 'OKL_TAX_SOURCES',

10190: OKL_API.set_message(
10191: p_app_name => 'OKL',
10192: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
10193: p_token1 => 'TABLE_NAME',
10194: p_token1_value => 'OKL_TAX_SOURCES',
10195: p_token2 => 'ERROR_CODE',
10196: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
10197: p_token3 => 'ITERATION',
10198: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 10206: 'Deleted from okl_tax_sources... ');

10202: END;
10203:
10204: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10205: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10206: 'Deleted from okl_tax_sources... ');
10207: END IF;
10208: END IF;
10209:
10210: EXIT WHEN l_prevtaxsources_csr%NOTFOUND;

Line 10603: -- Insert into okl_tax_sources

10599: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10600: 'tax_call_cnt '||tax_call_cnt);
10601: END IF;
10602:
10603: -- Insert into okl_tax_sources
10604: BEGIN
10605: IF lx_tax_sources_tbl.COUNT > 0 THEN
10606: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
10607: -- SAVE EXCEPTIONS

Line 10608: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);

10604: BEGIN
10605: IF lx_tax_sources_tbl.COUNT > 0 THEN
10606: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
10607: -- SAVE EXCEPTIONS
10608: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
10609: END IF;
10610: EXCEPTION
10611: WHEN OTHERS THEN
10612: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 10617: p_token1_value => 'OKL_TAX_SOURCES',

10613: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
10614: OKL_API.set_message( p_app_name => 'OKL',
10615: p_msg_name => 'OKL_TX_TRX_INS_ERR',
10616: p_token1 => 'TABLE_NAME',
10617: p_token1_value => 'OKL_TAX_SOURCES',
10618: p_token2 => 'ERROR_CODE',
10619: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
10620: p_token3 => 'ITERATION',
10621: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 10626: -- Insert into okl_tax_sources end

10622: END LOOP;
10623: RAISE OKL_API.G_EXCEPTION_ERROR;
10624: END IF;
10625: END;
10626: -- Insert into okl_tax_sources end
10627:
10628: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10629: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10630: 'Insert into okl_tax_sources ');

Line 10630: 'Insert into okl_tax_sources ');

10626: -- Insert into okl_tax_sources end
10627:
10628: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10629: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10630: 'Insert into okl_tax_sources ');
10631: END IF;
10632:
10633: IF lx_line_params_tbl.COUNT > 0 THEN
10634: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 10863: | OKL_TAX_SOURCES_PUB.update_tax_sources()

Line 10946: FROM okl_tax_sources

10942: -- k1 > A1 > RENT
10943: -- k1 > A1 > Estimated Property Tax
10944: CURSOR l_taxsources_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
10945: SELECT id, org_id, entity_code, event_class_code
10946: FROM okl_tax_sources
10947: WHERE khr_id = cp_khr_id
10948: AND kle_id = cp_kle_id
10949: AND tax_call_type_code = G_UPFRONT_TAX
10950: AND tax_line_status_code = G_ACTIVE_STATUS

Line 11011: FROM okl_tax_sources

11007: WHERE id = cp_fma_id;
11008:
11009: CURSOR l_okltaxsources_csr(cp_app_id IN NUMBER, cp_trx_id IN NUMBER) IS
11010: SELECT entity_code, event_class_code
11011: FROM okl_tax_sources
11012: WHERE application_id = cp_app_id
11013: AND trx_id = cp_trx_id
11014: AND trx_level_type = G_TRX_LEVEL_TYPE
11015: AND tax_call_type_code = G_UPFRONT_TAX

Line 11278: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);

11274:
11275: IF l_tax_src_tbl.COUNT > 0 THEN
11276: BEGIN
11277: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
11278: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
11279:
11280: EXCEPTION
11281: WHEN OTHERS THEN
11282: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 11288: p_token1_value => 'OKL_TAX_SOURCES',

11284: OKL_API.set_message(
11285: p_app_name => 'OKL',
11286: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
11287: p_token1 => 'TABLE_NAME',
11288: p_token1_value => 'OKL_TAX_SOURCES',
11289: p_token2 => 'ERROR_CODE',
11290: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
11291: p_token3 => 'ITERATION',
11292: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 11658: -- serialized (3 units), with 2 stream types, okl_tax_sources will

11654: IF (p_alc_final_call = 'Y') THEN
11655: -- Indicates tax for last serial number. Also, used to display the
11656: -- HGrid data
11657: -- alc_serialized_yn is set at the stream type level. If A1 is
11658: -- serialized (3 units), with 2 stream types, okl_tax_sources will
11659: -- have 6 rows. Out of these 2 rows (last ones for each atream type)
11660: -- will have alc_serialized_yn set to 'L'
11661: lp_tax_src_params_rec.alc_serialized_yn := 'L';
11662: ELSE

Line 11730: -- insert into okl_tax_sources

11726: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11727: 'prepared new tax sources ');
11728: END IF;
11729:
11730: -- insert into okl_tax_sources
11731: BEGIN
11732: IF lx_tax_sources_tbl.COUNT > 0 THEN
11733: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
11734: -- SAVE EXCEPTIONS

Line 11735: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);

11731: BEGIN
11732: IF lx_tax_sources_tbl.COUNT > 0 THEN
11733: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
11734: -- SAVE EXCEPTIONS
11735: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
11736: END IF;
11737: EXCEPTION
11738: WHEN OTHERS THEN
11739: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 11745: p_token1_value => 'OKL_TAX_SOURCES',

11741: OKL_API.set_message(
11742: p_app_name => 'OKL',
11743: p_msg_name => 'OKL_TX_TRX_INS_ERR',
11744: p_token1 => 'TABLE_NAME',
11745: p_token1_value => 'OKL_TAX_SOURCES',
11746: p_token2 => 'ERROR_CODE',
11747: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
11748: p_token3 => 'ITERATION',
11749: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 11754: -- Insert into okl_tax_sources end --

11750: END LOOP;
11751: RAISE OKL_API.G_EXCEPTION_ERROR;
11752: END IF;
11753: END;
11754: -- Insert into okl_tax_sources end --
11755:
11756: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
11757: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11758: ' inserted into okl_tax_sources ' );

Line 11758: ' inserted into okl_tax_sources ' );

11754: -- Insert into okl_tax_sources end --
11755:
11756: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
11757: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11758: ' inserted into okl_tax_sources ' );
11759: END IF;
11760:
11761: -- At this point tax sources for previous upfront tax have been Inactivated
11762: -- and tax sources for the current tax calculations have been inserted"

Line 12114: | OKL_TAX_SOURCES_PUB.update_tax_sources()

12110: | CALLED FROM calculate_sales_tax()
12111: |
12112: |
12113: | CALLS PROCEDURES/FUNCTIONS
12114: | OKL_TAX_SOURCES_PUB.update_tax_sources()
12115: |
12116: |
12117: | PARAMETERS
12118: | p_source_trx_id -- Source transaction ID

Line 12194: FROM okl_tax_sources

12190: bill_to_party_site_id, bill_to_location_id, bill_to_party_id,
12191: ship_to_cust_acct_site_use_id, bill_to_cust_acct_site_use_id,
12192: trx_currency_code, currency_conversion_type, currency_conversion_rate,
12193: currency_conversion_date, org_id, alc_serialized_yn
12194: FROM okl_tax_sources
12195: WHERE khr_id = cp_khr_id
12196: AND kle_id = cp_kle_id
12197: AND tax_call_type_code = G_UPFRONT_TAX
12198: AND tax_line_status_code = G_ACTIVE_STATUS

Line 12227: TYPE tax_sources_tbl_type IS TABLE OF OKL_TAX_SOURCES%ROWTYPE INDEX BY BINARY_INTEGER;

12223: AND enabled_flag = 'Y'
12224: AND NVL(start_date_active, sysdate) <= sysdate
12225: AND NVL(end_date_active, sysdate) >= sysdate;
12226:
12227: TYPE tax_sources_tbl_type IS TABLE OF OKL_TAX_SOURCES%ROWTYPE INDEX BY BINARY_INTEGER;
12228: TYPE tax_src_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12229:
12230: l_tax_src_tbl tax_src_tbl_type;
12231: l_tax_sources_tbl tax_sources_tbl_type;

Line 12519: UPDATE okl_tax_sources SET tax_line_status_code = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);

12515:
12516: IF l_tax_src_tbl.COUNT > 0 THEN
12517: BEGIN
12518: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
12519: UPDATE okl_tax_sources SET tax_line_status_code = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
12520: EXCEPTION
12521: WHEN OTHERS THEN
12522: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
12523: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 12528: p_token1_value => 'OKL_TAX_SOURCES',

12524: OKL_API.set_message(
12525: p_app_name => 'OKL',
12526: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
12527: p_token1 => 'TABLE_NAME',
12528: p_token1_value => 'OKL_TAX_SOURCES',
12529: p_token2 => 'ERROR_CODE',
12530: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
12531: p_token3 => 'ITERATION',
12532: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 12545: -- bulk insert into okl_tax_sources -- start

12541: 'Inactivating the status of previous active upfront tax sources - End ' );
12542: END IF;
12543: -- Inactivate the previous ACTIVE tax lines - end
12544:
12545: -- bulk insert into okl_tax_sources -- start
12546: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12547: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12548: ' Insert Adjusting tax sources - Start');
12549: END IF;

Line 12555: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);

12551: BEGIN
12552: IF l_tax_sources_tbl.COUNT > 0 THEN
12553: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
12554: -- SAVE EXCEPTIONS
12555: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
12556: END IF;
12557: EXCEPTION
12558: WHEN OTHERS THEN
12559: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 12564: p_token1_value => 'OKL_TAX_SOURCES',

12560: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
12561: OKL_API.set_message(p_app_name => 'OKL',
12562: p_msg_name => 'OKL_TX_TRX_INS_ERR',
12563: p_token1 => 'TABLE_NAME',
12564: p_token1_value => 'OKL_TAX_SOURCES',
12565: p_token2 => 'ERROR_CODE',
12566: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
12567: p_token3 => 'ITERATION',
12568: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 12578: -- bulk insert into okl_tax_sources -- end

12574: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12575: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12576: ' Insert Adjusting tax sources - End');
12577: END IF;
12578: -- bulk insert into okl_tax_sources -- end
12579:
12580: -- Reverse document call
12581: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12582: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',

Line 12616: -- zx_lines and update total_tax on okl_tax_sources

12612: RAISE OKL_API.G_EXCEPTION_ERROR;
12613: END IF;
12614:
12615: -- Get the total tax amount corresponding to 'Reverse' transaction from
12616: -- zx_lines and update total_tax on okl_tax_sources
12617: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12618: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12619: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
12620: END IF;

Line 12861: -- bulk insert into okl_tax_sources -- start

12857: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12858: 'l_new_tax_sources_tbl.COUNT '||l_new_tax_sources_tbl.COUNT);
12859: END IF;
12860:
12861: -- bulk insert into okl_tax_sources -- start
12862: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12863: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12864: ' Insert Split asset tax sources - Start');
12865: END IF;

Line 12871: INSERT INTO okl_tax_sources VALUES l_new_tax_sources_tbl(indx);

12867: BEGIN
12868: IF l_new_tax_sources_tbl.COUNT > 0 THEN
12869: FORALL indx in l_new_tax_sources_tbl.FIRST..l_new_tax_sources_tbl.LAST
12870: -- SAVE EXCEPTIONS
12871: INSERT INTO okl_tax_sources VALUES l_new_tax_sources_tbl(indx);
12872: END IF;
12873: EXCEPTION
12874: WHEN OTHERS THEN
12875: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 12880: p_token1_value => 'OKL_TAX_SOURCES',

12876: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
12877: OKL_API.set_message(p_app_name => 'OKL',
12878: p_msg_name => 'OKL_TX_TRX_INS_ERR',
12879: p_token1 => 'TABLE_NAME',
12880: p_token1_value => 'OKL_TAX_SOURCES',
12881: p_token2 => 'ERROR_CODE',
12882: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
12883: p_token3 => 'ITERATION',
12884: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 12894: -- bulk insert into okl_tax_sources -- end

12890: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12891: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12892: ' Insert Split asset tax sources - End');
12893: END IF;
12894: -- bulk insert into okl_tax_sources -- end
12895:
12896:
12897: IF l_line_params_tbl.COUNT > 0 THEN
12898: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 13191: FROM okl_tax_sources

13187: WHERE NAME = 'Booking';
13188:
13189: CURSOR l_tax_src_info_csr(cp_khr_id IN NUMBER, cp_trx_id IN NUMBER) IS
13190: SELECT org_id, application_id, entity_code, event_class_code
13191: FROM okl_tax_sources
13192: WHERE khr_id = cp_khr_id
13193: AND tax_call_type_code = G_UPFRONT_TAX
13194: AND tax_line_status_code = G_ACTIVE_STATUS
13195: AND application_id = G_OKL_APPLICATION_ID

Line 13202: FROM okl_tax_sources

13198: AND ROWNUM = 1;
13199:
13200: CURSOR l_prev_taxsources_csr(cp_khr_id IN NUMBER, cp_trx_id IN NUMBER) IS
13201: SELECT id
13202: FROM okl_tax_sources
13203: WHERE khr_id = cp_khr_id
13204: AND tax_call_type_code = G_UPFRONT_TAX
13205: AND tax_line_status_code = G_ACTIVE_STATUS
13206: AND application_id = G_OKL_APPLICATION_ID

Line 13215: FROM okl_tax_sources

13211: -- This cursor is used during Booking. It will pick up the Pre-booking tax lines
13212: -- Pre-Booking tax lines will be the only ACTIVE set of tax lines at the time K is being Booked
13213: CURSOR l_prevtaxsourcesbk_csr(cp_khr_id IN NUMBER) IS
13214: SELECT id
13215: FROM okl_tax_sources
13216: WHERE khr_id = cp_khr_id
13217: AND tax_call_type_code = G_UPFRONT_TAX
13218: AND tax_line_status_code = G_ACTIVE_STATUS
13219: AND application_id = G_OKL_APPLICATION_ID

Line 13469: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prev_tax_source_tbl(i);

13465: IF l_prev_tax_source_tbl.COUNT > 0 THEN
13466: l_delete_data := TRUE;
13467: BEGIN
13468: FORALL i IN l_prev_tax_source_tbl.FIRST..l_prev_tax_source_tbl.LAST
13469: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prev_tax_source_tbl(i);
13470:
13471: EXCEPTION
13472: WHEN OTHERS THEN
13473: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 13478: p_token1_value => 'OKL_TAX_SOURCES',

13474: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
13475: OKL_API.set_message(p_app_name => 'OKL',
13476: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
13477: p_token1 => 'TABLE_NAME',
13478: p_token1_value => 'OKL_TAX_SOURCES',
13479: p_token2 => 'ERROR_CODE',
13480: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
13481: p_token3 => 'ITERATION',
13482: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 14541: -- insert into okl_tax_sources

14537: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14538: 'lx_tax_sources_tbl.COUNT '||lx_tax_sources_tbl.COUNT);
14539: END IF;
14540:
14541: -- insert into okl_tax_sources
14542: BEGIN
14543: IF lx_tax_sources_tbl.COUNT > 0 THEN
14544: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
14545: -- SAVE EXCEPTIONS

Line 14546: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);

14542: BEGIN
14543: IF lx_tax_sources_tbl.COUNT > 0 THEN
14544: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
14545: -- SAVE EXCEPTIONS
14546: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
14547: END IF;
14548: EXCEPTION
14549: WHEN OTHERS THEN
14550: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 14556: p_token1_value => 'OKL_TAX_SOURCES',

14552: OKL_API.set_message(
14553: p_app_name => 'OKL',
14554: p_msg_name => 'OKL_TX_TRX_INS_ERR',
14555: p_token1 => 'TABLE_NAME',
14556: p_token1_value => 'OKL_TAX_SOURCES',
14557: p_token2 => 'ERROR_CODE',
14558: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
14559: p_token3 => 'ITERATION',
14560: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 14565: -- Insert into okl_tax_sources end --

14561: END LOOP;
14562: RAISE OKL_API.G_EXCEPTION_ERROR;
14563: END IF;
14564: END;
14565: -- Insert into okl_tax_sources end --
14566:
14567: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
14568: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14569: 'Insert into okl_tax_sources ');

Line 14569: 'Insert into okl_tax_sources ');

14565: -- Insert into okl_tax_sources end --
14566:
14567: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
14568: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14569: 'Insert into okl_tax_sources ');
14570: END IF;
14571:
14572: IF lx_line_params_tbl.COUNT > 0 THEN
14573: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 14962: | okl_tax_sources_pub.update_tax_sources()

Line 15029: FROM okl_tax_sources

15025: bill_to_party_site_id, bill_to_location_id, bill_to_party_id,
15026: ship_to_cust_acct_site_use_id, bill_to_cust_acct_site_use_id,
15027: trx_currency_code, currency_conversion_date, currency_conversion_rate,
15028: currency_conversion_type
15029: FROM okl_tax_sources
15030: WHERE khr_id = cp_khr_id
15031: AND tax_call_type_code = G_UPFRONT_TAX
15032: AND tax_line_status_code = G_ACTIVE_STATUS
15033: AND application_id = G_OKL_APPLICATION_ID

Line 15040: FROM okl_tax_sources

15036: AND ADJUSTED_DOC_TRX_LINE_ID IS NULL;
15037:
15038: CURSOR l_rbk_taxablelines_csr(cp_trx_id IN NUMBER, cp_khr_id IN NUMBER) IS
15039: SELECT id, kle_id
15040: FROM okl_tax_sources
15041: WHERE trx_id = cp_trx_id
15042: AND khr_id = cp_khr_id
15043: AND tax_call_type_code = G_UPFRONT_TAX
15044: AND tax_line_status_code = G_ACTIVE_STATUS;

Line 15271: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);

15267: -- Inactivate the previous ACTIVE tax lines - begin
15268: IF l_tax_src_tbl.COUNT > 0 THEN
15269: BEGIN
15270: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
15271: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
15272: EXCEPTION
15273: WHEN OTHERS THEN
15274: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
15275: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 15280: p_token1_value => 'OKL_TAX_SOURCES',

15276: OKL_API.set_message(
15277: p_app_name => 'OKL',
15278: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
15279: p_token1 => 'TABLE_NAME',
15280: p_token1_value => 'OKL_TAX_SOURCES',
15281: p_token2 => 'ERROR_CODE',
15282: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
15283: p_token3 => 'ITERATION',
15284: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 15299: -- bulk insert into okl_tax_sources -- start

15295: -- Inactivate the previous ACTIVE tax lines - end
15296:
15297: -- Push the negative tax lines populated before for original contract into
15298: -- tax sources
15299: -- bulk insert into okl_tax_sources -- start
15300: BEGIN
15301: IF l_tax_sources_tbl.COUNT > 0 THEN
15302: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
15303: -- SAVE EXCEPTIONS

Line 15304: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);

15300: BEGIN
15301: IF l_tax_sources_tbl.COUNT > 0 THEN
15302: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
15303: -- SAVE EXCEPTIONS
15304: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
15305: END IF;
15306: EXCEPTION
15307: WHEN OTHERS THEN
15308: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 15313: p_token1_value => 'OKL_TAX_SOURCES',

15309: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
15310: OKL_API.set_message(p_app_name => 'OKL',
15311: p_msg_name => 'OKL_TX_TRX_INS_ERR',
15312: p_token1 => 'TABLE_NAME',
15313: p_token1_value => 'OKL_TAX_SOURCES',
15314: p_token2 => 'ERROR_CODE',
15315: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
15316: p_token3 => 'ITERATION',
15317: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 15322: -- bulk insert into okl_tax_sources -- end

15318: END LOOP;
15319: RAISE OKL_API.G_EXCEPTION_ERROR;
15320: END IF;
15321: END;
15322: -- bulk insert into okl_tax_sources -- end
15323:
15324: -- Reverse document call for the reversal of original contract tax sources
15325: -- Populate ZX reverse transaction tables
15326: IF (l_booking_tax_exists) THEN -- Perform reversal only if the booking tax exists

Line 15360: -- for the 'Rebook' transaction and update total_tax in okl_tax_sources

15356: RAISE OKL_API.G_EXCEPTION_ERROR;
15357: END IF;
15358:
15359: -- Get the total tax amount corresponding to 'Reverse' transaction initiated
15360: -- for the 'Rebook' transaction and update total_tax in okl_tax_sources
15361: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
15362: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax.',
15363: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
15364: END IF;

Line 15444: 'Calling okl_tax_sources_pub.update_tax_sources for synching back original contract info for all Lines in Tax Sources');

15440: IF (l_txsv_tbl.COUNT > 0) THEN
15441:
15442: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
15443: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax',
15444: 'Calling okl_tax_sources_pub.update_tax_sources for synching back original contract info for all Lines in Tax Sources');
15445: END IF;
15446:
15447: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
15448: ,p_init_msg_list => p_init_msg_list

Line 15447: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

15443: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax',
15444: 'Calling okl_tax_sources_pub.update_tax_sources for synching back original contract info for all Lines in Tax Sources');
15445: END IF;
15446:
15447: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
15448: ,p_init_msg_list => p_init_msg_list
15449: ,x_return_status => x_return_status
15450: ,x_msg_count => x_msg_count
15451: ,x_msg_data => x_msg_data

Line 15715: FROM okl_tax_sources

15711: -- Check if quoting tax was already calculated for this quote. If so, first
15712: -- delete the quoting tax source transaction and tax details
15713: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS
15714: SELECT id
15715: FROM okl_tax_sources
15716: WHERE tax_call_type_code = G_UPFRONT_TAX
15717: AND trx_id = cp_trx_id;
15718:
15719: -- Get the previous tax trx details

Line 16043: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsources_tbl(i);

16039: END;
16040:
16041: BEGIN
16042: FORALL i IN l_prevtaxsources_tbl.FIRST..l_prevtaxsources_tbl.LAST
16043: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsources_tbl(i);
16044: EXCEPTION
16045: WHEN OTHERS THEN
16046: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
16047: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 16051: p_token1_value => 'OKL_TAX_SOURCES',

16047: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
16048: OKL_API.set_message( p_app_name => 'OKL',
16049: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
16050: p_token1 => 'TABLE_NAME',
16051: p_token1_value => 'OKL_TAX_SOURCES',
16052: p_token2 => 'ERROR_CODE',
16053: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
16054: p_token3 => 'ITERATION',
16055: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 17026: -- Insert into okl_tax_sources

17022: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17023: 'lx_line_params_tbl.COUNT '||lx_line_params_tbl.COUNT);
17024: END IF;
17025:
17026: -- Insert into okl_tax_sources
17027: BEGIN
17028: IF lx_tax_sources_tbl.COUNT > 0 THEN
17029: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
17030: -- SAVE EXCEPTIONS

Line 17031: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);

17027: BEGIN
17028: IF lx_tax_sources_tbl.COUNT > 0 THEN
17029: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
17030: -- SAVE EXCEPTIONS
17031: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
17032: END IF;
17033: EXCEPTION
17034: WHEN OTHERS THEN
17035: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 17040: p_token1_value => 'OKL_TAX_SOURCES',

17036: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
17037: OKL_API.set_message( p_app_name => 'OKL',
17038: p_msg_name => 'OKL_TX_TRX_INS_ERR',
17039: p_token1 => 'TABLE_NAME',
17040: p_token1_value => 'OKL_TAX_SOURCES',
17041: p_token2 => 'ERROR_CODE',
17042: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
17043: p_token3 => 'ITERATION',
17044: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 17050: ---- Insert into okl_tax_sources end -----

17046: RAISE OKL_API.G_EXCEPTION_ERROR;
17047: END IF;
17048: END;
17049:
17050: ---- Insert into okl_tax_sources end -----
17051: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
17052: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17053: 'Insert into okl_tax_sources ');
17054: END IF;

Line 17053: 'Insert into okl_tax_sources ');

17049:
17050: ---- Insert into okl_tax_sources end -----
17051: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
17052: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17053: 'Insert into okl_tax_sources ');
17054: END IF;
17055:
17056: IF lx_line_params_tbl.COUNT > 0 THEN
17057: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 18230: FROM okl_tax_sources

18226: CURSOR l_taxsources_csr(cp_tax_sources_id IN NUMBER) IS
18227: SELECT org_id, trx_line_id, application_id, event_class_code,
18228: entity_code, trx_level_type, khr_id, product_category, user_defined_fisc_class,
18229: trx_business_category, line_intended_use, alc_serialized_yn
18230: FROM okl_tax_sources
18231: WHERE id = cp_tax_sources_id;
18232:
18233: CURSOR l_zxlinestotaltax_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
18234: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,

Line 18337: 'Calling okl_tax_sources_pub.update_tax_sources for Updating Tax determinants');

18333: l_txsv_rec.line_intended_use := p_line_intended_use;
18334:
18335: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18336: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18337: 'Calling okl_tax_sources_pub.update_tax_sources for Updating Tax determinants');
18338: END IF;
18339:
18340: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18341: ,p_init_msg_list => p_init_msg_list

Line 18340: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

18336: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18337: 'Calling okl_tax_sources_pub.update_tax_sources for Updating Tax determinants');
18338: END IF;
18339:
18340: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18341: ,p_init_msg_list => p_init_msg_list
18342: ,x_return_status => l_return_status
18343: ,x_msg_count => x_msg_count
18344: ,x_msg_data => x_msg_data

Line 18482: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for current line in Tax Sources');

18478: END IF;
18479:
18480: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18481: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18482: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for current line in Tax Sources');
18483: END IF;
18484:
18485: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18486: ,p_init_msg_list => p_init_msg_list

Line 18485: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

18481: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18482: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for current line in Tax Sources');
18483: END IF;
18484:
18485: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18486: ,p_init_msg_list => p_init_msg_list
18487: ,x_return_status => l_return_status
18488: ,x_msg_count => x_msg_count
18489: ,x_msg_data => x_msg_data

Line 18797: -- and store in total_tax column of okl_tax_sources

18793: END IF;
18794:
18795: -- Overriding a tax line can impact the tax lines of other transaction lines
18796: -- Get the modified tax lines from zx_lines, sum up the total tax amount
18797: -- and store in total_tax column of okl_tax_sources
18798:
18799: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18800: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_details_override.',
18801: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');

Line 20738: FROM okl_tax_sources

20734: -- Rebook can be abandoned only prior to Rebook activation. Hence tax sources
20735: -- picked by this cursor will --be the ones created at the time of validation
20736: CURSOR l_taxsources_csr(cp_trx_id IN NUMBER) IS
20737: SELECT id, org_id, application_id, entity_code, event_class_code
20738: FROM okl_tax_sources
20739: WHERE trx_id = cp_trx_id
20740: AND application_id = G_OKL_APPLICATION_ID
20741: AND TAX_CALL_TYPE_CODE = G_UPFRONT_TAX
20742: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;

Line 20746: FROM okl_tax_sources

20742: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20743:
20744: CURSOR l_taxsources_prbk_csr(cp_trx_id IN NUMBER) IS
20745: SELECT id, org_id, entity_code, event_class_code
20746: FROM okl_tax_sources
20747: WHERE trx_id = cp_trx_id
20748: AND TAX_CALL_TYPE_CODE = G_UPFRONT_TAX
20749: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20750:

Line 20846: UPDATE okl_tax_sources SET tax_line_status_code = G_CANCELLED_STATUS

20842: IF (p_source_trx_name = 'Pre-Rebook') THEN
20843:
20844: FOR l_taxsources_prbk_rec in l_taxsources_prbk_csr(cp_trx_id => p_source_trx_id) LOOP
20845:
20846: UPDATE okl_tax_sources SET tax_line_status_code = G_CANCELLED_STATUS
20847: WHERE id = l_taxsources_prbk_rec.id;
20848:
20849: END LOOP;
20850:

Line 20875: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');

20871: IF (i > 1 AND p_source_trx_name = 'Rebook') THEN -- Update Tax Sources
20872:
20873: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
20874: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.cancel_document_tax.',
20875: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');
20876: END IF;
20877:
20878: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version
20879: ,p_init_msg_list => p_init_msg_list

Line 20878: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version

20874: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.cancel_document_tax.',
20875: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');
20876: END IF;
20877:
20878: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version
20879: ,p_init_msg_list => p_init_msg_list
20880: ,x_return_status => l_return_status
20881: ,x_msg_count => x_msg_count
20882: ,x_msg_data => x_msg_data