eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PV_REFERRALS_PKG

Source


1 package PV_REFERRALS_PKG as
2 /* $Header: pvreferrals.pls 120.3 2006/04/18 15:39:27 saarumug ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_REFERRAL_ID in NUMBER,
6   X_ACTUAL_CURRENCY_CODE in VARCHAR2,
7   X_BENEFIT_TYPE_CODE in VARCHAR2,
8   X_CUSTOMER_CONTACT_PHONE_TYPE in VARCHAR2,
9   X_CUSTOMER_CONTACT_EMAIL_ADDRE in VARCHAR2,
10   X_CUSTOMER_CONTACT_PHONE_EXT in VARCHAR2,
11   X_DECLINE_REASON_CODE in VARCHAR2,
12   X_ENTITY_TYPE in VARCHAR2,
13   X_ORDER_ID in NUMBER,
14   X_CLAIM_ID in NUMBER,
15   X_CLAIM_NUMBER in VARCHAR2,
16   X_EST_COMPENSATION_AMT in NUMBER,
17   X_CURRENCY_CODE in VARCHAR2,
18   X_ACTUAL_COMPENSATION_AMT in NUMBER,
19   X_STATUS_CHANGE_DATE in DATE,
20   X_DUPLICATE_CUSTOMER_FLAG in VARCHAR2,
21   X_PARTNER_CUST_ACCOUNT_ID in NUMBER,
22   X_CUSTOMER_COUNTRY in VARCHAR2,
23   X_CUSTOMER_CONTACT_TITLE in VARCHAR2,
24   X_CUSTOMER_CONTACT_FIRST_NAME in VARCHAR2,
25   X_CUSTOMER_CONTACT_LAST_NAME in VARCHAR2,
26   X_CUSTOMER_CONTACT_CNTRY_CODE in VARCHAR2,
27   X_CUSTOMER_CONTACT_AREA_CODE in VARCHAR2,
28   X_CUSTOMER_CONTACT_PHONE_NO in VARCHAR2,
29   X_CUSTOMER_PROVINCE in VARCHAR2,
30   X_CUSTOMER_POSTAL_CODE in VARCHAR2,
31   X_CUSTOMER_COUNTY in VARCHAR2,
32   X_ENTITY_ID_LINKED_TO in NUMBER,
33   X_OBJECT_VERSION_NUMBER in NUMBER,
34   X_BENEFIT_ID in NUMBER,
35   X_REFERRAL_CODE in VARCHAR2,
36   X_REFERRAL_STATUS in VARCHAR2,
37   X_PARTNER_ID in NUMBER,
38   X_PARTNER_CONTACT_RESOURCE_ID in NUMBER,
39   X_CUSTOMER_PARTY_ID in NUMBER,
40   X_CUSTOMER_ORG_CONTACT_ID in NUMBER,
41   X_CUSTOMER_CONTACT_PARTY_ID in NUMBER,
42   X_CUSTOMER_PARTY_SITE_ID in NUMBER,
43   X_CUSTOMER_NAME in VARCHAR2,
44   X_CUSTOMER_ADDRESS_TYPE in VARCHAR2,
45   X_CUSTOMER_ADDRESS1 in VARCHAR2,
46   X_CUSTOMER_ADDRESS2 in VARCHAR2,
47   X_CUSTOMER_ADDRESS3 in VARCHAR2,
48   X_CUSTOMER_ADDRESS4 in VARCHAR2,
49   X_ADDRESS_LINES_PHONETIC in VARCHAR2,
50   X_CUSTOMER_CITY in VARCHAR2,
51   X_CUSTOMER_STATE in VARCHAR2,
52   X_REFERRAL_NAME in VARCHAR2,
53   X_DESCRIPTION in VARCHAR2,
54   X_CREATION_DATE in DATE,
55   X_CREATED_BY in NUMBER,
56   X_LAST_UPDATE_DATE in DATE,
57   X_LAST_UPDATED_BY in NUMBER,
58   X_LAST_UPDATE_LOGIN in NUMBER,
59   X_ORG_ID in NUMBER,
60   X_SECURITY_GROUP_ID in NUMBER,
61   X_CUSTOMER_NAME_PRONOUNCIATION in VARCHAR2,
62   X_RETURN_REASON_CODE in VARCHAR2,
63   X_ATTRIBUTE_CATEGORY in VARCHAR2,
64   X_ATTRIBUTE1  in VARCHAR2,
65   X_ATTRIBUTE2  in VARCHAR2,
66   X_ATTRIBUTE3  in VARCHAR2,
67   X_ATTRIBUTE4  in VARCHAR2,
68   X_ATTRIBUTE5   in VARCHAR2,
69   X_ATTRIBUTE6   in VARCHAR2,
70   X_ATTRIBUTE7   in VARCHAR2,
71   X_ATTRIBUTE8   in VARCHAR2,
72   X_ATTRIBUTE9   in VARCHAR2,
73   X_ATTRIBUTE10  in VARCHAR2,
74   X_ATTRIBUTE11  in VARCHAR2,
75   X_ATTRIBUTE12  in VARCHAR2,
76   X_ATTRIBUTE13  in VARCHAR2,
77   X_ATTRIBUTE14  in VARCHAR2,
78   X_ATTRIBUTE15  in VARCHAR2,
79   X_ATTRIBUTE16  in VARCHAR2,
80   X_ATTRIBUTE17  in VARCHAR2,
81   X_ATTRIBUTE18  in VARCHAR2,
82   X_ATTRIBUTE19  in VARCHAR2,
83   X_ATTRIBUTE20  in VARCHAR2,
84   X_ATTRIBUTE21  in VARCHAR2,
85   X_ATTRIBUTE22  in VARCHAR2,
86   X_ATTRIBUTE23  in VARCHAR2,
87   X_ATTRIBUTE24  in VARCHAR2
88   );
89 procedure LOCK_ROW (
90   X_REFERRAL_ID in NUMBER,
91   X_ACTUAL_CURRENCY_CODE in VARCHAR2,
92   X_BENEFIT_TYPE_CODE in VARCHAR2,
93   X_CUSTOMER_CONTACT_PHONE_TYPE in VARCHAR2,
94   X_CUSTOMER_CONTACT_EMAIL_ADDRE in VARCHAR2,
95   X_CUSTOMER_CONTACT_PHONE_EXT in VARCHAR2,
96   X_DECLINE_REASON_CODE in VARCHAR2,
97   X_ENTITY_TYPE in VARCHAR2,
98   X_ORDER_ID in NUMBER,
99   X_CLAIM_ID in NUMBER,
100   X_CLAIM_NUMBER in VARCHAR2,
101   X_EST_COMPENSATION_AMT in NUMBER,
102   X_CURRENCY_CODE in VARCHAR2,
103   X_ACTUAL_COMPENSATION_AMT in NUMBER,
104   X_STATUS_CHANGE_DATE in DATE,
105   X_DUPLICATE_CUSTOMER_FLAG in VARCHAR2,
106   X_PARTNER_CUST_ACCOUNT_ID in NUMBER,
107   X_CUSTOMER_COUNTRY in VARCHAR2,
108   X_CUSTOMER_CONTACT_TITLE in VARCHAR2,
109   X_CUSTOMER_CONTACT_FIRST_NAME in VARCHAR2,
110   X_CUSTOMER_CONTACT_LAST_NAME in VARCHAR2,
111   X_CUSTOMER_CONTACT_CNTRY_CODE in VARCHAR2,
112   X_CUSTOMER_CONTACT_AREA_CODE in VARCHAR2,
113   X_CUSTOMER_CONTACT_PHONE_NO in VARCHAR2,
114   X_CUSTOMER_PROVINCE in VARCHAR2,
115   X_CUSTOMER_POSTAL_CODE in VARCHAR2,
116   X_CUSTOMER_COUNTY in VARCHAR2,
117   X_ENTITY_ID_LINKED_TO in NUMBER,
118   X_OBJECT_VERSION_NUMBER in NUMBER,
119   X_BENEFIT_ID in NUMBER,
120   X_REFERRAL_CODE in VARCHAR2,
121   X_REFERRAL_STATUS in VARCHAR2,
122   X_PARTNER_ID in NUMBER,
123   X_PARTNER_CONTACT_RESOURCE_ID in NUMBER,
124   X_CUSTOMER_PARTY_ID in NUMBER,
125   X_CUSTOMER_ORG_CONTACT_ID in NUMBER,
126   X_CUSTOMER_CONTACT_PARTY_ID in NUMBER,
127   X_CUSTOMER_PARTY_SITE_ID in NUMBER,
128   X_CUSTOMER_NAME in VARCHAR2,
129   X_CUSTOMER_ADDRESS_TYPE in VARCHAR2,
130   X_CUSTOMER_ADDRESS1 in VARCHAR2,
131   X_CUSTOMER_ADDRESS2 in VARCHAR2,
132   X_CUSTOMER_ADDRESS3 in VARCHAR2,
133   X_CUSTOMER_ADDRESS4 in VARCHAR2,
134   X_ADDRESS_LINES_PHONETIC in VARCHAR2,
135   X_CUSTOMER_CITY in VARCHAR2,
136   X_CUSTOMER_STATE in VARCHAR2,
137   X_REFERRAL_NAME in VARCHAR2,
138   X_DESCRIPTION in VARCHAR2,
139   X_ORG_ID in NUMBER,
140   X_SECURITY_GROUP_ID in NUMBER,
141   X_CUSTOMER_NAME_PRONOUNCIATION in VARCHAR2,
142   X_RETURN_REASON_CODE in VARCHAR2,
143   X_ATTRIBUTE_CATEGORY in VARCHAR2,
144   X_ATTRIBUTE1  in VARCHAR2,
145   X_ATTRIBUTE2  in VARCHAR2,
146   X_ATTRIBUTE3  in VARCHAR2,
147   X_ATTRIBUTE4  in VARCHAR2,
148   X_ATTRIBUTE5   in VARCHAR2,
149   X_ATTRIBUTE6   in VARCHAR2,
150   X_ATTRIBUTE7   in VARCHAR2,
151   X_ATTRIBUTE8   in VARCHAR2,
152   X_ATTRIBUTE9   in VARCHAR2,
153   X_ATTRIBUTE10  in VARCHAR2,
154   X_ATTRIBUTE11  in VARCHAR2,
155   X_ATTRIBUTE12  in VARCHAR2,
156   X_ATTRIBUTE13  in VARCHAR2,
157   X_ATTRIBUTE14  in VARCHAR2,
158   X_ATTRIBUTE15  in VARCHAR2,
159   X_ATTRIBUTE16  in VARCHAR2,
160   X_ATTRIBUTE17  in VARCHAR2,
161   X_ATTRIBUTE18  in VARCHAR2,
162   X_ATTRIBUTE19  in VARCHAR2,
163   X_ATTRIBUTE20  in VARCHAR2,
164   X_ATTRIBUTE21  in VARCHAR2,
165   X_ATTRIBUTE22  in VARCHAR2,
166   X_ATTRIBUTE23  in VARCHAR2,
167   X_ATTRIBUTE24  in VARCHAR2
168 );
169 procedure UPDATE_ROW (
170   X_REFERRAL_ID in NUMBER,
171   X_ACTUAL_CURRENCY_CODE in VARCHAR2,
172   X_BENEFIT_TYPE_CODE in VARCHAR2,
173   X_CUSTOMER_CONTACT_PHONE_TYPE in VARCHAR2,
174   X_CUSTOMER_CONTACT_EMAIL_ADDRE in VARCHAR2,
175   X_CUSTOMER_CONTACT_PHONE_EXT in VARCHAR2,
176   X_DECLINE_REASON_CODE in VARCHAR2,
177   X_ENTITY_TYPE in VARCHAR2,
178   X_ORDER_ID in NUMBER,
179   X_CLAIM_ID in NUMBER,
180   X_CLAIM_NUMBER in VARCHAR2,
181   X_EST_COMPENSATION_AMT in NUMBER,
182   X_CURRENCY_CODE in VARCHAR2,
183   X_ACTUAL_COMPENSATION_AMT in NUMBER,
184   X_STATUS_CHANGE_DATE in DATE,
185   X_DUPLICATE_CUSTOMER_FLAG in VARCHAR2,
186   X_PARTNER_CUST_ACCOUNT_ID in NUMBER,
187   X_CUSTOMER_COUNTRY in VARCHAR2,
188   X_CUSTOMER_CONTACT_TITLE in VARCHAR2,
189   X_CUSTOMER_CONTACT_FIRST_NAME in VARCHAR2,
190   X_CUSTOMER_CONTACT_LAST_NAME in VARCHAR2,
191   X_CUSTOMER_CONTACT_CNTRY_CODE in VARCHAR2,
192   X_CUSTOMER_CONTACT_AREA_CODE in VARCHAR2,
193   X_CUSTOMER_CONTACT_PHONE_NO in VARCHAR2,
194   X_CUSTOMER_PROVINCE in VARCHAR2,
195   X_CUSTOMER_POSTAL_CODE in VARCHAR2,
196   X_CUSTOMER_COUNTY in VARCHAR2,
197   X_ENTITY_ID_LINKED_TO in NUMBER,
198   X_OBJECT_VERSION_NUMBER in NUMBER,
199   X_BENEFIT_ID in NUMBER,
200   X_REFERRAL_CODE in VARCHAR2,
201   X_REFERRAL_STATUS in VARCHAR2,
202   X_PARTNER_ID in NUMBER,
203   X_PARTNER_CONTACT_RESOURCE_ID in NUMBER,
204   X_CUSTOMER_PARTY_ID in NUMBER,
205   X_CUSTOMER_ORG_CONTACT_ID in NUMBER,
206   X_CUSTOMER_CONTACT_PARTY_ID in NUMBER,
207   X_CUSTOMER_PARTY_SITE_ID in NUMBER,
208   X_CUSTOMER_NAME in VARCHAR2,
209   X_CUSTOMER_ADDRESS_TYPE in VARCHAR2,
210   X_CUSTOMER_ADDRESS1 in VARCHAR2,
211   X_CUSTOMER_ADDRESS2 in VARCHAR2,
212   X_CUSTOMER_ADDRESS3 in VARCHAR2,
213   X_CUSTOMER_ADDRESS4 in VARCHAR2,
214   X_ADDRESS_LINES_PHONETIC in VARCHAR2,
215   X_CUSTOMER_CITY in VARCHAR2,
216   X_CUSTOMER_STATE in VARCHAR2,
217   X_REFERRAL_NAME in VARCHAR2,
218   X_DESCRIPTION in VARCHAR2,
219   X_LAST_UPDATE_DATE in DATE,
220   X_LAST_UPDATED_BY in NUMBER,
221   X_LAST_UPDATE_LOGIN in NUMBER,
222   X_ORG_ID in NUMBER,
223   X_SECURITY_GROUP_ID in NUMBER,
224   X_CUSTOMER_NAME_PRONOUNCIATION in VARCHAR2,
225   X_RETURN_REASON_CODE in VARCHAR2,
226   X_ATTRIBUTE_CATEGORY in VARCHAR2,
227   X_ATTRIBUTE1  in VARCHAR2,
228   X_ATTRIBUTE2  in VARCHAR2,
229   X_ATTRIBUTE3  in VARCHAR2,
230   X_ATTRIBUTE4  in VARCHAR2,
231   X_ATTRIBUTE5   in VARCHAR2,
232   X_ATTRIBUTE6   in VARCHAR2,
233   X_ATTRIBUTE7   in VARCHAR2,
234   X_ATTRIBUTE8   in VARCHAR2,
235   X_ATTRIBUTE9   in VARCHAR2,
236   X_ATTRIBUTE10  in VARCHAR2,
237   X_ATTRIBUTE11  in VARCHAR2,
238   X_ATTRIBUTE12  in VARCHAR2,
239   X_ATTRIBUTE13  in VARCHAR2,
240   X_ATTRIBUTE14  in VARCHAR2,
241   X_ATTRIBUTE15  in VARCHAR2,
242   X_ATTRIBUTE16  in VARCHAR2,
243   X_ATTRIBUTE17  in VARCHAR2,
244   X_ATTRIBUTE18  in VARCHAR2,
245   X_ATTRIBUTE19  in VARCHAR2,
246   X_ATTRIBUTE20  in VARCHAR2,
247   X_ATTRIBUTE21  in VARCHAR2,
248   X_ATTRIBUTE22  in VARCHAR2,
249   X_ATTRIBUTE23  in VARCHAR2,
250   X_ATTRIBUTE24  in VARCHAR2
251 );
252 procedure DELETE_ROW (
253   X_REFERRAL_ID in NUMBER
254 );
255 procedure ADD_LANGUAGE;
256 end PV_REFERRALS_PKG;