[Home] [Help]
PACKAGE: APPS.JE_JEFILPIP_XMLP_PKG
Source
1 PACKAGE JE_JEFILPIP_XMLP_PKG AS
2 /* $Header: JEFILPIPS.pls 120.1 2007/12/25 16:53:00 dwkrishn noship $ */
3 P_PAYMENT_GROUP VARCHAR2(32767);
4
5 P_INVOICE_CURRENCY VARCHAR2(3);
6
7 P_VENDOR_ID NUMBER;
8
9 P_ONLY_PAST_FLAG VARCHAR2(1);
10
11 P_MATCH_STATUS_FLAG VARCHAR2(1);
12
13 P_ONLY_OPEN_INVOICES VARCHAR2(1) := 'Y';
14
15 P_ONLY_PAID_INVOICES VARCHAR2(1) := 'Y';
16
17 CP_ONLY_PAID_INVOICES VARCHAR2(1);
18
19 P_CHECK_VOUCHER VARCHAR2(80);
20
21 P_PAYMENT_PERIOD VARCHAR2(32767);
22
23 P_INV_POSTED_FLAG VARCHAR2(1);
24
25 P_PAY_POSTED_FLAG VARCHAR2(1);
26
27 P_CUT_DATE DATE;
28
29 CP_CUT_DATE DATE;
30
31 P_SUMMARY_LEVEL NUMBER;
32
33 P_CONC_REQUEST_ID NUMBER := 0;
34
35 P_GROUP_FIELD VARCHAR2(60);
36
37 P_INVOICE_PERIOD VARCHAR2(32767);
38
39 P_DEBUG_SWITCH VARCHAR2(32767);
40
41 P_CONFIRMED VARCHAR2(32767);
42
43 P_CHECKRUN_NAME VARCHAR2(50);
44
45 CP_INV_PAY_AMOUNT NUMBER;
46
47 CP_INVPP_OPEN_AMOUNT NUMBER;
48
49 CP_INVPP_GL_DATE DATE;
50
51 C_FLEXDATA VARCHAR2(600) := 'I.PAY_GROUP_LOOKUP_CODE';
52
53 SQL_PAYMENT_GROUP VARCHAR2(840);
54
55 SQL_INVOICE_CURRENCY VARCHAR2(500);
56
57 SQL_VENDOR_ID VARCHAR2(500);
58
59 SQL_DISTRIBUTIONS VARCHAR2(700);
60
61 SQL_PAYMENTS2 VARCHAR2(2000);
62
63 SQL_PAYMENTS3 VARCHAR2(3000);
64
65 C_COAI NUMBER;
66
67 SQL_PAYMENTS1 VARCHAR2(3000);
68
69 C_TITLE VARCHAR2(240);
70
71 C_SUMMARY_LEVEL VARCHAR2(80);
72
73 C_YES VARCHAR2(80);
74
75 C_APPROVAL_STATUS VARCHAR2(80);
76
77 C_NO VARCHAR2(80);
78
79 C_ALL VARCHAR2(80);
80
81 C_SOB NUMBER;
82
83 C_HOLD_FLAG VARCHAR2(32767);
84
85 C_PRECISION NUMBER := 2;
86
87 C_FUNCT_CURR VARCHAR2(32767);
88
89 SQL_PAYMENTS_FDP VARCHAR2(3000);
90
91 FUNCTION BEFOREREPORT RETURN BOOLEAN;
92
93 FUNCTION AFTERREPORT RETURN BOOLEAN;
94
95 FUNCTION C_INV_OPEN_AMOUNTFORMULA(C_INV_GROSS_AMOUNT IN NUMBER
96 ,C_INV_PAY_AMOUNT0 IN NUMBER
97 ,C_INV_DISCOUNT_TAKEN0 IN NUMBER) RETURN NUMBER;
98
99 FUNCTION C_INV_OPEN_BASEFORMULA(C_INV_OPEN_AMOUNT IN NUMBER
100 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
101
102 FUNCTION C_CUR_OPEN_AMOUNTFORMULA(C_CUR_GROSS_AMOUNT IN NUMBER
103 ,C_CUR_PAY_AMOUNT IN NUMBER
104 ,C_CUR_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
105
106 FUNCTION C_CUR_OPEN_BASEFORMULA(C_CUR_OPEN_AMOUNT IN NUMBER
107 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
108
109 FUNCTION C_GRP_OPEN_BASEFORMULA(C_GRP_GROSS_BASE IN NUMBER
110 ,C_GRP_PAY_BASE IN NUMBER
111 ,C_GRP_DISCOUNT_TAKEN_BASE IN NUMBER
112 ,C_GRP_GAINLOSS IN NUMBER) RETURN NUMBER;
113
114 FUNCTION C_VEN_OPEN_AMOUNTFORMULA(C_VEN_GROSS_AMOUNT IN NUMBER
115 ,C_VEN_PAY_AMOUNT IN NUMBER
116 ,C_VEN_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
117
118 FUNCTION C_VEN_OPEN_BASEFORMULA(C_VEN_OPEN_AMOUNT IN NUMBER
119 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
120
121 FUNCTION C_RPT_OPEN_BASEFORMULA(C_RPT_INV_BASE IN NUMBER
122 ,C_RPT_PAY_BASE IN NUMBER
123 ,C_RPT_DISCOUNT_TAKEN_BASE IN NUMBER
124 ,C_RPT_GAINLOSS IN NUMBER) RETURN NUMBER;
125
126 FUNCTION C_VENDOR_NAMEFORMULA RETURN VARCHAR2;
127
128 FUNCTION C_FLEXPROMPTFORMULA RETURN VARCHAR2;
129
130 FUNCTION C_SOB_NAMEFORMULA RETURN VARCHAR2;
131
132 FUNCTION SQL_CURRENCY RETURN BOOLEAN;
133
134 FUNCTION SQL_VENDOR RETURN BOOLEAN;
135
136 FUNCTION SQL_DISTRIBUTIONS_1 RETURN BOOLEAN;
137
138 FUNCTION SQL_PAYMENTS RETURN BOOLEAN;
139
140 FUNCTION C_BAL_FACTORFORMULA(DIST_BASE_AMOUNT IN NUMBER
141 ,P_INVOICE_ID IN NUMBER) RETURN NUMBER;
142
143 FUNCTION C_INV_GROSS_BASEFORMULA(CANCELLED_DATE IN DATE
144 ,C_INV_GROSS_BASE0 IN NUMBER
145 ,CANCELLED_AMOUNT IN NUMBER
146 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
147
148 FUNCTION C_INV_GROSS_AMOUNTFORMULA(CANCELLED_DATE IN DATE
149 ,C_INV_GROSS_AMOUNT1 IN NUMBER
150 ,CANCELLED_AMOUNT IN NUMBER) RETURN NUMBER;
151
152 FUNCTION C_INV_PAY_BASEFORMULA(P_INVOICE_ID IN NUMBER
153 ,C_INV_PAY_BASE0 IN NUMBER) RETURN NUMBER;
154
155 FUNCTION C_INV_GAINLOSSFORMULA(C_INV_GAINLOSS0 IN NUMBER) RETURN NUMBER;
156
157 FUNCTION C_INV_DISCOUNT_TAKEN_BASEFORMU(C_INV_DISC_TAKEN_BASE0 IN NUMBER) RETURN NUMBER;
158
159 FUNCTION C_INV_DISCOUNT_AVAILABLEFORMUL(C_INV_DISC_AVAIL0 IN NUMBER
160 ,C_BAL_FACTOR IN NUMBER) RETURN NUMBER;
161
162 FUNCTION NLS_PARAMETERS RETURN BOOLEAN;
163
164 FUNCTION C_APPROVE_FLAGFORMULA(P_INVOICE_ID IN NUMBER) RETURN VARCHAR2;
165
166 FUNCTION CF_CUT_DATEFORMULA RETURN CHAR;
167
168 FUNCTION CF_SYSDATEFORMULA RETURN CHAR;
169
170 FUNCTION CF_C_INV_DISCOUNT_DATEFORMULA(C_INV_DISCOUNT_DATE IN DATE) RETURN CHAR;
171
172 FUNCTION CF_INV_CHECK_GL_DATEFORMULA(C_INV_CHECK_GL_DATE IN DATE) RETURN CHAR;
173
174 FUNCTION C_SCH_OPEN_AMOUNTFORMULA(GROSS_AMOUNT IN NUMBER
175 ,C_SCH_PAY_AMOUNT IN NUMBER
176 ,C_SCH_DISCOUNT_TAKEN IN NUMBER) RETURN NUMBER;
177
178 FUNCTION C_SCH_OPEN_BASEFORMULA(C_SCH_OPEN_AMOUNT IN NUMBER
179 ,EXCHANGE_RATE IN NUMBER) RETURN NUMBER;
180
181 FUNCTION CP_INV_PAY_AMOUNT_P RETURN NUMBER;
182
183 FUNCTION CP_INVPP_OPEN_AMOUNT_P RETURN NUMBER;
184
185 FUNCTION CP_INVPP_GL_DATE_P RETURN DATE;
186
187 FUNCTION C_FLEXDATA_P RETURN VARCHAR2;
188
189 FUNCTION SQL_PAYMENT_GROUP_P RETURN VARCHAR2;
190
191 FUNCTION SQL_PAYMENT_GROUP_1 RETURN BOOLEAN;
192
193 FUNCTION SQL_INVOICE_CURRENCY_P RETURN VARCHAR2;
194
195 FUNCTION SQL_VENDOR_ID_P RETURN VARCHAR2;
196
197 FUNCTION SQL_DISTRIBUTIONS_P RETURN VARCHAR2;
198
199 FUNCTION SQL_PAYMENTS2_P RETURN VARCHAR2;
200
201 FUNCTION SQL_PAYMENTS3_P RETURN VARCHAR2;
202
203 FUNCTION C_COAI_P RETURN NUMBER;
204
205 FUNCTION SQL_PAYMENTS1_P RETURN VARCHAR2;
206
207 FUNCTION C_TITLE_P RETURN VARCHAR2;
208
209 FUNCTION C_SUMMARY_LEVEL_P RETURN VARCHAR2;
210
211 FUNCTION C_YES_P RETURN VARCHAR2;
212
213 FUNCTION C_APPROVAL_STATUS_P RETURN VARCHAR2;
214
215 FUNCTION C_NO_P RETURN VARCHAR2;
216
217 FUNCTION C_ALL_P RETURN VARCHAR2;
218
219 FUNCTION C_SOB_P RETURN NUMBER;
220
221 FUNCTION C_HOLD_FLAG_P RETURN VARCHAR2;
222
223 FUNCTION C_PRECISION_P RETURN NUMBER;
224
225 FUNCTION C_FUNCT_CURR_P RETURN VARCHAR2;
226
227 FUNCTION SQL_PAYMENTS_FDP_P RETURN VARCHAR2;
228
229 END JE_JEFILPIP_XMLP_PKG;
230
231
232