[Home] [Help]
PACKAGE: APPS.AP_APXIIMPT_XMLP_PKG
Source
1 PACKAGE AP_APXIIMPT_XMLP_PKG AS
2 /* $Header: APXIIMPTS.pls 120.0 2007/12/27 07:46:15 vjaganat 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_SET_OF_BOOKS_ID NUMBER;
12
13 P_TRACE_SWITCH VARCHAR2(1);
14
15 P_BATCH_NAME VARCHAR2(50);
16
17 P_GL_DATE DATE;
18
19 P_LOGIN_ID VARCHAR2(32767);
20
21 P_USER_ID VARCHAR2(32767);
22
23 P_HOLD_CODE VARCHAR2(25);
24
25 P_HOLD_REASON VARCHAR2(240);
26
27 P_COMMIT_CYCLES NUMBER;
28
29 P_SOURCE VARCHAR2(80);
30
31 P_GROUP_ID VARCHAR2(80);
32
33 P_PURGE_FLAG VARCHAR2(1);
34
35 P_SUMMARY_FLAG VARCHAR2(1);
36
37 P_ALLOW_RECOVERY_RATE_OVERRIDE VARCHAR2(30);
38
39 P_ALLOW_TAX_CODE_OVERRIDE VARCHAR2(30);
40
41 P_ENABLE_NON_RECOVERABLE_TAX VARCHAR2(30);
42
43 P_ORG_ID NUMBER;
44
45 P_BASE_CURRENCY_CODE VARCHAR2(32767);
46
47 P_PRECISION NUMBER;
48 /*added as fix*/
49 p_org_id_t number;
50 p_source_t VARCHAR2(80);
51 p_group_id_t VARCHAR2(80);
52 p_batch_name_t VARCHAR2(50);
53 p_hold_code_t VARCHAR2(25);
54 p_hold_reason_t VARCHAR2(240);
55 p_gl_date_t DATE;
56 p_purge_flag_t VARCHAR2(1);
57 p_trace_switch_t VARCHAR2(1);
58 p_debug_switch_t VARCHAR2(1);
59 p_summary_flag_t VARCHAR2(1);
60 /*fix ends*/
61
62 C_NLS_YES VARCHAR2(80);
63
64 C_NLS_NO VARCHAR2(80);
65
66 C_NLS_ALL VARCHAR2(80);
67
68 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
69
70 C_NLS_VOID VARCHAR2(80);
71
72 C_NLS_NA VARCHAR2(80);
73
74 C_NLS_END_OF_REPORT VARCHAR2(100);
75
76 C_REPORT_START_DATE DATE;
77
78 C_COMPANY_NAME_HEADER VARCHAR2(50);
79
80 C_BASE_CURRENCY_CODE VARCHAR2(15);
81
82 C_BASE_PRECISION NUMBER;
83
84 C_BASE_MIN_ACCT_UNIT NUMBER;
85
86 C_BASE_DESCRIPTION VARCHAR2(240);
87
88 C_CHART_OF_ACCOUNTS_ID NUMBER;
89
90 PAYABLES_OPEN_INTERFACE_IMPORT VARCHAR2(1);
91
92 C_ERROR_FLAG VARCHAR2(1) := 'N';
93
94 C_ERROR_MESSAGE VARCHAR2(500) := 'SQLERRM is null';
95
96 C_PRINT_BATCH VARCHAR2(1) := 'N';
97
98 C_INVOICES_FETCHED VARCHAR2(500);
99
100 C_INVOICES_CREATED VARCHAR2(500);
101
102 C_TOTAL_INVOICE_AMOUNT NUMBER;
103
104 C_TOTAL_INVOICES_CREATED VARCHAR2(20) := '0';
105
106 C_TOTAL_INVOICES_REJECTED NUMBER;
107
108 C_MSG_TYPE VARCHAR2(25);
109
110 C_MSG_TOKEN1 VARCHAR2(30);
111
112 C_MSG_TOKEN2 VARCHAR2(30);
113
114 C_MSG_TOKEN3 VARCHAR2(30);
115
116 C_MSG_COUNT NUMBER;
117
118 C_MSG_DATA VARCHAR2(500);
119
120 C_PA_MESSAGE VARCHAR2(2000);
121
122 CP_OPERATING_UNIT VARCHAR2(240);
123
124 CP_PURGE_FLAG VARCHAR2(240);
125
126 CREATE_RETROPRICE_ADJUSTMENTS NUMBER;
127
128 IMPORT_INVOICES NUMBER;
129
130 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
131
132 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
133
134 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
135
136 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
137
138 FUNCTION BEFOREREPORT RETURN BOOLEAN;
139
140 FUNCTION AFTERREPORT RETURN BOOLEAN;
141
142 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
143
144 FUNCTION GET_FLEXDATA RETURN BOOLEAN;
145
146 FUNCTION GET_BATCH_ID(P_BATCH_NAME_T IN VARCHAR2
147 ,P_BATCH_ID OUT NOCOPY NUMBER
148 ,P_BATCH_TYPE OUT NOCOPY VARCHAR2
149 ,P_CALLING_SEQUENCE IN VARCHAR2) RETURN BOOLEAN;
150
151 FUNCTION GET_CURRENT_DIST_LINE_NUM(P_INVOICE_ID IN NUMBER
152 ,P_CURRENT_DIST_NUM OUT NOCOPY NUMBER
153 ,P_CALLING_SEQUENCE IN VARCHAR2) RETURN BOOLEAN;
154
155 FUNCTION C_LINE_LEVELFORMULA(LINE_NUMBER IN NUMBER) RETURN VARCHAR2;
156
157 FUNCTION CF_SOURCE_NAMEFORMULA RETURN CHAR;
158
159 FUNCTION GET_OPERATING_UNIT RETURN BOOLEAN;
160
161 FUNCTION GET_PURGE_FLAG RETURN BOOLEAN;
162
163 FUNCTION CF_AUDIT_OUFORMULA(AUDIT_ORG_ID IN NUMBER) RETURN CHAR;
164
165 FUNCTION CF_REJECT_OUFORMULA(REJECT_ORG_ID IN NUMBER) RETURN CHAR;
166
167 FUNCTION CF_INVOICE_AMOUNT2FORMULA(CF_INVOICE_AMOUNT2 IN NUMBER) RETURN NUMBER;
168
169 FUNCTION CF_INVOICE_AMOUNT3FORMULA(CF_INVOICE_AMOUNT3 IN NUMBER) RETURN NUMBER;
170
171 FUNCTION CF_IPV_ADJ_AMOUNTFORMULA(CF_IPV_ADJ_AMOUNT IN NUMBER) RETURN NUMBER;
172
173 FUNCTION CF_TIPV_ADJ_AMOUNTFORMULA(CF_TIPV_ADJ_AMOUNT IN NUMBER) RETURN NUMBER;
174
175 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
176
177 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
178
179 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
180
181 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
182
183 FUNCTION C_NLS_VOID_P RETURN VARCHAR2;
184
185 FUNCTION C_NLS_NA_P RETURN VARCHAR2;
186
187 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
188
189 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
190
191 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
192
193 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
194
195 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
196
197 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
198
199 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
200
201 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
202
203 FUNCTION PAYABLES_OPEN_INTERFACE_IMPOR RETURN VARCHAR2;
204
205 FUNCTION C_ERROR_FLAG_P RETURN VARCHAR2;
206
207 FUNCTION C_ERROR_MESSAGE_P RETURN VARCHAR2;
208
209 FUNCTION C_PRINT_BATCH_P RETURN VARCHAR2;
210
211 FUNCTION C_INVOICES_FETCHED_P RETURN VARCHAR2;
212
213 FUNCTION C_INVOICES_CREATED_P RETURN VARCHAR2;
214
215 FUNCTION C_TOTAL_INVOICE_AMOUNT_P RETURN NUMBER;
216
217 FUNCTION C_TOTAL_INVOICES_CREATED_P RETURN VARCHAR2;
218
219 FUNCTION C_TOTAL_INVOICES_REJECTED_P RETURN NUMBER;
220
221 FUNCTION C_MSG_TYPE_P RETURN VARCHAR2;
222
223 FUNCTION C_MSG_TOKEN1_P RETURN VARCHAR2;
224
225 FUNCTION C_MSG_TOKEN2_P RETURN VARCHAR2;
226
227 FUNCTION C_MSG_TOKEN3_P RETURN VARCHAR2;
228
229 FUNCTION C_MSG_COUNT_P RETURN NUMBER;
230
231 FUNCTION C_MSG_DATA_P RETURN VARCHAR2;
232
233 FUNCTION C_PA_MESSAGE_P RETURN VARCHAR2;
234
235 FUNCTION CP_OPERATING_UNIT_P RETURN VARCHAR2;
236
237 FUNCTION CP_PURGE_FLAG_P RETURN VARCHAR2;
238
239 --FUNCTION CREATE_RETROPRICE_ADJUSTMENTS RETURN NUMBER;
240 FUNCTION FCREATE_RETROPRICE_ADJUSTMENTS RETURN NUMBER;
241
242 FUNCTION IMPORT_INVOICES_P RETURN NUMBER;
243
244 END AP_APXIIMPT_XMLP_PKG;
245