[Home] [Help]
PACKAGE: APPS.AS_OSI_LEAD_PUB
Source
1 PACKAGE AS_OSI_LEAD_PUB AUTHID CURRENT_USER as
2 /* $Header: custom_asxposis.pls 115.3.1157.2 2002/02/21 09:11:49 pkm ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_OSI_LEAD_PUB
8 --
9 -- PURPOSE
10 -- This package is a public API for inserting OSI enhanced oppy information into
11 -- OSM. It contains specification for pl/sql records and tables and the
12 -- Public fetch and update API.
13 --
14 -- Procedures:
15 -- osi_lead_fetch (see below for specification)
16 -- osi_lead_update (see below for specification)
17
18 --
19 -- NOTES
20 -- This package is publicly available for use
21 --
22 --
23 --
24 -- HISTORY
25 -- 12/12/99 JHIBNER Created
26 -- End of Comments
27
28
29 -- ***********************
30 -- Composite Types
31 -- ***********************
32
33 -- Start of Comments
34 --
35 -- OSI Opportunity Header Record: osi_rec_type
36 --
37 -- Required:
38 -- LEAD_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
39 -- CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN
40 --
41 -- Defaults:
42 -- LAST_UPDATE_DATE, LAST_UPDATED_BY,
43 -- CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN get standard stuff
44 -- End of Comments
45
46 TYPE osi_rec_type IS RECORD
47 ( last_update_date Date := FND_API.G_MISS_DATE,
48 last_updated_by varchar2(30) := FND_API.G_MISS_CHAR,
49 creation_Date Date := FND_API.G_MISS_DATE,
50 created_by varchar2(30) := FND_API.G_MISS_CHAR,
51 last_update_login varchar2(30) := FND_API.G_MISS_CHAR,
52 lead_id NUMBER := FND_API.G_MISS_NUM,
53 osi_lead_id NUMBER := FND_API.G_MISS_NUM,
54 CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
56 PO_FROM VARCHAR2(30) := FND_API.G_MISS_CHAR,
57 CONTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 CONTR_DRAFTING_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
59 PRIORITY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 SENIOR_CONTR_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
61 CONTR_SPEC_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 BOM_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 LEGAL_person_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 HIGHEST_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 CURRENT_APVL_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
66 SUPPORT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 INTERNATIONAL_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
68 CREDIT_APVL VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 FIN_ESCROW_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
70 FIN_ESCROW_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
71 CSI_ROLLIN VARCHAR2(30) := FND_API.G_MISS_CHAR,
72 LICENCE_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 SUPPORT_CREDIT_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
74 MD_DEAL_SUMMARY VARCHAR2(30) := FND_API.G_MISS_CHAR,
75 PROD_AVAIL_VER VARCHAR2(30) := FND_API.G_MISS_CHAR,
76 SHIP_LOCATION VARCHAR2(30) := FND_API.G_MISS_CHAR,
77 TAX_EXEMPT_CERT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 NL_REV_ALLOC_REQ VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 CONSULTING_CC VARCHAR2(30) := FND_API.G_MISS_CHAR,
80 SENIOR_CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81 LEGAL_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82 BOM_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83 CONTR_NOTES VARCHAR2(2000) := FND_API.G_MISS_CHAR,
84 CONTR_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
85 EXTRA_DOCS VARCHAR2(30) := FND_API.G_MISS_CHAR,
86 CUST_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
87 SITE_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
88 OPPY_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
89 );
90
91 G_MISS_OSI_REC osi_rec_type;
92
93 -- Start of Comments
94 --
95 -- Opportunity Table: osi_tbl_type
96 --
97 --
98 -- End of Comments
99
100 TYPE osi_tbl_type IS TABLE OF osi_rec_type
101 INDEX BY BINARY_INTEGER;
102
103 G_MISS_OSI_TBL osi_tbl_type;
104
105 TYPE osi_cvb_rec_type IS RECORD
106 ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
107 VEHICLE VARCHAR2(100) := FND_API.G_MISS_CHAR
108 );
109
110 G_MISS_OSI_CVB_REC osi_cvb_rec_type;
111
112 TYPE osi_cvb_tbl_type IS TABLE OF osi_cvb_rec_type
113 INDEX BY BINARY_INTEGER;
114
115 G_MISS_OSI_CVB_TBL osi_cvb_tbl_type;
116
117 TYPE osi_cnb_rec_type IS RECORD
118 ( CVEHICLE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119 CONTR_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR,
120 CNAME_ID VARCHAR2(30) := FND_API.G_MISS_CHAR
121 );
122
123 G_MISS_OSI_CNB_REC osi_cnb_rec_type;
124
125 TYPE osi_cnb_tbl_type IS TABLE OF osi_cnb_rec_type
126 INDEX BY BINARY_INTEGER;
127
128 G_MISS_OSI_CNB_TBL osi_cnb_tbl_type;
129
130 TYPE osi_lkp_rec_type IS RECORD
131 ( LKP_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
132 LKP_CODE VARCHAR2(100) := FND_API.G_MISS_CHAR,
133 LKP_VALUE VARCHAR2(200) := FND_API.G_MISS_CHAR
134 );
135
136 G_MISS_OSI_LKP_REC osi_lkp_rec_type;
137
138 TYPE osi_lkp_tbl_type IS TABLE OF osi_lkp_rec_type
139 INDEX BY BINARY_INTEGER;
140
141 G_MISS_OSI_LKP_TBL osi_lkp_tbl_type;
142
143 TYPE osi_nam_rec_type IS RECORD
144 ( NAM_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
145 NAM_ID VARCHAR2(30) := FND_API.G_MISS_CHAR,
146 NAM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
147 );
148
149 G_MISS_OSI_NAM_REC osi_nam_rec_type;
150
151 TYPE osi_nam_tbl_type IS TABLE OF osi_nam_rec_type
152 INDEX BY BINARY_INTEGER;
153
154 G_MISS_OSI_NAM_TBL osi_nam_tbl_type;
155
156 TYPE osi_ccs_rec_type IS RECORD
157 ( CC VARCHAR2(3) := FND_API.G_MISS_CHAR,
158 CENTER_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
159 );
160
161 G_MISS_OSI_CCS_REC osi_ccs_rec_type;
162
163 TYPE osi_ccs_tbl_type IS TABLE OF osi_ccs_rec_type
164 INDEX BY BINARY_INTEGER;
165
166 G_MISS_OSI_CCS_TBL osi_ccs_tbl_type;
167
168 TYPE osi_ovm_rec_type IS RECORD
169 ( OVM_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
170 OVM_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR
171 );
172
173 G_MISS_OSI_OVM_REC osi_ovm_rec_type;
174
175 TYPE osi_ovm_tbl_type IS TABLE OF osi_ovm_rec_type
176 INDEX BY BINARY_INTEGER;
177
178 G_MISS_OSI_OVM_TBL osi_ovm_tbl_type;
179
180 TYPE osi_ovd_rec_type IS RECORD
181 ( OVD_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
182 OVD_FLAG VARCHAR2(30) := FND_API.G_MISS_CHAR
183 );
184
185 G_MISS_OSI_OVD_REC osi_ovd_rec_type;
186
187 TYPE osi_ovd_tbl_type IS TABLE OF osi_ovd_rec_type
188 INDEX BY BINARY_INTEGER;
189
190 G_MISS_OSI_OVD_TBL osi_ovd_tbl_type;
191
192 PROCEDURE osi_lead_fetch
193 ( p_api_version_number IN NUMBER,
194 p_lead_id in VARCHAR2,
195 p_osi_rec out OSI_REC_TYPE ,
196 p_osi_ovd_tbl out OSI_OVD_TBL_TYPE
197 );
198 PROCEDURE osi_lead_fetch_all
199 ( p_api_version_number IN NUMBER,
200 p_lead_id in VARCHAR2,
201 p_osi_rec out OSI_REC_TYPE ,
202 p_osi_cvb_tbl out OSI_CVB_TBL_TYPE ,
203 p_osi_cnb_tbl out OSI_CNB_TBL_TYPE ,
204 p_osi_lkp_tbl out OSI_LKP_TBL_TYPE,
205 p_osi_nam_tbl out OSI_NAM_TBL_TYPE,
206 p_osi_ccs_tbl out OSI_CCS_TBL_TYPE,
207 p_osi_ovd_tbl out OSI_OVD_TBL_TYPE,
208 p_osi_ovm_tbl out OSI_OVM_TBL_TYPE
209 );
210 PROCEDURE osi_lookup_fetch_all
211 ( p_api_version_number IN NUMBER,
212 p_osi_cvb_tbl out OSI_CVB_TBL_TYPE ,
213 p_osi_cnb_tbl out OSI_CNB_TBL_TYPE ,
214 p_osi_lkp_tbl out OSI_LKP_TBL_TYPE,
215 p_osi_nam_tbl out OSI_NAM_TBL_TYPE,
216 p_osi_ccs_tbl out OSI_CCS_TBL_TYPE,
217 p_osi_ovm_tbl out OSI_OVM_TBL_TYPE
218 );
219 PROCEDURE osi_lead_update
220 ( p_api_version_number IN NUMBER,
221 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
222 p_commit IN VARCHAR2 := FND_API.G_FALSE,
223 p_osi_rec IN OSI_REC_TYPE,
224 p_osi_ovd_tbl IN OSI_OVD_TBL_TYPE,
225 x_return_status OUT VARCHAR2,
226 x_msg_count OUT VARCHAR2,
227 x_msg_data OUT VARCHAR2
228 );
229 PROCEDURE osi_cvb_fetch
230 ( p_api_version_number IN NUMBER,
231 p_osi_cvb_tbl out OSI_CVB_TBL_TYPE
232 );
233 PROCEDURE osi_cnb_fetch
234 ( p_api_version_number IN NUMBER,
235 p_osi_cnb_tbl out OSI_CNB_TBL_TYPE
236 );
237 PROCEDURE osi_lkp_fetch
238 ( p_api_version_number IN NUMBER,
239 p_osi_lkp_type in varchar2,
240 p_osi_lkp_tbl out OSI_LKP_TBL_TYPE
241 );
242 PROCEDURE osi_nam_fetch
243 ( p_api_version_number IN NUMBER,
244 p_osi_nam_type in varchar2,
245 p_osi_nam_tbl out OSI_NAM_TBL_TYPE
246 );
247 PROCEDURE osi_ccs_fetch
248 ( p_api_version_number IN NUMBER,
249 p_osi_ccs_tbl out OSI_CCS_TBL_TYPE
250 );
251 PROCEDURE osi_ovm_fetch
252 ( p_api_version_number IN NUMBER,
253 p_osi_ovm_tbl out OSI_OVM_TBL_TYPE
254 );
255 FUNCTION osi_get_button_html
256 ( p_api_version_number IN NUMBER
257 ) return varchar2;
258 FUNCTION osi_get_js_html
259 ( p_api_version_number IN NUMBER
260 ) return varchar2;
261 end AS_OSI_LEAD_PUB;