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.

APPS.PER_PAR_BUS dependencies on PER_PAR_SHD

Line 28: Procedure chk_non_updateable_args(p_rec in per_par_shd.g_rec_type) is

24: -- ----------------------------------------------------------------------------
25: -- |----------------------< chk_non_updateable_args >-----------------------|
26: -- ----------------------------------------------------------------------------
27: --
28: Procedure chk_non_updateable_args(p_rec in per_par_shd.g_rec_type) is
29: --
30: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
31: l_error exception;
32: l_argument varchar2(30);

Line 40: if not per_par_shd.api_updating

36: --
37: -- Only proceed with validation if a row exists for
38: -- the current record in the HR Schema
39: --
40: if not per_par_shd.api_updating
41: (p_participant_id => p_rec.participant_id
42: ,p_object_version_number => p_rec.object_version_number
43: ) then
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 51: if p_rec.business_group_id <> per_par_shd.g_old_rec.business_group_id then

47: end if;
48: --
49: hr_utility.set_location(l_proc, 6);
50: --
51: if p_rec.business_group_id <> per_par_shd.g_old_rec.business_group_id then
52: l_argument := 'business_group_id';
53: raise l_error;
54: -- elsif p_rec.questionnaire_template_id <> per_par_shd.g_old_rec.questionnaire_template_id then
55: -- l_argument := 'questionnaire_template_id';

Line 54: -- elsif p_rec.questionnaire_template_id <> per_par_shd.g_old_rec.questionnaire_template_id then

50: --
51: if p_rec.business_group_id <> per_par_shd.g_old_rec.business_group_id then
52: l_argument := 'business_group_id';
53: raise l_error;
54: -- elsif p_rec.questionnaire_template_id <> per_par_shd.g_old_rec.questionnaire_template_id then
55: -- l_argument := 'questionnaire_template_id';
56: -- raise l_error;
57: elsif p_rec.participation_in_table <> per_par_shd.g_old_rec.participation_in_table then
58: hr_utility.set_location(l_proc, 7);

Line 57: elsif p_rec.participation_in_table <> per_par_shd.g_old_rec.participation_in_table then

53: raise l_error;
54: -- elsif p_rec.questionnaire_template_id <> per_par_shd.g_old_rec.questionnaire_template_id then
55: -- l_argument := 'questionnaire_template_id';
56: -- raise l_error;
57: elsif p_rec.participation_in_table <> per_par_shd.g_old_rec.participation_in_table then
58: hr_utility.set_location(l_proc, 7);
59: l_argument := 'participation_in_table';
60: raise l_error;
61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then

Line 61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then

57: elsif p_rec.participation_in_table <> per_par_shd.g_old_rec.participation_in_table then
58: hr_utility.set_location(l_proc, 7);
59: l_argument := 'participation_in_table';
60: raise l_error;
61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then
62: hr_utility.set_location(l_proc, 8);
63: l_argument := 'participation_in_column';
64: raise l_error;
65: elsif p_rec.participation_in_id <> per_par_shd.g_old_rec.participation_in_id then

Line 65: elsif p_rec.participation_in_id <> per_par_shd.g_old_rec.participation_in_id then

61: elsif p_rec.participation_in_column <> per_par_shd.g_old_rec.participation_in_column then
62: hr_utility.set_location(l_proc, 8);
63: l_argument := 'participation_in_column';
64: raise l_error;
65: elsif p_rec.participation_in_id <> per_par_shd.g_old_rec.participation_in_id then
66: hr_utility.set_location(l_proc, 9);
67: l_argument := 'participation_in_id';
68: raise l_error;
69: end if;

Line 77: ,p_base_table => per_par_shd.g_tab_nam);

73: when l_error then
74: hr_api.argument_changed_error
75: (p_api_name => l_proc
76: ,p_argument => l_argument
77: ,p_base_table => per_par_shd.g_tab_nam);
78: when others then
79: raise;
80: hr_utility.set_location(' Leaving:'||l_proc, 12);
81: end chk_non_updateable_args;

Line 114: (p_rec in per_par_shd.g_rec_type

110: -- Access Status:
111: -- Internal Row Handler Development Only.
112: -- ----------------------------------------------------------------------------
113: procedure chk_update_allowed
114: (p_rec in per_par_shd.g_rec_type
115: )
116: is
117: --
118: l_proc varchar2(72) := g_package || 'chk_update_allowed';

Line 132: <> per_par_shd.g_old_rec.date_completed then

128: if ( p_rec.participation_status = 'REJECTED') then
129: -- Check that the columns arent being updated
130: --
131: if p_rec.date_completed
132: <> per_par_shd.g_old_rec.date_completed then
133: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
134: fnd_message.raise_error;
135: elsif p_rec.participation_type
136: <> per_par_shd.g_old_rec.participation_type then

Line 136: <> per_par_shd.g_old_rec.participation_type then

132: <> per_par_shd.g_old_rec.date_completed then
133: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
134: fnd_message.raise_error;
135: elsif p_rec.participation_type
136: <> per_par_shd.g_old_rec.participation_type then
137: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
138: fnd_message.raise_error;
139: elsif p_rec.last_notified_date
140: <> per_par_shd.g_old_rec.last_notified_date then

Line 140: <> per_par_shd.g_old_rec.last_notified_date then

136: <> per_par_shd.g_old_rec.participation_type then
137: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
138: fnd_message.raise_error;
139: elsif p_rec.last_notified_date
140: <> per_par_shd.g_old_rec.last_notified_date then
141: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
142: fnd_message.raise_error;
143: elsif p_rec.comments
144: <> per_par_shd.g_old_rec.comments then

Line 144: <> per_par_shd.g_old_rec.comments then

140: <> per_par_shd.g_old_rec.last_notified_date then
141: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
142: fnd_message.raise_error;
143: elsif p_rec.comments
144: <> per_par_shd.g_old_rec.comments then
145: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
146: fnd_message.raise_error;
147: elsif p_rec.person_id
148: <> per_par_shd.g_old_rec.person_id then

Line 148: <> per_par_shd.g_old_rec.person_id then

144: <> per_par_shd.g_old_rec.comments then
145: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
146: fnd_message.raise_error;
147: elsif p_rec.person_id
148: <> per_par_shd.g_old_rec.person_id then
149: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
150: fnd_message.raise_error;
151: elsif p_rec.attribute_category
152: <> per_par_shd.g_old_rec.attribute_category then

Line 152: <> per_par_shd.g_old_rec.attribute_category then

148: <> per_par_shd.g_old_rec.person_id then
149: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
150: fnd_message.raise_error;
151: elsif p_rec.attribute_category
152: <> per_par_shd.g_old_rec.attribute_category then
153: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
154: fnd_message.raise_error;
155: elsif p_rec.attribute1
156: <> per_par_shd.g_old_rec.attribute1 then

Line 156: <> per_par_shd.g_old_rec.attribute1 then

152: <> per_par_shd.g_old_rec.attribute_category then
153: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
154: fnd_message.raise_error;
155: elsif p_rec.attribute1
156: <> per_par_shd.g_old_rec.attribute1 then
157: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
158: fnd_message.raise_error;
159: elsif p_rec.attribute2
160: <> per_par_shd.g_old_rec.attribute2 then

Line 160: <> per_par_shd.g_old_rec.attribute2 then

156: <> per_par_shd.g_old_rec.attribute1 then
157: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
158: fnd_message.raise_error;
159: elsif p_rec.attribute2
160: <> per_par_shd.g_old_rec.attribute2 then
161: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
162: fnd_message.raise_error;
163: elsif p_rec.attribute3
164: <> per_par_shd.g_old_rec.attribute3 then

Line 164: <> per_par_shd.g_old_rec.attribute3 then

160: <> per_par_shd.g_old_rec.attribute2 then
161: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
162: fnd_message.raise_error;
163: elsif p_rec.attribute3
164: <> per_par_shd.g_old_rec.attribute3 then
165: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
166: fnd_message.raise_error;
167: elsif p_rec.attribute4
168: <> per_par_shd.g_old_rec.attribute4 then

Line 168: <> per_par_shd.g_old_rec.attribute4 then

164: <> per_par_shd.g_old_rec.attribute3 then
165: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
166: fnd_message.raise_error;
167: elsif p_rec.attribute4
168: <> per_par_shd.g_old_rec.attribute4 then
169: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
170: fnd_message.raise_error;
171: elsif p_rec.attribute5
172: <> per_par_shd.g_old_rec.attribute5 then

Line 172: <> per_par_shd.g_old_rec.attribute5 then

168: <> per_par_shd.g_old_rec.attribute4 then
169: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
170: fnd_message.raise_error;
171: elsif p_rec.attribute5
172: <> per_par_shd.g_old_rec.attribute5 then
173: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
174: fnd_message.raise_error;
175: elsif p_rec.attribute6
176: <> per_par_shd.g_old_rec.attribute6 then

Line 176: <> per_par_shd.g_old_rec.attribute6 then

172: <> per_par_shd.g_old_rec.attribute5 then
173: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
174: fnd_message.raise_error;
175: elsif p_rec.attribute6
176: <> per_par_shd.g_old_rec.attribute6 then
177: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
178: fnd_message.raise_error;
179: elsif p_rec.attribute7
180: <> per_par_shd.g_old_rec.attribute7 then

Line 180: <> per_par_shd.g_old_rec.attribute7 then

176: <> per_par_shd.g_old_rec.attribute6 then
177: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
178: fnd_message.raise_error;
179: elsif p_rec.attribute7
180: <> per_par_shd.g_old_rec.attribute7 then
181: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
182: fnd_message.raise_error;
183: elsif p_rec.attribute8
184: <> per_par_shd.g_old_rec.attribute8 then

Line 184: <> per_par_shd.g_old_rec.attribute8 then

180: <> per_par_shd.g_old_rec.attribute7 then
181: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
182: fnd_message.raise_error;
183: elsif p_rec.attribute8
184: <> per_par_shd.g_old_rec.attribute8 then
185: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
186: fnd_message.raise_error;
187: elsif p_rec.attribute9
188: <> per_par_shd.g_old_rec.attribute9 then

Line 188: <> per_par_shd.g_old_rec.attribute9 then

184: <> per_par_shd.g_old_rec.attribute8 then
185: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
186: fnd_message.raise_error;
187: elsif p_rec.attribute9
188: <> per_par_shd.g_old_rec.attribute9 then
189: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
190: fnd_message.raise_error;
191: elsif p_rec.attribute10
192: <> per_par_shd.g_old_rec.attribute10 then

Line 192: <> per_par_shd.g_old_rec.attribute10 then

188: <> per_par_shd.g_old_rec.attribute9 then
189: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
190: fnd_message.raise_error;
191: elsif p_rec.attribute10
192: <> per_par_shd.g_old_rec.attribute10 then
193: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
194: fnd_message.raise_error;
195: elsif p_rec.attribute11
196: <> per_par_shd.g_old_rec.attribute11 then

Line 196: <> per_par_shd.g_old_rec.attribute11 then

192: <> per_par_shd.g_old_rec.attribute10 then
193: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
194: fnd_message.raise_error;
195: elsif p_rec.attribute11
196: <> per_par_shd.g_old_rec.attribute11 then
197: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
198: fnd_message.raise_error;
199: elsif p_rec.attribute12
200: <> per_par_shd.g_old_rec.attribute12 then

Line 200: <> per_par_shd.g_old_rec.attribute12 then

196: <> per_par_shd.g_old_rec.attribute11 then
197: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
198: fnd_message.raise_error;
199: elsif p_rec.attribute12
200: <> per_par_shd.g_old_rec.attribute12 then
201: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
202: fnd_message.raise_error;
203: elsif p_rec.attribute13
204: <> per_par_shd.g_old_rec.attribute13 then

Line 204: <> per_par_shd.g_old_rec.attribute13 then

200: <> per_par_shd.g_old_rec.attribute12 then
201: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
202: fnd_message.raise_error;
203: elsif p_rec.attribute13
204: <> per_par_shd.g_old_rec.attribute13 then
205: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
206: fnd_message.raise_error;
207: elsif p_rec.attribute14
208: <> per_par_shd.g_old_rec.attribute14 then

Line 208: <> per_par_shd.g_old_rec.attribute14 then

204: <> per_par_shd.g_old_rec.attribute13 then
205: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
206: fnd_message.raise_error;
207: elsif p_rec.attribute14
208: <> per_par_shd.g_old_rec.attribute14 then
209: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
210: fnd_message.raise_error;
211: elsif p_rec.attribute15
212: <> per_par_shd.g_old_rec.attribute15 then

Line 212: <> per_par_shd.g_old_rec.attribute15 then

208: <> per_par_shd.g_old_rec.attribute14 then
209: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
210: fnd_message.raise_error;
211: elsif p_rec.attribute15
212: <> per_par_shd.g_old_rec.attribute15 then
213: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
214: fnd_message.raise_error;
215: elsif p_rec.attribute16
216: <> per_par_shd.g_old_rec.attribute16 then

Line 216: <> per_par_shd.g_old_rec.attribute16 then

212: <> per_par_shd.g_old_rec.attribute15 then
213: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
214: fnd_message.raise_error;
215: elsif p_rec.attribute16
216: <> per_par_shd.g_old_rec.attribute16 then
217: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
218: fnd_message.raise_error;
219: elsif p_rec.attribute17
220: <> per_par_shd.g_old_rec.attribute17 then

Line 220: <> per_par_shd.g_old_rec.attribute17 then

216: <> per_par_shd.g_old_rec.attribute16 then
217: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
218: fnd_message.raise_error;
219: elsif p_rec.attribute17
220: <> per_par_shd.g_old_rec.attribute17 then
221: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
222: fnd_message.raise_error;
223: elsif p_rec.attribute18
224: <> per_par_shd.g_old_rec.attribute18 then

Line 224: <> per_par_shd.g_old_rec.attribute18 then

220: <> per_par_shd.g_old_rec.attribute17 then
221: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
222: fnd_message.raise_error;
223: elsif p_rec.attribute18
224: <> per_par_shd.g_old_rec.attribute18 then
225: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
226: fnd_message.raise_error;
227: elsif p_rec.attribute19
228: <> per_par_shd.g_old_rec.attribute19 then

Line 228: <> per_par_shd.g_old_rec.attribute19 then

224: <> per_par_shd.g_old_rec.attribute18 then
225: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
226: fnd_message.raise_error;
227: elsif p_rec.attribute19
228: <> per_par_shd.g_old_rec.attribute19 then
229: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
230: fnd_message.raise_error;
231: elsif p_rec.attribute20
232: <> per_par_shd.g_old_rec.attribute20 then

Line 232: <> per_par_shd.g_old_rec.attribute20 then

228: <> per_par_shd.g_old_rec.attribute19 then
229: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
230: fnd_message.raise_error;
231: elsif p_rec.attribute20
232: <> per_par_shd.g_old_rec.attribute20 then
233: fnd_message.set_name('PER','PER_52465_PAR_UPD_NOT_ALLOWED');
234: fnd_message.raise_error;
235: end if;
236: end if;

Line 289: l_api_updating := per_par_shd.api_updating

285: begin
286: --
287: hr_utility.set_location('Entering: '||l_proc,10);
288: --
289: l_api_updating := per_par_shd.api_updating
290: (p_participant_id => p_participant_id
291: ,p_object_version_number => p_object_version_number
292: );
293: --

Line 298: if l_api_updating and (per_par_shd.g_old_rec.participation_type <> null) then

294: hr_utility.set_location(l_proc,20);
295: --
296: -- Check that update is allowed
297: --
298: if l_api_updating and (per_par_shd.g_old_rec.participation_type <> null) then
299: hr_utility.set_message(801,'PER_52466_PAR_TYPE_VAL_EXISTS');
300: hr_utility.raise_error;
301: else
302: if (p_participation_type <> null) and

Line 890: l_api_updating := per_par_shd.api_updating

886: -- Only proceed with validation if :
887: -- a) The current g_old_rec is current and
888: -- b) The value for participant role has changed
889: --
890: l_api_updating := per_par_shd.api_updating
891: (p_participant_id => p_participant_id
892: ,p_object_version_number => p_object_version_number);
893: --
894: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,

Line 894: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,

890: l_api_updating := per_par_shd.api_updating
891: (p_participant_id => p_participant_id
892: ,p_object_version_number => p_object_version_number);
893: --
894: if ( (l_api_updating and nvl(per_par_shd.g_old_rec.person_id,
895: hr_api.g_number)
896: <> nvl(p_person_id,hr_api.g_number)
897: ) or
898: (NOT l_api_updating)

Line 1017: (p_rec in per_par_shd.g_rec_type) is

1013: -- Access Status:
1014: -- Internal Row Handler Use Only.
1015: --
1016: procedure chk_df
1017: (p_rec in per_par_shd.g_rec_type) is
1018: --
1019: l_proc varchar2(72) := g_package||'chk_df';
1020: --
1021: begin

Line 1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1021: begin
1022: hr_utility.set_location('Entering:'||l_proc, 10);
1023: --
1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1023: --
1024: if ((p_rec.participant_id is not null) and (
1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1025: nvl(per_par_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1026: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1027: nvl(per_par_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1028: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1029: nvl(per_par_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1030: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1031: nvl(per_par_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1032: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1033: nvl(per_par_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1034: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1035: nvl(per_par_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1036: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1037: nvl(per_par_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1038: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1039: nvl(per_par_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1040: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1041: nvl(per_par_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1042: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1043: nvl(per_par_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1044: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1045: nvl(per_par_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1046: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1047: nvl(per_par_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1049: nvl(per_par_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1050: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1051: nvl(per_par_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1052: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1053: nvl(per_par_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1054: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1055: nvl(per_par_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1056: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1057: nvl(per_par_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1058: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1059: nvl(per_par_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1060: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or

Line 1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1061: nvl(per_par_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1062: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1063: nvl(per_par_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1064: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1065: nvl(per_par_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1066: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1067: or
1068: (p_rec.participant_id is null) then
1069: --

Line 1176: l_api_updating := per_par_shd.api_updating

1172: -- Only proceed with validation if :
1173: -- a) The current g_old_rec is current and
1174: -- b) The participant_usage_status value has changed
1175: --
1176: l_api_updating := per_par_shd.api_updating
1177: (p_participant_id => p_participant_id
1178: ,p_object_version_number => p_object_version_number);
1179: --
1180: IF (l_api_updating

Line 1181: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)

1177: (p_participant_id => p_participant_id
1178: ,p_object_version_number => p_object_version_number);
1179: --
1180: IF (l_api_updating
1181: AND nvl(per_par_shd.g_old_rec.participant_usage_status, hr_api.g_varchar2)
1182: = nvl(p_participant_usage_status, hr_api.g_varchar2))
1183: THEN
1184: RETURN;
1185: END IF;

Line 1226: Procedure insert_validate(p_rec in per_par_shd.g_rec_type

1222: --
1223: -- ----------------------------------------------------------------------------
1224: -- |---------------------------< insert_validate >----------------------------|
1225: -- ----------------------------------------------------------------------------
1226: Procedure insert_validate(p_rec in per_par_shd.g_rec_type
1227: ,p_effective_date in date) is
1228: --
1229: l_proc varchar2(72) := g_package||'insert_validate';
1230: --

Line 1237: ,p_associated_column1 => per_par_shd.g_tab_nam ||

1233: --
1234: -- Call all supporting business operations
1235: --
1236: hr_api.validate_bus_grp_id(p_rec.business_group_id
1237: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1238: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1239: hr_multi_message.end_validation_set;
1240: --
1241: hr_utility.set_location(l_proc, 1);

Line 1310: Procedure update_validate(p_rec in per_par_shd.g_rec_type

1306: --
1307: -- ----------------------------------------------------------------------------
1308: -- |---------------------------< update_validate >----------------------------|
1309: -- ----------------------------------------------------------------------------
1310: Procedure update_validate(p_rec in per_par_shd.g_rec_type
1311: ,p_effective_date in date) is
1312: --
1313: l_proc varchar2(72) := g_package||'update_validate';
1314: --

Line 1322: ,p_associated_column1 => per_par_shd.g_tab_nam ||

1318: -- Call all supporting business operations
1319: --
1320: --
1321: hr_api.validate_bus_grp_id(p_rec.business_group_id
1322: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1323: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1324:
1325: hr_multi_message.end_validation_set;
1326: --

Line 1366: ,p_associated_column1 => per_par_shd.g_tab_nam ||

1362: --
1363: hr_utility.set_location(l_proc, 5);
1364: --
1365: hr_api.validate_bus_grp_id(p_rec.business_group_id
1366: ,p_associated_column1 => per_par_shd.g_tab_nam ||
1367: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
1368:
1369: hr_multi_message.end_validation_set;
1370: --

Line 1389: Procedure delete_validate(p_rec in per_par_shd.g_rec_type) is

1385: --
1386: -- ----------------------------------------------------------------------------
1387: -- |---------------------------< delete_validate >----------------------------|
1388: -- ----------------------------------------------------------------------------
1389: Procedure delete_validate(p_rec in per_par_shd.g_rec_type) is
1390: --
1391: l_proc varchar2(72) := g_package||'delete_validate';
1392: --
1393: Begin