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_TTM_UPD dependencies on PQH_TTM_SHD

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

Line 78: pqh_ttm_shd.constraint_error

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

Line 82: pqh_ttm_shd.constraint_error

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

Line 86: pqh_ttm_shd.constraint_error

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

Line 124: Procedure pre_update(p_rec in pqh_ttm_shd.g_rec_type) is

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

Line 167: p_effective_date in date,p_rec in pqh_ttm_shd.g_rec_type) is

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

Line 188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag

184: ,p_transaction_id =>p_rec.transaction_id
185: ,p_transaction_category_id =>p_rec.transaction_category_id
186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_effective_date =>p_effective_date
188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag
189: ,p_template_id_o =>pqh_ttm_shd.g_old_rec.template_id
190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id
191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id
192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number

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

185: ,p_transaction_category_id =>p_rec.transaction_category_id
186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_effective_date =>p_effective_date
188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag
189: ,p_template_id_o =>pqh_ttm_shd.g_old_rec.template_id
190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id
191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id
192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number
193: );

Line 190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id

186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_effective_date =>p_effective_date
188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag
189: ,p_template_id_o =>pqh_ttm_shd.g_old_rec.template_id
190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id
191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id
192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number
193: );
194: --

Line 191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id

187: ,p_effective_date =>p_effective_date
188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag
189: ,p_template_id_o =>pqh_ttm_shd.g_old_rec.template_id
190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id
191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id
192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number
193: );
194: --
195: exception

Line 192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number

188: ,p_enable_flag_o =>pqh_ttm_shd.g_old_rec.enable_flag
189: ,p_template_id_o =>pqh_ttm_shd.g_old_rec.template_id
190: ,p_transaction_id_o =>pqh_ttm_shd.g_old_rec.transaction_id
191: ,p_transaction_category_id_o =>pqh_ttm_shd.g_old_rec.transaction_category_id
192: ,p_object_version_number_o =>pqh_ttm_shd.g_old_rec.object_version_number
193: );
194: --
195: exception
196: --

Line 254: Procedure convert_defs(p_rec in out nocopy pqh_ttm_shd.g_rec_type) is

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

Line 269: pqh_ttm_shd.g_old_rec.enable_flag;

265: -- is being used then we must set to the 'current' argument value.
266: --
267: If (p_rec.enable_flag = hr_api.g_varchar2) then
268: p_rec.enable_flag :=
269: pqh_ttm_shd.g_old_rec.enable_flag;
270: End If;
271: If (p_rec.template_id = hr_api.g_number) then
272: p_rec.template_id :=
273: pqh_ttm_shd.g_old_rec.template_id;

Line 273: pqh_ttm_shd.g_old_rec.template_id;

269: pqh_ttm_shd.g_old_rec.enable_flag;
270: End If;
271: If (p_rec.template_id = hr_api.g_number) then
272: p_rec.template_id :=
273: pqh_ttm_shd.g_old_rec.template_id;
274: End If;
275: If (p_rec.transaction_id = hr_api.g_number) then
276: p_rec.transaction_id :=
277: pqh_ttm_shd.g_old_rec.transaction_id;

Line 277: pqh_ttm_shd.g_old_rec.transaction_id;

273: pqh_ttm_shd.g_old_rec.template_id;
274: End If;
275: If (p_rec.transaction_id = hr_api.g_number) then
276: p_rec.transaction_id :=
277: pqh_ttm_shd.g_old_rec.transaction_id;
278: End If;
279: If (p_rec.transaction_category_id = hr_api.g_number) then
280: p_rec.transaction_category_id :=
281: pqh_ttm_shd.g_old_rec.transaction_category_id;

Line 281: pqh_ttm_shd.g_old_rec.transaction_category_id;

277: pqh_ttm_shd.g_old_rec.transaction_id;
278: End If;
279: If (p_rec.transaction_category_id = hr_api.g_number) then
280: p_rec.transaction_category_id :=
281: pqh_ttm_shd.g_old_rec.transaction_category_id;
282: End If;
283:
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 295: p_rec in out nocopy pqh_ttm_shd.g_rec_type

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

Line 305: pqh_ttm_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_ttm_shd.lck
306: (
307: p_rec.transaction_template_id,
308: p_rec.object_version_number
309: );

Line 349: l_rec pqh_ttm_shd.g_rec_type;

345: p_transaction_category_id in number default hr_api.g_number,
346: p_object_version_number in out nocopy number
347: ) is
348: --
349: l_rec pqh_ttm_shd.g_rec_type;
350: l_proc varchar2(72) := g_package||'upd';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);

Line 359: pqh_ttm_shd.convert_args

355: -- Call conversion function to turn arguments into the
356: -- l_rec structure.
357: --
358: l_rec :=
359: pqh_ttm_shd.convert_args
360: (
361: p_transaction_template_id,
362: p_enable_flag,
363: p_template_id,