[Home] [Help]
PACKAGE: APPS.ZX_TRD_SERVICES_PUB_PKG
Source
1 PACKAGE ZX_TRD_SERVICES_PUB_PKG AS
2 /* $Header: zxmwrecdmsrvpubs.pls 120.26 2006/10/13 19:11:11 hsi 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
30 PROCEDURE determine_recovery(
31 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
32 x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE override_recovery(
35 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
36 x_return_status OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE reverse_tax_dist(
40 p_rec_nrec_dist_tbl OUT NOCOPY REC_NREC_DIST_TBL_TYPE,
41 x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE validate_document_for_tax(
44 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
45 p_transaction_rec IN ZX_API_PUB.transaction_rec_type,
46 x_hold_status OUT NOCOPY zx_api_pub.hold_codes_tbl_type,
47 x_validate_status OUT NOCOPY VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2);
49
50 PROCEDURE reverse_distributions(
51 x_return_status OUT NOCOPY VARCHAR2);
52
53 PROCEDURE update_exchange_rate (
54 p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
55 p_ledger_id IN NUMBER,
56 p_currency_conversion_rate IN NUMBER,
57 p_currency_conversion_type IN VARCHAR2,
58 p_currency_conversion_date IN DATE,
59 x_return_status OUT NOCOPY VARCHAR2 );
60
61 PROCEDURE GET_CCID(
62 p_gl_date IN DATE,
63 p_tax_rate_id IN NUMBER,
64 p_rec_rate_id IN NUMBER,
65 p_Self_Assessed_Flag IN VARCHAR2,
66 p_Recoverable_Flag IN VARCHAR2,
67 p_tax_jurisdiction_id IN NUMBER,
68 p_tax_regime_id IN NUMBER,
69 p_tax_id IN NUMBER,
70 p_tax_status_id IN NUMBER,
71 p_org_id IN NUMBER,
72 p_revenue_expense_ccid IN NUMBER,
73 p_ledger_id IN NUMBER,
74 p_account_source_tax_rate_id IN NUMBER,
75 p_rec_nrec_tax_dist_id IN NUMBER,
76 p_rec_nrec_ccid OUT NOCOPY NUMBER,
77 p_tax_liab_ccid OUT NOCOPY NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2);
79
80 PROCEDURE GET_OUTPUT_TAX_CCID(
81 p_gl_date IN DATE,
82 p_tax_rate_id IN NUMBER,
83 p_location_segment_id IN NUMBER,
84 p_tax_line_id IN NUMBER,
85 p_org_id IN NUMBER,
86 p_ledger_id IN NUMBER,
87 p_event_class_code IN VARCHAR2,
88 p_entity_code IN VARCHAR2,
89 p_application_id IN NUMBER,
90 p_document_id IN NUMBER,
91 p_document_line_id IN NUMBER,
92 p_trx_level_type IN VARCHAR2,
93 p_tax_account_ccid OUT NOCOPY NUMBER,
94 p_interim_tax_ccid OUT NOCOPY NUMBER,
95 p_adj_ccid OUT NOCOPY NUMBER,
96 p_edisc_ccid OUT NOCOPY NUMBER,
97 p_unedisc_ccid OUT NOCOPY NUMBER,
98 p_finchrg_ccid OUT NOCOPY NUMBER,
99 p_adj_non_rec_tax_ccid OUT NOCOPY NUMBER,
100 p_edisc_non_rec_tax_ccid OUT NOCOPY NUMBER,
101 p_unedisc_non_rec_tax_ccid OUT NOCOPY NUMBER,
102 p_finchrg_non_rec_tax_ccid OUT NOCOPY NUMBER,
103 x_return_status OUT NOCOPY VARCHAR2);
104
105 FUNCTION GET_RECOVERABLE_CCID(
106 p_rec_nrec_dist_id IN NUMBER,
107 p_tax_line_id IN NUMBER,
108 p_gl_date IN DATE,
109 p_tax_rate_id IN NUMBER,
110 p_rec_rate_id IN NUMBER,
111 p_ledger_id IN NUMBER,
112 p_source_rate_id IN NUMBER,
113 p_content_owner_id IN NUMBER) RETURN NUMBER;
114
115
116
117 FUNCTION round_amt_to_mau (
118 p_ledger_id NUMBER,
119 p_unrounded_amt NUMBER ) RETURN NUMBER;
120
121 FUNCTION get_tax_hold_rls_val_frm_code (
122 p_tax_hold_released_code IN VARCHAR2
123 ) RETURN NUMBER;
124
125 FUNCTION get_prod_total_tax_amt(
126 p_prepay_tax_amt NUMBER,
127 p_line_amt NUMBER,
128 p_prepay_line_amt NUMBER ) RETURN NUMBER;
129
130 PROCEDURE is_recoverability_affected(
131 p_pa_item_info_tbl IN OUT NOCOPY ZX_API_PUB.pa_item_info_tbl_type,
132 x_return_status OUT NOCOPY VARCHAR2);
133
134 PROCEDURE update_posting_flag(
135 p_tax_dist_id_tbl IN ZX_API_PUB.TAX_DIST_ID_TBL_TYPE,
136 x_return_status OUT NOCOPY VARCHAR2);
137
138 END ZX_TRD_SERVICES_PUB_PKG;
139