[Home] [Help]
PACKAGE: APPS.ZX_TRD_SERVICES_PUB_PKG
Source
1 PACKAGE ZX_TRD_SERVICES_PUB_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxmwrecdmsrvpubs.pls 120.27 2011/02/22 09:46:21 smuthusa ship $ */
3
4 TYPE rec_nrec_dist_tbl_type IS TABLE of ZX_REC_NREC_DIST%ROWTYPE
5 INDEX BY BINARY_INTEGER;
6
7 TYPE tax_line_tbl_type IS TABLE OF zx_lines%ROWTYPE
8 INDEX BY BINARY_INTEGER;
9
10 TYPE tax_hold_status IS RECORD(
11 no_hold VARCHAR2(1),
12 tax_variance VARCHAR2(1),
13 tax_amount_range VARCHAR2(1),
14 natural_account_tax VARCHAR2(1));
15
16 TYPE tax_variance_info_rec_type IS RECORD(
17 trx_line_dist_qty NUMBER,
18 price_diff NUMBER,
19 ref_doc_trx_line_dist_qty NUMBER,
20 ref_doc_curr_conv_rate NUMBER,
21 applied_to_doc_curr_conv_rate NUMBER);
22
23 TYPE tax_variance_info_tbl_type IS TABLE OF
24 tax_variance_info_rec_type INDEX BY BINARY_INTEGER;
25
26 g_tax_dist_id NUMBER;
27 g_tax_variance_info_tbl tax_variance_info_tbl_type;
28 g_variance_calc_flag VARCHAR2(1);
29 -- Bug 11675911 / Bug 10621602
30 g_retained_value NUMBER;
31 g_ret_doc_type VARCHAR2(1);
32
33 PROCEDURE determine_recovery(
34 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37 PROCEDURE override_recovery(
38 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
39 x_return_status OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE reverse_tax_dist(
43 p_rec_nrec_dist_tbl OUT NOCOPY REC_NREC_DIST_TBL_TYPE,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE validate_document_for_tax(
47 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
48 p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
49 x_hold_status OUT NOCOPY zx_api_pub.hold_codes_tbl_type,
50 x_validate_status OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE reverse_distributions(
54 x_return_status OUT NOCOPY VARCHAR2);
55
56 PROCEDURE update_exchange_rate (
57 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
58 p_ledger_id IN NUMBER,
59 p_currency_conversion_rate IN NUMBER,
60 p_currency_conversion_type IN VARCHAR2,
61 p_currency_conversion_date IN DATE,
62 x_return_status OUT NOCOPY VARCHAR2 );
63
64 PROCEDURE GET_CCID(
65 p_gl_date IN DATE,
66 p_tax_rate_id IN NUMBER,
67 p_rec_rate_id IN NUMBER,
68 p_Self_Assessed_Flag IN VARCHAR2,
69 p_Recoverable_Flag IN VARCHAR2,
70 p_tax_jurisdiction_id IN NUMBER,
71 p_tax_regime_id IN NUMBER,
72 p_tax_id IN NUMBER,
73 p_tax_status_id IN NUMBER,
74 p_org_id IN NUMBER,
75 p_revenue_expense_ccid IN NUMBER,
76 p_ledger_id IN NUMBER,
77 p_account_source_tax_rate_id IN NUMBER,
78 p_rec_nrec_tax_dist_id IN NUMBER,
79 p_rec_nrec_ccid OUT NOCOPY NUMBER,
80 p_tax_liab_ccid OUT NOCOPY NUMBER,
81 x_return_status OUT NOCOPY VARCHAR2);
82
83 PROCEDURE GET_OUTPUT_TAX_CCID(
84 p_gl_date IN DATE,
85 p_tax_rate_id IN NUMBER,
86 p_location_segment_id IN NUMBER,
87 p_tax_line_id IN NUMBER,
88 p_org_id IN NUMBER,
89 p_ledger_id IN NUMBER,
90 p_event_class_code IN VARCHAR2,
91 p_entity_code IN VARCHAR2,
92 p_application_id IN NUMBER,
93 p_document_id IN NUMBER,
94 p_document_line_id IN NUMBER,
95 p_trx_level_type IN VARCHAR2,
96 p_tax_account_ccid OUT NOCOPY NUMBER,
97 p_interim_tax_ccid OUT NOCOPY NUMBER,
98 p_adj_ccid OUT NOCOPY NUMBER,
99 p_edisc_ccid OUT NOCOPY NUMBER,
100 p_unedisc_ccid OUT NOCOPY NUMBER,
101 p_finchrg_ccid OUT NOCOPY NUMBER,
102 p_adj_non_rec_tax_ccid OUT NOCOPY NUMBER,
103 p_edisc_non_rec_tax_ccid OUT NOCOPY NUMBER,
104 p_unedisc_non_rec_tax_ccid OUT NOCOPY NUMBER,
105 p_finchrg_non_rec_tax_ccid OUT NOCOPY NUMBER,
106 x_return_status OUT NOCOPY VARCHAR2);
107
108 FUNCTION GET_RECOVERABLE_CCID(
109 p_rec_nrec_dist_id IN NUMBER,
110 p_tax_line_id IN NUMBER,
111 p_gl_date IN DATE,
112 p_tax_rate_id IN NUMBER,
113 p_rec_rate_id IN NUMBER,
114 p_ledger_id IN NUMBER,
115 p_source_rate_id IN NUMBER,
116 p_content_owner_id IN NUMBER) RETURN NUMBER;
117
118
119
120 FUNCTION round_amt_to_mau (
121 p_ledger_id NUMBER,
122 p_unrounded_amt NUMBER ) RETURN NUMBER;
123
124 FUNCTION get_tax_hold_rls_val_frm_code (
125 p_tax_hold_released_code IN VARCHAR2
126 ) RETURN NUMBER;
127
128 FUNCTION get_prod_total_tax_amt(
129 p_prepay_tax_amt NUMBER,
130 p_line_amt NUMBER,
131 p_prepay_line_amt NUMBER ) RETURN NUMBER;
132
133 PROCEDURE is_recoverability_affected(
134 p_pa_item_info_tbl IN OUT NOCOPY ZX_API_PUB.pa_item_info_tbl_type,
135 x_return_status OUT NOCOPY VARCHAR2);
136
137 PROCEDURE update_posting_flag(
138 p_tax_dist_id_tbl IN ZX_API_PUB.TAX_DIST_ID_TBL_TYPE,
139 x_return_status OUT NOCOPY VARCHAR2);
140
141 END ZX_TRD_SERVICES_PUB_PKG;
142