APPS.PQH_TAT_UPD dependencies on PQH_TAT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_tat_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_tat_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 79: pqh_tat_shd.constraint_error

75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: pqh_tat_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error

Line 83: pqh_tat_shd.constraint_error

79: pqh_tat_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: pqh_tat_shd.constraint_error

Line 87: pqh_tat_shd.constraint_error

83: pqh_tat_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: pqh_tat_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then
90: Raise;
91: End update_dml;

Line 125: Procedure pre_update(p_rec in pqh_tat_shd.g_rec_type) is

121: -- Internal Row Handler Use Only.
122: --
123: -- {End Of Comments}
124: -- ----------------------------------------------------------------------------
125: Procedure pre_update(p_rec in pqh_tat_shd.g_rec_type) is
126: --
127: l_proc varchar2(72) := g_package||'pre_update';
128: --
129: Begin

Line 168: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure post_update(
168: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'post_update';
171: --
172: Begin

Line 190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag

186: ,p_attribute_id =>p_rec.attribute_id
187: ,p_template_id =>p_rec.template_id
188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_effective_date =>p_effective_date
190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id

Line 191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag

187: ,p_template_id =>p_rec.template_id
188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_effective_date =>p_effective_date
190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number

Line 192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag

188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_effective_date =>p_effective_date
190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
196: );

Line 193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id

189: ,p_effective_date =>p_effective_date
190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
196: );
197: --

Line 194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id

190: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
196: );
197: --
198: exception

Line 195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number

191: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
192: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
193: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
194: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
195: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
196: );
197: --
198: exception
199: --

Line 257: Procedure convert_defs(p_rec in out nocopy pqh_tat_shd.g_rec_type) is

253: -- Internal Row Handler Use Only.
254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure convert_defs(p_rec in out nocopy pqh_tat_shd.g_rec_type) is
258: --
259: l_proc varchar2(72) := g_package||'convert_defs';
260: --
261: Begin

Line 272: pqh_tat_shd.g_old_rec.required_flag;

268: -- is being used then we must set to the 'current' argument value.
269: --
270: If (p_rec.required_flag = hr_api.g_varchar2) then
271: p_rec.required_flag :=
272: pqh_tat_shd.g_old_rec.required_flag;
273: End If;
274: If (p_rec.view_flag = hr_api.g_varchar2) then
275: p_rec.view_flag :=
276: pqh_tat_shd.g_old_rec.view_flag;

Line 276: pqh_tat_shd.g_old_rec.view_flag;

272: pqh_tat_shd.g_old_rec.required_flag;
273: End If;
274: If (p_rec.view_flag = hr_api.g_varchar2) then
275: p_rec.view_flag :=
276: pqh_tat_shd.g_old_rec.view_flag;
277: End If;
278: If (p_rec.edit_flag = hr_api.g_varchar2) then
279: p_rec.edit_flag :=
280: pqh_tat_shd.g_old_rec.edit_flag;

Line 280: pqh_tat_shd.g_old_rec.edit_flag;

276: pqh_tat_shd.g_old_rec.view_flag;
277: End If;
278: If (p_rec.edit_flag = hr_api.g_varchar2) then
279: p_rec.edit_flag :=
280: pqh_tat_shd.g_old_rec.edit_flag;
281: End If;
282: If (p_rec.attribute_id = hr_api.g_number) then
283: p_rec.attribute_id :=
284: pqh_tat_shd.g_old_rec.attribute_id;

Line 284: pqh_tat_shd.g_old_rec.attribute_id;

280: pqh_tat_shd.g_old_rec.edit_flag;
281: End If;
282: If (p_rec.attribute_id = hr_api.g_number) then
283: p_rec.attribute_id :=
284: pqh_tat_shd.g_old_rec.attribute_id;
285: End If;
286: If (p_rec.template_id = hr_api.g_number) then
287: p_rec.template_id :=
288: pqh_tat_shd.g_old_rec.template_id;

Line 288: pqh_tat_shd.g_old_rec.template_id;

284: pqh_tat_shd.g_old_rec.attribute_id;
285: End If;
286: If (p_rec.template_id = hr_api.g_number) then
287: p_rec.template_id :=
288: pqh_tat_shd.g_old_rec.template_id;
289: End If;
290:
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 302: p_rec in out nocopy pqh_tat_shd.g_rec_type

298: -- ----------------------------------------------------------------------------
299: Procedure upd
300: (
301: p_effective_date in date,
302: p_rec in out nocopy pqh_tat_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'upd';
306: --

Line 312: pqh_tat_shd.lck

308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- We must lock the row which we need to update.
311: --
312: pqh_tat_shd.lck
313: (
314: p_rec.template_attribute_id,
315: p_rec.object_version_number
316: );

Line 357: l_rec pqh_tat_shd.g_rec_type;

353: p_template_id in number default hr_api.g_number,
354: p_object_version_number in out nocopy number
355: ) is
356: --
357: l_rec pqh_tat_shd.g_rec_type;
358: l_proc varchar2(72) := g_package||'upd';
359: --
360: Begin
361: hr_utility.set_location('Entering:'||l_proc, 5);

Line 367: pqh_tat_shd.convert_args

363: -- Call conversion function to turn arguments into the
364: -- l_rec structure.
365: --
366: l_rec :=
367: pqh_tat_shd.convert_args
368: (
369: p_required_flag,
370: p_view_flag,
371: p_edit_flag,