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_RTM_UPD dependencies on PQH_RTM_SHD

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

Line 77: pqh_rtm_shd.constraint_error

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

Line 81: pqh_rtm_shd.constraint_error

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

Line 85: pqh_rtm_shd.constraint_error

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

Line 123: Procedure pre_update(p_rec in pqh_rtm_shd.g_rec_type) is

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

Line 166: p_effective_date in date,p_rec in pqh_rtm_shd.g_rec_type) is

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

Line 187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id

183: ,p_template_id =>p_rec.template_id
184: ,p_enable_flag =>p_rec.enable_flag
185: ,p_object_version_number =>p_rec.object_version_number
186: ,p_effective_date =>p_effective_date
187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id
188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id
189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id
190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag
191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number

Line 188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id

184: ,p_enable_flag =>p_rec.enable_flag
185: ,p_object_version_number =>p_rec.object_version_number
186: ,p_effective_date =>p_effective_date
187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id
188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id
189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id
190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag
191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number
192: );

Line 189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id

185: ,p_object_version_number =>p_rec.object_version_number
186: ,p_effective_date =>p_effective_date
187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id
188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id
189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id
190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag
191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number
192: );
193: --

Line 190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag

186: ,p_effective_date =>p_effective_date
187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id
188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id
189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id
190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag
191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number
192: );
193: --
194: exception

Line 191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number

187: ,p_role_id_o =>pqh_rtm_shd.g_old_rec.role_id
188: ,p_transaction_category_id_o =>pqh_rtm_shd.g_old_rec.transaction_category_id
189: ,p_template_id_o =>pqh_rtm_shd.g_old_rec.template_id
190: ,p_enable_flag_o =>pqh_rtm_shd.g_old_rec.enable_flag
191: ,p_object_version_number_o =>pqh_rtm_shd.g_old_rec.object_version_number
192: );
193: --
194: exception
195: --

Line 253: Procedure convert_defs(p_rec in out nocopy pqh_rtm_shd.g_rec_type) is

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

Line 268: pqh_rtm_shd.g_old_rec.role_id;

264: -- is being used then we must set to the 'current' argument value.
265: --
266: If (p_rec.role_id = hr_api.g_number) then
267: p_rec.role_id :=
268: pqh_rtm_shd.g_old_rec.role_id;
269: End If;
270: If (p_rec.transaction_category_id = hr_api.g_number) then
271: p_rec.transaction_category_id :=
272: pqh_rtm_shd.g_old_rec.transaction_category_id;

Line 272: pqh_rtm_shd.g_old_rec.transaction_category_id;

268: pqh_rtm_shd.g_old_rec.role_id;
269: End If;
270: If (p_rec.transaction_category_id = hr_api.g_number) then
271: p_rec.transaction_category_id :=
272: pqh_rtm_shd.g_old_rec.transaction_category_id;
273: End If;
274: If (p_rec.template_id = hr_api.g_number) then
275: p_rec.template_id :=
276: pqh_rtm_shd.g_old_rec.template_id;

Line 276: pqh_rtm_shd.g_old_rec.template_id;

272: pqh_rtm_shd.g_old_rec.transaction_category_id;
273: End If;
274: If (p_rec.template_id = hr_api.g_number) then
275: p_rec.template_id :=
276: pqh_rtm_shd.g_old_rec.template_id;
277: End If;
278: If (p_rec.enable_flag = hr_api.g_varchar2) then
279: p_rec.enable_flag :=
280: pqh_rtm_shd.g_old_rec.enable_flag;

Line 280: pqh_rtm_shd.g_old_rec.enable_flag;

276: pqh_rtm_shd.g_old_rec.template_id;
277: End If;
278: If (p_rec.enable_flag = hr_api.g_varchar2) then
279: p_rec.enable_flag :=
280: pqh_rtm_shd.g_old_rec.enable_flag;
281: End If;
282:
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 294: p_rec in out nocopy pqh_rtm_shd.g_rec_type

290: -- ----------------------------------------------------------------------------
291: Procedure upd
292: (
293: p_effective_date in date,
294: p_rec in out nocopy pqh_rtm_shd.g_rec_type
295: ) is
296: --
297: l_proc varchar2(72) := g_package||'upd';
298: --

Line 304: pqh_rtm_shd.lck

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

Line 347: l_rec pqh_rtm_shd.g_rec_type;

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

Line 357: pqh_rtm_shd.convert_args

353: -- Call conversion function to turn arguments into the
354: -- l_rec structure.
355: --
356: l_rec :=
357: pqh_rtm_shd.convert_args
358: (
359: p_role_template_id,
360: p_role_id,
361: hr_api.g_number,