APPS.GHR_PDC_DEL dependencies on GHR_PDC_SHD

Line 51: Procedure delete_dml(p_rec in ghr_pdc_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ghr_pdc_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

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

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: --ghr_pdc_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ghr_pd_classifications row.
61: --
62: delete from ghr_pd_classifications

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

61: --
62: delete from ghr_pd_classifications
63: where pd_classification_id = p_rec.pd_classification_id;
64: --
65: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
73: ghr_pdc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status

Line 73: ghr_pdc_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
73: ghr_pdc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
73: ghr_pdc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: --ghr_pdc_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ghr_pdc_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ghr_pdc_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in ghr_pdc_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in ghr_pdc_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

163: --
164: begin
165: ghr_pdc_rkd.after_delete (
166: p_pd_classification_id => p_rec.pd_classification_id,
167: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,

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

164: begin
165: ghr_pdc_rkd.after_delete (
166: p_pd_classification_id => p_rec.pd_classification_id,
167: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,

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

165: ghr_pdc_rkd.after_delete (
166: p_pd_classification_id => p_rec.pd_classification_id,
167: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number

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

166: p_pd_classification_id => p_rec.pd_classification_id,
167: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
174: );

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

167: p_position_description_id_o => ghr_pdc_shd.g_old_rec.position_description_id,
168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
174: );
175: exception

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

168: p_class_grade_by_o => ghr_pdc_shd.g_old_rec.class_grade_by,
169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
174: );
175: exception
176: when hr_api.cannot_find_prog_unit then

Line 173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number

169: p_official_title_o => ghr_pdc_shd.g_old_rec.official_title,
170: p_pay_plan_o => ghr_pdc_shd.g_old_rec.pay_plan,
171: p_occupational_code_o => ghr_pdc_shd.g_old_rec.occupational_code,
172: p_grade_level_o => ghr_pdc_shd.g_old_rec.grade_level,
173: p_object_version_number_o => ghr_pdc_shd.g_old_rec.object_version_number
174: );
175: exception
176: when hr_api.cannot_find_prog_unit then
177: hr_api.cannot_find_prog_unit_error

Line 192: p_rec in ghr_pdc_shd.g_rec_type

188: -- |---------------------------------< del >----------------------------------|
189: -- ----------------------------------------------------------------------------
190: Procedure del
191: (
192: p_rec in ghr_pdc_shd.g_rec_type
193: ) is
194: --
195: l_proc varchar2(72) := g_package||'del';
196: --

Line 202: ghr_pdc_shd.lck

198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- We must lock the row which we need to delete.
201: --
202: ghr_pdc_shd.lck
203: (
204: p_rec.pd_classification_id,
205: p_rec.object_version_number
206: );

Line 234: l_rec ghr_pdc_shd.g_rec_type;

230: p_pd_classification_id in number,
231: p_object_version_number in number
232: ) is
233: --
234: l_rec ghr_pdc_shd.g_rec_type;
235: l_proc varchar2(72) := g_package||'del';
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);