[Home] [Help]
PACKAGE: APPS.JAI_ETCS_PKG
Source
1 PACKAGE jai_etcs_pkg AS
2 /* $Header: jai_ar_etcs_prc.pls 120.2.12000000.1 2007/07/24 06:55:33 rallamse noship $ */
3
4 /***************************************************************************************************
5 CREATED BY : CSahoo
6 CREATED DATE : 01-FEB-2007
7 ENHANCEMENT BUG : 5631784
8 PURPOSE : NEW ENH: TAX COLLECTION AT SOURCE IN RECEIVABLES
9
10
11 -- #
12 -- # Change History -
13
14
15 1. 01/02/2007 CSahoo for bug#5631784. File Version 120.0
16 Forward Porting of 11i BUG#4742259 (TAX COLLECTION AT SOURCE IN RECEIVABLES)
17
18 2. 26.06.2007 sacsethi for bug 6153881 file version 120.2
19
20 Problem - R12RUP03-ST1:UNABLE TO RUN TCS RETURN REPORTS
21
22 Solution - According to R12 Standard we should not use legal entity in out code , so
23 removing legal_entity_id from code ...
24
25 *******************************************************************************************************/
26
27 -- debug variables
28 v_pad_date VARCHAR2(1) := ' ';
29 v_pad_char VARCHAR2(1) := ' ';
30 v_pad_number VARCHAR2(1) := '0';
31
32 -- File Header Size Variables
33 s_line_number NUMBER(2) := 9;
34 s_record_type NUMBER(2) := 2;
35 s_file_type NUMBER(2) := 3;
36 s_upload_type NUMBER(2) := 1;
37 s_file_sequence_number NUMBER(2) := 9;
38 s_deductor_tan NUMBER(2) := 10;
39 s_number_of_batches NUMBER(2) := 9;
40 v_underline_char VARCHAR2(1) := '-';
41
42 -- Challan Detail
43 s_batch_number NUMBER(2) := 9;
44 s_challan_slno NUMBER(2) := 9;
45 s_challan_section NUMBER(2) := 5;
46 s_amount_deducted NUMBER(2) := 14;
47 s_amount_sur NUMBER(2) := 14;
48 s_amount_cess NUMBER(2) := 14;
49 s_amount_tcs NUMBER(2) := 14;
50 s_chq_dd_num NUMBER(2) := 14;
51 s_challan_num NUMBER(2) := 9;
52 s_bank_branch_code NUMBER(2) := 7;
53 s_tds_dep_book_ent NUMBER(2) := 1;
54 s_filler4 NUMBER(2) := 1;
55
56 -- Deductee Detail
57 s_deductee_slno NUMBER(2) := 9;
58 s_deductee_section NUMBER(2) := 5;
59 s_deductee_code NUMBER(2) := 2;
60 s_deductee_pan NUMBER(2) := 10;
61 s_deductee_name NUMBER(2) := 75;
62 s_deductee_address1 NUMBER(2) := 25;
63 s_deductee_address2 NUMBER(2) := 25;
64 s_deductee_address3 NUMBER(2) := 25;
65 s_deductee_address4 NUMBER(2) := 25;
66 s_deductee_address5 NUMBER(2) := 25;
67 s_deductee_state NUMBER(2) := 2;
68 s_deductee_pin NUMBER(2) := 6;
69 s_payment_amount NUMBER(2) := 14;
70 s_tax_rate NUMBER(2) := 4;
71 s_grossing_up_factor NUMBER(2) := 1;
72 s_tax_deducted NUMBER(2) := 14;
73 s_challan_no NUMBER(2) := 9;
74 s_reason_for_nDeduction NUMBER(2) := 1;
75 s_filler NUMBER(2) := 14;
76 s_filler6 NUMBER(2) := 1;
77 s_book_ent_oth NUMBER(2) := 1;
78 s_date NUMBER(1) := 8;
79
80
81 ---ADDED BY VASAVI---
82 G_DATE_DUMMY CONSTANT VARCHAR2(1) := '-';
83 v_delimeter VARCHAR2(1) := '^' ;
84 v_quart_len NUMBER := 15 ;
85
86 sq_len_1 NUMBER := 1 ;
87 sq_len_2 NUMBER :=2 ;
88 sq_len_3 NUMBER :=3 ;
89 sq_len_4 NUMBER :=4 ;
90 sq_len_5 NUMBER :=5 ;
91 sq_len_6 NUMBER :=6 ;
92 sq_len_7 NUMBER :=7 ;
93 sq_len_8 NUMBER :=8 ;
94 sq_len_9 NUMBER :=9 ;
95 sq_len_10 NUMBER :=10 ;
96 sq_len_14 NUMBER :=14 ;
97 sq_len_15 NUMBER :=15 ;
98 sq_len_20 NUMBER :=20 ;
99 sq_len_25 NUMBER :=25 ;
100 sq_len_75 NUMBER :=75 ;
101
102 v_quart_pad VARCHAR2(1) := ' ';
103 v_q_noval_filler VARCHAR2(1) := '-';
104 v_q_null_filler VARCHAR2(1) := '*';
105 v_quart_numfill NUMBER := 0 ;
106 v_format_amount VARCHAR2(17) := 'FM999999999990D00' ;
107 v_format_rate VARCHAR2(9) := 'FM90D0000';
108 ln_batch_id NUMBER ;
109 lv_action VARCHAR2(1) ;
110
111
112 PROCEDURE openFile(
113 p_directory IN VARCHAR2,
114 p_filename IN VARCHAR2
115 ) ;
116
117 PROCEDURE closeFile ;
118
119 PROCEDURE create_fh(p_batch_id IN NUMBER) ;
120
121 PROCEDURE create_quarterly_fh
122 (p_batch_id IN NUMBER,
123 p_period IN VARCHAR2,
124 p_RespPersAddress IN VARCHAR2,
125 p_RespPersState IN VARCHAR2,
126 p_RespPersPin IN NUMBER,
127 p_RespPersAddrChange IN VARCHAR2
128 );
129
130
131 PROCEDURE generate_etcs_returns(
132 p_err_buf OUT NOCOPY VARCHAR2,
133 p_ret_code OUT NOCOPY NUMBER,
134 p_tan_number IN VARCHAR2,
135 p_organization_id IN NUMBER,
136 p_fin_year IN NUMBER,
137 p_tax_authority_id IN NUMBER,
138 p_tax_authority_site_id IN NUMBER,
139 p_seller_name IN VARCHAR2,
140 p_seller_state IN VARCHAR2,
141 p_addrChangedSinceLastRet IN VARCHAR2,
142 p_persRespForCollection IN VARCHAR2,
143 p_desgOfPersResponsible IN VARCHAR2,
144 p_Start_Date IN DATE,
145 p_End_Date IN DATE,
146 p_pro_rcpt_num_org_ret IN NUMBER,
147 p_file_path IN VARCHAR2,
148 p_filename IN VARCHAR2,
149 p_collection_code IN VARCHAR2,
150 p_generate_headers IN VARCHAR2 DEFAULT NULL,
151 p_period IN VARCHAR2 DEFAULT NULL,
152 p_RespPersAddress IN VARCHAR2 DEFAULT NULL,
153 p_RespPersState IN VARCHAR2 DEFAULT NULL,
154 p_RespPersPin IN NUMBER DEFAULT NULL,
155 p_RespPersAddrChange IN VARCHAR2 DEFAULT NULL,
156 p_action IN VARCHAR2 DEFAULT NULL,
157 p_collector_status IN VARCHAR2 DEFAULT NULL
158 ) ;
159
160 PROCEDURE yearly_returns
161 (
162 p_err_buf OUT NOCOPY VARCHAR2,
163 p_ret_code OUT NOCOPY NUMBER,
164 p_tan_number IN VARCHAR2,
165 p_organization_id IN NUMBER,
166 p_fin_year IN NUMBER,
167 p_collection_code IN VARCHAR2,
168 p_tax_authority_id IN NUMBER,
169 p_tax_authority_site_id IN NUMBER,
170 p_seller_name IN VARCHAR2,
171 p_seller_state IN VARCHAR2,
172 p_addrChangedSinceLastRet IN VARCHAR2,
173 p_persRespForCollection IN VARCHAR2,
174 p_desgOfPersResponsible IN VARCHAR2,
175 p_start_date IN VARCHAR2,
176 p_end_date IN VARCHAR2,
177 p_pro_rcpt_num_org_ret IN NUMBER,
178 p_file_path IN VARCHAR2,
179 p_filename IN VARCHAR2,
180 p_generate_headers IN VARCHAR2 DEFAULT 'N'
181 ) ;
182
183 PROCEDURE quarterly_returns
184 (
185 p_err_buf OUT NOCOPY VARCHAR2,
186 p_ret_code OUT NOCOPY NUMBER,
187 p_tan_number IN VARCHAR2,
188 p_organization_id IN NUMBER,
189 p_fin_year IN NUMBER,
190 p_period IN VARCHAR2 ,
191 p_collection_code IN VARCHAR2,
192 p_tax_authority_id IN NUMBER,
193 p_tax_authority_site_id IN NUMBER,
194 p_seller_name IN VARCHAR2,
195 p_seller_state IN VARCHAR2,
196 p_addrChangedSinceLastRet IN VARCHAR2,
197 p_collector_status IN VARCHAR2,
198 p_persRespForCollection IN VARCHAR2,
199 p_desgOfPersResponsible IN VARCHAR2,
200 p_RespPersAddress IN VARCHAR2 ,
201 p_RespPersState IN VARCHAR2 ,
202 p_RespPersPin IN VARCHAR2 ,
203 p_RespPersAddrChange IN VARCHAR2,
204 p_start_date IN VARCHAR2,
205 p_end_date IN VARCHAR2,
206 p_pro_rcpt_num_org_ret IN NUMBER,
207 p_file_path IN VARCHAR2,
208 p_filename IN VARCHAR2,
209 p_action IN VARCHAR2
210 ) ;
211 END jai_etcs_pkg;