[Home] [Help]
PACKAGE BODY: APPS.ARP_CONT_PKG
Source
1 PACKAGE BODY arp_cont_pkg as
2 /* $Header: AROCONTB.pls 120.1 2005/08/11 00:42:38 hyu noship $ */
3 --
4 -- PROCEDURE
5 -- check_unique_contact_name
6 --
7 -- DESCRIPTION
8 -- This procedure checks that a contact name is unique.
9 -- If it is not it sets a message on the stack and returns
10 -- a warning flag.
11 --
12 -- SCOPE - PUBLIC
13 --
14 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
15 --
16 -- ARGUMENTS : IN: x_rowid - uid of row
17 -- x_customer_id - customer_id
18 -- x_first_name -
19 -- x_last_name
20 -- OUT:
21 -- x_warning_flag - W - Warning generated
22 -- null - no warning genrated
23 -- NOTES
24 --
25 --
26 --
27 --
28 PROCEDURE check_unique_contact_name ( x_rowid IN VARCHAR2,
29 x_customer_id IN NUMBER,
30 x_first_name IN VARCHAR2,
31 x_last_name IN VARCHAR2,
32 x_warning_flag IN OUT NOCOPY VARCHAR2 ) IS
33 begin
34 NULL;
35 END check_unique_contact_name;
36 --
37 --
38 --
39 --
40 --
41 -- PROCEDURE
42 -- check_unique_orig_system_ref
43 --
44 -- DESCRIPTION
45 -- This procedure checks that orig_system_reference is unique.
46 -- If it is not it sets a message on the stack and returns
47 -- failure.
48 --
49 -- SCOPE - PUBLIC
50 --
51 -- EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
52 --
53 -- ARGUMENTS : IN: x_rowid - uid of row
54 -- x_orig_system_reference - value to check
55 -- OUT:
56
57 -- NOTES
58 --
59 --
60 --
61 --
62 PROCEDURE check_unique_orig_system_ref( x_rowid IN VARCHAR2,
63 x_orig_system_reference IN VARCHAR2 ) IS
64 --
65 --
66 begin
67 NULL;
68 end check_unique_orig_system_ref;
69
70 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
71 X_Contact_Id IN OUT NOCOPY NUMBER,
72 X_Created_By NUMBER,
73 X_Creation_Date DATE,
74 X_Customer_Id NUMBER,
75 X_Last_Name VARCHAR2,
76 X_Last_Updated_By NUMBER,
77 X_Last_Update_Date DATE,
78 X_Orig_System_Reference IN OUT NOCOPY VARCHAR2,
79 X_Status VARCHAR2,
80 X_Address_Id NUMBER,
81 X_Contact_Key VARCHAR2,
82 X_First_Name VARCHAR2,
83 X_Job_Title VARCHAR2,
84 X_Last_Update_Login NUMBER,
85 X_Mail_Stop VARCHAR2,
86 X_Title VARCHAR2,
87 X_Attribute_Category VARCHAR2,
88 X_Attribute1 VARCHAR2,
89 X_Attribute2 VARCHAR2,
90 X_Attribute3 VARCHAR2,
91 X_Attribute4 VARCHAR2,
92 X_Attribute5 VARCHAR2,
93 X_Attribute6 VARCHAR2,
94 X_Attribute7 VARCHAR2,
95 X_Attribute8 VARCHAR2,
96 X_Attribute9 VARCHAR2,
97 X_Attribute10 VARCHAR2,
98 X_Attribute11 VARCHAR2,
99 X_Attribute12 VARCHAR2,
100 X_Attribute13 VARCHAR2,
101 X_Attribute14 VARCHAR2,
102 X_Attribute15 VARCHAR2,
103 X_Attribute16 VARCHAR2,
104 X_Attribute17 VARCHAR2,
105 X_Attribute18 VARCHAR2,
106 X_Attribute19 VARCHAR2,
107 X_Attribute20 VARCHAR2,
108 X_Attribute21 VARCHAR2,
109 X_Attribute22 VARCHAR2,
110 X_Attribute23 VARCHAR2,
111 X_Attribute24 VARCHAR2,
112 X_Attribute25 VARCHAR2,
113 X_Email_Address VARCHAR2,
114 X_Last_Name_Alt VARCHAR2 default null,
115 X_First_Name_Alt VARCHAR2 default null
116 ) IS
117
118 BEGIN
119 NULL;
120 END Insert_Row;
121
122
123 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
124 X_contact_id number,
125 X_Last_Name VARCHAR2,
126 X_Status VARCHAR2,
127 X_Contact_Key VARCHAR2,
128 X_First_Name VARCHAR2,
129 X_Job_Title VARCHAR2,
130 X_Mail_Stop VARCHAR2,
131 X_Title VARCHAR2,
132 X_Attribute_Category VARCHAR2,
133 X_Attribute1 VARCHAR2,
134 X_Attribute2 VARCHAR2,
135 X_Attribute3 VARCHAR2,
136 X_Attribute4 VARCHAR2,
137 X_Attribute5 VARCHAR2,
138 X_Attribute6 VARCHAR2,
139 X_Attribute7 VARCHAR2,
140 X_Attribute8 VARCHAR2,
141 X_Attribute9 VARCHAR2,
142 X_Attribute10 VARCHAR2,
143 X_Attribute11 VARCHAR2,
144 X_Attribute12 VARCHAR2,
145 X_Attribute13 VARCHAR2,
146 X_Attribute14 VARCHAR2,
147 X_Attribute15 VARCHAR2,
148 X_Attribute16 VARCHAR2,
149 X_Attribute17 VARCHAR2,
150 X_Attribute18 VARCHAR2,
151 X_Attribute19 VARCHAR2,
152 X_Attribute20 VARCHAR2,
153 X_Attribute21 VARCHAR2,
154 X_Attribute22 VARCHAR2,
155 X_Attribute23 VARCHAR2,
156 X_Attribute24 VARCHAR2,
157 X_Attribute25 VARCHAR2,
158 X_Email_Address VARCHAR2,
159 X_Last_Name_Alt VARCHAR2 default g_varchar2,
160 X_First_Name_Alt VARCHAR2 default g_varchar2
161 ) IS
162 BEGIN
163 NULL;
164 END Lock_Row;
165
166
167
168 PROCEDURE Update_Row(X_Rowid VARCHAR2,
169 X_contact_id number,
170 X_Last_Name VARCHAR2,
171 X_Last_Updated_By NUMBER,
172 X_Last_Update_Date DATE,
173 X_Status VARCHAR2,
174 X_Contact_Key VARCHAR2,
175 X_First_Name VARCHAR2,
176 X_Job_Title VARCHAR2,
177 X_Last_Update_Login NUMBER,
178 X_Mail_Stop VARCHAR2,
179 X_Title VARCHAR2,
180 X_Attribute_Category VARCHAR2,
181 X_Attribute1 VARCHAR2,
182 X_Attribute2 VARCHAR2,
183 X_Attribute3 VARCHAR2,
184 X_Attribute4 VARCHAR2,
185 X_Attribute5 VARCHAR2,
186 X_Attribute6 VARCHAR2,
187 X_Attribute7 VARCHAR2,
188 X_Attribute8 VARCHAR2,
189 X_Attribute9 VARCHAR2,
190 X_Attribute10 VARCHAR2,
191 X_Attribute11 VARCHAR2,
192 X_Attribute12 VARCHAR2,
193 X_Attribute13 VARCHAR2,
194 X_Attribute14 VARCHAR2,
195 X_Attribute15 VARCHAR2,
196 X_Attribute16 VARCHAR2,
197 X_Attribute17 VARCHAR2,
198 X_Attribute18 VARCHAR2,
199 X_Attribute19 VARCHAR2,
200 X_Attribute20 VARCHAR2,
201 X_Attribute21 VARCHAR2,
202 X_Attribute22 VARCHAR2,
203 X_Attribute23 VARCHAR2,
204 X_Attribute24 VARCHAR2,
205 X_Attribute25 VARCHAR2,
206 X_Email_Address VARCHAR2,
207 X_Last_Name_Alt VARCHAR2 default g_varchar2,
208 X_First_Name_Alt VARCHAR2 default g_varchar2
209 ) IS
210 BEGIN
211 NULL;
212 END Update_Row;
213
214
215
216 END arp_cont_pkg;