1 PACKAGE AP_APXINUPD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: APXINUPDS.pls 120.0 2007/12/27 08:04:05 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_LAST_UPDATED_BY NUMBER;
14
15 P_FA_INSTALLED_FLAG VARCHAR2(1);
16
17 P_PO_INSTALLED_FLAG VARCHAR2(1);
18
19 P_PA_INSTALLED_FLAG VARCHAR2(1);
20
21 P_INV_INSTALLED_FLAG VARCHAR2(32767);
22
23 P_CHV_INSTALLED_FLAG VARCHAR2(32767) := 'N';
24
25 P_MRP_INSTALLED_FLAG VARCHAR2(32767) := 'N';
26
27 P_PN_INSTALLED_FLAG VARCHAR2(32767);
28
29 P_POS_CALLED VARCHAR2(1);
30
31 P_PRIMARY_PAY VARCHAR2(1) := 'N';
32
33 C_BASE_CURRENCY_CODE VARCHAR2(15);
34
35 C_BASE_PRECISION NUMBER;
36
37 C_BASE_MIN_ACCT_UNIT NUMBER;
38
39 C_BASE_DESCRIPTION VARCHAR2(240);
40
41 C_COMPANY_NAME_HEADER VARCHAR2(50);
42
43 C_REPORT_START_DATE DATE;
44
45 C_NLS_YES VARCHAR2(80);
46
47 C_NLS_NO VARCHAR2(80);
48
49 C_NLS_ALL VARCHAR2(80);
50
51 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
52
53 C_REPORT_RUN_TIME VARCHAR2(8);
54
55 C_CHART_OF_ACCOUNTS_ID NUMBER;
56
57 C_NLS_END_OF_REPORT VARCHAR2(100);
58
59 --added as fix
60 P_LAST_UPDATED_BY_T number;
61 P_SET_OF_BOOKS_ID_T number;
62 P_FA_INSTALLED_FLAG_T VARCHAR2(1);
63 P_PO_INSTALLED_FLAG_T VARCHAR2(1);
64 P_PA_INSTALLED_FLAG_T VARCHAR2(1);
65 P_INV_INSTALLED_FLAG_T VARCHAR2(32767);
66 P_PN_INSTALLED_FLAG_T VARCHAR2(32760);
67 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
68
69 FUNCTION CUSTOM_INIT RETURN BOOLEAN;
70
71 FUNCTION GET_COVER_PAGE_VALUES RETURN BOOLEAN;
72
73 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
74
75 FUNCTION BEFOREREPORT RETURN BOOLEAN;
76
77 FUNCTION AFTERREPORT RETURN BOOLEAN;
78
79 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
80
81 FUNCTION GET_FLEXDATA RETURN BOOLEAN;
82
83 FUNCTION CALCULATE_RUN_TIME RETURN BOOLEAN;
84
85 FUNCTION C_VENDOR_SITE_IDFORMULA(C_ORG_ID IN NUMBER
86 ,C_KEEP_SITE_FLAG IN VARCHAR2
87 ,C_VENDOR_ID IN NUMBER
88 ,C_VENDOR_SITE_CODE IN VARCHAR2
89 ,C_OLD_VENDOR_SITE_ID IN NUMBER) RETURN NUMBER;
90
91 FUNCTION C_DUPLICATE_YES_NOFORMULA(C_INVOICE_ID IN NUMBER
92 ,C_INVOICE_NUM IN VARCHAR2
93 ,C_VENDOR_ID IN NUMBER
94 ,C_VENDOR_SITE_ID IN NUMBER
95 ,C_PARTY_ID IN NUMBER
96 ,C_PARTY_SITE_ID IN NUMBER
97 ,C_PAID_INVOICES_FLAG IN VARCHAR2
98 ,C_DUP_VENDOR_ID IN NUMBER
99 ,C_DUP_VENDOR_SITE_ID IN NUMBER) RETURN VARCHAR2;
100
101 FUNCTION C_DUP_INVOICEFORMULA(C_DUPLICATE_YES_NO IN VARCHAR2) RETURN NUMBER;
102
103 FUNCTION C_NON_DUP_INVOICEFORMULA(C_DUPLICATE_YES_NO IN VARCHAR2) RETURN NUMBER;
104
105 FUNCTION C_PAID_AMOUNTFORMULA(C_DUPLICATE_YES_NO IN VARCHAR2
106 ,C_PAYMENT_STATUS_FLAG IN VARCHAR2
107 ,C_AMOUNT_PAID IN NUMBER
108 ,C_DISCOUNT_AMOUNT_TAKEN IN NUMBER) RETURN NUMBER;
109
110 FUNCTION C_CHANGED_AMOUNTFORMULA(C_DUPLICATE_YES_NO IN VARCHAR2
111 ,C_INVOICE_AMOUNT IN NUMBER) RETURN NUMBER;
112
113 FUNCTION C_PAID_INVOICEFORMULA(C_PAYMENT_STATUS_FLAG IN VARCHAR2) RETURN NUMBER;
114
115 FUNCTION C_UNPAID_INVOICEFORMULA(C_PAYMENT_STATUS_FLAG IN VARCHAR2) RETURN NUMBER;
116
117 FUNCTION C_DUP_RECURRING_COUNTFORMULA(C_DUP_VENDOR_ID IN NUMBER
118 ,C_DUP_VENDOR_SITE_ID IN NUMBER
119 ,C_VENDOR_ID IN NUMBER
120 ,C_VENDOR_SITE_ID IN NUMBER) RETURN NUMBER;
121
122 FUNCTION C_RECURRING_COUNTFORMULA(C_VENDOR_ID IN NUMBER
123 ,C_VENDOR_SITE_ID IN NUMBER
124 ,C_DUP_VENDOR_ID IN NUMBER
125 ,C_DUP_VENDOR_SITE_ID IN NUMBER) RETURN NUMBER;
126
127 FUNCTION C_UPDATE_DUP_VENDORFORMULA(C_DUP_INVOICE_COUNT IN NUMBER
128 ,C_DUP_RECURRING_COUNT IN NUMBER
129 ,C_KEEP_SITE_FLAG IN VARCHAR2
130 ,C_VENDOR_SITE_ID IN NUMBER
131 ,C_ENTRY_ID IN NUMBER
132 ,C_PAID_INVOICE_COUNT_RESET IN NUMBER
133 ,C_UNPAID_INVOICE_COUNT_RESET IN NUMBER
134 ,C_DUP_VENDOR_ID IN NUMBER
135 ,C_DUP_VENDOR_SITE_ID IN NUMBER
136 ,C_VENDOR_ID IN NUMBER
137 ,C_PARTY_SITE_ID IN NUMBER
138 ,C_DUP_PARTY_SITE_ID IN NUMBER) RETURN NUMBER;
139
140 FUNCTION DUPLICATE_SITES RETURN BOOLEAN;
141
142 FUNCTION C_VENDOR_SITE_ID_POFORMULA(C_ORG_ID_PO IN NUMBER
143 ,C_KEEP_SITE_FLAG_PO IN VARCHAR2
144 ,C_VENDOR_ID_PO IN NUMBER
145 ,C_VENDOR_SITE_CODE_PO IN VARCHAR2
146 ,C_OLD_VENDOR_SITE_ID_PO IN NUMBER) RETURN NUMBER;
147
148 FUNCTION C_MODIFY_PO_TABLESFORMULA(C_DUP_VENDOR_ID_PO IN NUMBER
149 ,C_KEEP_SITE_FLAG_PO IN VARCHAR2
150 ,C_PARTY_SITE_ID_PO IN NUMBER
151 ,C_DUP_PARTY_SITE_ID_PO IN NUMBER
152 ,C_DUP_VENDOR_SITE_ID_PO IN NUMBER
153 ,C_VENDOR_ID_PO IN NUMBER
154 ,C_VENDOR_SITE_ID_PO IN NUMBER
155 ,C_PO_COUNT IN NUMBER
156 ,C_ENTRY_ID_PO IN NUMBER) RETURN NUMBER;
157
158 FUNCTION C_MODIFY_RFQ_VENDORSFORMULA(C_VENDOR_ID_PO IN NUMBER
159 ,C_VENDOR_SITE_ID_PO IN NUMBER
160 ,C_PO_HEADER_ID IN NUMBER) RETURN NUMBER;
161
162 FUNCTION G_DUPLICATE_VENDORS_POGROUPFIL RETURN BOOLEAN;
163
164 FUNCTION G_DUPLICATE_VENDORSGROUPFILTER RETURN BOOLEAN;
165
166 FUNCTION C_CURRENCY_CODEFORMULA(C_INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN VARCHAR2;
167
168 FUNCTION C_INVOICE_COUNTFORMULA(C_DUP_INVOICE_COUNT IN NUMBER
169 ,C_NON_DUP_INVOICE_COUNT IN NUMBER
170 ,C_DUP_RECURRING_COUNT IN NUMBER
171 ,C_RECURRING_COUNT IN NUMBER) RETURN NUMBER;
172
173 FUNCTION DUPLICATE_TAX_SITES RETURN BOOLEAN;
174
175 FUNCTION C_OPERATING_UNITFORMULA(C_ORG_ID IN NUMBER) RETURN CHAR;
176
177 FUNCTION C_OPERATING_UNITPOFORMULA(C_ORG_ID_PO IN NUMBER) RETURN CHAR;
178
179 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
180
181 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
182
183 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
184
185 FUNCTION C_BASE_DESCRIPTION_P RETURN VARCHAR2;
186
187 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
188
189 FUNCTION C_REPORT_START_DATE_P RETURN DATE;
190
191 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
192
193 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
194
195 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
196
197 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
198
199 FUNCTION C_REPORT_RUN_TIME_P RETURN VARCHAR2;
200
201 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
202
203 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
204
205 END AP_APXINUPD_XMLP_PKG;
206