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 HR_API

Line 83: When hr_api.check_integrity_violated Then

79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
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

Line 86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.parent_integrity_violated Then

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
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then

Line 90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: When hr_api.unique_integrity_violated Then

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
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When Others Then

Line 94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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;
98: --

Line 222: when hr_api.cannot_find_prog_unit then

218: );
219: --
220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'pqh_copy_entity_txns'
226: ,p_hook_type => 'AU');

Line 224: hr_api.cannot_find_prog_unit_error

220: exception
221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'pqh_copy_entity_txns'
226: ,p_hook_type => 'AU');
227: --
228: end;

Line 292: If (p_rec.transaction_category_id = hr_api.g_number) then

288: -- p_rec plsql record structure
289: -- to see if a system default is being used. If a system default
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

Line 296: If (p_rec.txn_category_attribute_id = hr_api.g_number) then

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;
299: End If;
300: If (p_rec.context_business_group_id = hr_api.g_number) then

Line 300: If (p_rec.context_business_group_id = hr_api.g_number) then

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;
303: End If;
304: If (p_rec.datetrack_mode = hr_api.g_varchar2) then

Line 304: If (p_rec.datetrack_mode = hr_api.g_varchar2) then

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;
307: End If;
308: If (p_rec.context = hr_api.g_varchar2) then

Line 308: If (p_rec.context = hr_api.g_varchar2) then

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 ;
311: End If;
312: If (p_rec.action_date = hr_api.g_date) then

Line 312: If (p_rec.action_date = hr_api.g_date) then

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 ;
315: End If;
316: If (p_rec.src_effective_date = hr_api.g_date) then

Line 316: If (p_rec.src_effective_date = hr_api.g_date) then

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 ;
319: End If;
320: If (p_rec.number_of_copies = hr_api.g_number) then

Line 320: If (p_rec.number_of_copies = hr_api.g_number) then

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 ;
323: End If;
324: If (p_rec.display_name = hr_api.g_varchar2) then

Line 324: If (p_rec.display_name = hr_api.g_varchar2) then

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;
327: End If;
328: If (p_rec.replacement_type_cd = hr_api.g_varchar2) then

Line 328: If (p_rec.replacement_type_cd = hr_api.g_varchar2) then

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;
331: End If;
332: If (p_rec.start_with = hr_api.g_varchar2) then

Line 332: If (p_rec.start_with = hr_api.g_varchar2) then

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;
335: End If;
336: If (p_rec.increment_by = hr_api.g_number) then

Line 336: If (p_rec.increment_by = hr_api.g_number) then

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;
339: End If;
340: If (p_rec.status = hr_api.g_varchar2) then

Line 340: If (p_rec.status = hr_api.g_varchar2) then

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;
343: End If;
344:

Line 403: p_transaction_category_id in number default hr_api.g_number,

399: Procedure upd
400: (
401: p_effective_date in date,
402: p_copy_entity_txn_id in number,
403: p_transaction_category_id in number default hr_api.g_number,
404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,

Line 404: p_txn_category_attribute_id in number default hr_api.g_number,

400: (
401: p_effective_date in date,
402: p_copy_entity_txn_id in number,
403: p_transaction_category_id in number default hr_api.g_number,
404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,

Line 405: p_context_business_group_id in number default hr_api.g_number,

401: p_effective_date in date,
402: p_copy_entity_txn_id in number,
403: p_transaction_category_id in number default hr_api.g_number,
404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,

Line 406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,

402: p_copy_entity_txn_id in number,
403: p_transaction_category_id in number default hr_api.g_number,
404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,

Line 407: p_context in varchar2 default hr_api.g_varchar2,

403: p_transaction_category_id in number default hr_api.g_number,
404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,

Line 408: p_action_date in date default hr_api.g_date,

404: p_txn_category_attribute_id in number default hr_api.g_number,
405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,

Line 409: p_src_effective_date in date default hr_api.g_date,

405: p_context_business_group_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,

Line 410: p_number_of_copies in number default hr_api.g_number,

406: p_datetrack_mode in varchar2 default hr_api.g_varchar2,
407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,

Line 411: p_display_name in varchar2 default hr_api.g_varchar2,

407: p_context in varchar2 default hr_api.g_varchar2,
408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,
415: p_status in varchar2 default hr_api.g_varchar2,

Line 412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,

408: p_action_date in date default hr_api.g_date,
409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,
415: p_status in varchar2 default hr_api.g_varchar2,
416: p_object_version_number in out nocopy number

Line 413: p_start_with in varchar2 default hr_api.g_varchar2,

409: p_src_effective_date in date default hr_api.g_date,
410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,
415: p_status in varchar2 default hr_api.g_varchar2,
416: p_object_version_number in out nocopy number
417: ) is

Line 414: p_increment_by in number default hr_api.g_number ,

410: p_number_of_copies in number default hr_api.g_number,
411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,
415: p_status in varchar2 default hr_api.g_varchar2,
416: p_object_version_number in out nocopy number
417: ) is
418: --

Line 415: p_status in varchar2 default hr_api.g_varchar2,

411: p_display_name in varchar2 default hr_api.g_varchar2,
412: p_replacement_type_cd in varchar2 default hr_api.g_varchar2,
413: p_start_with in varchar2 default hr_api.g_varchar2,
414: p_increment_by in number default hr_api.g_number ,
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;