DBA Data[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