1 package jai_ar_tcs_rep_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_tcs_repo_pkg.pls 120.3 2011/08/18 11:40:10 mbremkum ship $ */
3
4 /***************************************************************************************************
5 -- #
6 -- # Change History -
7
8
9 1. 01/02/2007 CSahoo for bug#5631784. File Version 120.0
10
11 Forward Porting of 11i BUG#4742259 (TAX COLLECTION AT SOURCE IN RECEIVABLES)
12
13 2. ssumaith - bug# 6109941 - the tcs fin year was being retreived incorrectly. This has been corrected in the
14 cursor get_tcs_fin_year
15
16 *******************************************************************************************************/
17
18 PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,
19 p_ractl IN RA_CUSTOMER_TRX_LINES_ALL%ROWTYPE DEFAULT NULL ,
20 p_process_flag OUT NOCOPY VARCHAR2 ,
21 p_process_message OUT NOCOPY VARCHAR2
22 );
23
24 PROCEDURE wsh_interim_accounting ( p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
25 p_delivery_detail_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE ,
26 p_order_header_id IN JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID%TYPE ,
27 p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE ,
28 p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
29 p_currency_code IN VARCHAR2 ,
30 p_process_flag OUT NOCOPY VARCHAR2 ,
31 p_process_message OUT NOCOPY VARCHAR2
32 );
33 PROCEDURE validate_sales_order ( p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE ,
34 p_process_flag OUT NOCOPY VARCHAR2 ,
35 p_process_message OUT NOCOPY VARCHAR2
36 );
37 PROCEDURE validate_invoice ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
38 p_document_type OUT NOCOPY VARCHAR2 ,
39 p_process_flag OUT NOCOPY VARCHAR2 ,
40 p_process_message OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE validate_app_unapp ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
44 p_document_type OUT NOCOPY VARCHAR2 ,
45 p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
46 p_process_flag OUT NOCOPY VARCHAR2 ,
47 p_process_message OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
51 p_document_type IN VARCHAR2 ,
52 p_process_flag OUT NOCOPY VARCHAR2 ,
53 p_process_message OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
57 p_document_type IN VARCHAR2 ,
58 p_process_flag OUT NOCOPY VARCHAR2 ,
59 p_process_message OUT NOCOPY VARCHAR2
60 );
61 PROCEDURE process_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
62 p_document_type IN VARCHAR2 ,
66
63 p_process_flag OUT NOCOPY VARCHAR2 ,
64 p_process_message OUT NOCOPY VARCHAR2
65 );
67 PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
68 p_document_type IN VARCHAR2 ,
69 p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
70 p_process_flag OUT NOCOPY VARCHAR2 ,
71 p_process_message OUT NOCOPY VARCHAR2
72 );
73
74
75 PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
76 p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
77 p_document_type IN VARCHAR2 ,
78 p_process_flag OUT NOCOPY VARCHAR2 ,
79 p_process_message OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
83 p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
84 p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
85 p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
86 p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
87 p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
88 p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
89 p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
90 p_parent_transaction_id IN JAI_RGM_REFS_ALL.parent_transaction_id%TYPE DEFAULT NULL ,
91 p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
92 p_document_id IN NUMBER ,
93 p_document_type IN VARCHAR2 ,
94 p_document_line_id IN NUMBER ,
95 p_document_date IN DATE ,
96 p_table_name IN VARCHAR2 ,
97 p_line_amount IN NUMBER ,
98 p_document_amount IN NUMBER ,
99 p_org_id IN NUMBER ,
100 p_organization_id IN NUMBER ,
101 p_party_id IN NUMBER ,
102 p_party_site_id IN NUMBER ,
103 p_item_classification IN VARCHAR2 ,
104 p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
105 p_process_flag OUT NOCOPY VARCHAR2 ,
106 p_process_message OUT NOCOPY VARCHAR2
107 );
108
109 PROCEDURE insert_repository_taxes ( p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
110 p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
111 p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
112 p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
116 p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
113 p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
114 p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
115 p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
117 p_process_flag OUT NOCOPY VARCHAR2 ,
118 p_process_message OUT NOCOPY VARCHAR2
119 );
120
121 PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
122 p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
123 p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
124 p_apportion_factor IN NUMBER DEFAULT NULL ,
125 p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
126 p_process_flag OUT NOCOPY VARCHAR2 ,
127 p_process_message OUT NOCOPY VARCHAR2
128 );
129
130 PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
131 p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
132 p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
133 p_new_document_date IN DATE ,
134 p_apportion_factor IN NUMBER DEFAULT 1 ,
135 p_process_flag OUT NOCOPY VARCHAR2 ,
136 p_process_message OUT NOCOPY VARCHAR2
137 );
138
139 PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
140 p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
141 p_complete_flag IN RA_CUSTOMER_TRX_ALL.COMPLETE_FLAG%TYPE ,
142 p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
143 p_process_flag OUT NOCOPY VARCHAR2 ,
144 p_process_message OUT NOCOPY VARCHAR2
145 );
146 PROCEDURE generate_document ( p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,
147 p_total_tax_amt IN NUMBER ,
148 p_process_flag OUT NOCOPY VARCHAR2 ,
149 p_process_message OUT NOCOPY VARCHAR2
150 );
151
152 PROCEDURE process_transactions ( p_event IN VARCHAR2 ,
153 p_document_type IN VARCHAR2 DEFAULT NULL ,
154 p_ooh IN OE_ORDER_HEADERS_ALL%ROWTYPE DEFAULT NULL ,
155 p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,
156 p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE DEFAULT NULL ,
157 p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
158 p_process_flag OUT NOCOPY VARCHAR2 ,
159 p_process_message OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
163 p_errbuf OUT NOCOPY VARCHAR2 ,
167
164 p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
165 p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
166 p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
168 );
169
170 /*Bug 12543504 - Procedure to move TCS Taxes from Libility to Interim Liability on RMA receipt*/
171 PROCEDURE receipt_interim_accounting(p_shipment_line_id IN NUMBER,
172 p_shipment_header_id IN NUMBER,
173 p_organization_id IN NUMBER,
174 p_line_location_id IN NUMBER,
175 p_currency_conversion_rate IN NUMBER,
176 p_transaction_type IN VARCHAR2,
177 p_transaction_id IN NUMBER,
178 v_currency_code IN VARCHAR2,
179 p_process_flag OUT NOCOPY VARCHAR2,
180 p_process_message OUT NOCOPY VARCHAR2
181 );
182 /*Bug 12543504 - End*/
183
184 /*
185 | cursor modified by ssumaith for the bug 6109941
186 | the fin_year value was being incorrectly coded.
187 | The basic reason was was the join bwtween the hr_operating_units
188 | and jai_ap_tds_years. Hence retreiving the value from the jai_ap_tds_years
189 | only
190 */
191
192 CURSOR get_tcs_fin_year ( cp_org_id NUMBER ,
193 cp_trx_date DATE
194 )
195 IS
196 SELECT
197 fin_year
198 FROM
199 JAI_AP_TDS_YEARS jtyi
200 WHERE
201 jtyi.legal_entity_id = cp_org_id
202 AND trunc(cp_trx_date) BETWEEN trunc(jtyi.start_date) and trunc(nvl(jtyi.end_date,sysdate)); --Added trunc by JMEENA for bug#9538920
203
204 CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
205 cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
206 cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE
207 )
208 IS
209 SELECT
210 regime_id ,
211 attribute_value org_tan_no
212 FROM
213 JAI_RGM_ORG_REGNS_V rgm_attr_v
214 WHERE
215 rgm_attr_v.regime_code = cp_regime_code
216 AND rgm_attr_v.attribute_code = cp_attribute_code
217 AND rgm_attr_v.organization_id = cp_organization_id;
218
219 END jai_ar_tcs_rep_pkg;
|
|
|