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.PQH_DEF_UPD dependencies on PQH_DEF_SHD

Line 55: (p_rec in out nocopy pqh_def_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_def_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 88: pqh_def_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: pqh_def_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --

Line 93: pqh_def_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: pqh_def_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --

Line 98: pqh_def_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: pqh_def_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in pqh_def_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in pqh_def_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 183: ,p_rec in pqh_def_shd.g_rec_type

179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_effective_date in date
183: ,p_rec in pqh_def_shd.g_rec_type
184: ) is
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --

Line 207: => pqh_def_shd.g_old_rec.validation_name

203: => p_rec.remuneration_regulation
204: ,p_object_version_number
205: => p_rec.object_version_number
206: ,p_validation_name_o
207: => pqh_def_shd.g_old_rec.validation_name
208: ,p_business_group_id_o
209: => pqh_def_shd.g_old_rec.business_group_id
210: ,p_employment_type_o
211: => pqh_def_shd.g_old_rec.employment_type

Line 209: => pqh_def_shd.g_old_rec.business_group_id

205: => p_rec.object_version_number
206: ,p_validation_name_o
207: => pqh_def_shd.g_old_rec.validation_name
208: ,p_business_group_id_o
209: => pqh_def_shd.g_old_rec.business_group_id
210: ,p_employment_type_o
211: => pqh_def_shd.g_old_rec.employment_type
212: ,p_remuneration_regulation_o
213: => pqh_def_shd.g_old_rec.remuneration_regulation

Line 211: => pqh_def_shd.g_old_rec.employment_type

207: => pqh_def_shd.g_old_rec.validation_name
208: ,p_business_group_id_o
209: => pqh_def_shd.g_old_rec.business_group_id
210: ,p_employment_type_o
211: => pqh_def_shd.g_old_rec.employment_type
212: ,p_remuneration_regulation_o
213: => pqh_def_shd.g_old_rec.remuneration_regulation
214: ,p_object_version_number_o
215: => pqh_def_shd.g_old_rec.object_version_number

Line 213: => pqh_def_shd.g_old_rec.remuneration_regulation

209: => pqh_def_shd.g_old_rec.business_group_id
210: ,p_employment_type_o
211: => pqh_def_shd.g_old_rec.employment_type
212: ,p_remuneration_regulation_o
213: => pqh_def_shd.g_old_rec.remuneration_regulation
214: ,p_object_version_number_o
215: => pqh_def_shd.g_old_rec.object_version_number
216: );
217: --

Line 215: => pqh_def_shd.g_old_rec.object_version_number

211: => pqh_def_shd.g_old_rec.employment_type
212: ,p_remuneration_regulation_o
213: => pqh_def_shd.g_old_rec.remuneration_regulation
214: ,p_object_version_number_o
215: => pqh_def_shd.g_old_rec.object_version_number
216: );
217: --
218: exception
219: --

Line 275: (p_rec in out nocopy pqh_def_shd.g_rec_type

271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure convert_defs
275: (p_rec in out nocopy pqh_def_shd.g_rec_type
276: ) is
277: --
278: Begin
279: --

Line 287: pqh_def_shd.g_old_rec.validation_name;

283: -- is being used then we must set to the 'current' argument value.
284: --
285: If (p_rec.validation_name = hr_api.g_varchar2) then
286: p_rec.validation_name :=
287: pqh_def_shd.g_old_rec.validation_name;
288: End If;
289: If (p_rec.business_group_id = hr_api.g_number) then
290: p_rec.business_group_id :=
291: pqh_def_shd.g_old_rec.business_group_id;

Line 291: pqh_def_shd.g_old_rec.business_group_id;

287: pqh_def_shd.g_old_rec.validation_name;
288: End If;
289: If (p_rec.business_group_id = hr_api.g_number) then
290: p_rec.business_group_id :=
291: pqh_def_shd.g_old_rec.business_group_id;
292: End If;
293: If (p_rec.employment_type = hr_api.g_varchar2) then
294: p_rec.employment_type :=
295: pqh_def_shd.g_old_rec.employment_type;

Line 295: pqh_def_shd.g_old_rec.employment_type;

291: pqh_def_shd.g_old_rec.business_group_id;
292: End If;
293: If (p_rec.employment_type = hr_api.g_varchar2) then
294: p_rec.employment_type :=
295: pqh_def_shd.g_old_rec.employment_type;
296: End If;
297: If (p_rec.remuneration_regulation = hr_api.g_varchar2) then
298: p_rec.remuneration_regulation :=
299: pqh_def_shd.g_old_rec.remuneration_regulation;

Line 299: pqh_def_shd.g_old_rec.remuneration_regulation;

295: pqh_def_shd.g_old_rec.employment_type;
296: End If;
297: If (p_rec.remuneration_regulation = hr_api.g_varchar2) then
298: p_rec.remuneration_regulation :=
299: pqh_def_shd.g_old_rec.remuneration_regulation;
300: End If;
301: --
302: End convert_defs;
303: --

Line 309: ,p_rec in out nocopy pqh_def_shd.g_rec_type

305: -- |---------------------------------< upd >----------------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure upd
308: (p_effective_date in date
309: ,p_rec in out nocopy pqh_def_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --

Line 319: pqh_def_shd.lck

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

Line 371: l_rec pqh_def_shd.g_rec_type;

367: ,p_employment_type in varchar2 default hr_api.g_varchar2
368: ,p_remuneration_regulation in varchar2 default hr_api.g_varchar2
369: ) is
370: --
371: l_rec pqh_def_shd.g_rec_type;
372: l_proc varchar2(72) := g_package||'upd';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);

Line 381: pqh_def_shd.convert_args

377: -- Call conversion function to turn arguments into the
378: -- l_rec structure.
379: --
380: l_rec :=
381: pqh_def_shd.convert_args
382: (p_wrkplc_vldtn_id
383: ,p_validation_name
384: ,p_business_group_id
385: ,p_employment_type