[Home] [Help]
PACKAGE: APPS.ZX_JL_EXTRACT_PKG
Source
1 PACKAGE ZX_JL_EXTRACT_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxriextrajlppvts.pls 120.2 2006/04/28 20:11:47 skorrapa ship $ */
3
4
5 --
6 -----------------------------------------
7 --Public Type Declarations
8 -----------------------------------------
9 --
10
11 --
12 -----------------------------------------
13 --Public Variable Declarations
14 -----------------------------------------
15 --
16
17 -----------------------------------------
18 --Private Methods Declarations
19 -----------------------------------------
20
21 -----------------------------------------
22 --Public Methods Declarations
23 -----------------------------------------
24
25 /*===========================================================================+
26 | PROCEDURE |
27 | FILTER_JL_AP_TAX_LINES |
28 | Type : Public |
29 | Pre-req : None |
30 | Function : |
31 | This procedure filters tax lines on SUB ITF Table. |
32 | And insert tax lines into jl_tax_extr_jl_temp Table if necessary |
33 | |
34 | Called from AR_TAX_EXTRACT.EXECUTE_SQL |
35 | |
36 | Parameters : |
37 | IN : P_MUN_TAX_TYPE_FROM IN VARCHAR2 Optional |
38 | P_MUN_TAX_TYPE_TO IN VARCHAR2 Optional |
39 | P_PROV_TAX_TYPE_FROM IN VARCHAR2 Optional |
40 | P_PROV_TAX_TYPE_TO IN VARCHAR2 Optional |
41 | P_EXC_TAX_TYPE_FROM IN VARCHAR2 Optional |
42 | P_EXC_TAX_TYPE_TO IN VARCHAR2 Optional |
43 | P_NON_TAXAB_TAX_TYPE IN VARCHAR2 Optional |
44 | P_VAT_PERC_TAX_TYPE_FROM IN VARCHAR2 Optional |
45 | P_VAT_PERC_TAX_TYPE_TO IN VARCHAR2 Optional |
46 | P_VAT_TAX_TYPE IN VARCHAR2 Optional |
47 | P_EXCLUDING_TRX_LETTER IN VARCHAR2 Optional |
48 | P_TRANSACTION_LETTER_FROM IN VARCHAR2 Optional |
49 | P_TRANSACTION_LETTER_TO IN VARCHAR2 Optional |
50 | P_REPORT_NAME IN VARCHAR2 Required |
51 | P_REQUEST_ID IN NUMBER Required |
52 | P_EXTRACT_DECLARER_ID IN NUMBER Required |
53 | |
54 | MODIFICATION HISTORY |
55 | 07-Nov-03 Hidetaka Kojima created |
56 | 17-Feb-04 Hidekoji Modified parameters |
57 | |
58 +===========================================================================*/
59
60 PROCEDURE FILTER_JL_AP_TAX_LINES;
61
62
63 /*===========================================================================+
64 | PROCEDURE |
65 | FILTER_JL_AR_TAX_LINES |
66 | Type : Public |
67 | Pre-req : None |
68 | Function : |
69 | This procedure filters tax lines on SUB ITF Table. |
70 | and insert tax lines into ar_tax_extr_jl_temp Table if necessary. |
71 | |
72 | Called from AR_TAX_EXTRACT.EXECUTE_SQL |
73 | |
74 | Parameters : |
75 | IN : P_MUN_TAX_CATEG_REGIME IN VARCHAR2 Optional |
76 | P_PROV_TAX_CATEG_REGIME IN VARCHAR2 Optional |
77 | P_EXC_TAX_CATEGORY IN VARCHAR2 Optional |
78 | P_VAT_ADDIT_TAX_CATEGORY IN VARCHAR2 Optional |
79 | P_VAT_NON_TAXAB_TAX_CATEG IN VARCHAR2 Optional |
80 | P_VAT_NOT_CATEG_TAX_CATEG IN VARCHAR2 Optional |
81 | P_VAT_PERC_TAX_CATEGORY IN VARCHAR2 Optional |
82 | P_VAT_TAX_CATEGORY IN VARCHAR2 Optional |
83 | P_INC_SELF_WD_TAX_CATEG IN VARCHAR2 Optional |
84 | P_REPORT_NAME IN VARCHAR2 Required |
85 | P_REQUEST_ID IN NUMBER Required |
86 | P_EXTRACT_DECLARER_ID IN NUMBER Required |
87 | P_GL_DATE_FROM IN DATE Optional |
88 | P_GL_DATE_TO IN DATE Optional |
89 | P_TRX_LETTER_FROM IN VARCHAR2 Optional |
90 | P_TRX_LETTER_TO IN VARCHAR2 Optional |
91 | |
92 | MODIFICATION HISTORY |
93 | 07-Nov-03 Hidetaka Kojima created |
94 | |
95 | |
96 +===========================================================================*/
97
98
99 PROCEDURE FILTER_JL_AR_TAX_LINES
100 (P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
101 );
102
103 /*==================================================================================+
104 | PROCEDURE |
105 | POPULATE_JL_AP |
106 | Type : Public |
107 | Pre-req : None |
108 | Function : |
109 | This procedure calls the API to select the JL AP specific data from |
110 | JL tables and returns fetched values |
111 | |
112 | Called from AR_TAX_POPULATE.POPULATE_INV |
113 | |
114 | Parameters : |
115 | IN : |
116 | OUT: |
117 | |
118 | MODIFICATION HISTORY |
119 | 27-Oct-03 Asako Takahashi created |
120 | 17-Feb-04 Hidekoji Modified the parameters |
121 | 11-May-04 Hidekoji Modified the parameters |
122 | |
123 +==================================================================================*/
124
125 PROCEDURE POPULATE_JL_AP(
126 P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
127 );
128
129 /*=====================================================================================+
130 | PROCEDURE |
131 | POPULATE_JL_AR |
132 | Type : Public |
133 | Pre-req : None |
134 | Function : |
135 | This procedure calls the API to select the JL AR specific data from |
136 | JL tables and returns fetched values |
137 | |
138 | Called from ARP_TAX_EXTRACT.POPULATE_MISSING_COLUMNS. |
139 | |
140 | Parameters : |
141 | IN : |
142 | OUT: |
143 | |
144 | MODIFICATION HISTORY |
145 | 27-Oct-03 Asako Takahashi created |
146 | 17-Feb-04 Hidekoji Modified the parameters |
147 | 11-May-04 Hidekoji Modified the parameters |
148 | |
149 +=====================================================================================*/
150
151 PROCEDURE POPULATE_JL_AR(
152 P_TRL_GLOBAL_VARIABLES_REC IN ZX_EXTRACT_PKG.TRL_GLOBAL_VARIABLES_REC_TYPE
153 );
154
155 END ZX_JL_EXTRACT_PKG;