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.HXC_TBB_UPD dependencies on HR_API

Line 108: when hr_api.check_integrity_violated then

104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: end if;
106:
107: exception
108: when hr_api.check_integrity_violated then
109: -- a check constraint has been violated
110: hxc_tbb_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: when hr_api.parent_integrity_violated then

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

107: exception
108: when hr_api.check_integrity_violated then
109: -- a check constraint has been violated
110: hxc_tbb_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: when hr_api.parent_integrity_violated then
113: -- parent integrity has been violated
114: hxc_tbb_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: when hr_api.parent_integrity_violated then

108: when hr_api.check_integrity_violated then
109: -- a check constraint has been violated
110: hxc_tbb_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: when hr_api.parent_integrity_violated then
113: -- parent integrity has been violated
114: hxc_tbb_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: when hr_api.unique_integrity_violated then

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

111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: when hr_api.parent_integrity_violated then
113: -- parent integrity has been violated
114: hxc_tbb_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: when hr_api.unique_integrity_violated then
117: -- unique integrity has been violated
118: hxc_tbb_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 116: when hr_api.unique_integrity_violated then

112: when hr_api.parent_integrity_violated then
113: -- parent integrity has been violated
114: hxc_tbb_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: when hr_api.unique_integrity_violated then
117: -- unique integrity has been violated
118: hxc_tbb_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: when others then

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

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: when hr_api.unique_integrity_violated then
117: -- unique integrity has been violated
118: hxc_tbb_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: when others then
121: raise;
122:
123: end update_dml;

Line 298: when hr_api.cannot_find_prog_unit then

294: );
295:
296: exception
297:
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'HXC_TIME_BUILDING_BLOCKS'
301: ,p_hook_type => 'AU');
302:

Line 299: hr_api.cannot_find_prog_unit_error

295:
296: exception
297:
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'HXC_TIME_BUILDING_BLOCKS'
301: ,p_hook_type => 'AU');
302:
303: end;

Line 365: if (p_rec.type = hr_api.g_varchar2) then

361: -- p_rec plsql record structure
362: -- to see if a system default is being used. if a system default
363: -- is being used then we must set to the 'current' argument value.
364:
365: if (p_rec.type = hr_api.g_varchar2) then
366: p_rec.type :=
367: hxc_tbb_shd.g_old_rec.type;
368: end if;
369:

Line 370: if (p_rec.measure = hr_api.g_number) then

366: p_rec.type :=
367: hxc_tbb_shd.g_old_rec.type;
368: end if;
369:
370: if (p_rec.measure = hr_api.g_number) then
371: p_rec.measure :=
372: hxc_tbb_shd.g_old_rec.measure;
373: end if;
374:

Line 375: if (p_rec.unit_of_measure = hr_api.g_varchar2) then

371: p_rec.measure :=
372: hxc_tbb_shd.g_old_rec.measure;
373: end if;
374:
375: if (p_rec.unit_of_measure = hr_api.g_varchar2) then
376: p_rec.unit_of_measure :=
377: hxc_tbb_shd.g_old_rec.unit_of_measure;
378: end if;
379:

Line 380: if (p_rec.start_time = hr_api.g_date) then

376: p_rec.unit_of_measure :=
377: hxc_tbb_shd.g_old_rec.unit_of_measure;
378: end if;
379:
380: if (p_rec.start_time = hr_api.g_date) then
381: p_rec.start_time :=
382: hxc_tbb_shd.g_old_rec.start_time;
383: end if;
384:

Line 385: if (p_rec.stop_time = hr_api.g_date) then

381: p_rec.start_time :=
382: hxc_tbb_shd.g_old_rec.start_time;
383: end if;
384:
385: if (p_rec.stop_time = hr_api.g_date) then
386: p_rec.stop_time :=
387: hxc_tbb_shd.g_old_rec.stop_time;
388: end if;
389:

Line 390: if (p_rec.parent_building_block_id = hr_api.g_number) then

386: p_rec.stop_time :=
387: hxc_tbb_shd.g_old_rec.stop_time;
388: end if;
389:
390: if (p_rec.parent_building_block_id = hr_api.g_number) then
391: p_rec.parent_building_block_id :=
392: hxc_tbb_shd.g_old_rec.parent_building_block_id;
393: end if;
394:

Line 395: if (p_rec.scope = hr_api.g_varchar2) then

391: p_rec.parent_building_block_id :=
392: hxc_tbb_shd.g_old_rec.parent_building_block_id;
393: end if;
394:
395: if (p_rec.scope = hr_api.g_varchar2) then
396: p_rec.scope :=
397: hxc_tbb_shd.g_old_rec.scope;
398: end if;
399:

Line 400: if (p_rec.approval_status = hr_api.g_varchar2) then

396: p_rec.scope :=
397: hxc_tbb_shd.g_old_rec.scope;
398: end if;
399:
400: if (p_rec.approval_status = hr_api.g_varchar2) then
401: p_rec.approval_status :=
402: hxc_tbb_shd.g_old_rec.approval_status;
403: end if;
404:

Line 405: if (p_rec.resource_id = hr_api.g_number) then

401: p_rec.approval_status :=
402: hxc_tbb_shd.g_old_rec.approval_status;
403: end if;
404:
405: if (p_rec.resource_id = hr_api.g_number) then
406: p_rec.resource_id :=
407: hxc_tbb_shd.g_old_rec.resource_id;
408: end if;
409:

Line 410: if (p_rec.resource_type = hr_api.g_varchar2) then

406: p_rec.resource_id :=
407: hxc_tbb_shd.g_old_rec.resource_id;
408: end if;
409:
410: if (p_rec.resource_type = hr_api.g_varchar2) then
411: p_rec.resource_type :=
412: hxc_tbb_shd.g_old_rec.resource_type;
413: end if;
414:

Line 415: if (p_rec.approval_style_id = hr_api.g_number) then

411: p_rec.resource_type :=
412: hxc_tbb_shd.g_old_rec.resource_type;
413: end if;
414:
415: if (p_rec.approval_style_id = hr_api.g_number) then
416: p_rec.approval_style_id :=
417: hxc_tbb_shd.g_old_rec.approval_style_id;
418: end if;
419:

Line 420: if (p_rec.date_from = hr_api.g_date) then

416: p_rec.approval_style_id :=
417: hxc_tbb_shd.g_old_rec.approval_style_id;
418: end if;
419:
420: if (p_rec.date_from = hr_api.g_date) then
421: p_rec.date_from :=
422: hxc_tbb_shd.g_old_rec.date_from;
423: end if;
424:

Line 425: if (p_rec.date_to = hr_api.g_date) then

421: p_rec.date_from :=
422: hxc_tbb_shd.g_old_rec.date_from;
423: end if;
424:
425: if (p_rec.date_to = hr_api.g_date) then
426: p_rec.date_to :=
427: hxc_tbb_shd.g_old_rec.date_to;
428: end if;
429:

Line 430: if (p_rec.comment_text = hr_api.g_varchar2) then

426: p_rec.date_to :=
427: hxc_tbb_shd.g_old_rec.date_to;
428: end if;
429:
430: if (p_rec.comment_text = hr_api.g_varchar2) then
431: p_rec.comment_text :=
432: hxc_tbb_shd.g_old_rec.comment_text;
433: end if;
434:

Line 435: if (p_rec.data_set_id = hr_api.g_number) then

431: p_rec.comment_text :=
432: hxc_tbb_shd.g_old_rec.comment_text;
433: end if;
434:
435: if (p_rec.data_set_id = hr_api.g_number) then
436: p_rec.data_set_id :=
437: hxc_tbb_shd.g_old_rec.data_set_id;
438: end if;
439:

Line 505: ,p_approval_status in varchar2 default hr_api.g_varchar2

501: procedure upd
502: (p_effective_date in date
503: ,p_time_building_block_id in number
504: ,p_object_version_number in out nocopy number
505: ,p_approval_status in varchar2 default hr_api.g_varchar2
506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date

Line 506: ,p_measure in number default hr_api.g_number

502: (p_effective_date in date
503: ,p_time_building_block_id in number
504: ,p_object_version_number in out nocopy number
505: ,p_approval_status in varchar2 default hr_api.g_varchar2
506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number

Line 507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2

503: ,p_time_building_block_id in number
504: ,p_object_version_number in out nocopy number
505: ,p_approval_status in varchar2 default hr_api.g_varchar2
506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number

Line 508: ,p_start_time in date default hr_api.g_date

504: ,p_object_version_number in out nocopy number
505: ,p_approval_status in varchar2 default hr_api.g_varchar2
506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number

Line 509: ,p_stop_time in date default hr_api.g_date

505: ,p_approval_status in varchar2 default hr_api.g_varchar2
506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date

Line 510: ,p_parent_building_block_id in number default hr_api.g_number

506: ,p_measure in number default hr_api.g_number
507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date

Line 511: ,p_parent_building_block_ovn in number default hr_api.g_number

507: ,p_unit_of_measure in varchar2 default hr_api.g_varchar2
508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2

Line 512: ,p_approval_style_id in number default hr_api.g_number

508: ,p_start_time in date default hr_api.g_date
509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number

Line 513: ,p_date_from in date default hr_api.g_date

509: ,p_stop_time in date default hr_api.g_date
510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number

Line 514: ,p_date_to in date default hr_api.g_date

510: ,p_parent_building_block_id in number default hr_api.g_number
511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number
518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2

Line 515: ,p_comment_text in varchar2 default hr_api.g_varchar2

511: ,p_parent_building_block_ovn in number default hr_api.g_number
512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number
518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2
519: ) is

Line 516: ,p_application_set_id in number default hr_api.g_number

512: ,p_approval_style_id in number default hr_api.g_number
513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number
518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2
519: ) is
520:

Line 517: ,p_data_set_id in number default hr_api.g_number

513: ,p_date_from in date default hr_api.g_date
514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number
518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2
519: ) is
520:
521: l_rec hxc_tbb_shd.g_rec_type;

Line 518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2

514: ,p_date_to in date default hr_api.g_date
515: ,p_comment_text in varchar2 default hr_api.g_varchar2
516: ,p_application_set_id in number default hr_api.g_number
517: ,p_data_set_id in number default hr_api.g_number
518: ,p_translation_display_key in varchar2 default hr_api.g_varchar2
519: ) is
520:
521: l_rec hxc_tbb_shd.g_rec_type;
522: l_proc varchar2(72);

Line 539: ,hr_api.g_varchar2

535:
536: l_rec :=
537: hxc_tbb_shd.convert_args
538: (p_time_building_block_id
539: ,hr_api.g_varchar2
540: ,p_measure
541: ,p_unit_of_measure
542: ,p_start_time
543: ,p_stop_time

Line 546: ,hr_api.g_varchar2

542: ,p_start_time
543: ,p_stop_time
544: ,p_parent_building_block_id
545: ,p_parent_building_block_ovn
546: ,hr_api.g_varchar2
547: ,p_object_version_number
548: ,p_approval_status
549: ,hr_api.g_number
550: ,hr_api.g_varchar2

Line 549: ,hr_api.g_number

545: ,p_parent_building_block_ovn
546: ,hr_api.g_varchar2
547: ,p_object_version_number
548: ,p_approval_status
549: ,hr_api.g_number
550: ,hr_api.g_varchar2
551: ,p_approval_style_id
552: ,null
553: ,null

Line 550: ,hr_api.g_varchar2

546: ,hr_api.g_varchar2
547: ,p_object_version_number
548: ,p_approval_status
549: ,hr_api.g_number
550: ,hr_api.g_varchar2
551: ,p_approval_style_id
552: ,null
553: ,null
554: ,p_comment_text