1 package jai_ap_tds_processing_pkg as
2 /* $Header: jai_ap_tds_prc.pls 120.4.12020000.2 2013/05/16 10:43:10 anupgupt ship $ */
3 /* ----------------------------------------------------------------------------
4 FILENAME : jai_ap_tds_prc.pls
5
6 Created By : Aparajita
7
8 Created Date : 21-jul-2005
9
10 Bug :
11
12 Purpose : Revamp of TDS certificate and eTDS reporting.
13
14 Called from : Concurrents,
15 JAIATDSP - India - Process TDS Payments
16 JAIATDSC - India - Generate TDS Certificates
17
18 CHANGE HISTORY:
19 -------------------------------------------------------------------------------
20 S.No Date Author and Details
21 -------------------------------------------------------------------------------
22 1. 21/7/2005 Created by Aparajita for bug#4448293. Version#115.0.
23
24 Cleanup of TDS certificate and eTDS reporting.
25 2. 29/03/2007 bduvarag for bug#5647725,File version 120.1
26 Forward porting the changes done in 11i bug#5647215
27
28 3. 12-06-2007 sacsethi for bug 6119195 file version 120.6
29
30 R12RUP03-ST1: INDIA - PROCESS TDS PAYMENTS GIVES ERROR MESSAGE WHILE SUBMITTING
31
32 Probelem - After execution of Concurrent India TDS Payments , some concurrent execution
33 error was coming - FDPSTP failed due to ORA-01861: literal does not match format string
34
35 Solution - This problem was due to procedure process_tds_payments , Argument pd_tds_payment_from_date ,
36 pd_tds_payment_to_date parameter was of date type , whcih we made it as varchar2 and
37 create two variable with name ld_tds_payment_to_date ,ld_tds_payment_from_date
38
39 4. 05-Jan-2011 Bug 10621438
40 Description: TDS Certificates are generated based on TDS Invoice Date Range
41 Fix: TDS Certificates are generated on Quarterly basis. Start and End Date
42 are replaced by Financial Year and Quarter parameter
43
44 ---------------------------------------------------------------------------- */
45
46
47 procedure process_tds_payments
48 (
49 errbuf out nocopy varchar2,
50 retcode out nocopy varchar2,
51 pd_tds_payment_from_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
52 pd_tds_payment_to_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
53 pv_org_tan_num in varchar2,
54 p_section_type in varchar2,/*bduvarag for Bug#5647725*/
55 pv_tds_section in varchar2 default null,
56 pn_tds_authority_id in number default null,
57 pn_tds_authority_site_id in number default null,
58 pn_vendor_id in number default null,
59 pn_vendor_site_id in number default null,
60 pv_regenerate_flag in varchar2 default 'N'
61 );
62
63 procedure process_tds_certificates
64 (
65 errbuf out nocopy varchar2,
66 retcode out nocopy varchar2,
67 --pd_tds_payment_from_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
68 --pd_tds_payment_to_date in varchar2,
69 pv_org_tan_num in varchar2,
70 pn_fin_year in number,
71 pv_quarter in varchar2,
72 p_section_type in varchar2,/*bduvarag for Bug#5647725*/
73 pv_tds_section in varchar2 default null,
74 pn_tds_authority_id in number default null,
75 pn_tds_authority_site_id in number default null,
76 pn_vendor_id in number default null,
77 pn_vendor_site_id in number default null
78 );
79
80 end jai_ap_tds_processing_pkg;