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_CET_UPD dependencies on PQH_CET_SHD

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

Line 85: pqh_cet_shd.constraint_error

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

Line 89: pqh_cet_shd.constraint_error

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

Line 93: pqh_cet_shd.constraint_error

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

Line 131: Procedure pre_update(p_rec in pqh_cet_shd.g_rec_type) is

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

Line 174: p_effective_date in date,p_rec in pqh_cet_shd.g_rec_type) is

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

Line 204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id

200: ,p_increment_by =>p_rec.increment_by
201: ,p_status =>p_rec.status
202: ,p_object_version_number =>p_rec.object_version_number
203: ,p_effective_date =>p_effective_date
204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context

Line 205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id

201: ,p_status =>p_rec.status
202: ,p_object_version_number =>p_rec.object_version_number
203: ,p_effective_date =>p_effective_date
204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date

Line 206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id

202: ,p_object_version_number =>p_rec.object_version_number
203: ,p_effective_date =>p_effective_date
204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date

Line 207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode

203: ,p_effective_date =>p_effective_date
204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies

Line 208: ,p_context_o =>pqh_cet_shd.g_old_rec.context

204: ,p_transaction_category_id_o =>pqh_cet_shd.g_old_rec.transaction_category_id
205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name

Line 209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date

205: ,p_txn_category_attribute_id_o =>pqh_cet_shd.g_old_rec.txn_category_attribute_id
206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd

Line 210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date

206: ,p_context_business_group_id_o =>pqh_cet_shd.g_old_rec.context_business_group_id
207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with

Line 211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies

207: ,p_datetrack_mode_o =>pqh_cet_shd.g_old_rec.datetrack_mode
208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by

Line 212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name

208: ,p_context_o =>pqh_cet_shd.g_old_rec.context
209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status

Line 213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd

209: ,p_action_date_o =>pqh_cet_shd.g_old_rec.action_date
210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status
217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number

Line 214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with

210: ,p_src_effective_date_o =>pqh_cet_shd.g_old_rec.src_effective_date
211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status
217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
218: );

Line 215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by

211: ,p_number_of_copies_o =>pqh_cet_shd.g_old_rec.number_of_copies
212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status
217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
218: );
219: --

Line 216: ,p_status_o =>pqh_cet_shd.g_old_rec.status

212: ,p_display_name_o =>pqh_cet_shd.g_old_rec.display_name
213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status
217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
218: );
219: --
220: exception

Line 217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number

213: ,p_replacement_type_cd_o =>pqh_cet_shd.g_old_rec.replacement_type_cd
214: ,p_start_with_o =>pqh_cet_shd.g_old_rec.start_with
215: ,p_increment_by_o =>pqh_cet_shd.g_old_rec.increment_by
216: ,p_status_o =>pqh_cet_shd.g_old_rec.status
217: ,p_object_version_number_o =>pqh_cet_shd.g_old_rec.object_version_number
218: );
219: --
220: exception
221: --

Line 279: Procedure convert_defs(p_rec in out nocopy pqh_cet_shd.g_rec_type) is

275: -- Internal Row Handler Use Only.
276: --
277: -- {End Of Comments}
278: -- ----------------------------------------------------------------------------
279: Procedure convert_defs(p_rec in out nocopy pqh_cet_shd.g_rec_type) is
280: --
281: l_proc varchar2(72) := g_package||'convert_defs';
282: --
283: Begin

Line 294: pqh_cet_shd.g_old_rec.transaction_category_id;

290: -- is being used then we must set to the 'current' argument value.
291: --
292: If (p_rec.transaction_category_id = hr_api.g_number) then
293: p_rec.transaction_category_id :=
294: pqh_cet_shd.g_old_rec.transaction_category_id;
295: End If;
296: If (p_rec.txn_category_attribute_id = hr_api.g_number) then
297: p_rec.txn_category_attribute_id :=
298: pqh_cet_shd.g_old_rec.txn_category_attribute_id;

Line 298: pqh_cet_shd.g_old_rec.txn_category_attribute_id;

294: pqh_cet_shd.g_old_rec.transaction_category_id;
295: End If;
296: If (p_rec.txn_category_attribute_id = hr_api.g_number) then
297: p_rec.txn_category_attribute_id :=
298: pqh_cet_shd.g_old_rec.txn_category_attribute_id;
299: End If;
300: If (p_rec.context_business_group_id = hr_api.g_number) then
301: p_rec.context_business_group_id :=
302: pqh_cet_shd.g_old_rec.context_business_group_id;

Line 302: pqh_cet_shd.g_old_rec.context_business_group_id;

298: pqh_cet_shd.g_old_rec.txn_category_attribute_id;
299: End If;
300: If (p_rec.context_business_group_id = hr_api.g_number) then
301: p_rec.context_business_group_id :=
302: pqh_cet_shd.g_old_rec.context_business_group_id;
303: End If;
304: If (p_rec.datetrack_mode = hr_api.g_varchar2) then
305: p_rec.datetrack_mode :=
306: pqh_cet_shd.g_old_rec.datetrack_mode;

Line 306: pqh_cet_shd.g_old_rec.datetrack_mode;

302: pqh_cet_shd.g_old_rec.context_business_group_id;
303: End If;
304: If (p_rec.datetrack_mode = hr_api.g_varchar2) then
305: p_rec.datetrack_mode :=
306: pqh_cet_shd.g_old_rec.datetrack_mode;
307: End If;
308: If (p_rec.context = hr_api.g_varchar2) then
309: p_rec.context :=
310: pqh_cet_shd.g_old_rec.context ;

Line 310: pqh_cet_shd.g_old_rec.context ;

306: pqh_cet_shd.g_old_rec.datetrack_mode;
307: End If;
308: If (p_rec.context = hr_api.g_varchar2) then
309: p_rec.context :=
310: pqh_cet_shd.g_old_rec.context ;
311: End If;
312: If (p_rec.action_date = hr_api.g_date) then
313: p_rec.action_date :=
314: pqh_cet_shd.g_old_rec.action_date ;

Line 314: pqh_cet_shd.g_old_rec.action_date ;

310: pqh_cet_shd.g_old_rec.context ;
311: End If;
312: If (p_rec.action_date = hr_api.g_date) then
313: p_rec.action_date :=
314: pqh_cet_shd.g_old_rec.action_date ;
315: End If;
316: If (p_rec.src_effective_date = hr_api.g_date) then
317: p_rec.src_effective_date :=
318: pqh_cet_shd.g_old_rec.src_effective_date ;

Line 318: pqh_cet_shd.g_old_rec.src_effective_date ;

314: pqh_cet_shd.g_old_rec.action_date ;
315: End If;
316: If (p_rec.src_effective_date = hr_api.g_date) then
317: p_rec.src_effective_date :=
318: pqh_cet_shd.g_old_rec.src_effective_date ;
319: End If;
320: If (p_rec.number_of_copies = hr_api.g_number) then
321: p_rec.number_of_copies :=
322: pqh_cet_shd.g_old_rec.number_of_copies ;

Line 322: pqh_cet_shd.g_old_rec.number_of_copies ;

318: pqh_cet_shd.g_old_rec.src_effective_date ;
319: End If;
320: If (p_rec.number_of_copies = hr_api.g_number) then
321: p_rec.number_of_copies :=
322: pqh_cet_shd.g_old_rec.number_of_copies ;
323: End If;
324: If (p_rec.display_name = hr_api.g_varchar2) then
325: p_rec.display_name :=
326: pqh_cet_shd.g_old_rec.display_name;

Line 326: pqh_cet_shd.g_old_rec.display_name;

322: pqh_cet_shd.g_old_rec.number_of_copies ;
323: End If;
324: If (p_rec.display_name = hr_api.g_varchar2) then
325: p_rec.display_name :=
326: pqh_cet_shd.g_old_rec.display_name;
327: End If;
328: If (p_rec.replacement_type_cd = hr_api.g_varchar2) then
329: p_rec.replacement_type_cd :=
330: pqh_cet_shd.g_old_rec.replacement_type_cd;

Line 330: pqh_cet_shd.g_old_rec.replacement_type_cd;

326: pqh_cet_shd.g_old_rec.display_name;
327: End If;
328: If (p_rec.replacement_type_cd = hr_api.g_varchar2) then
329: p_rec.replacement_type_cd :=
330: pqh_cet_shd.g_old_rec.replacement_type_cd;
331: End If;
332: If (p_rec.start_with = hr_api.g_varchar2) then
333: p_rec.start_with :=
334: pqh_cet_shd.g_old_rec.start_with;

Line 334: pqh_cet_shd.g_old_rec.start_with;

330: pqh_cet_shd.g_old_rec.replacement_type_cd;
331: End If;
332: If (p_rec.start_with = hr_api.g_varchar2) then
333: p_rec.start_with :=
334: pqh_cet_shd.g_old_rec.start_with;
335: End If;
336: If (p_rec.increment_by = hr_api.g_number) then
337: p_rec.increment_by :=
338: pqh_cet_shd.g_old_rec.increment_by;

Line 338: pqh_cet_shd.g_old_rec.increment_by;

334: pqh_cet_shd.g_old_rec.start_with;
335: End If;
336: If (p_rec.increment_by = hr_api.g_number) then
337: p_rec.increment_by :=
338: pqh_cet_shd.g_old_rec.increment_by;
339: End If;
340: If (p_rec.status = hr_api.g_varchar2) then
341: p_rec.status :=
342: pqh_cet_shd.g_old_rec.status;

Line 342: pqh_cet_shd.g_old_rec.status;

338: pqh_cet_shd.g_old_rec.increment_by;
339: End If;
340: If (p_rec.status = hr_api.g_varchar2) then
341: p_rec.status :=
342: pqh_cet_shd.g_old_rec.status;
343: End If;
344:
345: --
346: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 356: p_rec in out nocopy pqh_cet_shd.g_rec_type

352: -- ----------------------------------------------------------------------------
353: Procedure upd
354: (
355: p_effective_date in date,
356: p_rec in out nocopy pqh_cet_shd.g_rec_type
357: ) is
358: --
359: l_proc varchar2(72) := g_package||'upd';
360: --

Line 366: pqh_cet_shd.lck

362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: -- We must lock the row which we need to update.
365: --
366: pqh_cet_shd.lck
367: (
368: p_rec.copy_entity_txn_id,
369: p_rec.object_version_number
370: );

Line 419: l_rec pqh_cet_shd.g_rec_type;

415: p_status in varchar2 default hr_api.g_varchar2,
416: p_object_version_number in out nocopy number
417: ) is
418: --
419: l_rec pqh_cet_shd.g_rec_type;
420: l_proc varchar2(72) := g_package||'upd';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);

Line 429: pqh_cet_shd.convert_args

425: -- Call conversion function to turn arguments into the
426: -- l_rec structure.
427: --
428: l_rec :=
429: pqh_cet_shd.convert_args
430: (
431: p_copy_entity_txn_id,
432: p_transaction_category_id,
433: p_txn_category_attribute_id,