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_UPD dependencies on GHR_PDC_SHD

Line 54: Procedure update_dml(p_rec in out NOCOPY ghr_pdc_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 ghr_pdc_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: --ghr_pdc_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: --ghr_pdc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ghr_pd_classifications Row
68: --
69: update ghr_pd_classifications

Line 79: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

75: grade_level = p_rec.grade_level,
76: object_version_number = p_rec.object_version_number
77: where pd_classification_id = p_rec.pd_classification_id;
78: --
79: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

Line 86: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
87: ghr_pdc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated

Line 87: ghr_pdc_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
87: ghr_pdc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

Line 91: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

87: ghr_pdc_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
92: ghr_pdc_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: ghr_pdc_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
92: ghr_pdc_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

Line 96: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

92: ghr_pdc_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
97: ghr_pdc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

Line 97: ghr_pdc_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
97: ghr_pdc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

Line 100: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

96: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
97: ghr_pdc_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in ghr_pdc_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in ghr_pdc_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in ghr_pdc_shd.g_rec_type) is

174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in ghr_pdc_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

Line 197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,

193: p_pay_plan => p_rec.pay_plan,
194: p_occupational_code => p_rec.occupational_code,
195: p_grade_level => p_rec.grade_level,
196: p_object_version_number => p_rec.object_version_number,
197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,

Line 198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,

194: p_occupational_code => p_rec.occupational_code,
195: p_grade_level => p_rec.grade_level,
196: p_object_version_number => p_rec.object_version_number,
197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,

Line 199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,

195: p_grade_level => p_rec.grade_level,
196: p_object_version_number => p_rec.object_version_number,
197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number

Line 200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,

196: p_object_version_number => p_rec.object_version_number,
197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
204: );

Line 201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,

197: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
204: );
205:

Line 202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,

198: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
204: );
205:
206: exception

Line 203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number

199: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
200: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
201: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
202: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
203: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
204: );
205:
206: exception
207: when hr_api.cannot_find_prog_unit then

Line 262: Procedure convert_defs(p_rec in out NOCOPY ghr_pdc_shd.g_rec_type) is

258: -- Internal Row Handler Use Only.
259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: Procedure convert_defs(p_rec in out NOCOPY ghr_pdc_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'convert_defs';
265: --
266: Begin

Line 277: ghr_pdc_shd.g_old_rec.position_description_id;

273: -- is being used then we must set to the 'current' argument value.
274: --
275: If (p_rec.position_description_id = hr_api.g_number) then
276: p_rec.position_description_id :=
277: ghr_pdc_shd.g_old_rec.position_description_id;
278: End If;
279: If (p_rec.class_grade_by = hr_api.g_varchar2) then
280: p_rec.class_grade_by :=
281: ghr_pdc_shd.g_old_rec.class_grade_by;

Line 281: ghr_pdc_shd.g_old_rec.class_grade_by;

277: ghr_pdc_shd.g_old_rec.position_description_id;
278: End If;
279: If (p_rec.class_grade_by = hr_api.g_varchar2) then
280: p_rec.class_grade_by :=
281: ghr_pdc_shd.g_old_rec.class_grade_by;
282: End If;
283: If (p_rec.official_title = hr_api.g_varchar2) then
284: p_rec.official_title :=
285: ghr_pdc_shd.g_old_rec.official_title;

Line 285: ghr_pdc_shd.g_old_rec.official_title;

281: ghr_pdc_shd.g_old_rec.class_grade_by;
282: End If;
283: If (p_rec.official_title = hr_api.g_varchar2) then
284: p_rec.official_title :=
285: ghr_pdc_shd.g_old_rec.official_title;
286: End If;
287: If (p_rec.pay_plan = hr_api.g_varchar2) then
288: p_rec.pay_plan :=
289: ghr_pdc_shd.g_old_rec.pay_plan;

Line 289: ghr_pdc_shd.g_old_rec.pay_plan;

285: ghr_pdc_shd.g_old_rec.official_title;
286: End If;
287: If (p_rec.pay_plan = hr_api.g_varchar2) then
288: p_rec.pay_plan :=
289: ghr_pdc_shd.g_old_rec.pay_plan;
290: End If;
291: If (p_rec.occupational_code = hr_api.g_varchar2) then
292: p_rec.occupational_code :=
293: ghr_pdc_shd.g_old_rec.occupational_code;

Line 293: ghr_pdc_shd.g_old_rec.occupational_code;

289: ghr_pdc_shd.g_old_rec.pay_plan;
290: End If;
291: If (p_rec.occupational_code = hr_api.g_varchar2) then
292: p_rec.occupational_code :=
293: ghr_pdc_shd.g_old_rec.occupational_code;
294: End If;
295: If (p_rec.grade_level = hr_api.g_varchar2) then
296: p_rec.grade_level :=
297: ghr_pdc_shd.g_old_rec.grade_level;

Line 297: ghr_pdc_shd.g_old_rec.grade_level;

293: ghr_pdc_shd.g_old_rec.occupational_code;
294: End If;
295: If (p_rec.grade_level = hr_api.g_varchar2) then
296: p_rec.grade_level :=
297: ghr_pdc_shd.g_old_rec.grade_level;
298: End If;
299:
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 310: p_rec in out NOCOPY ghr_pdc_shd.g_rec_type

306: -- |---------------------------------< upd >----------------------------------|
307: -- ----------------------------------------------------------------------------
308: Procedure upd
309: (
310: p_rec in out NOCOPY ghr_pdc_shd.g_rec_type
311: ) is
312: --
313: l_proc varchar2(72) := g_package||'upd';
314: --

Line 320: ghr_pdc_shd.lck

316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- We must lock the row which we need to update.
319: --
320: ghr_pdc_shd.lck
321: (
322: p_rec.pd_classification_id,
323: p_rec.object_version_number
324: );

Line 363: l_rec ghr_pdc_shd.g_rec_type;

359: p_grade_level in varchar2 default hr_api.g_varchar2,
360: p_object_version_number in out NOCOPY number
361: ) is
362: --
363: l_rec ghr_pdc_shd.g_rec_type;
364: l_proc varchar2(72) := g_package||'upd';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);

Line 376: ghr_pdc_shd.convert_args

372: -- Call conversion function to turn arguments into the
373: -- l_rec structure.
374: --
375: l_rec :=
376: ghr_pdc_shd.convert_args
377: (
378: p_pd_classification_id,
379: p_position_description_id,
380: p_class_grade_by,