[Home] [Help]
PACKAGE: APPS.AP_APXCRRCR_XMLP_PKG
Source
1 PACKAGE AP_APXCRRCR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: APXCRRCRS.pls 120.1 2008/06/10 09:44:40 npannamp noship $ */
3 P_DEBUG_SWITCH VARCHAR2(1);
4
5 P_CONC_REQUEST_ID NUMBER := 0;
6
7 P_MIN_PRECISION NUMBER;
8
9 P_FLEXDATA VARCHAR2(600);
10
11 P_CHECK_DATE DATE;
12 P_CHECK_DATE_V DATE;
13 P_CHECK_DATE_V1 varchar2(30);
14 P_PAY_THROUGH_DATE DATE;
15 P_PAY_THROUGH_DATE_v DATE;
16 P_PAY_THROUGH_DATE_v1 varchar2(30);
17 P_SUMMARY_FLAG VARCHAR2(1);
18
19 P_INCLUDE_UNAPPROVED VARCHAR2(1);
20
21 SORT_BY_ALTERNATE VARCHAR2(5);
22
23 P_INCLUDE_UNVALIDATED VARCHAR2(1);
24
25 P_TEMPLATE_ID NUMBER;
26
27 P_PAY_ONLY_WHEN_DUE_FLAG VARCHAR2(1);
28
29 P_INCLUDE_SELECTED VARCHAR2(1);
30
31 C_REPORT_START_DATE DATE;
32
33 C_NLS_YES VARCHAR2(80);
34
35 C_NLS_NO VARCHAR2(80);
36
37 C_NLS_ALL VARCHAR2(80);
38
39 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
40
41 C_REPORT_RUN_TIME VARCHAR2(8);
42
43 C_CHART_OF_ACCOUNTS_ID NUMBER;
44
45 C_NLS_END_OF_REPORT VARCHAR2(100);
46
47 C_HI_PAYMENT_PRIORITY NUMBER;
48
49 C_LOW_PAYMENT_PRIORITY NUMBER;
50
51 C_ZERO_INVOICES_ALLOWED VARCHAR2(1);
52
53 C_VENDOR_ID NUMBER;
54
55 C_PAY_FROM_DATE DATE;
56
57 C_PAYMENT_METHOD_CODE VARCHAR2(30);
58
59 C_VENDOR_TYPE_LOOKUP_CODE VARCHAR2(30);
60
61 C_OU_GROUP_OPTION VARCHAR2(20);
62
63 C_LE_GROUP_OPTION VARCHAR2(20);
64
65 C_CURRENCY_GROUP_OPTION VARCHAR2(20);
66
67 C_PAY_GROUP_OPTION VARCHAR2(20);
68
69 C_INV_EXCHANGE_RATE_TYPE VARCHAR2(20);
70
71 C_PARTY_ID NUMBER;
72
73 C_DISC_PAY_THRU_DATE DATE;
74
75 C_TEMPLATE_NAME VARCHAR2(175);
76
77 C_UNAPPROVED_PREDICATE VARCHAR2(200):= ' ';
78
79 C_UNVALIDATED_PREDICATE VARCHAR2(200) := ' ';
80
81 C_NLS_HOLDS VARCHAR2(20);
82
83 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
84
85 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
86
87 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
88
89 FUNCTION BEFOREREPORT RETURN BOOLEAN;
90
91 FUNCTION AFTERREPORT RETURN BOOLEAN;
92
93 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
94
95 FUNCTION CALCULATE_RUN_TIME RETURN BOOLEAN;
96
97 FUNCTION C_PAY_DATEFORMULA(C_SORT_PAY_DATE IN DATE) RETURN VARCHAR2;
98
99 FUNCTION C_HOLD_COUNTFORMULA(C_INVOICE_ID IN NUMBER) RETURN NUMBER;
100
101 FUNCTION C_NLS_SUMMARY_FLAGFORMULA RETURN VARCHAR2;
102
103 FUNCTION C_APPROVED_STATUSFORMULA(C_INVOICE_ID IN NUMBER) RETURN VARCHAR2;
104
105 FUNCTION C_AMOUNT_ROUNDFORMULA(C_CURRENCY_CODE IN VARCHAR2
106 ,C_AMOUNT IN NUMBER) RETURN NUMBER;
107
108 FUNCTION C_AMOUNTFORMULA(C_TAKE_DISC_FLAG IN VARCHAR2
109 ,C_DISC_AMT IN NUMBER
110 ,C_DISC_DATE IN DATE
111 ,C_SEC_DISC_DATE IN DATE
112 ,C_SEC_DISC_AMT IN NUMBER
113 ,C_THRD_DISC_DATE IN DATE
114 ,C_THRD_DISC_AMT IN NUMBER
115 ,C_GROSS_AMOUNT IN NUMBER
116 ,C_AMT_REMAINING IN NUMBER) RETURN NUMBER;
117
118 FUNCTION C_BASE_CURRENCY_AMOUNTFORMULA(C_TAKE_DISC_FLAG IN VARCHAR2
119 ,C_DISC_AMT IN NUMBER
120 ,C_DISC_DATE IN DATE
121 ,C_SEC_DISC_DATE IN DATE
122 ,C_SEC_DISC_AMT IN NUMBER
123 ,C_THRD_DISC_DATE IN DATE
124 ,C_THRD_DISC_AMT IN NUMBER
125 ,C_GROSS_AMOUNT IN NUMBER
126 ,C_AMT_REMAINING IN NUMBER
127 ,C_BASE_MIN_ACCOUNT_UNIT IN NUMBER
128 ,C_EXCH_RATE IN NUMBER
129 ,C_PAYMENT_CROSS_RATE IN NUMBER
130 ,C_BASE_PRECISION IN NUMBER) RETURN NUMBER;
131
132 FUNCTION C_SORT_PAY_DATEFORMULA(C_TAKE_DISC_FLAG IN VARCHAR2
133 ,C_DUE_DATE IN DATE
134 ,C_DISC_DATE IN DATE
135 ,C_SEC_DISC_DATE IN DATE
136 ,C_THRD_DISC_DATE IN DATE) RETURN DATE;
137
138 FUNCTION C_NLS_INCL_UNAPPROVEDFORMULA RETURN CHAR;
139
140 FUNCTION C_NLS_INCL_UNVALIDATEDFORMULA RETURN CHAR;
141
142 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
143
144 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
145
146 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
147
148 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
149
150 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
151
152 FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
153
154 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
155
156 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
157
158 FUNCTION C_HI_PAYMENT_PRIORITY_P RETURN NUMBER;
159
160 FUNCTION C_LOW_PAYMENT_PRIORITY_P RETURN NUMBER;
161
162 FUNCTION C_ZERO_INVOICES_ALLOWED_P RETURN VARCHAR2;
163
164 FUNCTION C_VENDOR_ID_P RETURN NUMBER;
165
166 FUNCTION C_PAY_FROM_DATE_P RETURN DATE;
167
168 FUNCTION C_PAYMENT_METHOD_CODE_P RETURN VARCHAR2;
169
170 FUNCTION C_VENDOR_TYPE_LOOKUP_CODE_P RETURN VARCHAR2;
171
172 FUNCTION C_OU_GROUP_OPTION_P RETURN VARCHAR2;
173
174 FUNCTION C_LE_GROUP_OPTION_P RETURN VARCHAR2;
175
176 FUNCTION C_CURRENCY_GROUP_OPTION_P RETURN VARCHAR2;
177
178 FUNCTION C_PAY_GROUP_OPTION_P RETURN VARCHAR2;
179
180 FUNCTION C_INV_EXCHANGE_RATE_TYPE_P RETURN VARCHAR2;
181
182 FUNCTION C_PARTY_ID_P RETURN NUMBER;
183
184 FUNCTION C_DISC_PAY_THRU_DATE_P RETURN DATE;
185
186 FUNCTION C_TEMPLATE_NAME_P RETURN VARCHAR2;
187
188 FUNCTION C_UNAPPROVED_PREDICATE_P RETURN VARCHAR2;
189
190 FUNCTION C_UNVALIDATED_PREDICATE_P RETURN VARCHAR2;
191
192 FUNCTION C_NLS_HOLDS_P RETURN VARCHAR2;
193
194 END AP_APXCRRCR_XMLP_PKG;
195
196