[Home] [Help]
PACKAGE: APPS.AP_APXVDVSR_XMLP_PKG
Source
1 PACKAGE AP_APXVDVSR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: APXVDVSRS.pls 120.0 2007/12/27 08:51:37 vjaganat noship $ */
3 P_FLEXDATA VARCHAR2(800);
4 P_CONC_REQUEST_ID NUMBER := 0;
5 P_MINPRECISION NUMBER;
6 P_DEBUG_SWITCH VARCHAR2(1);
7 P_SOB_ID NUMBER;
8 P_VENDOR_ID_PAR NUMBER;
9 P_VENDOR_TYPE_PAR VARCHAR2(30);
10 P_PAY_GROUP_PAR VARCHAR2(25);
11 P_VENDOR_STATUS_PAR VARCHAR2(8);
12 P_SITE_STATUS_PAR VARCHAR2(8);
13 P_CONTACT_STATUS_PAR VARCHAR2(8);
14 P_SITE_PAR VARCHAR2(2);
15 P_CONTACT_PAR VARCHAR2(2);
16 P_ORDER_BY_PAR VARCHAR2(30);
17 P_ORDER_BY VARCHAR2(300) := 'AND 1 = 1';
18 P_VENDOR_ID_SQL VARCHAR2(100) := 'AND 1 = 1' ;
19 SORT_BY_ALTERNATE VARCHAR2(5);
20 DEFAULT_COUNTRY_CODE VARCHAR2(5);
21 P_PRINT_HOME_COUNTRY VARCHAR2(5);
22 DEFAULT_COUNTRY_NAME VARCHAR2(80);
23 P_SORT_VENDOR_NUM_ALPHA VARCHAR2(25) := '''NO SORT''';
24 P_SORT_VENDOR_NUM_NUMERIC VARCHAR2(25) := '0';
25 P_INCOME_TAX_REP_PAR VARCHAR2(2);
26 P_BANK_ACCOUNT_PAR VARCHAR2(2);
27 P_BANK_ACCOUNT_STATUS_PAR VARCHAR2(8);
28 P_WHERE_DATES VARCHAR2(500);
29 P_CREATED_BY NUMBER;
30 P_UPDATED_BY NUMBER;
31 P_CREATION_DATE_FROM DATE;
32 P_CREATION_DATE_TO DATE;
33 P_UPDATE_DATE_FROM DATE;
34 P_UPDATE_DATE_TO DATE;
35 LP_V_CREATION_DATE_FROM VARCHAR2(1000) := 'AND 1 = 1' ;
36 LP_V_CREATION_DATE_TO VARCHAR2(1000) := 'AND 1 = 1' ;
37 LP_V_UPDATE_DATE_FROM VARCHAR2(1000) := 'AND 1 = 1' ;
38 LP_V_UPDATE_DATE_TO VARCHAR2(1000) := 'AND 1 = 1' ;
39 P_TRACE_SWITCH VARCHAR2(1);
40 LP_S_CREATION_DATE_FROM VARCHAR2(1000) := 'AND 1 = 1' ;
41 LP_S_CREATION_DATE_TO VARCHAR2(1000) := 'AND 1 = 1' ;
42 LP_S_UPDATE_DATE_FROM VARCHAR2(1000) := 'AND 1 = 1' ;
43 LP_S_UPDATE_DATE_TO VARCHAR2(1000) := 'AND 1 = 1' ;
44 LP_S_CREATED_BY VARCHAR2(1000) := 'AND 1 = 1' ;
45 LP_S_UPDATED_BY VARCHAR2(1000) := 'AND 1 = 1' ;
46 LP_V_CREATED_BY VARCHAR2(1000) := 'AND 1 = 1' ;
47 LP_V_UPDATED_BY VARCHAR2(1000) := 'AND 1 = 1' ;
48 P_SUPPLIERS_THIS_ORG VARCHAR2(32767);
49 P_SUPPLIERS_THIS_ORG_SQL VARCHAR2(500) := 'AND 1 = 1' ;
50 C_PAY_ALONE VARCHAR2(20);
51 C_PAYMENT_METHOD VARCHAR2(30);
52 C_BASE_CURRENCY_CODE VARCHAR2(32767) := '$$$';
53 C_BASE_PRECISION NUMBER := 2;
54 C_BASE_MIN_ACCT_UNIT NUMBER;
55 C_NLS_YES VARCHAR2(80) := 'Yes';
56 C_NLS_NO VARCHAR2(80) := 'No';
57 C_NLS_ACTIVE VARCHAR2(80);
58 C_COMPANY_NAME_HEADER VARCHAR2(30) := 'No Company Name';
59 C_CHART_OF_ACCOUNTS_ID NUMBER := 50105;
60 C_NLS_INACTIVE VARCHAR2(80);
61 C_START_TIME DATE;
62 C_END_TIME DATE;
63 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
64 C_MANUAL_VENDOR_NUM_TYPE VARCHAR2(20);
65 C_NLS_END_OF_REPORT VARCHAR2(100);
66 CP_VENDOR_NAME VARCHAR2(240);
67 CP_CREATED_BY VARCHAR2(120);
68 CP_UPDATED_BY VARCHAR2(120);
69 CP_ORDER_BY VARCHAR2(100);
70 CP_INCOME_TAX VARCHAR2(20);
71 CP_SITE_INF VARCHAR2(20);
72 CP_HOME_COUNTRY VARCHAR2(20);
73 CP_PAY_GROUP VARCHAR2(100);
74 CP_CONTACT_INF VARCHAR2(20);
75 CP_BANK_ACCOUNT_INF VARCHAR2(20);
76 CP_VENDOR_STATUS_INF VARCHAR2(82);
77 CP_SITE_STATUS_INF VARCHAR2(20);
78 CP_BANK_ACT_STATUS_INF VARCHAR2(80);
79 CP_CONTACT_STATUS_INF VARCHAR2(20);
80 C_STATUS_NLS_ACTIVE VARCHAR2(20);
81 C_STATUS_NLS_ALL VARCHAR2(20);
82 CP_SUPPLIERS_THIS_ORG VARCHAR2(20);
83 FUNCTION BEFOREREPORT RETURN BOOLEAN;
84 FUNCTION AFTERREPORT RETURN BOOLEAN;
85 FUNCTION CUSTOM_INIT(C_PAY_GROUP IN NUMBER) RETURN BOOLEAN;
86 FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN;
87 FUNCTION GET_COMPANY_NAME RETURN BOOLEAN;
88 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
89 FUNCTION C_PAY_GROUPFORMULA RETURN NUMBER;
90 FUNCTION GIVE_MESSAGES RETURN BOOLEAN;
91 FUNCTION C_ADDRESS_CONCATENATEDFORMULA(C_ADDRESS1 IN VARCHAR2
92 ,C_ADDRESS2 IN VARCHAR2
93 ,ADDRESS3 IN VARCHAR2
94 ,C_CITY IN VARCHAR2
95 ,C_STATE IN VARCHAR2
96 ,C_ZIP IN VARCHAR2
97 ,C_COUNTRY_NAME IN VARCHAR2
98 ,C_COUNTRY_CODE IN VARCHAR2) RETURN VARCHAR2;
99 PROCEDURE GET_PARAMETER_DESCRIPTION;
100 FUNCTION C_PAYMENT_METHODFORMULA RETURN CHAR;
101 FUNCTION C_IBY_INFOFORMULA(C_VENDOR_SITE_ID IN NUMBER
102 ,C_ORG_ID IN NUMBER
103 ,C_PARTY_ID IN NUMBER
104 ,C_PARTY_SITE_ID IN NUMBER
105 ,C_PAYMENT_CURRENCY_CODE IN VARCHAR2) RETURN CHAR;
106 FUNCTION C_PAY_ALONE_P RETURN VARCHAR2;
107 FUNCTION C_PAYMENT_METHOD_P RETURN VARCHAR2;
108 FUNCTION C_BASE_CURRENCY_CODE_P RETURN VARCHAR2;
109 FUNCTION C_BASE_PRECISION_P RETURN NUMBER;
110 FUNCTION C_BASE_MIN_ACCT_UNIT_P RETURN NUMBER;
111 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
112 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
113 FUNCTION C_NLS_ACTIVE_P RETURN VARCHAR2;
114 FUNCTION C_COMPANY_NAME_HEADER_P RETURN VARCHAR2;
115 FUNCTION C_CHART_OF_ACCOUNTS_ID_P RETURN NUMBER;
116 FUNCTION C_NLS_INACTIVE_P RETURN VARCHAR2;
117 FUNCTION C_START_TIME_P RETURN DATE;
118 FUNCTION C_END_TIME_P RETURN DATE;
119 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
120 FUNCTION C_MANUAL_VENDOR_NUM_TYPE_P RETURN VARCHAR2;
121 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
122 FUNCTION CP_VENDOR_NAME_P RETURN VARCHAR2;
123 FUNCTION CP_CREATED_BY_P RETURN VARCHAR2;
124 FUNCTION CP_UPDATED_BY_P RETURN VARCHAR2;
125 FUNCTION CP_ORDER_BY_P RETURN VARCHAR2;
126 FUNCTION CP_INCOME_TAX_P RETURN VARCHAR2;
127 FUNCTION CP_SITE_INF_P RETURN VARCHAR2;
128 FUNCTION CP_HOME_COUNTRY_P RETURN VARCHAR2;
129 FUNCTION CP_PAY_GROUP_P RETURN VARCHAR2;
130 FUNCTION CP_CONTACT_INF_P RETURN VARCHAR2;
131 FUNCTION CP_BANK_ACCOUNT_INF_P RETURN VARCHAR2;
132 FUNCTION CP_VENDOR_STATUS_INF_P RETURN VARCHAR2;
133 FUNCTION CP_SITE_STATUS_INF_P RETURN VARCHAR2;
134 FUNCTION CP_BANK_ACT_STATUS_INF_P RETURN VARCHAR2;
135 FUNCTION CP_CONTACT_STATUS_INF_P RETURN VARCHAR2;
136 FUNCTION C_STATUS_NLS_ACTIVE_P RETURN VARCHAR2;
137 FUNCTION C_STATUS_NLS_ALL_P RETURN VARCHAR2;
138 FUNCTION CP_SUPPLIERS_THIS_ORG_P RETURN VARCHAR2;
139 FUNCTION FORMAT_ADDRESS_LABEL(ADDRESS_STYLE IN VARCHAR2
140 ,ADDRESS1 IN VARCHAR2
141 ,ADDRESS2 IN VARCHAR2
142 ,ADDRESS3 IN VARCHAR2
143 ,ADDRESS4 IN VARCHAR2
144 ,CITY IN VARCHAR2
145 ,COUNTY IN VARCHAR2
146 ,STATE IN VARCHAR2
147 ,PROVINCE IN VARCHAR2
148 ,POSTAL_CODE IN VARCHAR2
149 ,TERRITORY_SHORT_NAME IN VARCHAR2
150 ,COUNTRY_CODE IN VARCHAR2
151 ,CUSTOMER_NAME IN VARCHAR2
152 ,BILL_TO_LOCATION IN VARCHAR2
153 ,FIRST_NAME IN VARCHAR2
154 ,LAST_NAME IN VARCHAR2
155 ,MAIL_STOP IN VARCHAR2
156 ,DEFAULT_COUNTRY_CODE IN VARCHAR2
157 ,DEFAULT_COUNTRY_DESC IN VARCHAR2
158 ,PRINT_HOME_COUNTRY_FLAG IN VARCHAR2
159 ,WIDTH IN NUMBER
160 ,HEIGHT_MIN IN NUMBER
161 ,HEIGHT_MAX IN NUMBER) RETURN VARCHAR2;
162 /*function R_vendorFormatTrigger(c_creation_date_vendor in DATE,c_update_date_vendor in DATE,c_created_by_v_num in NUMBER, c_updated_by_v_num in NUMBER ) return varchar2 ;*/
163 END AP_APXVDVSR_XMLP_PKG;
164