[Home] [Help]
PACKAGE: APPS.ZX_TRD_INTERNAL_SERVICES_PVT
Source
1 PACKAGE ZX_TRD_INTERNAL_SERVICES_PVT AUTHID CURRENT_USER AS
2 /* $Header: zxmirecdmsrvpvts.pls 120.11 2008/04/04 20:19:44 sachandr ship $ */
3
4 -- Tax Recovery Cache
5 --
6 TYPE zx_tax_recovery_info_cache_rec IS RECORD(
7 tax_regime_code zx_taxes_b.tax_regime_code%TYPE,
8 tax zx_taxes_b.tax%TYPE,
9 tax_id zx_taxes_b.tax_id%TYPE,
10 allow_recoverability_flag zx_taxes_b.allow_recoverability_flag%TYPE,
11 primary_recovery_type_code zx_taxes_b.primary_recovery_type_code%TYPE,
12 primary_rec_type_rule_flag zx_taxes_b.primary_rec_type_rule_flag%TYPE,
13 secondary_recovery_type_code zx_taxes_b.secondary_recovery_type_code%TYPE,
14 secondary_rec_type_rule_flag zx_taxes_b.secondary_rec_type_rule_flag%TYPE,
15 primary_rec_rate_det_rule_flag zx_taxes_b.primary_rec_rate_det_rule_flag%TYPE,
16 sec_rec_rate_det_rule_flag zx_taxes_b.sec_rec_rate_det_rule_flag%TYPE,
17 def_primary_rec_rate_code zx_taxes_b.def_primary_rec_rate_code%TYPE,
18 def_secondary_rec_rate_code zx_taxes_b.def_secondary_rec_rate_code%TYPE,
19 effective_from zx_taxes_b.effective_from%TYPE,
20 effective_to zx_taxes_b.effective_to%TYPE,
21 def_rec_settlement_option_code zx_taxes_b.def_rec_settlement_option_code%TYPE,
22 tax_account_source_tax zx_taxes_b.tax_account_source_tax%TYPE);
23
24 TYPE zx_tax_recovery_info_cache IS TABLE OF zx_tax_recovery_info_cache_rec
25 INDEX by BINARY_INTEGER;
26
27 g_tax_recovery_info_tbl zx_tax_recovery_info_cache;
28
29 PROCEDURE CALC_TAX_DIST(
30 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
31 p_tax_line_index IN NUMBER,
32 p_trx_line_dist_index IN NUMBER,
33 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
34 p_rnd_begin_index IN NUMBER,
35 p_rnd_end_index IN OUT NOCOPY NUMBER,
36 p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_error_buffer OUT NOCOPY VARCHAR2);
39 /*
40 Procedure Reverse_Tax_Dist(
41 p_rec_nrec_dist_tbl OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
42 p_rnd_begin_index IN NUMBER,
43 p_rnd_end_index IN OUT NOCOPY NUMBER,
44 p_return_status OUT NOCOPY VARCHAR2,
45 p_error_buffer OUT NOCOPY VARCHAR2);
46 */
47 PROCEDURE cancel_tax_line(
48 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
49 p_tax_line_index IN NUMBER,
50 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
51 p_rnd_begin_index IN NUMBER,
52 p_rnd_end_index IN OUT NOCOPY NUMBER,
53 p_event_class_rec IN ZX_API_PUB.event_class_rec_type,
54 p_return_status OUT NOCOPY VARCHAR2,
55 p_error_buffer OUT NOCOPY VARCHAR2);
56
57 PROCEDURE calc_variance_factors(
58 p_return_status OUT NOCOPY VARCHAR2,
59 p_error_buffer OUT NOCOPY VARCHAR2);
60
61 PROCEDURE DET_APPL_REC_TYPE(
62 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
63 p_tax_line_index IN NUMBER,
64 p_trx_line_dist_index IN NUMBER,
65 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
66 p_rnd_begin_index IN NUMBER,
67 p_rnd_end_index OUT NOCOPY NUMBER,
68 p_return_status OUT NOCOPY VARCHAR2,
69 p_error_buffer OUT NOCOPY VARCHAR2);
70
71 PROCEDURE GET_TAX_RELATED_COLUMNS_STA(
72 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
73 p_tax_line_index IN NUMBER,
74 p_trx_line_dist_index IN NUMBER,
75 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
76 p_rnd_begin_index IN NUMBER,
77 p_rnd_end_index IN NUMBER,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_error_buffer OUT NOCOPY VARCHAR2);
80
81 PROCEDURE GET_TAX_RELATED_COLUMNS_VAR(
82 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
83 p_tax_line_index IN NUMBER,
84 p_trx_line_dist_index IN NUMBER,
85 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
86 p_rnd_begin_index IN NUMBER,
87 p_rnd_end_index IN NUMBER,
88 p_return_status OUT NOCOPY VARCHAR2,
89 p_error_buffer OUT NOCOPY VARCHAR2);
90
91 PROCEDURE GET_REC_RATE(
92 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
93 p_tax_line_index IN NUMBER,
94 p_trx_line_dist_index IN NUMBER,
95 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
96 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
97 p_rnd_begin_index IN NUMBER,
98 p_rnd_end_index IN OUT NOCOPY NUMBER,
99 p_return_status OUT NOCOPY VARCHAR2,
100 p_error_buffer OUT NOCOPY VARCHAR2);
101
102 PROCEDURE get_rec_nrec_dist_amt(
103 p_detail_tax_line_tbl IN ZX_TRD_SERVICES_PUB_PKG.TAX_LINE_TBL_TYPE,
104 p_tax_line_index IN NUMBER,
105 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
106 p_rnd_begin_index IN NUMBER,
107 p_rnd_end_index IN NUMBER,
108 p_return_status OUT NOCOPY VARCHAR2,
109 p_error_buffer OUT NOCOPY VARCHAR2);
110
111 PROCEDURE round_rec_nrec_amt(
112 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.REC_NREC_DIST_TBL_TYPE,
113 p_rnd_begin_index IN NUMBER,
114 p_rnd_end_index IN NUMBER,
115 p_tax_line_amt IN NUMBER,
116 p_tax_line_amt_tax_curr IN NUMBER,
117 p_tax_line_amt_funcl_curr IN NUMBER,
118 p_return_status OUT NOCOPY VARCHAR2,
119 p_error_buffer OUT NOCOPY VARCHAR2);
120
121 PROCEDURE create_mrc_tax_dists (
122 p_event_class_rec IN zx_api_pub.event_class_rec_type,
123 p_rec_nrec_dist_tbl IN OUT NOCOPY ZX_TRD_SERVICES_PUB_PKG.rec_nrec_dist_tbl_type,
124 p_rnd_begin_index IN NUMBER,
125 p_rnd_end_index IN OUT NOCOPY NUMBER,
126 p_return_status OUT NOCOPY VARCHAR2,
127 p_error_buffer OUT NOCOPY VARCHAR2);
128
129 END ZX_TRD_INTERNAL_SERVICES_PVT;
130