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_CEC_UPD dependencies on PQH_CEC_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pqh_cec_shd.g_rec_type) is

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

Line 81: pqh_cec_shd.constraint_error

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

Line 85: pqh_cec_shd.constraint_error

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

Line 89: pqh_cec_shd.constraint_error

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

Line 127: Procedure pre_update(p_rec in pqh_cec_shd.g_rec_type) is

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

Line 169: Procedure post_update(p_rec in pqh_cec_shd.g_rec_type) is

165: -- Internal Row Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure post_update(p_rec in pqh_cec_shd.g_rec_type) is
170: --
171: l_proc varchar2(72) := g_package||'post_update';
172: --
173: Begin

Line 189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name

185: ,p_legislation_code =>p_rec.legislation_code
186: ,p_responsibility_key =>p_rec.responsibility_key
187: ,p_transaction_short_name =>p_rec.transaction_short_name
188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number

Line 190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code

186: ,p_responsibility_key =>p_rec.responsibility_key
187: ,p_transaction_short_name =>p_rec.transaction_short_name
188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
194: );

Line 191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key

187: ,p_transaction_short_name =>p_rec.transaction_short_name
188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
194: );
195: --

Line 192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name

188: ,p_object_version_number =>p_rec.object_version_number
189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
194: );
195: --
196: exception

Line 193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number

189: ,p_application_short_name_o =>pqh_cec_shd.g_old_rec.application_short_name
190: ,p_legislation_code_o =>pqh_cec_shd.g_old_rec.legislation_code
191: ,p_responsibility_key_o =>pqh_cec_shd.g_old_rec.responsibility_key
192: ,p_transaction_short_name_o =>pqh_cec_shd.g_old_rec.transaction_short_name
193: ,p_object_version_number_o =>pqh_cec_shd.g_old_rec.object_version_number
194: );
195: --
196: exception
197: --

Line 255: Procedure convert_defs(p_rec in out nocopy pqh_cec_shd.g_rec_type) is

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

Line 270: pqh_cec_shd.g_old_rec.application_short_name;

266: -- is being used then we must set to the 'current' argument value.
267: --
268: If (p_rec.application_short_name = hr_api.g_varchar2) then
269: p_rec.application_short_name :=
270: pqh_cec_shd.g_old_rec.application_short_name;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pqh_cec_shd.g_old_rec.legislation_code;

Line 274: pqh_cec_shd.g_old_rec.legislation_code;

270: pqh_cec_shd.g_old_rec.application_short_name;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pqh_cec_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.responsibility_key = hr_api.g_varchar2) then
277: p_rec.responsibility_key :=
278: pqh_cec_shd.g_old_rec.responsibility_key;

Line 278: pqh_cec_shd.g_old_rec.responsibility_key;

274: pqh_cec_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.responsibility_key = hr_api.g_varchar2) then
277: p_rec.responsibility_key :=
278: pqh_cec_shd.g_old_rec.responsibility_key;
279: End If;
280: If (p_rec.transaction_short_name = hr_api.g_varchar2) then
281: p_rec.transaction_short_name :=
282: pqh_cec_shd.g_old_rec.transaction_short_name;

Line 282: pqh_cec_shd.g_old_rec.transaction_short_name;

278: pqh_cec_shd.g_old_rec.responsibility_key;
279: End If;
280: If (p_rec.transaction_short_name = hr_api.g_varchar2) then
281: p_rec.transaction_short_name :=
282: pqh_cec_shd.g_old_rec.transaction_short_name;
283: End If;
284:
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 295: p_rec in out nocopy pqh_cec_shd.g_rec_type

291: -- |---------------------------------< upd >----------------------------------|
292: -- ----------------------------------------------------------------------------
293: Procedure upd
294: (
295: p_rec in out nocopy pqh_cec_shd.g_rec_type
296: ) is
297: --
298: l_proc varchar2(72) := g_package||'upd';
299: --

Line 305: pqh_cec_shd.lck

301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- We must lock the row which we need to update.
304: --
305: pqh_cec_shd.lck
306: (
307: p_rec.context,
308: p_rec.object_version_number
309: );

Line 346: l_rec pqh_cec_shd.g_rec_type;

342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,
343: p_object_version_number in out nocopy number
344: ) is
345: --
346: l_rec pqh_cec_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'upd';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);

Line 356: pqh_cec_shd.convert_args

352: -- Call conversion function to turn arguments into the
353: -- l_rec structure.
354: --
355: l_rec :=
356: pqh_cec_shd.convert_args
357: (
358: p_context,
359: p_application_short_name,
360: p_legislation_code,