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_TIMECARD_SUMMARY_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 8: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

4: g_debug boolean := hr_utility.debug_enabled;
5: g_check_for_reasons varchar2(1) := null;
6:
7: function get_migration_apr_status
8: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
10: ) return varchar2 is
11:
12: begin

Line 9: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

5: g_check_for_reasons varchar2(1) := null;
6:
7: function get_migration_apr_status
8: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
9: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
10: ) return varchar2 is
11:
12: begin
13:

Line 19: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

15:
16: end get_migration_apr_status;
17:
18: procedure get_recorded_hours
19: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
20: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
21: ,p_hours out nocopy number
22: ,p_details out nocopy details
23: ) is

Line 20: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type

16: end get_migration_apr_status;
17:
18: procedure get_recorded_hours
19: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
20: ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
21: ,p_hours out nocopy number
22: ,p_details out nocopy details
23: ) is
24:

Line 25: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type

21: ,p_hours out nocopy number
22: ,p_details out nocopy details
23: ) is
24:
25: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type
26: ,p_ovn in hxc_time_building_blocks.object_version_number%type
27: ) is
28: select details.time_building_block_id
29: ,details.object_version_number

Line 26: ,p_ovn in hxc_time_building_blocks.object_version_number%type

22: ,p_details out nocopy details
23: ) is
24:
25: cursor c_detail_info(p_id in hxc_time_building_blocks.time_building_block_id%type
26: ,p_ovn in hxc_time_building_blocks.object_version_number%type
27: ) is
28: select details.time_building_block_id
29: ,details.object_version_number
30: ,details.start_time

Line 35: from hxc_time_building_blocks days, hxc_time_building_blocks details

31: ,details.stop_time
32: ,details.measure
33: ,details.type
34: ,details.creation_date
35: from hxc_time_building_blocks days, hxc_time_building_blocks details
36: where days.parent_building_block_id = p_id
37: and days.parent_building_block_ovn = p_ovn
38: and details.parent_building_block_id = days.time_building_block_id
39: and details.parent_building_block_ovn = days.object_version_number

Line 44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

40: and days.date_to = hr_general.end_of_time
41: and details.date_to = hr_general.end_of_time;
42:
43: CURSOR c_tc_resource_id(
44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
46: ) IS
47: SELECT tbb.resource_id
48: FROM hxc_time_building_blocks tbb

Line 45: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

41: and details.date_to = hr_general.end_of_time;
42:
43: CURSOR c_tc_resource_id(
44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
46: ) IS
47: SELECT tbb.resource_id
48: FROM hxc_time_building_blocks tbb
49: WHERE tbb.time_building_block_id = p_timecard_id

Line 48: FROM hxc_time_building_blocks tbb

44: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
46: ) IS
47: SELECT tbb.resource_id
48: FROM hxc_time_building_blocks tbb
49: WHERE tbb.time_building_block_id = p_timecard_id
50: AND tbb.object_version_number = p_timecard_ovn;
51:
52: /* Bug fix for 5526281 */

Line 53: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

49: WHERE tbb.time_building_block_id = p_timecard_id
50: AND tbb.object_version_number = p_timecard_ovn;
51:
52: /* Bug fix for 5526281 */
53: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
54: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
55: ) IS
56: SELECT tbb.start_time,tbb.stop_time
57: FROM hxc_time_building_blocks tbb

Line 54: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

50: AND tbb.object_version_number = p_timecard_ovn;
51:
52: /* Bug fix for 5526281 */
53: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
54: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
55: ) IS
56: SELECT tbb.start_time,tbb.stop_time
57: FROM hxc_time_building_blocks tbb
58: WHERE tbb.time_building_block_id = p_timecard_id

Line 57: FROM hxc_time_building_blocks tbb

53: CURSOR get_timecard_start_date(p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
54: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
55: ) IS
56: SELECT tbb.start_time,tbb.stop_time
57: FROM hxc_time_building_blocks tbb
58: WHERE tbb.time_building_block_id = p_timecard_id
59: AND tbb.object_version_number = p_timecard_ovn;
60:
61: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

Line 61: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

57: FROM hxc_time_building_blocks tbb
58: WHERE tbb.time_building_block_id = p_timecard_id
59: AND tbb.object_version_number = p_timecard_ovn;
60:
61: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
62: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
63: /* end of bug fix for 5526281 */
64:
65: l_index number :=1;

Line 156: (p_id in hxc_time_building_blocks.time_building_block_id%type

152:
153: function get_has_reasons(p_details in details) return varchar2 is
154:
155: cursor c_reasons
156: (p_id in hxc_time_building_blocks.time_building_block_id%type
157: ) is
158: select 'Y'
159: from hxc_time_attribute_usages tau, hxc_time_attributes ta
160: where tau.time_building_block_id = p_id

Line 210: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

206: return l_submission_date;
207:
208: end get_submission_date;
209:
210: procedure insert_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
211: ,p_mode in varchar2 default 'NORMAL'
212: ,p_attribute_category in varchar2 default null
213: ,p_attribute1 in varchar2 default null
214: ,p_attribute2 in varchar2 default null

Line 251: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is

247: ,p_tk_audit_process_name in varchar2
248: ,p_tk_audit_item_key in varchar2
249: ) is
250:
251: cursor c_timecard_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
252: select resource_id
253: ,start_time
254: ,stop_time
255: ,object_version_number

Line 259: from hxc_time_building_blocks

255: ,object_version_number
256: ,approval_status
257: ,creation_date
258: ,data_set_id
259: from hxc_time_building_blocks
260: where time_building_block_id = p_id
261: and date_to = hr_general.end_of_time
262: and scope = 'TIMECARD';
263:

Line 269: l_approval_status hxc_time_building_blocks.approval_status%type;

265: select 'Y'
266: from hxc_time_attributes
267: where attribute_category = hxc_timecard.c_reason_attribute;
268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;

Line 270: l_resource_id hxc_time_building_blocks.resource_id%type;

266: from hxc_time_attributes
267: where attribute_category = hxc_timecard.c_reason_attribute;
268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;

Line 271: l_start_time hxc_time_building_blocks.start_time%type;

267: where attribute_category = hxc_timecard.c_reason_attribute;
268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;
275: l_ovn hxc_time_building_blocks.object_version_number%type;

Line 272: l_stop_time hxc_time_building_blocks.stop_time%type;

268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;
275: l_ovn hxc_time_building_blocks.object_version_number%type;
276: l_has_reasons varchar2(1);

Line 273: l_submission_date hxc_time_building_blocks.creation_date%type;

269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;
275: l_ovn hxc_time_building_blocks.object_version_number%type;
276: l_has_reasons varchar2(1);
277: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;

Line 274: l_creation_date hxc_time_building_blocks.creation_date%type;

270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;
275: l_ovn hxc_time_building_blocks.object_version_number%type;
276: l_has_reasons varchar2(1);
277: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
278: l_details details;

Line 275: l_ovn hxc_time_building_blocks.object_version_number%type;

271: l_start_time hxc_time_building_blocks.start_time%type;
272: l_stop_time hxc_time_building_blocks.stop_time%type;
273: l_submission_date hxc_time_building_blocks.creation_date%type;
274: l_creation_date hxc_time_building_blocks.creation_date%type;
275: l_ovn hxc_time_building_blocks.object_version_number%type;
276: l_has_reasons varchar2(1);
277: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
278: l_details details;
279: l_data_set_id hxc_time_building_blocks.data_set_id%type;

Line 279: l_data_set_id hxc_time_building_blocks.data_set_id%type;

275: l_ovn hxc_time_building_blocks.object_version_number%type;
276: l_has_reasons varchar2(1);
277: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
278: l_details details;
279: l_data_set_id hxc_time_building_blocks.data_set_id%type;
280:
281: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
282: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
283: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;

Line 523: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

519: end if;
520:
521: End insert_summary_row;
522:
523: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
524: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
527: ) is

Line 576: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

572:
573:
574: End update_summary_row;
575:
576: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
577:
578: Begin
579:
580: delete from hxc_timecard_summary where timecard_id = p_timecard_id;

Line 589: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

585: FND_MESSAGE.raise_error;
586:
587: End delete_summary_row;
588:
589: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
590:
591: Begin
592:
593: update hxc_timecard_summary

Line 599: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

595: where timecard_id = p_timecard_id;
596:
597: End reject_timecard;
598:
599: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
600:
601: CURSOR c_timecard_details (c_timecard_id NUMBER)
602: IS
603: SELECT resource_id,

Line 659: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

655:
656:
657: End approve_timecard;
658:
659: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
660:
661: Begin
662:
663: update hxc_timecard_summary

Line 684: hxc_time_building_blocks day,

680: p_timecard_ovn IN NUMBER,
681: p_process_id IN NUMBER )
682: IS SELECT 1
683: FROM hxc_timecard_summary sum,
684: hxc_time_building_blocks day,
685: hxc_time_building_blocks det,
686: hxc_latest_details hld
687: WHERE sum.timecard_id = p_timecard_id
688: AND sum.timecard_ovn = p_timecard_ovn

Line 685: hxc_time_building_blocks det,

681: p_process_id IN NUMBER )
682: IS SELECT 1
683: FROM hxc_timecard_summary sum,
684: hxc_time_building_blocks day,
685: hxc_time_building_blocks det,
686: hxc_latest_details hld
687: WHERE sum.timecard_id = p_timecard_id
688: AND sum.timecard_ovn = p_timecard_ovn
689: AND day.parent_building_block_id = sum.timecard_id