1 package jai_ap_tds_processing_pkg as
2 /* $Header: jai_ap_tds_prc.pls 120.2.12000000.1 2007/07/24 06:55:18 rallamse 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 ---------------------------------------------------------------------------- */
40
41
42 procedure process_tds_payments
43 (
44 errbuf out nocopy varchar2,
45 retcode out nocopy varchar2,
46 pd_tds_payment_from_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
47 pd_tds_payment_to_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
48 pv_org_tan_num in varchar2,
49 p_section_type in varchar2,/*bduvarag for Bug#5647725*/
50 pv_tds_section in varchar2 default null,
51 pn_tds_authority_id in number default null,
52 pn_tds_authority_site_id in number default null,
53 pn_vendor_id in number default null,
54 pn_vendor_site_id in number default null,
55 pv_regenerate_flag in varchar2 default 'N'
56 );
57
58 procedure process_tds_certificates
59 (
60 errbuf out nocopy varchar2,
61 retcode out nocopy varchar2,
62 pd_tds_payment_from_date in varchar2, --Date 12-jun-2007 sacsethi for bug 6119195
63 pd_tds_payment_to_date in varchar2,
64 pv_org_tan_num in varchar2,
65 p_section_type in varchar2,/*bduvarag for Bug#5647725*/
66 pv_tds_section in varchar2 default null,
67 pn_tds_authority_id in number default null,
68 pn_tds_authority_site_id in number default null,
69 pn_vendor_id in number default null,
70 pn_vendor_site_id in number default null
71 );
72
73 end jai_ap_tds_processing_pkg;