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_TEM_UPD dependencies on PQH_TEM_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_tem_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_tem_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 84: pqh_tem_shd.constraint_error

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

Line 88: pqh_tem_shd.constraint_error

84: pqh_tem_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_tem_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_tem_shd.constraint_error

Line 92: pqh_tem_shd.constraint_error

88: pqh_tem_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_tem_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When Others Then
95: Raise;
96: End update_dml;

Line 130: Procedure pre_update(p_rec in pqh_tem_shd.g_rec_type) is

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

Line 173: p_effective_date in date,p_rec in pqh_tem_shd.g_rec_type) is

169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure post_update(
173: p_effective_date in date,p_rec in pqh_tem_shd.g_rec_type) is
174: --
175: l_proc varchar2(72) := g_package||'post_update';
176: --
177: Begin

Line 200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name

196: ,p_freeze_status_cd =>p_rec.freeze_status_cd
197: ,p_template_type_cd =>p_rec.template_type_cd
198: ,p_legislation_code =>p_rec.legislation_code
199: ,p_effective_date =>p_effective_date
200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag

Line 201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name

197: ,p_template_type_cd =>p_rec.template_type_cd
198: ,p_legislation_code =>p_rec.legislation_code
199: ,p_effective_date =>p_effective_date
200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id

Line 202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag

198: ,p_legislation_code =>p_rec.legislation_code
199: ,p_effective_date =>p_effective_date
200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag

Line 203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag

199: ,p_effective_date =>p_effective_date
200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number

Line 204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag

200: ,p_template_name_o =>pqh_tem_shd.g_old_rec.template_name
201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd

Line 205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id

201: ,p_short_name_o =>pqh_tem_shd.g_old_rec.short_name
202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd

Line 206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag

202: ,p_attribute_only_flag_o =>pqh_tem_shd.g_old_rec.attribute_only_flag
203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code

Line 207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number

203: ,p_enable_flag_o =>pqh_tem_shd.g_old_rec.enable_flag
204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
211: );

Line 208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd

204: ,p_create_flag_o =>pqh_tem_shd.g_old_rec.create_flag
205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
211: );
212: --

Line 209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd

205: ,p_transaction_category_id_o =>pqh_tem_shd.g_old_rec.transaction_category_id
206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
211: );
212: --
213: exception

Line 210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code

206: ,p_under_review_flag_o =>pqh_tem_shd.g_old_rec.under_review_flag
207: ,p_object_version_number_o =>pqh_tem_shd.g_old_rec.object_version_number
208: ,p_freeze_status_cd_o =>pqh_tem_shd.g_old_rec.freeze_status_cd
209: ,p_template_type_cd_o =>pqh_tem_shd.g_old_rec.template_type_cd
210: ,p_legislation_code_o =>pqh_tem_shd.g_old_rec.legislation_code
211: );
212: --
213: exception
214: --

Line 272: Procedure convert_defs(p_rec in out nocopy pqh_tem_shd.g_rec_type) is

268: -- Internal Row Handler Use Only.
269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure convert_defs(p_rec in out nocopy pqh_tem_shd.g_rec_type) is
273: --
274: l_proc varchar2(72) := g_package||'convert_defs';
275: --
276: Begin

Line 287: pqh_tem_shd.g_old_rec.template_name;

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

Line 291: pqh_tem_shd.g_old_rec.short_name;

287: pqh_tem_shd.g_old_rec.template_name;
288: End If;
289: If (p_rec.short_name = hr_api.g_varchar2) then
290: p_rec.short_name :=
291: pqh_tem_shd.g_old_rec.short_name;
292: End If;
293: If (p_rec.attribute_only_flag = hr_api.g_varchar2) then
294: p_rec.attribute_only_flag :=
295: pqh_tem_shd.g_old_rec.attribute_only_flag;

Line 295: pqh_tem_shd.g_old_rec.attribute_only_flag;

291: pqh_tem_shd.g_old_rec.short_name;
292: End If;
293: If (p_rec.attribute_only_flag = hr_api.g_varchar2) then
294: p_rec.attribute_only_flag :=
295: pqh_tem_shd.g_old_rec.attribute_only_flag;
296: End If;
297: If (p_rec.enable_flag = hr_api.g_varchar2) then
298: p_rec.enable_flag :=
299: pqh_tem_shd.g_old_rec.enable_flag;

Line 299: pqh_tem_shd.g_old_rec.enable_flag;

295: pqh_tem_shd.g_old_rec.attribute_only_flag;
296: End If;
297: If (p_rec.enable_flag = hr_api.g_varchar2) then
298: p_rec.enable_flag :=
299: pqh_tem_shd.g_old_rec.enable_flag;
300: End If;
301: If (p_rec.create_flag = hr_api.g_varchar2) then
302: p_rec.create_flag :=
303: pqh_tem_shd.g_old_rec.create_flag;

Line 303: pqh_tem_shd.g_old_rec.create_flag;

299: pqh_tem_shd.g_old_rec.enable_flag;
300: End If;
301: If (p_rec.create_flag = hr_api.g_varchar2) then
302: p_rec.create_flag :=
303: pqh_tem_shd.g_old_rec.create_flag;
304: End If;
305: If (p_rec.transaction_category_id = hr_api.g_number) then
306: p_rec.transaction_category_id :=
307: pqh_tem_shd.g_old_rec.transaction_category_id;

Line 307: pqh_tem_shd.g_old_rec.transaction_category_id;

303: pqh_tem_shd.g_old_rec.create_flag;
304: End If;
305: If (p_rec.transaction_category_id = hr_api.g_number) then
306: p_rec.transaction_category_id :=
307: pqh_tem_shd.g_old_rec.transaction_category_id;
308: End If;
309: If (p_rec.under_review_flag = hr_api.g_varchar2) then
310: p_rec.under_review_flag :=
311: pqh_tem_shd.g_old_rec.under_review_flag;

Line 311: pqh_tem_shd.g_old_rec.under_review_flag;

307: pqh_tem_shd.g_old_rec.transaction_category_id;
308: End If;
309: If (p_rec.under_review_flag = hr_api.g_varchar2) then
310: p_rec.under_review_flag :=
311: pqh_tem_shd.g_old_rec.under_review_flag;
312: End If;
313: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then
314: p_rec.freeze_status_cd :=
315: pqh_tem_shd.g_old_rec.freeze_status_cd;

Line 315: pqh_tem_shd.g_old_rec.freeze_status_cd;

311: pqh_tem_shd.g_old_rec.under_review_flag;
312: End If;
313: If (p_rec.freeze_status_cd = hr_api.g_varchar2) then
314: p_rec.freeze_status_cd :=
315: pqh_tem_shd.g_old_rec.freeze_status_cd;
316: End If;
317: If (p_rec.template_type_cd = hr_api.g_varchar2) then
318: p_rec.template_type_cd :=
319: pqh_tem_shd.g_old_rec.template_type_cd;

Line 319: pqh_tem_shd.g_old_rec.template_type_cd;

315: pqh_tem_shd.g_old_rec.freeze_status_cd;
316: End If;
317: If (p_rec.template_type_cd = hr_api.g_varchar2) then
318: p_rec.template_type_cd :=
319: pqh_tem_shd.g_old_rec.template_type_cd;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then
322: p_rec.legislation_code :=
323: pqh_tem_shd.g_old_rec.legislation_code;

Line 323: pqh_tem_shd.g_old_rec.legislation_code;

319: pqh_tem_shd.g_old_rec.template_type_cd;
320: End If;
321: If (p_rec.legislation_code = hr_api.g_varchar2) then
322: p_rec.legislation_code :=
323: pqh_tem_shd.g_old_rec.legislation_code;
324: End If;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: --

Line 336: p_rec in out nocopy pqh_tem_shd.g_rec_type

332: -- ----------------------------------------------------------------------------
333: Procedure upd
334: (
335: p_effective_date in date,
336: p_rec in out nocopy pqh_tem_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --

Line 346: pqh_tem_shd.lck

342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: pqh_tem_shd.lck
347: (
348: p_rec.template_id,
349: p_rec.object_version_number
350: );

Line 396: l_rec pqh_tem_shd.g_rec_type;

392: p_template_type_cd in varchar2 default hr_api.g_varchar2,
393: p_legislation_code in varchar2 default hr_api.g_varchar2
394: ) is
395: --
396: l_rec pqh_tem_shd.g_rec_type;
397: l_proc varchar2(72) := g_package||'upd';
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);

Line 406: pqh_tem_shd.convert_args

402: -- Call conversion function to turn arguments into the
403: -- l_rec structure.
404: --
405: l_rec :=
406: pqh_tem_shd.convert_args
407: (
408: p_template_name,
409: p_short_name,
410: p_template_id,