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 6080: -- populate okl_tax_sources pl/sql table

6076: lx_pc_code := G_PC_CODE;
6077: lx_tax_classification_code := G_TAX_CLASS_CODE;
6078: END IF;
6079:
6080: -- populate okl_tax_sources pl/sql table
6081: px_tax_sources_tbl(p_tax_call_cnt).id := get_seq_id;
6082: px_tax_sources_tbl(p_tax_call_cnt).khr_id := p_tax_src_params_rec.khr_id;
6083: px_tax_sources_tbl(p_tax_call_cnt).kle_id := p_tax_src_params_rec.kle_id;
6084: px_tax_sources_tbl(p_tax_call_cnt).sty_id := p_tax_src_params_rec.sty_id;

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

8155: | Date Author Description of Changes
8156: | 08-APR-05 SECHAWLA Created
8157: | 22-APR-08 SECHAWLA 6975983 Do not error out if there is no tax in eBTax for
8158: | the Billed stream elements. Create taxable line
8159: | in okl_tax_sources. There won't be aby tax lines
8160: | in okl_tax_trx_details.
8161: |
8162: *=======================================================================*/
8163: PROCEDURE process_tax_schedule_tax(

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

8725: -- billed (under old/new solution) If so, insert already calculated tax
8726: -- lines into tax sources and tax trx details with trx type of
8727: -- 'Tax Schedule' If Billed under new solution, then tax would have been
8728: -- calculated under 'Billing' transaction type and tax lines inserted into
8729: -- okl_tax_sources/okl_tax_trx_detials. Insert these tax lines back into tax
8730: -- sources/tax trx details with transaction type of 'Tax Schedule'
8731:
8732: l_bill_ts_tx_src_cnt := 0;
8733: l_bill_ts_tx_src_tbl.DELETE;

Line 8991: 'before Insert into okl_tax_sources ');

8987: -- all the data for the billed stream elements
8988:
8989: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
8990: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
8991: 'before Insert into okl_tax_sources ');
8992: END IF;
8993:
8994: ---- Insert into okl_tax_sources begin -----
8995: BEGIN

Line 8994: ---- Insert into okl_tax_sources begin -----

8990: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
8991: 'before Insert into okl_tax_sources ');
8992: END IF;
8993:
8994: ---- Insert into okl_tax_sources begin -----
8995: BEGIN
8996: IF l_tax_sources_tbl.COUNT > 0 THEN
8997: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
8998: -- SAVE EXCEPTIONS

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

8995: BEGIN
8996: IF l_tax_sources_tbl.COUNT > 0 THEN
8997: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
8998: -- SAVE EXCEPTIONS
8999: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
9000: END IF;
9001: EXCEPTION
9002: WHEN OTHERS THEN
9003: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 9008: p_token1_value => 'OKL_TAX_SOURCES',

9004: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
9005: OKL_API.set_message(p_app_name => 'OKL',
9006: p_msg_name => 'OKL_TX_TRX_INS_ERR',
9007: p_token1 => 'TABLE_NAME',
9008: p_token1_value => 'OKL_TAX_SOURCES',
9009: p_token2 => 'ERROR_CODE',
9010: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9011: p_token3 => 'ITERATION',
9012: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 9017: ---- Insert into okl_tax_sources end -----

9013: END LOOP;
9014: RAISE OKL_API.G_EXCEPTION_ERROR;
9015: END IF;
9016: END;
9017: ---- Insert into okl_tax_sources end -----
9018:
9019: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
9020: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9021: 'before Insert into okl_tax_trx_details ');

Line 9599: 'before Insert into okl_tax_sources ');

9595: CLOSE c_k_unbilled_streams_csr;
9596:
9597: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
9598: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9599: 'before Insert into okl_tax_sources ');
9600: END IF;
9601:
9602: ---- Insert into okl_tax_sources begin -----
9603: BEGIN

Line 9602: ---- Insert into okl_tax_sources begin -----

9598: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9599: 'before Insert into okl_tax_sources ');
9600: END IF;
9601:
9602: ---- Insert into okl_tax_sources begin -----
9603: BEGIN
9604: IF l_tax_sources_tbl.COUNT > 0 THEN
9605: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
9606: -- SAVE EXCEPTIONS

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

9603: BEGIN
9604: IF l_tax_sources_tbl.COUNT > 0 THEN
9605: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
9606: -- SAVE EXCEPTIONS
9607: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
9608: END IF;
9609: EXCEPTION
9610: WHEN OTHERS THEN
9611: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 9616: p_token1_value => 'OKL_TAX_SOURCES',

9612: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
9613: OKL_API.set_message(p_app_name => 'OKL',
9614: p_msg_name => 'OKL_TX_TRX_INS_ERR',
9615: p_token1 => 'TABLE_NAME',
9616: p_token1_value => 'OKL_TAX_SOURCES',
9617: p_token2 => 'ERROR_CODE',
9618: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
9619: p_token3 => 'ITERATION',
9620: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 9625: ---- Insert into okl_tax_sources end -----

9621: END LOOP;
9622: RAISE OKL_API.G_EXCEPTION_ERROR;
9623: END IF;
9624: END;
9625: ---- Insert into okl_tax_sources end -----
9626:
9627: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
9628: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_schedule_tax.',
9629: 'lx_line_params_tbl.COUNT '||lx_line_params_tbl.COUNT);

Line 9991: FROM okl_tax_sources

9987:
9988: -- get the previous tax source transaction for this quote
9989: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS
9990: SELECT id
9991: FROM okl_tax_sources
9992: WHERE trx_id = cp_trx_id;
9993:
9994: -- get the previous tax trx details
9995: CURSOR l_prevtaxtrxdet_csr(cp_txs_id IN NUMBER) IS

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

10214: END IF;
10215:
10216: BEGIN
10217: FORALL i IN l_prevtaxsrc_tbl.FIRST..l_prevtaxsrc_tbl.LAST
10218: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsrc_tbl(i);
10219: EXCEPTION
10220: WHEN OTHERS THEN
10221: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
10222: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 10227: p_token1_value => 'OKL_TAX_SOURCES',

10223: OKL_API.set_message(
10224: p_app_name => 'OKL',
10225: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
10226: p_token1 => 'TABLE_NAME',
10227: p_token1_value => 'OKL_TAX_SOURCES',
10228: p_token2 => 'ERROR_CODE',
10229: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
10230: p_token3 => 'ITERATION',
10231: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

10235: END;
10236:
10237: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10238: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10239: 'Deleted from okl_tax_sources... ');
10240: END IF;
10241: END IF;
10242:
10243: EXIT WHEN l_prevtaxsources_csr%NOTFOUND;

Line 10638: -- Insert into okl_tax_sources

10634: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10635: 'tax_call_cnt '||tax_call_cnt);
10636: END IF;
10637:
10638: -- Insert into okl_tax_sources
10639: BEGIN
10640: IF lx_tax_sources_tbl.COUNT > 0 THEN
10641: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
10642: -- SAVE EXCEPTIONS

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

10639: BEGIN
10640: IF lx_tax_sources_tbl.COUNT > 0 THEN
10641: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
10642: -- SAVE EXCEPTIONS
10643: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
10644: END IF;
10645: EXCEPTION
10646: WHEN OTHERS THEN
10647: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 10652: p_token1_value => 'OKL_TAX_SOURCES',

10648: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
10649: OKL_API.set_message( p_app_name => 'OKL',
10650: p_msg_name => 'OKL_TX_TRX_INS_ERR',
10651: p_token1 => 'TABLE_NAME',
10652: p_token1_value => 'OKL_TAX_SOURCES',
10653: p_token2 => 'ERROR_CODE',
10654: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
10655: p_token3 => 'ITERATION',
10656: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 10661: -- Insert into okl_tax_sources end

10657: END LOOP;
10658: RAISE OKL_API.G_EXCEPTION_ERROR;
10659: END IF;
10660: END;
10661: -- Insert into okl_tax_sources end
10662:
10663: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10664: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10665: 'Insert into okl_tax_sources ');

Line 10665: 'Insert into okl_tax_sources ');

10661: -- Insert into okl_tax_sources end
10662:
10663: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
10664: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quote_tax.',
10665: 'Insert into okl_tax_sources ');
10666: END IF;
10667:
10668: IF lx_line_params_tbl.COUNT > 0 THEN
10669: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 10898: | OKL_TAX_SOURCES_PUB.update_tax_sources()

Line 10981: FROM okl_tax_sources

10977: -- k1 > A1 > RENT
10978: -- k1 > A1 > Estimated Property Tax
10979: CURSOR l_taxsources_csr(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
10980: SELECT id, org_id, entity_code, event_class_code
10981: FROM okl_tax_sources
10982: WHERE khr_id = cp_khr_id
10983: AND kle_id = cp_kle_id
10984: AND tax_call_type_code = G_UPFRONT_TAX
10985: AND tax_line_status_code = G_ACTIVE_STATUS

Line 11046: FROM okl_tax_sources

11042: WHERE id = cp_fma_id;
11043:
11044: CURSOR l_okltaxsources_csr(cp_app_id IN NUMBER, cp_trx_id IN NUMBER) IS
11045: SELECT entity_code, event_class_code
11046: FROM okl_tax_sources
11047: WHERE application_id = cp_app_id
11048: AND trx_id = cp_trx_id
11049: AND trx_level_type = G_TRX_LEVEL_TYPE
11050: AND tax_call_type_code = G_UPFRONT_TAX

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

11309:
11310: IF l_tax_src_tbl.COUNT > 0 THEN
11311: BEGIN
11312: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
11313: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
11314:
11315: EXCEPTION
11316: WHEN OTHERS THEN
11317: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 11323: p_token1_value => 'OKL_TAX_SOURCES',

11319: OKL_API.set_message(
11320: p_app_name => 'OKL',
11321: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
11322: p_token1 => 'TABLE_NAME',
11323: p_token1_value => 'OKL_TAX_SOURCES',
11324: p_token2 => 'ERROR_CODE',
11325: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
11326: p_token3 => 'ITERATION',
11327: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

11689: IF (p_alc_final_call = 'Y') THEN
11690: -- Indicates tax for last serial number. Also, used to display the
11691: -- HGrid data
11692: -- alc_serialized_yn is set at the stream type level. If A1 is
11693: -- serialized (3 units), with 2 stream types, okl_tax_sources will
11694: -- have 6 rows. Out of these 2 rows (last ones for each atream type)
11695: -- will have alc_serialized_yn set to 'L'
11696: lp_tax_src_params_rec.alc_serialized_yn := 'L';
11697: ELSE

Line 11765: -- insert into okl_tax_sources

11761: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11762: 'prepared new tax sources ');
11763: END IF;
11764:
11765: -- insert into okl_tax_sources
11766: BEGIN
11767: IF lx_tax_sources_tbl.COUNT > 0 THEN
11768: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
11769: -- SAVE EXCEPTIONS

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

11766: BEGIN
11767: IF lx_tax_sources_tbl.COUNT > 0 THEN
11768: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
11769: -- SAVE EXCEPTIONS
11770: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
11771: END IF;
11772: EXCEPTION
11773: WHEN OTHERS THEN
11774: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 11780: p_token1_value => 'OKL_TAX_SOURCES',

11776: OKL_API.set_message(
11777: p_app_name => 'OKL',
11778: p_msg_name => 'OKL_TX_TRX_INS_ERR',
11779: p_token1 => 'TABLE_NAME',
11780: p_token1_value => 'OKL_TAX_SOURCES',
11781: p_token2 => 'ERROR_CODE',
11782: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
11783: p_token3 => 'ITERATION',
11784: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 11789: -- Insert into okl_tax_sources end --

11785: END LOOP;
11786: RAISE OKL_API.G_EXCEPTION_ERROR;
11787: END IF;
11788: END;
11789: -- Insert into okl_tax_sources end --
11790:
11791: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
11792: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11793: ' inserted into okl_tax_sources ' );

Line 11793: ' inserted into okl_tax_sources ' );

11789: -- Insert into okl_tax_sources end --
11790:
11791: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
11792: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_asset_loc_tax.',
11793: ' inserted into okl_tax_sources ' );
11794: END IF;
11795:
11796: -- At this point tax sources for previous upfront tax have been Inactivated
11797: -- and tax sources for the current tax calculations have been inserted"

Line 12149: | OKL_TAX_SOURCES_PUB.update_tax_sources()

12145: | CALLED FROM calculate_sales_tax()
12146: |
12147: |
12148: | CALLS PROCEDURES/FUNCTIONS
12149: | OKL_TAX_SOURCES_PUB.update_tax_sources()
12150: |
12151: |
12152: | PARAMETERS
12153: | p_source_trx_id -- Source transaction ID

Line 12229: FROM okl_tax_sources

12225: bill_to_party_site_id, bill_to_location_id, bill_to_party_id,
12226: ship_to_cust_acct_site_use_id, bill_to_cust_acct_site_use_id,
12227: trx_currency_code, currency_conversion_type, currency_conversion_rate,
12228: currency_conversion_date, org_id, alc_serialized_yn
12229: FROM okl_tax_sources
12230: WHERE khr_id = cp_khr_id
12231: AND kle_id = cp_kle_id
12232: AND tax_call_type_code = G_UPFRONT_TAX
12233: AND tax_line_status_code = G_ACTIVE_STATUS

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

12258: AND enabled_flag = 'Y'
12259: AND NVL(start_date_active, sysdate) <= sysdate
12260: AND NVL(end_date_active, sysdate) >= sysdate;
12261:
12262: TYPE tax_sources_tbl_type IS TABLE OF OKL_TAX_SOURCES%ROWTYPE INDEX BY BINARY_INTEGER;
12263: TYPE tax_src_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12264:
12265: l_tax_src_tbl tax_src_tbl_type;
12266: l_tax_sources_tbl tax_sources_tbl_type;

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

12550:
12551: IF l_tax_src_tbl.COUNT > 0 THEN
12552: BEGIN
12553: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
12554: UPDATE okl_tax_sources SET tax_line_status_code = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
12555: EXCEPTION
12556: WHEN OTHERS THEN
12557: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
12558: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 12563: p_token1_value => 'OKL_TAX_SOURCES',

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

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

12576: 'Inactivating the status of previous active upfront tax sources - End ' );
12577: END IF;
12578: -- Inactivate the previous ACTIVE tax lines - end
12579:
12580: -- bulk insert into okl_tax_sources -- start
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.',
12583: ' Insert Adjusting tax sources - Start');
12584: END IF;

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

12586: BEGIN
12587: IF l_tax_sources_tbl.COUNT > 0 THEN
12588: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
12589: -- SAVE EXCEPTIONS
12590: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
12591: END IF;
12592: EXCEPTION
12593: WHEN OTHERS THEN
12594: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 12599: p_token1_value => 'OKL_TAX_SOURCES',

12595: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
12596: OKL_API.set_message(p_app_name => 'OKL',
12597: p_msg_name => 'OKL_TX_TRX_INS_ERR',
12598: p_token1 => 'TABLE_NAME',
12599: p_token1_value => 'OKL_TAX_SOURCES',
12600: p_token2 => 'ERROR_CODE',
12601: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
12602: p_token3 => 'ITERATION',
12603: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

12609: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12610: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12611: ' Insert Adjusting tax sources - End');
12612: END IF;
12613: -- bulk insert into okl_tax_sources -- end
12614:
12615: -- Reverse document call
12616: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12617: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',

Line 12651: -- zx_lines and update total_tax on okl_tax_sources

12647: RAISE OKL_API.G_EXCEPTION_ERROR;
12648: END IF;
12649:
12650: -- Get the total tax amount corresponding to 'Reverse' transaction from
12651: -- zx_lines and update total_tax on okl_tax_sources
12652: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12653: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12654: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
12655: END IF;

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

12892: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12893: 'l_new_tax_sources_tbl.COUNT '||l_new_tax_sources_tbl.COUNT);
12894: END IF;
12895:
12896: -- bulk insert into okl_tax_sources -- start
12897: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12898: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12899: ' Insert Split asset tax sources - Start');
12900: END IF;

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

12902: BEGIN
12903: IF l_new_tax_sources_tbl.COUNT > 0 THEN
12904: FORALL indx in l_new_tax_sources_tbl.FIRST..l_new_tax_sources_tbl.LAST
12905: -- SAVE EXCEPTIONS
12906: INSERT INTO okl_tax_sources VALUES l_new_tax_sources_tbl(indx);
12907: END IF;
12908: EXCEPTION
12909: WHEN OTHERS THEN
12910: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 12915: p_token1_value => 'OKL_TAX_SOURCES',

12911: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
12912: OKL_API.set_message(p_app_name => 'OKL',
12913: p_msg_name => 'OKL_TX_TRX_INS_ERR',
12914: p_token1 => 'TABLE_NAME',
12915: p_token1_value => 'OKL_TAX_SOURCES',
12916: p_token2 => 'ERROR_CODE',
12917: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
12918: p_token3 => 'ITERATION',
12919: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

12925: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12926: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12927: ' Insert Split asset tax sources - End');
12928: END IF;
12929: -- bulk insert into okl_tax_sources -- end
12930:
12931:
12932: IF l_line_params_tbl.COUNT > 0 THEN
12933: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 13226: FROM okl_tax_sources

13222: WHERE NAME = 'Booking';
13223:
13224: CURSOR l_tax_src_info_csr(cp_khr_id IN NUMBER, cp_trx_id IN NUMBER) IS
13225: SELECT org_id, application_id, entity_code, event_class_code
13226: FROM okl_tax_sources
13227: WHERE khr_id = cp_khr_id
13228: AND tax_call_type_code = G_UPFRONT_TAX
13229: AND tax_line_status_code = G_ACTIVE_STATUS
13230: AND application_id = G_OKL_APPLICATION_ID

Line 13237: FROM okl_tax_sources

13233: AND ROWNUM = 1;
13234:
13235: CURSOR l_prev_taxsources_csr(cp_khr_id IN NUMBER, cp_trx_id IN NUMBER) IS
13236: SELECT id
13237: FROM okl_tax_sources
13238: WHERE khr_id = cp_khr_id
13239: AND tax_call_type_code = G_UPFRONT_TAX
13240: AND tax_line_status_code = G_ACTIVE_STATUS
13241: AND application_id = G_OKL_APPLICATION_ID

Line 13250: FROM okl_tax_sources

13246: -- This cursor is used during Booking. It will pick up the Pre-booking tax lines
13247: -- Pre-Booking tax lines will be the only ACTIVE set of tax lines at the time K is being Booked
13248: CURSOR l_prevtaxsourcesbk_csr(cp_khr_id IN NUMBER) IS
13249: SELECT id
13250: FROM okl_tax_sources
13251: WHERE khr_id = cp_khr_id
13252: AND tax_call_type_code = G_UPFRONT_TAX
13253: AND tax_line_status_code = G_ACTIVE_STATUS
13254: AND application_id = G_OKL_APPLICATION_ID

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

13536: IF l_prev_tax_source_tbl.COUNT > 0 THEN
13537: l_delete_data := TRUE;
13538: BEGIN
13539: FORALL i IN l_prev_tax_source_tbl.FIRST..l_prev_tax_source_tbl.LAST
13540: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prev_tax_source_tbl(i);
13541:
13542: EXCEPTION
13543: WHEN OTHERS THEN
13544: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 13549: p_token1_value => 'OKL_TAX_SOURCES',

13545: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
13546: OKL_API.set_message(p_app_name => 'OKL',
13547: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
13548: p_token1 => 'TABLE_NAME',
13549: p_token1_value => 'OKL_TAX_SOURCES',
13550: p_token2 => 'ERROR_CODE',
13551: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
13552: p_token3 => 'ITERATION',
13553: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 14612: -- insert into okl_tax_sources

14608: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14609: 'lx_tax_sources_tbl.COUNT '||lx_tax_sources_tbl.COUNT);
14610: END IF;
14611:
14612: -- insert into okl_tax_sources
14613: BEGIN
14614: IF lx_tax_sources_tbl.COUNT > 0 THEN
14615: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
14616: -- SAVE EXCEPTIONS

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

14613: BEGIN
14614: IF lx_tax_sources_tbl.COUNT > 0 THEN
14615: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
14616: -- SAVE EXCEPTIONS
14617: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
14618: END IF;
14619: EXCEPTION
14620: WHEN OTHERS THEN
14621: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 14627: p_token1_value => 'OKL_TAX_SOURCES',

14623: OKL_API.set_message(
14624: p_app_name => 'OKL',
14625: p_msg_name => 'OKL_TX_TRX_INS_ERR',
14626: p_token1 => 'TABLE_NAME',
14627: p_token1_value => 'OKL_TAX_SOURCES',
14628: p_token2 => 'ERROR_CODE',
14629: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
14630: p_token3 => 'ITERATION',
14631: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 14636: -- Insert into okl_tax_sources end --

14632: END LOOP;
14633: RAISE OKL_API.G_EXCEPTION_ERROR;
14634: END IF;
14635: END;
14636: -- Insert into okl_tax_sources end --
14637:
14638: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
14639: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14640: 'Insert into okl_tax_sources ');

Line 14640: 'Insert into okl_tax_sources ');

14636: -- Insert into okl_tax_sources end --
14637:
14638: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
14639: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_booking_upfront_tax.',
14640: 'Insert into okl_tax_sources ');
14641: END IF;
14642:
14643: IF lx_line_params_tbl.COUNT > 0 THEN
14644: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 15033: | okl_tax_sources_pub.update_tax_sources()

Line 15100: FROM okl_tax_sources

15096: bill_to_party_site_id, bill_to_location_id, bill_to_party_id,
15097: ship_to_cust_acct_site_use_id, bill_to_cust_acct_site_use_id,
15098: trx_currency_code, currency_conversion_date, currency_conversion_rate,
15099: currency_conversion_type
15100: FROM okl_tax_sources
15101: WHERE khr_id = cp_khr_id
15102: AND tax_call_type_code = G_UPFRONT_TAX
15103: AND tax_line_status_code = G_ACTIVE_STATUS
15104: AND application_id = G_OKL_APPLICATION_ID

Line 15111: FROM okl_tax_sources

15107: AND ADJUSTED_DOC_TRX_LINE_ID IS NULL;
15108:
15109: CURSOR l_rbk_taxablelines_csr(cp_trx_id IN NUMBER, cp_khr_id IN NUMBER) IS
15110: SELECT id, kle_id
15111: FROM okl_tax_sources
15112: WHERE trx_id = cp_trx_id
15113: AND khr_id = cp_khr_id
15114: AND tax_call_type_code = G_UPFRONT_TAX
15115: AND tax_line_status_code = G_ACTIVE_STATUS;

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

15339: -- Inactivate the previous ACTIVE tax lines - begin
15340: IF l_tax_src_tbl.COUNT > 0 THEN
15341: BEGIN
15342: FORALL i IN l_tax_src_tbl.FIRST..l_tax_src_tbl.LAST
15343: UPDATE OKL_TAX_SOURCES SET TAX_LINE_STATUS_CODE = G_INACTIVE_STATUS WHERE id = l_tax_src_tbl(i);
15344: EXCEPTION
15345: WHEN OTHERS THEN
15346: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
15347: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 15352: p_token1_value => 'OKL_TAX_SOURCES',

15348: OKL_API.set_message(
15349: p_app_name => 'OKL',
15350: p_msg_name => 'OKL_TX_TRX_UPD_ERR',
15351: p_token1 => 'TABLE_NAME',
15352: p_token1_value => 'OKL_TAX_SOURCES',
15353: p_token2 => 'ERROR_CODE',
15354: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
15355: p_token3 => 'ITERATION',
15356: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

15367: -- Inactivate the previous ACTIVE tax lines - end
15368:
15369: -- Push the negative tax lines populated before for original contract into
15370: -- tax sources
15371: -- bulk insert into okl_tax_sources -- start
15372: BEGIN
15373: IF l_tax_sources_tbl.COUNT > 0 THEN
15374: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
15375: -- SAVE EXCEPTIONS

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

15372: BEGIN
15373: IF l_tax_sources_tbl.COUNT > 0 THEN
15374: FORALL indx in l_tax_sources_tbl.FIRST..l_tax_sources_tbl.LAST
15375: -- SAVE EXCEPTIONS
15376: INSERT INTO okl_tax_sources VALUES l_tax_sources_tbl(indx);
15377: END IF;
15378: EXCEPTION
15379: WHEN OTHERS THEN
15380: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 15385: p_token1_value => 'OKL_TAX_SOURCES',

15381: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
15382: OKL_API.set_message(p_app_name => 'OKL',
15383: p_msg_name => 'OKL_TX_TRX_INS_ERR',
15384: p_token1 => 'TABLE_NAME',
15385: p_token1_value => 'OKL_TAX_SOURCES',
15386: p_token2 => 'ERROR_CODE',
15387: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
15388: p_token3 => 'ITERATION',
15389: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

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

15390: END LOOP;
15391: RAISE OKL_API.G_EXCEPTION_ERROR;
15392: END IF;
15393: END;
15394: -- bulk insert into okl_tax_sources -- end
15395:
15396: -- Reverse document call for the reversal of original contract tax sources
15397: -- Populate ZX reverse transaction tables
15398: IF (l_booking_tax_exists) THEN -- Perform reversal only if the booking tax exists

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

15428: RAISE OKL_API.G_EXCEPTION_ERROR;
15429: END IF;
15430:
15431: -- Get the total tax amount corresponding to 'Reverse' transaction initiated
15432: -- for the 'Rebook' transaction and update total_tax in okl_tax_sources
15433: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
15434: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax.',
15435: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
15436: END IF;

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

15512: IF (l_txsv_tbl.COUNT > 0) THEN
15513:
15514: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
15515: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax',
15516: 'Calling okl_tax_sources_pub.update_tax_sources for synching back original contract info for all Lines in Tax Sources');
15517: END IF;
15518:
15519: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
15520: ,p_init_msg_list => p_init_msg_list

Line 15519: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

15515: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_rebook_upfront_tax',
15516: 'Calling okl_tax_sources_pub.update_tax_sources for synching back original contract info for all Lines in Tax Sources');
15517: END IF;
15518:
15519: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
15520: ,p_init_msg_list => p_init_msg_list
15521: ,x_return_status => x_return_status
15522: ,x_msg_count => x_msg_count
15523: ,x_msg_data => x_msg_data

Line 15787: FROM okl_tax_sources

15783: -- Check if quoting tax was already calculated for this quote. If so, first
15784: -- delete the quoting tax source transaction and tax details
15785: CURSOR l_prevtaxsources_csr(cp_trx_id IN NUMBER) IS
15786: SELECT id
15787: FROM okl_tax_sources
15788: WHERE tax_call_type_code = G_UPFRONT_TAX
15789: AND trx_id = cp_trx_id;
15790:
15791: -- Get the previous tax trx details

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

16111: END;
16112:
16113: BEGIN
16114: FORALL i IN l_prevtaxsources_tbl.FIRST..l_prevtaxsources_tbl.LAST
16115: DELETE FROM OKL_TAX_SOURCES WHERE id = l_prevtaxsources_tbl(i);
16116: EXCEPTION
16117: WHEN OTHERS THEN
16118: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
16119: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP

Line 16123: p_token1_value => 'OKL_TAX_SOURCES',

16119: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
16120: OKL_API.set_message( p_app_name => 'OKL',
16121: p_msg_name => 'OKL_TX_TRX_DEL_ERR',
16122: p_token1 => 'TABLE_NAME',
16123: p_token1_value => 'OKL_TAX_SOURCES',
16124: p_token2 => 'ERROR_CODE',
16125: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
16126: p_token3 => 'ITERATION',
16127: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 17098: -- Insert into okl_tax_sources

17094: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17095: 'lx_line_params_tbl.COUNT '||lx_line_params_tbl.COUNT);
17096: END IF;
17097:
17098: -- Insert into okl_tax_sources
17099: BEGIN
17100: IF lx_tax_sources_tbl.COUNT > 0 THEN
17101: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
17102: -- SAVE EXCEPTIONS

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

17099: BEGIN
17100: IF lx_tax_sources_tbl.COUNT > 0 THEN
17101: FORALL indx in lx_tax_sources_tbl.FIRST..lx_tax_sources_tbl.LAST
17102: -- SAVE EXCEPTIONS
17103: INSERT INTO okl_tax_sources VALUES lx_tax_sources_tbl(indx);
17104: END IF;
17105: EXCEPTION
17106: WHEN OTHERS THEN
17107: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN

Line 17112: p_token1_value => 'OKL_TAX_SOURCES',

17108: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
17109: OKL_API.set_message( p_app_name => 'OKL',
17110: p_msg_name => 'OKL_TX_TRX_INS_ERR',
17111: p_token1 => 'TABLE_NAME',
17112: p_token1_value => 'OKL_TAX_SOURCES',
17113: p_token2 => 'ERROR_CODE',
17114: p_token2_value => SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),
17115: p_token3 => 'ITERATION',
17116: p_token3_value => SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);

Line 17122: ---- Insert into okl_tax_sources end -----

17118: RAISE OKL_API.G_EXCEPTION_ERROR;
17119: END IF;
17120: END;
17121:
17122: ---- Insert into okl_tax_sources end -----
17123: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
17124: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17125: 'Insert into okl_tax_sources ');
17126: END IF;

Line 17125: 'Insert into okl_tax_sources ');

17121:
17122: ---- Insert into okl_tax_sources end -----
17123: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
17124: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_quoting_upfront_tax.',
17125: 'Insert into okl_tax_sources ');
17126: END IF;
17127:
17128: IF lx_line_params_tbl.COUNT > 0 THEN
17129: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN

Line 18381: FROM okl_tax_sources

18377: CURSOR l_taxsources_csr(cp_tax_sources_id IN NUMBER) IS
18378: SELECT org_id, trx_line_id, application_id, event_class_code,
18379: entity_code, trx_level_type, khr_id, product_category, user_defined_fisc_class,
18380: trx_business_category, line_intended_use, alc_serialized_yn
18381: FROM okl_tax_sources
18382: WHERE id = cp_tax_sources_id;
18383:
18384: CURSOR l_zxlinestotaltax_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
18385: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,

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

18484: l_txsv_rec.line_intended_use := p_line_intended_use;
18485:
18486: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18487: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18488: 'Calling okl_tax_sources_pub.update_tax_sources for Updating Tax determinants');
18489: END IF;
18490:
18491: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18492: ,p_init_msg_list => p_init_msg_list

Line 18491: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

18487: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18488: 'Calling okl_tax_sources_pub.update_tax_sources for Updating Tax determinants');
18489: END IF;
18490:
18491: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18492: ,p_init_msg_list => p_init_msg_list
18493: ,x_return_status => l_return_status
18494: ,x_msg_count => x_msg_count
18495: ,x_msg_data => x_msg_data

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

18629: END IF;
18630:
18631: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18632: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18633: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for current line in Tax Sources');
18634: END IF;
18635:
18636: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18637: ,p_init_msg_list => p_init_msg_list

Line 18636: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version

18632: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_determ_override.',
18633: 'Calling okl_tax_sources_pub.update_tax_sources for updating Total Tax for current line in Tax Sources');
18634: END IF;
18635:
18636: okl_tax_sources_pub.update_tax_sources(p_api_version => p_api_version
18637: ,p_init_msg_list => p_init_msg_list
18638: ,x_return_status => l_return_status
18639: ,x_msg_count => x_msg_count
18640: ,x_msg_data => x_msg_data

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

18944: END IF;
18945:
18946: -- Overriding a tax line can impact the tax lines of other transaction lines
18947: -- Get the modified tax lines from zx_lines, sum up the total tax amount
18948: -- and store in total_tax column of okl_tax_sources
18949:
18950: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18951: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_details_override.',
18952: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');

Line 20926: FROM okl_tax_sources

20922: -- Rebook can be abandoned only prior to Rebook activation. Hence tax sources
20923: -- picked by this cursor will --be the ones created at the time of validation
20924: CURSOR l_taxsources_csr(cp_trx_id IN NUMBER) IS
20925: SELECT id, org_id, application_id, entity_code, event_class_code
20926: FROM okl_tax_sources
20927: WHERE trx_id = cp_trx_id
20928: AND application_id = G_OKL_APPLICATION_ID
20929: AND TAX_CALL_TYPE_CODE = G_UPFRONT_TAX
20930: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;

Line 20934: FROM okl_tax_sources

20930: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20931:
20932: CURSOR l_taxsources_prbk_csr(cp_trx_id IN NUMBER) IS
20933: SELECT id, org_id, entity_code, event_class_code
20934: FROM okl_tax_sources
20935: WHERE trx_id = cp_trx_id
20936: AND TAX_CALL_TYPE_CODE = G_UPFRONT_TAX
20937: AND TAX_LINE_STATUS_CODE = G_ACTIVE_STATUS;
20938:

Line 21034: UPDATE okl_tax_sources SET tax_line_status_code = G_CANCELLED_STATUS

21030: IF (p_source_trx_name = 'Pre-Rebook') THEN
21031:
21032: FOR l_taxsources_prbk_rec in l_taxsources_prbk_csr(cp_trx_id => p_source_trx_id) LOOP
21033:
21034: UPDATE okl_tax_sources SET tax_line_status_code = G_CANCELLED_STATUS
21035: WHERE id = l_taxsources_prbk_rec.id;
21036:
21037: END LOOP;
21038:

Line 21063: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');

21059: IF (i > 1 AND p_source_trx_name = 'Rebook') THEN -- Update Tax Sources
21060:
21061: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
21062: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.cancel_document_tax.',
21063: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');
21064: END IF;
21065:
21066: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version
21067: ,p_init_msg_list => p_init_msg_list

Line 21066: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version

21062: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.cancel_document_tax.',
21063: 'Calling OKL_TAX_SOURCES_PUB.update_tax_sources ');
21064: END IF;
21065:
21066: OKL_TAX_SOURCES_PUB.update_tax_sources(p_api_version => p_api_version
21067: ,p_init_msg_list => p_init_msg_list
21068: ,x_return_status => l_return_status
21069: ,x_msg_count => x_msg_count
21070: ,x_msg_data => x_msg_data