DBA Data[Home] [Help]

APPS.ZX_TDS_CALC_SERVICES_PUB_PKG dependencies on ZX_API_PUB

Line 41: --p_event_class_rec IN zx_api_pub.event_class_rec_type,

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,

Line 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,

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,

Line 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,

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;

Line 74: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type,

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;

Line 229: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_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;

Line 1497: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

1493: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1494: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1495: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1496:
1497: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1498:
1499: RETURN;
1500: END IF; -- ctrl_total_line_tx_amt <> 0
1501: END IF; -- l_tax_exists_flg = 'Y' or ELSE

Line 1557: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,

1553: | This procedure is called for every transaction line |
1554: * ======================================================================*/
1555: PROCEDURE override_detail_tax_lines (
1556: p_trx_line_index IN BINARY_INTEGER,
1557: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1558: x_return_status OUT NOCOPY VARCHAR2) IS
1559:
1560:
1561: BEGIN

Line 1632: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,

1628: | |
1629: * ======================================================================*/
1630: PROCEDURE override_summary_tax_lines (
1631: p_trx_line_index IN BINARY_INTEGER,
1632: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1633: x_return_status OUT NOCOPY VARCHAR2) IS
1634:
1635: BEGIN
1636: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1703: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,

1699: | PROCEDURE tax_line_determination |
1700: | This procedure is called for the whole transaction |
1701: * ======================================================================*/
1702: PROCEDURE tax_line_determination (
1703: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
1704: x_return_status OUT NOCOPY VARCHAR2) IS
1705:
1706: l_error_buffer VARCHAR2(240);
1707:

Line 1946: p_event_class_rec IN zx_api_pub.event_class_rec_type,

1942: | Public procedure prorate_imported_sum_tax_lines is used to prorate |
1943: | imported summary tax lines to create detail tax lines. |
1944: *=========================================================================*/
1945: PROCEDURE prorate_imported_sum_tax_lines (
1946: p_event_class_rec IN zx_api_pub.event_class_rec_type,
1947: x_return_status OUT NOCOPY VARCHAR2) IS
1948:
1949: BEGIN
1950:

Line 2026: p_event_class_rec IN zx_api_pub.event_class_rec_type,

2022: | PROCEDURE calculate_tax_for_import |
2023: * ======================================================================*/
2024: PROCEDURE calculate_tax_for_import (
2025: p_trx_line_index IN BINARY_INTEGER,
2026: p_event_class_rec IN zx_api_pub.event_class_rec_type,
2027: x_return_status OUT NOCOPY VARCHAR2) IS
2028:
2029: l_tax_date DATE;
2030: l_tax_determine_date DATE;

Line 2150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2146:
2147: END calculate_tax_for_import;
2148:
2149: PROCEDURE update_exchange_rate (
2150: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2151: p_ledger_id IN NUMBER,
2152: p_currency_conversion_rate IN NUMBER,
2153: p_currency_conversion_type IN VARCHAR2,
2154: p_currency_conversion_date IN DATE,

Line 2340: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,

2336: | PROCEDURE reverse_document |
2337: | |
2338: * ======================================================================*/
2339: PROCEDURE reverse_document (
2340: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
2341: x_return_status OUT NOCOPY VARCHAR2 ) IS
2342: BEGIN
2343: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2344:

Line 2756: -- p_event_class_rec IN zx_api_pub.event_class_rec_type,

2752: | rewrite for bug fix 3420456 |
2753: *=========================================================================*/
2754:
2755: PROCEDURE process_taxes_for_xml_inv_line (
2756: -- p_event_class_rec IN zx_api_pub.event_class_rec_type,
2757: x_return_status OUT NOCOPY VARCHAR2) IS
2758:
2759: CURSOR get_total_line_tax_amt_csr IS
2760: SELECT /*+ INDEX(tax_line ZX_DETAIL_TAX_LINES_GT_U1) */

Line 2866: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

2862: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
2863: -- l_trx_line_id_tbl(i);
2864: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
2865: -- l_trx_level_type_tbl(i);
2866: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
2867:
2868: RETURN;
2869: ELSE
2870: CLOSE get_mismatch_tax_lines_csr;

Line 2989: --p_event_class_rec IN zx_api_pub.event_class_rec_type,

2985: | invoices with header level control tax amount. |
2986: *=========================================================================*/
2987:
2988: PROCEDURE process_taxes_for_xml_inv_hdr (
2989: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
2990: x_return_status OUT NOCOPY VARCHAR2) IS
2991:
2992: CURSOR get_total_trx_tax_amt_csr IS
2993: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

Line 3088: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

3084:
3085: FND_MESSAGE.SET_NAME('ZX','ZX_HDR_CTRL_TOTAL_TAX_MISMATCH');
3086:
3087: -- FND_MSG_PUB.Add;
3088: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
3089:
3090: RETURN;
3091: ELSE
3092: CLOSE get_mismatch_tax_lines_csr;

Line 3216: ---p_event_class_rec IN zx_api_pub.event_class_rec_type,

3212: | This procedure is used to adjust tax lines for XML invoices |
3213: | with header level control tax amount. |
3214: *=========================================================================*/
3215: PROCEDURE adjust_tax_for_xml_inv_line (
3216: ---p_event_class_rec IN zx_api_pub.event_class_rec_type,
3217: x_return_status OUT NOCOPY VARCHAR2) IS
3218:
3219: CURSOR get_total_line_tax_amt_csr IS
3220: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

Line 3357: --p_event_class_rec IN zx_api_pub.event_class_rec_type,

3353: | This procedure contains the code for adjusting tax lines for XML |
3354: | invoices with header level control tax amount. |
3355: *=========================================================================*/
3356: PROCEDURE adjust_tax_for_xml_inv_hdr (
3357: --p_event_class_rec IN zx_api_pub.event_class_rec_type,
3358: x_return_status OUT NOCOPY VARCHAR2) IS
3359:
3360: CURSOR get_total_trx_tax_amt_csr IS
3361: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

Line 3477: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,

3473: | tax line with last_manual_entry = 'TAX_AMOUNT'. |
3474: | |
3475: * ======================================================================*/
3476: PROCEDURE match_tax_amt_to_summary_line (
3477: p_event_class_rec IN OUT NOCOPY zx_api_pub.event_class_rec_type,
3478: x_return_status OUT NOCOPY VARCHAR2) IS
3479:
3480: CURSOR get_sum_tax_lines_for_adj_csr IS
3481: SELECT tax_amt, summary_tax_line_id

Line 3693: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

3689: | PROCEDURE init_for_header is used to initialize the Global |
3690: | Structures / Global Temp Tables owned by TDM at header level. |
3691: * ======================================================================*/
3692: PROCEDURE init_for_header (
3693: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3694: x_return_status OUT NOCOPY VARCHAR2 ) IS
3695:
3696: BEGIN
3697: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3799: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

3795: | PROCEDURE init_for_line is used to initialize the Global |
3796: | Structures / Global Temp Tables owned by TDM at line level. |
3797: * ======================================================================*/
3798: PROCEDURE init_for_line (
3799: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3800: x_return_status OUT NOCOPY VARCHAR2 ) IS
3801:
3802: BEGIN
3803: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3865: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

3861: | PROCEDURE init_for_tax_line is used to initialize the Global |
3862: | Structures / Global Temp Tables owned by TDM at tax line level. |
3863: * ======================================================================*/
3864: PROCEDURE init_for_tax_line (
3865: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3866: x_return_status OUT NOCOPY VARCHAR2 ) IS
3867:
3868: BEGIN
3869: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3909: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

3905: | PROCEDURE init_for_tax_dist is used to initialize the Global |
3906: | Structures/Global Temp Tables owned by TDM at tax distribution level.|
3907: * ======================================================================*/
3908: PROCEDURE init_for_tax_dist (
3909: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3910: x_return_status OUT NOCOPY VARCHAR2 ) IS
3911:
3912: BEGIN
3913: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 3955: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,

3951: | PROCEDURE initialize is used to initialize the Global |
3952: | Structures / Global Temp Tables owned by TDM |
3953: * ======================================================================*/
3954: PROCEDURE initialize (
3955: p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
3956: p_init_level IN VARCHAR2,
3957: x_return_status OUT NOCOPY VARCHAR2 ) IS
3958:
3959: BEGIN