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.GHR_PDC_BUS dependencies on GHR_PDC_SHD

Line 15: PROCEDURE CHK_NON_UPDATEABLE_ARGS(p_rec IN ghr_pdc_shd.g_rec_type)

11: --
12: --------------------------------------------------
13: --
14:
15: PROCEDURE CHK_NON_UPDATEABLE_ARGS(p_rec IN ghr_pdc_shd.g_rec_type)
16:
17: IS
18:
19: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';

Line 35: IF not ghr_pdc_shd.api_updating

31: -- Only proceed with the validation if the row exists for
32: -- the current record in the HR schema.
33: --
34:
35: IF not ghr_pdc_shd.api_updating
36: (p_pd_classification_id => p_rec.pd_classification_id,
37: p_object_version_number => p_rec.object_version_number)
38: THEN
39:

Line 50: <> NVL(ghr_pdc_shd.g_old_rec.position_description_id, hr_api.g_number)

46: hr_utility.set_location (l_proc, 30);
47: --
48:
49: IF NVL(p_rec.position_description_id, hr_api.g_number)
50: <> NVL(ghr_pdc_shd.g_old_rec.position_description_id, hr_api.g_number)
51: THEN
52: l_argument := 'position_description_id';
53: RAISE l_error;
54:

Line 63: <> NVL(ghr_pdc_shd.g_old_rec.class_grade_by,hr_api.g_varchar2)

59:
60:
61:
62: IF NVL(p_rec.class_grade_by, hr_api.g_varchar2)
63: <> NVL(ghr_pdc_shd.g_old_rec.class_grade_by,hr_api.g_varchar2)
64: THEN
65:
66: l_argument := 'class_grade_by';
67: RAISE l_error;

Line 74: <> NVL(ghr_pdc_shd.g_old_rec.official_title,hr_api.g_varchar2)

70: /* The following lines are commented as we have not completely defined the business rules for classification/certification information. This information cannot be changed once the PD has been classified. */
71:
72:
73: /* IF NVL(p_rec.official_title, hr_api.g_varchar2)
74: <> NVL(ghr_pdc_shd.g_old_rec.official_title,hr_api.g_varchar2)
75: THEN
76:
77: l_argument := 'official_title';
78: RAISE l_error;

Line 82: <> NVL(ghr_pdc_shd.g_old_rec.pay_plan,hr_api.g_varchar2)

78: RAISE l_error;
79: END IF;
80:
81: IF NVL(p_rec.pay_plan, hr_api.g_varchar2)
82: <> NVL(ghr_pdc_shd.g_old_rec.pay_plan,hr_api.g_varchar2)
83: THEN
84:
85: l_argument := 'pay_plan';
86: RAISE l_error;

Line 90: <> NVL(ghr_pdc_shd.g_old_rec.occupational_code,hr_api.g_varchar2)

86: RAISE l_error;
87: END IF;
88:
89: IF NVL(p_rec.occupational_code, hr_api.g_varchar2)
90: <> NVL(ghr_pdc_shd.g_old_rec.occupational_code,hr_api.g_varchar2)
91: THEN
92:
93: l_argument := 'occupational_code';
94: RAISE l_error;

Line 98: <> NVL(ghr_pdc_shd.g_old_rec.grade_level,hr_api.g_varchar2)

94: RAISE l_error;
95: END IF;
96:
97: IF NVL(p_rec.grade_level, hr_api.g_varchar2)
98: <> NVL(ghr_pdc_shd.g_old_rec.grade_level,hr_api.g_varchar2)
99: THEN
100:
101: l_argument := 'grade_level';
102: RAISE l_error;

Line 164: l_api_updating := ghr_pdc_shd.api_updating(

160: -- b) The grade_level value has changed
161: -- c) A record is being inserted.
162: --
163:
164: l_api_updating := ghr_pdc_shd.api_updating(
165: p_pd_classification_id => p_pd_classification_id,
166: p_object_version_number => p_object_version_number);
167:
168: IF (l_api_updating

Line 170: ((nvl(ghr_pdc_shd.g_old_rec.grade_level,hr_api.g_varchar2)

166: p_object_version_number => p_object_version_number);
167:
168: IF (l_api_updating
169: AND
170: ((nvl(ghr_pdc_shd.g_old_rec.grade_level,hr_api.g_varchar2)
171: <> nvl(p_grade_level,hr_api.g_varchar2))))
172: OR
173: NOT l_api_updating THEN
174:

Line 252: l_api_updating := ghr_pdc_shd.api_updating(

248: -- b) The grade_level value has changed
249: -- c) A record is being inserted.
250: --
251:
252: l_api_updating := ghr_pdc_shd.api_updating(
253: p_pd_classification_id => p_pd_classification_id,
254: p_object_version_number => p_object_version_number);
255:
256: IF (l_api_updating

Line 258: ((nvl(ghr_pdc_shd.g_old_rec.pay_plan,hr_api.g_varchar2)

254: p_object_version_number => p_object_version_number);
255:
256: IF (l_api_updating
257: AND
258: ((nvl(ghr_pdc_shd.g_old_rec.pay_plan,hr_api.g_varchar2)
259: <> nvl(p_pay_plan,hr_api.g_varchar2))))
260: OR
261: NOT l_api_updating THEN
262:

Line 331: l_api_updating := ghr_pdc_shd.api_updating(

327: -- b) The grade_level value has changed
328: -- c) A record is being inserted.
329: --
330:
331: l_api_updating := ghr_pdc_shd.api_updating(
332: p_pd_classification_id => p_pd_classification_id,
333: p_object_version_number => p_object_version_number);
334:
335: IF (l_api_updating

Line 337: ((nvl(ghr_pdc_shd.g_old_rec.occupational_code,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334:
335: IF (l_api_updating
336: AND
337: ((nvl(ghr_pdc_shd.g_old_rec.occupational_code,hr_api.g_varchar2)
338: <> nvl(p_occupational_code,hr_api.g_varchar2))))
339: OR
340: NOT l_api_updating THEN
341:

Line 409: l_api_updating := ghr_pdc_shd.api_updating(

405: -- b) The class_grade_by value has changed
406: -- c) A record is being inserted.
407: --
408:
409: l_api_updating := ghr_pdc_shd.api_updating(
410: p_pd_classification_id => p_pd_classification_id,
411: p_object_version_number => p_object_version_number);
412:
413:

Line 416: ((nvl(ghr_pdc_shd.g_old_rec.class_grade_by,hr_api.g_varchar2)

412:
413:
414: IF (l_api_updating
415: AND
416: ((nvl(ghr_pdc_shd.g_old_rec.class_grade_by,hr_api.g_varchar2)
417: <> nvl(p_class_grade_by,hr_api.g_varchar2))))
418: OR
419: NOT l_api_updating THEN
420:

Line 458: Procedure insert_validate(p_rec in ghr_pdc_shd.g_rec_type) is

454:
455: -- ----------------------------------------------------------------------------
456: -- |---------------------------< insert_validate >----------------------------|
457: -- ----------------------------------------------------------------------------
458: Procedure insert_validate(p_rec in ghr_pdc_shd.g_rec_type) is
459: --
460: l_proc varchar2(72) := g_package||'insert_validate';
461: l_effective_date date ;
462: --

Line 512: Procedure update_validate(p_rec in ghr_pdc_shd.g_rec_type) is

508: --
509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< update_validate >----------------------------|
511: -- ----------------------------------------------------------------------------
512: Procedure update_validate(p_rec in ghr_pdc_shd.g_rec_type) is
513: --
514: l_proc varchar2(72) := g_package||'update_validate';
515: l_effective_date date;
516: --

Line 564: Procedure delete_validate(p_rec in ghr_pdc_shd.g_rec_type) is

560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< delete_validate >----------------------------|
563: -- ----------------------------------------------------------------------------
564: Procedure delete_validate(p_rec in ghr_pdc_shd.g_rec_type) is
565: --
566: l_proc varchar2(72) := g_package||'delete_validate';
567: --
568: Begin