1 PACKAGE jai_cmn_st_forms_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_cmn_st_forms.pls 120.2 2006/07/06 08:04:59 aiyer ship $ */
3
4 /* --------------------------------------------------------------------------------------
5 Filename:
6
7 Change History:
8
9 Slno Date Bug Remarks
10 --------- --------- ---------- -------------------------------------------------------------
11 1. 08-Jun-2005 Version 116.1 jai_cmn_st_forms -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
12 as required for CASE COMPLAINCE.
13 2. 05-Jul-2006 Aiyer for the bug 5369250, Version 120.2
14 Issue:-
15 The concurrent failes with the following error :-
16 "FDPSTP failed due to ORA-01861: literal does not match format string ORA-06512: at line 1 "
17
18 Reason:-
19 The procedure generate_forms has two parameters p_from_date and p_to_date which are of type date , however the concurrent program
20 passes it in the canonical format and hence the failure.
21
22 Fix:-
23 Modified the procedure generate_forms.
24 Changed the datatype of p_from_date and p_to_date from date to varchar2 as this parameter.
25
26 Dependency due to this fix:-
27 None
28
29 */
30
31 gd_from_date CONSTANT DATE DEFAULT SYSDATE ; --rpokkula for File.Sql.35
32 gd_to_date CONSTANT DATE DEFAULT SYSDATE ; --rpokkula for File.Sql.35
33 gv_reprocess CONSTANT DATE DEFAULT SYSDATE ; --rpokkula for File.Sql.35
34
35 PROCEDURE generate_ap_forms
36 (
37 p_err_buf OUT NOCOPY varchar2,
38 P_ret_code OUT NOCOPY varchar2,
39 p_org_id IN number,
40 p_vendor_id IN number,
41 p_vendor_site_id IN number,
42 p_invoice_from_date IN date,
43 p_invoice_to_date IN date,
44 P_reprocess IN varchar2
45 );
46
47 PROCEDURE generate_forms
48 (
49 errbuf OUT NOCOPY varchar2 ,
50 ret_code OUT NOCOPY varchar2 ,
51 p_from_date varchar2, --default SYSDATE , -- Added global variable gd_from_date in package spec. by rpokkula for File.Sql.35
52 p_to_date varchar2, --default SYSDATE , -- Added global variable gd_to_date in package spec. by rpokkula for File.Sql.35
53 p_all_orgs varchar2 ,
54 p_org_id number ,
55 p_party_type varchar2 ,
56 p_party_id number default null ,
57 p_party_site_id number default null ,
58 p_reprocess varchar2, -- default 'N' , -- Added global variable gv_reprocess in package spec. by rpokkula for File.Sql.35
59 P_Enable_Trace varchar2
60 );
61
62
63 PROCEDURE generate_iso_forms(
64 errbuf OUT NOCOPY varchar2 ,
65 ret_code OUT NOCOPY varchar2 ,
66 p_org_id number ,
67 p_party_type varchar2 ,
68 p_party_id number default null ,
69 p_party_site_id number default null ,
70 p_from_date date, -- default SYSDATE , -- Added global variable gd_from_date in package spec. by rpokkula for File.Sql.35
71 p_to_date date -- default SYSDATE -- Added global variable gd_to_date in package spec. by rpokkula for File.Sql.35
72 );
73
74
75 procedure generate_ar_forms(
76 errbuf OUT NOCOPY varchar2 ,
77 ret_code OUT NOCOPY varchar2 ,
78 p_org_id number ,
79 p_party_type varchar2 ,
80 p_party_id number default null ,
81 p_party_site_id number default null ,
82 p_from_date date, -- default SYSDATE , -- Added global variable gd_from_date in package spec. by rpokkula for File.Sql.35
83 p_to_date date -- default SYSDATE -- Added global variable gd_to_date in package spec. by rpokkula for File.Sql.35
84 );
85
86
87
88 END jai_cmn_st_forms_pkg ;