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_OPS_UPD dependencies on PQH_OPS_SHD

Line 55: (p_rec in out nocopy pqh_ops_shd.g_rec_type

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

Line 89: pqh_ops_shd.constraint_error

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

Line 94: pqh_ops_shd.constraint_error

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

Line 99: pqh_ops_shd.constraint_error

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

Line 139: (p_rec in pqh_ops_shd.g_rec_type

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

Line 184: ,p_rec in pqh_ops_shd.g_rec_type

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

Line 210: => pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id

206: => p_rec.unit_percentage
207: ,p_object_version_number
208: => p_rec.object_version_number
209: ,p_wrkplc_vldtn_ver_id_o
210: => pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id
211: ,p_wrkplc_operation_id_o
212: => pqh_ops_shd.g_old_rec.wrkplc_operation_id
213: ,p_business_group_id_o
214: => pqh_ops_shd.g_old_rec.business_group_id

Line 212: => pqh_ops_shd.g_old_rec.wrkplc_operation_id

208: => p_rec.object_version_number
209: ,p_wrkplc_vldtn_ver_id_o
210: => pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id
211: ,p_wrkplc_operation_id_o
212: => pqh_ops_shd.g_old_rec.wrkplc_operation_id
213: ,p_business_group_id_o
214: => pqh_ops_shd.g_old_rec.business_group_id
215: ,p_description_o
216: => pqh_ops_shd.g_old_rec.description

Line 214: => pqh_ops_shd.g_old_rec.business_group_id

210: => pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id
211: ,p_wrkplc_operation_id_o
212: => pqh_ops_shd.g_old_rec.wrkplc_operation_id
213: ,p_business_group_id_o
214: => pqh_ops_shd.g_old_rec.business_group_id
215: ,p_description_o
216: => pqh_ops_shd.g_old_rec.description
217: ,p_unit_percentage_o
218: => pqh_ops_shd.g_old_rec.unit_percentage

Line 216: => pqh_ops_shd.g_old_rec.description

212: => pqh_ops_shd.g_old_rec.wrkplc_operation_id
213: ,p_business_group_id_o
214: => pqh_ops_shd.g_old_rec.business_group_id
215: ,p_description_o
216: => pqh_ops_shd.g_old_rec.description
217: ,p_unit_percentage_o
218: => pqh_ops_shd.g_old_rec.unit_percentage
219: ,p_object_version_number_o
220: => pqh_ops_shd.g_old_rec.object_version_number

Line 218: => pqh_ops_shd.g_old_rec.unit_percentage

214: => pqh_ops_shd.g_old_rec.business_group_id
215: ,p_description_o
216: => pqh_ops_shd.g_old_rec.description
217: ,p_unit_percentage_o
218: => pqh_ops_shd.g_old_rec.unit_percentage
219: ,p_object_version_number_o
220: => pqh_ops_shd.g_old_rec.object_version_number
221: );
222: --

Line 220: => pqh_ops_shd.g_old_rec.object_version_number

216: => pqh_ops_shd.g_old_rec.description
217: ,p_unit_percentage_o
218: => pqh_ops_shd.g_old_rec.unit_percentage
219: ,p_object_version_number_o
220: => pqh_ops_shd.g_old_rec.object_version_number
221: );
222: --
223: exception
224: --

Line 280: (p_rec in out nocopy pqh_ops_shd.g_rec_type

276: --
277: -- {End Of Comments}
278: -- ----------------------------------------------------------------------------
279: Procedure convert_defs
280: (p_rec in out nocopy pqh_ops_shd.g_rec_type
281: ) is
282: --
283: Begin
284: --

Line 292: pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id;

288: -- is being used then we must set to the 'current' argument value.
289: --
290: If (p_rec.wrkplc_vldtn_ver_id = hr_api.g_number) then
291: p_rec.wrkplc_vldtn_ver_id :=
292: pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id;
293: End If;
294: If (p_rec.wrkplc_operation_id = hr_api.g_number) then
295: p_rec.wrkplc_operation_id :=
296: pqh_ops_shd.g_old_rec.wrkplc_operation_id;

Line 296: pqh_ops_shd.g_old_rec.wrkplc_operation_id;

292: pqh_ops_shd.g_old_rec.wrkplc_vldtn_ver_id;
293: End If;
294: If (p_rec.wrkplc_operation_id = hr_api.g_number) then
295: p_rec.wrkplc_operation_id :=
296: pqh_ops_shd.g_old_rec.wrkplc_operation_id;
297: End If;
298: If (p_rec.business_group_id = hr_api.g_number) then
299: p_rec.business_group_id :=
300: pqh_ops_shd.g_old_rec.business_group_id;

Line 300: pqh_ops_shd.g_old_rec.business_group_id;

296: pqh_ops_shd.g_old_rec.wrkplc_operation_id;
297: End If;
298: If (p_rec.business_group_id = hr_api.g_number) then
299: p_rec.business_group_id :=
300: pqh_ops_shd.g_old_rec.business_group_id;
301: End If;
302: If (p_rec.description = hr_api.g_varchar2) then
303: p_rec.description :=
304: pqh_ops_shd.g_old_rec.description;

Line 304: pqh_ops_shd.g_old_rec.description;

300: pqh_ops_shd.g_old_rec.business_group_id;
301: End If;
302: If (p_rec.description = hr_api.g_varchar2) then
303: p_rec.description :=
304: pqh_ops_shd.g_old_rec.description;
305: End If;
306: If (p_rec.unit_percentage = hr_api.g_number) then
307: p_rec.unit_percentage :=
308: pqh_ops_shd.g_old_rec.unit_percentage;

Line 308: pqh_ops_shd.g_old_rec.unit_percentage;

304: pqh_ops_shd.g_old_rec.description;
305: End If;
306: If (p_rec.unit_percentage = hr_api.g_number) then
307: p_rec.unit_percentage :=
308: pqh_ops_shd.g_old_rec.unit_percentage;
309: End If;
310: --
311: End convert_defs;
312: --

Line 318: ,p_rec in out nocopy pqh_ops_shd.g_rec_type

314: -- |---------------------------------< upd >----------------------------------|
315: -- ----------------------------------------------------------------------------
316: Procedure upd
317: (p_effective_date in date
318: ,p_rec in out nocopy pqh_ops_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'upd';
322: --

Line 328: pqh_ops_shd.lck

324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- We must lock the row which we need to update.
327: --
328: pqh_ops_shd.lck
329: (p_rec.wrkplc_vldtn_op_id
330: ,p_rec.object_version_number
331: );
332: --

Line 381: l_rec pqh_ops_shd.g_rec_type;

377: ,p_description in varchar2 default hr_api.g_varchar2
378: ,p_unit_percentage in number default hr_api.g_number
379: ) is
380: --
381: l_rec pqh_ops_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'upd';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 391: pqh_ops_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- l_rec structure.
389: --
390: l_rec :=
391: pqh_ops_shd.convert_args
392: (p_wrkplc_vldtn_op_id
393: ,p_wrkplc_vldtn_ver_id
394: ,p_wrkplc_operation_id
395: ,p_business_group_id