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 HR_API

Line 49: IF NVL(p_rec.position_description_id, hr_api.g_number)

45: --
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;

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 62: IF NVL(p_rec.class_grade_by, hr_api.g_varchar2)

58:
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';

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 73: /* IF NVL(p_rec.official_title, hr_api.g_varchar2)

69:
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';

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 81: IF NVL(p_rec.pay_plan, hr_api.g_varchar2)

77: l_argument := 'official_title';
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';

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 89: IF NVL(p_rec.occupational_code, hr_api.g_varchar2)

85: l_argument := 'pay_plan';
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';

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 97: IF NVL(p_rec.grade_level, hr_api.g_varchar2)

93: l_argument := 'occupational_code';
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';

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 117: hr_api.argument_changed_error

113: EXCEPTION
114:
115: WHEN l_error THEN
116:
117: hr_api.argument_changed_error
118:
119: (p_api_name => l_proc,
120: p_argument => l_argument);
121:

Line 150: hr_api.mandatory_arg_error

146: hr_utility.set_location('Entering: '|| l_proc, 10);
147:
148: -- Check Mandatory Parameters are set
149:
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc,
152: p_argument => 'effective date',
153: p_argument_value => p_effective_date
154: );

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 171: <> nvl(p_grade_level,hr_api.g_varchar2))))

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:
175: --

Line 185: IF hr_api.not_exists_in_hr_lookups

181: --
182:
183: IF p_grade_level is NOT NULL THEN
184:
185: IF hr_api.not_exists_in_hr_lookups
186: (p_effective_date => p_effective_date,
187: p_lookup_type => 'GHR_US_GRADE_OR_LEVEL',
188: p_lookup_code => p_grade_level
189: ) THEN

Line 238: hr_api.mandatory_arg_error

234: hr_utility.set_location('Entering: '|| l_proc, 10);
235:
236: -- Check Mandatory Parameters are set
237:
238: hr_api.mandatory_arg_error
239: (p_api_name => l_proc,
240: p_argument => 'effective date',
241: p_argument_value => p_effective_date
242: );

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 259: <> nvl(p_pay_plan,hr_api.g_varchar2))))

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:
263: --

Line 317: hr_api.mandatory_arg_error

313: hr_utility.set_location('Entering: '|| l_proc, 10);
314:
315: -- Check Mandatory Parameters are set
316:
317: hr_api.mandatory_arg_error
318: (p_api_name => l_proc,
319: p_argument => 'effective date',
320: p_argument_value => p_effective_date
321: );

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 338: <> nvl(p_occupational_code,hr_api.g_varchar2))))

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:
342: --

Line 352: IF hr_api.not_exists_in_hr_lookups

348: --
349:
350: IF p_occupational_code is NOT NULL THEN
351:
352: IF hr_api.not_exists_in_hr_lookups
353: (p_effective_date => p_effective_date,
354: p_lookup_type => 'GHR_US_OCC_SERIES',
355: p_lookup_code => p_occupational_code
356: ) THEN

Line 394: hr_api.mandatory_arg_error

390: hr_utility.set_location('Entering: '|| l_proc, 10);
391:
392: -- Check Mandatory Parameters are set
393:
394: hr_api.mandatory_arg_error
395: (p_api_name => l_proc,
396: p_argument => 'effective date',
397: p_argument_value => p_effective_date
398: );

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 417: <> nvl(p_class_grade_by,hr_api.g_varchar2))))

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:
421:

Line 432: IF hr_api.not_exists_in_hr_lookups

428:
429: IF p_class_grade_by is NOT NULL THEN
430:
431:
432: IF hr_api.not_exists_in_hr_lookups
433: (p_effective_date => p_effective_date,
434: p_lookup_type => 'GHR_US_CLASS_GRADE_BY',
435: p_lookup_code => p_class_grade_by
436: ) THEN