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_PSS_UPD dependencies on PER_PSS_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_pss_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_pss_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 104: per_pss_shd.constraint_error

100: --
101: Exception
102: When hr_api.check_integrity_violated Then
103: -- A check constraint has been violated
104: per_pss_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error

Line 108: per_pss_shd.constraint_error

104: per_pss_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_pss_shd.constraint_error

Line 112: per_pss_shd.constraint_error

108: per_pss_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.unique_integrity_violated Then
111: -- Unique integrity has been violated
112: per_pss_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: Raise;
116: End update_dml;

Line 150: Procedure pre_update(p_rec in per_pss_shd.g_rec_type) is

146: -- Internal Row Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_update(p_rec in per_pss_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) := g_package||'pre_update';
153: --
154: Begin

Line 192: Procedure post_update(p_rec in per_pss_shd.g_rec_type,

188: -- Internal Row Handler Use Only.
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_update(p_rec in per_pss_shd.g_rec_type,
193: p_effective_date in date) is
194: --
195: l_proc varchar2(72) := g_package||'post_update';
196: --

Line 259: => per_pss_shd.g_old_rec.object_version_number,

255: => p_rec.attribute19,
256: p_attribute20
257: => p_rec.attribute20,
258: p_object_version_number_o
259: => per_pss_shd.g_old_rec.object_version_number,
260: p_survey_name_o
261: => per_pss_shd.g_old_rec.survey_name,
262: --ras p_currency_code_o
263: --ras => per_pss_shd.g_old_rec.currency_code,

Line 261: => per_pss_shd.g_old_rec.survey_name,

257: => p_rec.attribute20,
258: p_object_version_number_o
259: => per_pss_shd.g_old_rec.object_version_number,
260: p_survey_name_o
261: => per_pss_shd.g_old_rec.survey_name,
262: --ras p_currency_code_o
263: --ras => per_pss_shd.g_old_rec.currency_code,
264: p_survey_type_code_o
265: => per_pss_shd.g_old_rec.survey_type_code,

Line 263: --ras => per_pss_shd.g_old_rec.currency_code,

259: => per_pss_shd.g_old_rec.object_version_number,
260: p_survey_name_o
261: => per_pss_shd.g_old_rec.survey_name,
262: --ras p_currency_code_o
263: --ras => per_pss_shd.g_old_rec.currency_code,
264: p_survey_type_code_o
265: => per_pss_shd.g_old_rec.survey_type_code,
266: p_base_region_o
267: => per_pss_shd.g_old_rec.base_region,

Line 265: => per_pss_shd.g_old_rec.survey_type_code,

261: => per_pss_shd.g_old_rec.survey_name,
262: --ras p_currency_code_o
263: --ras => per_pss_shd.g_old_rec.currency_code,
264: p_survey_type_code_o
265: => per_pss_shd.g_old_rec.survey_type_code,
266: p_base_region_o
267: => per_pss_shd.g_old_rec.base_region,
268: p_attribute_category_o
269: => per_pss_shd.g_old_rec.attribute_category,

Line 267: => per_pss_shd.g_old_rec.base_region,

263: --ras => per_pss_shd.g_old_rec.currency_code,
264: p_survey_type_code_o
265: => per_pss_shd.g_old_rec.survey_type_code,
266: p_base_region_o
267: => per_pss_shd.g_old_rec.base_region,
268: p_attribute_category_o
269: => per_pss_shd.g_old_rec.attribute_category,
270: p_attribute1_o
271: => per_pss_shd.g_old_rec.attribute1,

Line 269: => per_pss_shd.g_old_rec.attribute_category,

265: => per_pss_shd.g_old_rec.survey_type_code,
266: p_base_region_o
267: => per_pss_shd.g_old_rec.base_region,
268: p_attribute_category_o
269: => per_pss_shd.g_old_rec.attribute_category,
270: p_attribute1_o
271: => per_pss_shd.g_old_rec.attribute1,
272: p_attribute2_o
273: => per_pss_shd.g_old_rec.attribute2,

Line 271: => per_pss_shd.g_old_rec.attribute1,

267: => per_pss_shd.g_old_rec.base_region,
268: p_attribute_category_o
269: => per_pss_shd.g_old_rec.attribute_category,
270: p_attribute1_o
271: => per_pss_shd.g_old_rec.attribute1,
272: p_attribute2_o
273: => per_pss_shd.g_old_rec.attribute2,
274: p_attribute3_o
275: => per_pss_shd.g_old_rec.attribute3,

Line 273: => per_pss_shd.g_old_rec.attribute2,

269: => per_pss_shd.g_old_rec.attribute_category,
270: p_attribute1_o
271: => per_pss_shd.g_old_rec.attribute1,
272: p_attribute2_o
273: => per_pss_shd.g_old_rec.attribute2,
274: p_attribute3_o
275: => per_pss_shd.g_old_rec.attribute3,
276: p_attribute4_o
277: => per_pss_shd.g_old_rec.attribute4,

Line 275: => per_pss_shd.g_old_rec.attribute3,

271: => per_pss_shd.g_old_rec.attribute1,
272: p_attribute2_o
273: => per_pss_shd.g_old_rec.attribute2,
274: p_attribute3_o
275: => per_pss_shd.g_old_rec.attribute3,
276: p_attribute4_o
277: => per_pss_shd.g_old_rec.attribute4,
278: p_attribute5_o
279: => per_pss_shd.g_old_rec.attribute5,

Line 277: => per_pss_shd.g_old_rec.attribute4,

273: => per_pss_shd.g_old_rec.attribute2,
274: p_attribute3_o
275: => per_pss_shd.g_old_rec.attribute3,
276: p_attribute4_o
277: => per_pss_shd.g_old_rec.attribute4,
278: p_attribute5_o
279: => per_pss_shd.g_old_rec.attribute5,
280: p_attribute6_o
281: => per_pss_shd.g_old_rec.attribute6,

Line 279: => per_pss_shd.g_old_rec.attribute5,

275: => per_pss_shd.g_old_rec.attribute3,
276: p_attribute4_o
277: => per_pss_shd.g_old_rec.attribute4,
278: p_attribute5_o
279: => per_pss_shd.g_old_rec.attribute5,
280: p_attribute6_o
281: => per_pss_shd.g_old_rec.attribute6,
282: p_attribute7_o
283: => per_pss_shd.g_old_rec.attribute7,

Line 281: => per_pss_shd.g_old_rec.attribute6,

277: => per_pss_shd.g_old_rec.attribute4,
278: p_attribute5_o
279: => per_pss_shd.g_old_rec.attribute5,
280: p_attribute6_o
281: => per_pss_shd.g_old_rec.attribute6,
282: p_attribute7_o
283: => per_pss_shd.g_old_rec.attribute7,
284: p_attribute8_o
285: => per_pss_shd.g_old_rec.attribute8,

Line 283: => per_pss_shd.g_old_rec.attribute7,

279: => per_pss_shd.g_old_rec.attribute5,
280: p_attribute6_o
281: => per_pss_shd.g_old_rec.attribute6,
282: p_attribute7_o
283: => per_pss_shd.g_old_rec.attribute7,
284: p_attribute8_o
285: => per_pss_shd.g_old_rec.attribute8,
286: p_attribute9_o
287: => per_pss_shd.g_old_rec.attribute9,

Line 285: => per_pss_shd.g_old_rec.attribute8,

281: => per_pss_shd.g_old_rec.attribute6,
282: p_attribute7_o
283: => per_pss_shd.g_old_rec.attribute7,
284: p_attribute8_o
285: => per_pss_shd.g_old_rec.attribute8,
286: p_attribute9_o
287: => per_pss_shd.g_old_rec.attribute9,
288: p_attribute10_o
289: => per_pss_shd.g_old_rec.attribute10,

Line 287: => per_pss_shd.g_old_rec.attribute9,

283: => per_pss_shd.g_old_rec.attribute7,
284: p_attribute8_o
285: => per_pss_shd.g_old_rec.attribute8,
286: p_attribute9_o
287: => per_pss_shd.g_old_rec.attribute9,
288: p_attribute10_o
289: => per_pss_shd.g_old_rec.attribute10,
290: p_attribute11_o
291: => per_pss_shd.g_old_rec.attribute11,

Line 289: => per_pss_shd.g_old_rec.attribute10,

285: => per_pss_shd.g_old_rec.attribute8,
286: p_attribute9_o
287: => per_pss_shd.g_old_rec.attribute9,
288: p_attribute10_o
289: => per_pss_shd.g_old_rec.attribute10,
290: p_attribute11_o
291: => per_pss_shd.g_old_rec.attribute11,
292: p_attribute12_o
293: => per_pss_shd.g_old_rec.attribute12,

Line 291: => per_pss_shd.g_old_rec.attribute11,

287: => per_pss_shd.g_old_rec.attribute9,
288: p_attribute10_o
289: => per_pss_shd.g_old_rec.attribute10,
290: p_attribute11_o
291: => per_pss_shd.g_old_rec.attribute11,
292: p_attribute12_o
293: => per_pss_shd.g_old_rec.attribute12,
294: p_attribute13_o
295: => per_pss_shd.g_old_rec.attribute13,

Line 293: => per_pss_shd.g_old_rec.attribute12,

289: => per_pss_shd.g_old_rec.attribute10,
290: p_attribute11_o
291: => per_pss_shd.g_old_rec.attribute11,
292: p_attribute12_o
293: => per_pss_shd.g_old_rec.attribute12,
294: p_attribute13_o
295: => per_pss_shd.g_old_rec.attribute13,
296: p_attribute14_o
297: => per_pss_shd.g_old_rec.attribute14,

Line 295: => per_pss_shd.g_old_rec.attribute13,

291: => per_pss_shd.g_old_rec.attribute11,
292: p_attribute12_o
293: => per_pss_shd.g_old_rec.attribute12,
294: p_attribute13_o
295: => per_pss_shd.g_old_rec.attribute13,
296: p_attribute14_o
297: => per_pss_shd.g_old_rec.attribute14,
298: p_attribute15_o
299: => per_pss_shd.g_old_rec.attribute15,

Line 297: => per_pss_shd.g_old_rec.attribute14,

293: => per_pss_shd.g_old_rec.attribute12,
294: p_attribute13_o
295: => per_pss_shd.g_old_rec.attribute13,
296: p_attribute14_o
297: => per_pss_shd.g_old_rec.attribute14,
298: p_attribute15_o
299: => per_pss_shd.g_old_rec.attribute15,
300: p_attribute16_o
301: => per_pss_shd.g_old_rec.attribute16,

Line 299: => per_pss_shd.g_old_rec.attribute15,

295: => per_pss_shd.g_old_rec.attribute13,
296: p_attribute14_o
297: => per_pss_shd.g_old_rec.attribute14,
298: p_attribute15_o
299: => per_pss_shd.g_old_rec.attribute15,
300: p_attribute16_o
301: => per_pss_shd.g_old_rec.attribute16,
302: p_attribute17_o
303: => per_pss_shd.g_old_rec.attribute17,

Line 301: => per_pss_shd.g_old_rec.attribute16,

297: => per_pss_shd.g_old_rec.attribute14,
298: p_attribute15_o
299: => per_pss_shd.g_old_rec.attribute15,
300: p_attribute16_o
301: => per_pss_shd.g_old_rec.attribute16,
302: p_attribute17_o
303: => per_pss_shd.g_old_rec.attribute17,
304: p_attribute18_o
305: => per_pss_shd.g_old_rec.attribute18,

Line 303: => per_pss_shd.g_old_rec.attribute17,

299: => per_pss_shd.g_old_rec.attribute15,
300: p_attribute16_o
301: => per_pss_shd.g_old_rec.attribute16,
302: p_attribute17_o
303: => per_pss_shd.g_old_rec.attribute17,
304: p_attribute18_o
305: => per_pss_shd.g_old_rec.attribute18,
306: p_attribute19_o
307: => per_pss_shd.g_old_rec.attribute19,

Line 305: => per_pss_shd.g_old_rec.attribute18,

301: => per_pss_shd.g_old_rec.attribute16,
302: p_attribute17_o
303: => per_pss_shd.g_old_rec.attribute17,
304: p_attribute18_o
305: => per_pss_shd.g_old_rec.attribute18,
306: p_attribute19_o
307: => per_pss_shd.g_old_rec.attribute19,
308: p_attribute20_o
309: => per_pss_shd.g_old_rec.attribute20

Line 307: => per_pss_shd.g_old_rec.attribute19,

303: => per_pss_shd.g_old_rec.attribute17,
304: p_attribute18_o
305: => per_pss_shd.g_old_rec.attribute18,
306: p_attribute19_o
307: => per_pss_shd.g_old_rec.attribute19,
308: p_attribute20_o
309: => per_pss_shd.g_old_rec.attribute20
310: );
311:

Line 309: => per_pss_shd.g_old_rec.attribute20

305: => per_pss_shd.g_old_rec.attribute18,
306: p_attribute19_o
307: => per_pss_shd.g_old_rec.attribute19,
308: p_attribute20_o
309: => per_pss_shd.g_old_rec.attribute20
310: );
311:
312: exception
313: when hr_api.cannot_find_prog_unit then

Line 368: Procedure convert_defs(p_rec in out nocopy per_pss_shd.g_rec_type) is

364: -- Internal Row Handler Use Only.
365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure convert_defs(p_rec in out nocopy per_pss_shd.g_rec_type) is
369: --
370: l_proc varchar2(72) := g_package||'convert_defs';
371: --
372: Begin

Line 383: per_pss_shd.g_old_rec.survey_name;

379: -- is being used then we must set to the 'current' argument value.
380: --
381: If (p_rec.survey_name = hr_api.g_varchar2) then
382: p_rec.survey_name :=
383: per_pss_shd.g_old_rec.survey_name;
384: End If;
385: If (p_rec.survey_company_code = hr_api.g_varchar2) then
386: p_rec.survey_company_code :=
387: per_pss_shd.g_old_rec.survey_company_code;

Line 387: per_pss_shd.g_old_rec.survey_company_code;

383: per_pss_shd.g_old_rec.survey_name;
384: End If;
385: If (p_rec.survey_company_code = hr_api.g_varchar2) then
386: p_rec.survey_company_code :=
387: per_pss_shd.g_old_rec.survey_company_code;
388: End If;
389: If (p_rec.identifier = hr_api.g_varchar2) then
390: p_rec.identifier :=
391: per_pss_shd.g_old_rec.identifier;

Line 391: per_pss_shd.g_old_rec.identifier;

387: per_pss_shd.g_old_rec.survey_company_code;
388: End If;
389: If (p_rec.identifier = hr_api.g_varchar2) then
390: p_rec.identifier :=
391: per_pss_shd.g_old_rec.identifier;
392: End If;
393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then
394: --ras p_rec.currency_code :=
395: --ras per_pss_shd.g_old_rec.currency_code;

Line 395: --ras per_pss_shd.g_old_rec.currency_code;

391: per_pss_shd.g_old_rec.identifier;
392: End If;
393: --ras If (p_rec.currency_code = hr_api.g_varchar2) then
394: --ras p_rec.currency_code :=
395: --ras per_pss_shd.g_old_rec.currency_code;
396: --ras End If;
397: If (p_rec.survey_type_code = hr_api.g_varchar2) then
398: p_rec.survey_type_code :=
399: per_pss_shd.g_old_rec.survey_type_code;

Line 399: per_pss_shd.g_old_rec.survey_type_code;

395: --ras per_pss_shd.g_old_rec.currency_code;
396: --ras End If;
397: If (p_rec.survey_type_code = hr_api.g_varchar2) then
398: p_rec.survey_type_code :=
399: per_pss_shd.g_old_rec.survey_type_code;
400: End If;
401: If (p_rec.base_region = hr_api.g_varchar2) then
402: p_rec.base_region :=
403: per_pss_shd.g_old_rec.base_region;

Line 403: per_pss_shd.g_old_rec.base_region;

399: per_pss_shd.g_old_rec.survey_type_code;
400: End If;
401: If (p_rec.base_region = hr_api.g_varchar2) then
402: p_rec.base_region :=
403: per_pss_shd.g_old_rec.base_region;
404: End If;
405: If (p_rec.attribute_category = hr_api.g_varchar2) then
406: p_rec.attribute_category :=
407: per_pss_shd.g_old_rec.attribute_category;

Line 407: per_pss_shd.g_old_rec.attribute_category;

403: per_pss_shd.g_old_rec.base_region;
404: End If;
405: If (p_rec.attribute_category = hr_api.g_varchar2) then
406: p_rec.attribute_category :=
407: per_pss_shd.g_old_rec.attribute_category;
408: End If;
409: If (p_rec.attribute1 = hr_api.g_varchar2) then
410: p_rec.attribute1 :=
411: per_pss_shd.g_old_rec.attribute1;

Line 411: per_pss_shd.g_old_rec.attribute1;

407: per_pss_shd.g_old_rec.attribute_category;
408: End If;
409: If (p_rec.attribute1 = hr_api.g_varchar2) then
410: p_rec.attribute1 :=
411: per_pss_shd.g_old_rec.attribute1;
412: End If;
413: If (p_rec.attribute2 = hr_api.g_varchar2) then
414: p_rec.attribute2 :=
415: per_pss_shd.g_old_rec.attribute2;

Line 415: per_pss_shd.g_old_rec.attribute2;

411: per_pss_shd.g_old_rec.attribute1;
412: End If;
413: If (p_rec.attribute2 = hr_api.g_varchar2) then
414: p_rec.attribute2 :=
415: per_pss_shd.g_old_rec.attribute2;
416: End If;
417: If (p_rec.attribute3 = hr_api.g_varchar2) then
418: p_rec.attribute3 :=
419: per_pss_shd.g_old_rec.attribute3;

Line 419: per_pss_shd.g_old_rec.attribute3;

415: per_pss_shd.g_old_rec.attribute2;
416: End If;
417: If (p_rec.attribute3 = hr_api.g_varchar2) then
418: p_rec.attribute3 :=
419: per_pss_shd.g_old_rec.attribute3;
420: End If;
421: If (p_rec.attribute4 = hr_api.g_varchar2) then
422: p_rec.attribute4 :=
423: per_pss_shd.g_old_rec.attribute4;

Line 423: per_pss_shd.g_old_rec.attribute4;

419: per_pss_shd.g_old_rec.attribute3;
420: End If;
421: If (p_rec.attribute4 = hr_api.g_varchar2) then
422: p_rec.attribute4 :=
423: per_pss_shd.g_old_rec.attribute4;
424: End If;
425: If (p_rec.attribute5 = hr_api.g_varchar2) then
426: p_rec.attribute5 :=
427: per_pss_shd.g_old_rec.attribute5;

Line 427: per_pss_shd.g_old_rec.attribute5;

423: per_pss_shd.g_old_rec.attribute4;
424: End If;
425: If (p_rec.attribute5 = hr_api.g_varchar2) then
426: p_rec.attribute5 :=
427: per_pss_shd.g_old_rec.attribute5;
428: End If;
429: If (p_rec.attribute6 = hr_api.g_varchar2) then
430: p_rec.attribute6 :=
431: per_pss_shd.g_old_rec.attribute6;

Line 431: per_pss_shd.g_old_rec.attribute6;

427: per_pss_shd.g_old_rec.attribute5;
428: End If;
429: If (p_rec.attribute6 = hr_api.g_varchar2) then
430: p_rec.attribute6 :=
431: per_pss_shd.g_old_rec.attribute6;
432: End If;
433: If (p_rec.attribute7 = hr_api.g_varchar2) then
434: p_rec.attribute7 :=
435: per_pss_shd.g_old_rec.attribute7;

Line 435: per_pss_shd.g_old_rec.attribute7;

431: per_pss_shd.g_old_rec.attribute6;
432: End If;
433: If (p_rec.attribute7 = hr_api.g_varchar2) then
434: p_rec.attribute7 :=
435: per_pss_shd.g_old_rec.attribute7;
436: End If;
437: If (p_rec.attribute8 = hr_api.g_varchar2) then
438: p_rec.attribute8 :=
439: per_pss_shd.g_old_rec.attribute8;

Line 439: per_pss_shd.g_old_rec.attribute8;

435: per_pss_shd.g_old_rec.attribute7;
436: End If;
437: If (p_rec.attribute8 = hr_api.g_varchar2) then
438: p_rec.attribute8 :=
439: per_pss_shd.g_old_rec.attribute8;
440: End If;
441: If (p_rec.attribute9 = hr_api.g_varchar2) then
442: p_rec.attribute9 :=
443: per_pss_shd.g_old_rec.attribute9;

Line 443: per_pss_shd.g_old_rec.attribute9;

439: per_pss_shd.g_old_rec.attribute8;
440: End If;
441: If (p_rec.attribute9 = hr_api.g_varchar2) then
442: p_rec.attribute9 :=
443: per_pss_shd.g_old_rec.attribute9;
444: End If;
445: If (p_rec.attribute10 = hr_api.g_varchar2) then
446: p_rec.attribute10 :=
447: per_pss_shd.g_old_rec.attribute10;

Line 447: per_pss_shd.g_old_rec.attribute10;

443: per_pss_shd.g_old_rec.attribute9;
444: End If;
445: If (p_rec.attribute10 = hr_api.g_varchar2) then
446: p_rec.attribute10 :=
447: per_pss_shd.g_old_rec.attribute10;
448: End If;
449: If (p_rec.attribute11 = hr_api.g_varchar2) then
450: p_rec.attribute11 :=
451: per_pss_shd.g_old_rec.attribute11;

Line 451: per_pss_shd.g_old_rec.attribute11;

447: per_pss_shd.g_old_rec.attribute10;
448: End If;
449: If (p_rec.attribute11 = hr_api.g_varchar2) then
450: p_rec.attribute11 :=
451: per_pss_shd.g_old_rec.attribute11;
452: End If;
453: If (p_rec.attribute12 = hr_api.g_varchar2) then
454: p_rec.attribute12 :=
455: per_pss_shd.g_old_rec.attribute12;

Line 455: per_pss_shd.g_old_rec.attribute12;

451: per_pss_shd.g_old_rec.attribute11;
452: End If;
453: If (p_rec.attribute12 = hr_api.g_varchar2) then
454: p_rec.attribute12 :=
455: per_pss_shd.g_old_rec.attribute12;
456: End If;
457: If (p_rec.attribute13 = hr_api.g_varchar2) then
458: p_rec.attribute13 :=
459: per_pss_shd.g_old_rec.attribute13;

Line 459: per_pss_shd.g_old_rec.attribute13;

455: per_pss_shd.g_old_rec.attribute12;
456: End If;
457: If (p_rec.attribute13 = hr_api.g_varchar2) then
458: p_rec.attribute13 :=
459: per_pss_shd.g_old_rec.attribute13;
460: End If;
461: If (p_rec.attribute14 = hr_api.g_varchar2) then
462: p_rec.attribute14 :=
463: per_pss_shd.g_old_rec.attribute14;

Line 463: per_pss_shd.g_old_rec.attribute14;

459: per_pss_shd.g_old_rec.attribute13;
460: End If;
461: If (p_rec.attribute14 = hr_api.g_varchar2) then
462: p_rec.attribute14 :=
463: per_pss_shd.g_old_rec.attribute14;
464: End If;
465: If (p_rec.attribute15 = hr_api.g_varchar2) then
466: p_rec.attribute15 :=
467: per_pss_shd.g_old_rec.attribute15;

Line 467: per_pss_shd.g_old_rec.attribute15;

463: per_pss_shd.g_old_rec.attribute14;
464: End If;
465: If (p_rec.attribute15 = hr_api.g_varchar2) then
466: p_rec.attribute15 :=
467: per_pss_shd.g_old_rec.attribute15;
468: End If;
469: If (p_rec.attribute16 = hr_api.g_varchar2) then
470: p_rec.attribute16 :=
471: per_pss_shd.g_old_rec.attribute16;

Line 471: per_pss_shd.g_old_rec.attribute16;

467: per_pss_shd.g_old_rec.attribute15;
468: End If;
469: If (p_rec.attribute16 = hr_api.g_varchar2) then
470: p_rec.attribute16 :=
471: per_pss_shd.g_old_rec.attribute16;
472: End If;
473: If (p_rec.attribute17 = hr_api.g_varchar2) then
474: p_rec.attribute17 :=
475: per_pss_shd.g_old_rec.attribute17;

Line 475: per_pss_shd.g_old_rec.attribute17;

471: per_pss_shd.g_old_rec.attribute16;
472: End If;
473: If (p_rec.attribute17 = hr_api.g_varchar2) then
474: p_rec.attribute17 :=
475: per_pss_shd.g_old_rec.attribute17;
476: End If;
477: If (p_rec.attribute18 = hr_api.g_varchar2) then
478: p_rec.attribute18 :=
479: per_pss_shd.g_old_rec.attribute18;

Line 479: per_pss_shd.g_old_rec.attribute18;

475: per_pss_shd.g_old_rec.attribute17;
476: End If;
477: If (p_rec.attribute18 = hr_api.g_varchar2) then
478: p_rec.attribute18 :=
479: per_pss_shd.g_old_rec.attribute18;
480: End If;
481: If (p_rec.attribute19 = hr_api.g_varchar2) then
482: p_rec.attribute19 :=
483: per_pss_shd.g_old_rec.attribute19;

Line 483: per_pss_shd.g_old_rec.attribute19;

479: per_pss_shd.g_old_rec.attribute18;
480: End If;
481: If (p_rec.attribute19 = hr_api.g_varchar2) then
482: p_rec.attribute19 :=
483: per_pss_shd.g_old_rec.attribute19;
484: End If;
485: If (p_rec.attribute20 = hr_api.g_varchar2) then
486: p_rec.attribute20 :=
487: per_pss_shd.g_old_rec.attribute20;

Line 487: per_pss_shd.g_old_rec.attribute20;

483: per_pss_shd.g_old_rec.attribute19;
484: End If;
485: If (p_rec.attribute20 = hr_api.g_varchar2) then
486: p_rec.attribute20 :=
487: per_pss_shd.g_old_rec.attribute20;
488: End If;
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 10);
491: --

Line 499: p_rec in out nocopy per_pss_shd.g_rec_type,

495: -- |---------------------------------< upd >----------------------------------|
496: -- ----------------------------------------------------------------------------
497: Procedure upd
498: (
499: p_rec in out nocopy per_pss_shd.g_rec_type,
500: p_effective_date in date
501: ) is
502: --
503: l_proc varchar2(72) := g_package||'upd';

Line 510: per_pss_shd.lck

506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- We must lock the row which we need to update.
509: --
510: per_pss_shd.lck
511: (
512: p_rec.salary_survey_id,
513: p_rec.object_version_number
514: );

Line 573: l_rec per_pss_shd.g_rec_type;

569: p_attribute20 in varchar2 default hr_api.g_varchar2,
570: p_effective_date in date default hr_api.g_date
571: ) is
572: --
573: l_rec per_pss_shd.g_rec_type;
574: l_proc varchar2(72) := g_package||'upd';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);

Line 583: per_pss_shd.convert_args

579: -- Call conversion function to turn arguments into the
580: -- l_rec structure.
581: --
582: l_rec :=
583: per_pss_shd.convert_args
584: (
585: p_salary_survey_id,
586: p_object_version_number,
587: p_survey_name,