PACKAGE: APPS.JAI_AR_EER1_PKG

Source

1 PACKAGE jai_ar_eer1_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_ar_eer1_pkg.pls 120.2.12010000.2 2008/11/19 11:49:40 mbremkum ship $ */
3 
4   v_filehandle      UTL_FILE.FILE_TYPE;
5   v_utl_file_dir    VARCHAR2(512);
6   v_utl_file_name   VARCHAR2(50);
7 
8   -- Padding Variables
9   v_pad_char        VARCHAR2(1) := ' ';
10   v_pad_date        VARCHAR2(1) := ' ';
11   v_pad_number      VARCHAR2(1) := '0';
12   v_quart_pad       VARCHAR2(1) := ' ';
13   v_q_noval_filler  VARCHAR2(1) := '-';
14   v_q_null_filler   VARCHAR2(1) := '*';
15   v_underline_char  VARCHAR2(1) := '-';
16   v_delimeter       VARCHAR2(1) := ',' ;
17   v_append          VARCHAR2(1) := '"' ;
18 
19   -- Length Variables
20   sq_len_2          number := 2;
21   sq_len_3          number := 3;
22   sq_len_6          number := 6;
23   sq_len_7          number := 7;
24   sq_len_8          number := 8;
25   sq_len_10         number := 10;
26   sq_len_11         number := 11;
27   sq_len_12         number := 12;
28   sq_len_13         number := 13;
29   sq_len_15         number := 15;
30   sq_len_20         number := 20;
31   sq_len_40         number := 40;
32   sq_len_50         number :=50;
33   sq_len_255        number := 255;
34 
35   p_str             varchar2(2000);
36   p_action          varchar2(2);
37 
38   lv_last_flag      varchar2(1) := 'Y';
39 
40 
41 
42   -- The Procedure which will be called first
43 
44   PROCEDURE generate_flat_file
45   (
46     p_err_buf OUT NOCOPY VARCHAR2,
47     p_ret_code OUT NOCOPY NUMBER,
48     p_organization_id     IN  NUMBER,
49     p_location_id         IN  NUMBER,
50     pv_start_date          IN  VARCHAR2,
51     pv_end_date            IN  VARCHAR2,
52     p_registration_number IN  VARCHAR2,
53     p_operating_unit      IN  NUMBER,
54     p_auth_sign           IN VARCHAR2,
55     p_place               IN VARCHAR2,
56     p_file_path           IN VARCHAR2,
57     p_filename            IN VARCHAR2,
58     p_action_flg          IN VARCHAR2 DEFAULT 'N'
59   ) ;
60 
61   FUNCTION format_action(f_field_name varchar2, f_len_field number, f_action varchar2, f_last_flag varchar2 DEFAULT 'N')
62   RETURN varchar2;
63 
64   PROCEDURE openFile(
65     p_directory IN VARCHAR2,
66     p_filename  IN VARCHAR2 );
67 
68   PROCEDURE closeFile;
69 
70   PROCEDURE create_ceth_header;
71 
72   PROCEDURE create_duty_header;
73 
74   PROCEDURE create_input_header;
75 
76   PROCEDURE create_cenvat_header;
77 
78   PROCEDURE create_payment_header;
79 
80   PROCEDURE create_sam_header;
81 
82 
83   PROCEDURE populate_duty_paid_details (  p_end_date    IN  DATE,
84     p_location_id   IN  NUMBER,
85     p_organization_id IN  NUMBER,
86     p_start_date    IN  DATE );
87 
88   PROCEDURE populate_ceth_wise_details( p_organization_id IN  NUMBER,
89     p_location_id   IN  NUMBER,
90     p_start_date    IN  DATE,
91     p_end_date    IN  DATE
92   );
93 
94   PROCEDURE populate_cenvat_credit_details (  p_end_date    IN  DATE,
95   p_location_id   IN  NUMBER,
96   p_operating_unit  IN  NUMBER,
97   p_organization_id IN  NUMBER,
98   p_registration_number IN  VARCHAR2,
99   p_start_date    IN  DATE );
100 
101   PROCEDURE populate_input_details
102   (   p_end_date        IN  DATE,
103       p_location_id     IN  NUMBER,
104       p_organization_id IN  NUMBER,
105       p_start_date      IN  DATE
106   ) ;
107 
108   PROCEDURE populate_payment_details
109   (p_start_date   in DATE
110   ) ;
111 
112   PROCEDURE populate_sam_details
113    (
114       p_organization_id IN NUMBER,
115       p_location_id     IN NUMBER,
116       p_start_date      IN DATE,
117       p_end_date        IN DATE,
118       p_auth_sign       IN VARCHAR2,
119       p_place           IN VARCHAR2
120    ) ;
121 
122 END jai_ar_eer1_pkg;