[Home] [Help]
37: PROCEDURE fetch_detail_tax_lines (
38: x_return_status OUT NOCOPY VARCHAR2);
39:
40: PROCEDURE process_taxes_for_xml_inv_line (
41: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2);
43:
44: PROCEDURE process_taxes_for_xml_inv_hdr (
45: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
41: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
42: x_return_status OUT NOCOPY VARCHAR2);
43:
44: PROCEDURE process_taxes_for_xml_inv_hdr (
45: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE adjust_tax_for_xml_inv_line (
49: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
45: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
46: x_return_status OUT NOCOPY VARCHAR2);
47:
48: PROCEDURE adjust_tax_for_xml_inv_line (
49: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
50: x_return_status OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE adjust_tax_for_xml_inv_hdr (
53: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
49: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
50: x_return_status OUT NOCOPY VARCHAR2);
51:
52: PROCEDURE adjust_tax_for_xml_inv_hdr (
53: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
54: x_return_status OUT NOCOPY VARCHAR2);
55:
56: PROCEDURE match_tax_amt_to_summary_line (
57: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
53: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
54: x_return_status OUT NOCOPY VARCHAR2);
55:
56: PROCEDURE match_tax_amt_to_summary_line (
57: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
58: x_return_status OUT NOCOPY VARCHAR2);
59:
60: g_current_runtime_level NUMBER;
61: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
70: | line and also unique tax regimes for whole transaction |
71: * ======================================================================*/
72: PROCEDURE get_tax_regimes (
73: p_trx_line_index IN BINARY_INTEGER,
74: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,
75: x_return_status OUT NOCOPY VARCHAR2 ) IS
76:
77: /* Bug 4959835*/
78: l_template_usage_code zx_det_factor_templ_b.template_usage_code%type;
225: | This procedure is called for every transaction line |
226: * ======================================================================*/
227: PROCEDURE calculate_tax (
228: p_trx_line_index IN BINARY_INTEGER,
229: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
230: x_return_status OUT NOCOPY VARCHAR2) IS
231:
232: l_begin_index BINARY_INTEGER;
233: l_end_index BINARY_INTEGER;
1547: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1548: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1550:
1551: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1552:
1553: RETURN;
1554: END IF; -- ctrl_total_line_tx_amt <> 0
1555: END IF; -- l_tax_exists_flg = 'Y' or ELSE
1607: | This procedure is called for every transaction line |
1608: * ======================================================================*/
1609: PROCEDURE override_detail_tax_lines (
1610: p_trx_line_index IN BINARY_INTEGER,
1611: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1612: x_return_status OUT NOCOPY VARCHAR2) IS
1613:
1614:
1615: BEGIN
1682: | |
1683: * ======================================================================*/
1684: PROCEDURE override_summary_tax_lines (
1685: p_trx_line_index IN BINARY_INTEGER,
1686: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1687: x_return_status OUT NOCOPY VARCHAR2) IS
1688:
1689: BEGIN
1690: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1753: | PROCEDURE tax_line_determination |
1754: | This procedure is called for the whole transaction |
1755: * ======================================================================*/
1756: PROCEDURE tax_line_determination (
1757: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1758: x_return_status OUT NOCOPY VARCHAR2) IS
1759:
1760: l_error_buffer VARCHAR2(240);
1761:
1996: | Public procedure prorate_imported_sum_tax_lines is used to prorate |
1997: | imported summary tax lines to create detail tax lines. |
1998: *=========================================================================*/
1999: PROCEDURE prorate_imported_sum_tax_lines (
2000: p_event_class_rec IN zx_api_pub.event_class_rec_type,
2001: x_return_status OUT NOCOPY VARCHAR2) IS
2002:
2003: BEGIN
2004:
2076: | PROCEDURE calculate_tax_for_import |
2077: * ======================================================================*/
2078: PROCEDURE calculate_tax_for_import (
2079: p_trx_line_index IN BINARY_INTEGER,
2080: p_event_class_rec IN zx_api_pub.event_class_rec_type,
2081: x_return_status OUT NOCOPY VARCHAR2) IS
2082:
2083: l_tax_date DATE;
2084: l_tax_determine_date DATE;
2200:
2201: END calculate_tax_for_import;
2202:
2203: PROCEDURE update_exchange_rate (
2204: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2205: p_ledger_id IN NUMBER,
2206: p_currency_conversion_rate IN NUMBER,
2207: p_currency_conversion_type IN VARCHAR2,
2208: p_currency_conversion_date IN DATE,
2390: | PROCEDURE reverse_document |
2391: | |
2392: * ======================================================================*/
2393: PROCEDURE reverse_document (
2394: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2395: x_return_status OUT NOCOPY VARCHAR2 ) IS
2396: BEGIN
2397: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2398:
2814: | rewrite for bug fix 3420456 |
2815: *=========================================================================*/
2816:
2817: PROCEDURE process_taxes_for_xml_inv_line (
2818: -- p_event_class_rec IN zx_api_pub.event_class_rec_type,
2819: x_return_status OUT NOCOPY VARCHAR2) IS
2820:
2821: CURSOR get_total_line_tax_amt_csr IS
2822: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */
2930: --l_context_info_rec.APPLICATION_ID := l_application_id_tbl(i);
2931: --l_context_info_rec.ENTITY_CODE := l_entity_code_tbl(i);
2932: --l_context_info_rec.EVENT_CLASS_CODE := l_event_class_code_tbl(i);
2933: --l_context_info_rec.TRX_ID := l_trx_id_tbl(i);
2934: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
2935:
2936: --Added following update for Bug#13893772
2937: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
2938: zx_detail_tax_lines_gt
3092: | invoices with header level control tax amount. |
3093: *=========================================================================*/
3094:
3095: PROCEDURE process_taxes_for_xml_inv_hdr (
3096: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3097: x_return_status OUT NOCOPY VARCHAR2) IS
3098:
3099: CURSOR get_total_trx_tax_amt_csr IS
3100: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3203: --l_context_info_rec.APPLICATION_ID := l_application_id_tbl(i);
3204: --l_context_info_rec.ENTITY_CODE := l_entity_code_tbl(i);
3205: --l_context_info_rec.EVENT_CLASS_CODE := l_event_class_code_tbl(i);
3206: --l_context_info_rec.TRX_ID := l_trx_id_tbl(i);
3207: --ZX_API_PUB.add_msg( p_context_info_rec => l_context_info_rec );
3208:
3209: --Added following update for Bug#13893772
3210: UPDATE /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3211: zx_detail_tax_lines_gt
3363: | This procedure is used to adjust tax lines for XML invoices |
3364: | with header level control tax amount. |
3365: *=========================================================================*/
3366: PROCEDURE adjust_tax_for_xml_inv_line (
3367: ---p_event_class_rec IN zx_api_pub.event_class_rec_type,
3368: x_return_status OUT NOCOPY VARCHAR2) IS
3369:
3370: CURSOR get_total_line_tax_amt_csr IS
3371: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3567: | This procedure contains the code for adjusting tax lines for XML |
3568: | invoices with header level control tax amount. |
3569: *=========================================================================*/
3570: PROCEDURE adjust_tax_for_xml_inv_hdr (
3571: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3572: x_return_status OUT NOCOPY VARCHAR2) IS
3573:
3574: CURSOR get_total_trx_tax_amt_csr IS
3575: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3750: | tax line with last_manual_entry = 'TAX_AMOUNT'. |
3751: | |
3752: * ======================================================================*/
3753: PROCEDURE match_tax_amt_to_summary_line (
3754: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
3755: x_return_status OUT NOCOPY VARCHAR2) IS
3756:
3757: CURSOR get_sum_tax_lines_for_adj_csr IS
3758: SELECT tax_amt, summary_tax_line_id
3979: | PROCEDURE init_for_header is used to initialize the Global |
3980: | Structures / Global Temp Tables owned by TDM at header level. |
3981: * ======================================================================*/
3982: PROCEDURE init_for_header (
3983: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3984: x_return_status OUT NOCOPY VARCHAR2 ) IS
3985:
3986: BEGIN
3987: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4090: | PROCEDURE init_for_line is used to initialize the Global |
4091: | Structures / Global Temp Tables owned by TDM at line level. |
4092: * ======================================================================*/
4093: PROCEDURE init_for_line (
4094: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
4095: x_return_status OUT NOCOPY VARCHAR2 ) IS
4096:
4097: BEGIN
4098: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4156: | PROCEDURE init_for_tax_line is used to initialize the Global |
4157: | Structures / Global Temp Tables owned by TDM at tax line level. |
4158: * ======================================================================*/
4159: PROCEDURE init_for_tax_line (
4160: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
4161: x_return_status OUT NOCOPY VARCHAR2 ) IS
4162:
4163: BEGIN
4164: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4200: | PROCEDURE init_for_tax_dist is used to initialize the Global |
4201: | Structures/Global Temp Tables owned by TDM at tax distribution level.|
4202: * ======================================================================*/
4203: PROCEDURE init_for_tax_dist (
4204: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
4205: x_return_status OUT NOCOPY VARCHAR2 ) IS
4206:
4207: BEGIN
4208: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4246: | PROCEDURE initialize is used to initialize the Global |
4247: | Structures / Global Temp Tables owned by TDM |
4248: * ======================================================================*/
4249: PROCEDURE initialize (
4250: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
4251: p_init_level IN VARCHAR2,
4252: x_return_status OUT NOCOPY VARCHAR2 ) IS
4253:
4254: BEGIN