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

Line 37: block_id hxc_time_building_blocks.time_building_block_id%TYPE

33: ,approval_status VARCHAR2(150)
34: );
35:
36: TYPE block_info IS RECORD(
37: block_id hxc_time_building_blocks.time_building_block_id%TYPE
38: ,block_ovn hxc_time_building_blocks.object_version_number%TYPE
39: ,added VARCHAR2(1)
40: );
41:

Line 38: ,block_ovn hxc_time_building_blocks.object_version_number%TYPE

34: );
35:
36: TYPE block_info IS RECORD(
37: block_id hxc_time_building_blocks.time_building_block_id%TYPE
38: ,block_ovn hxc_time_building_blocks.object_version_number%TYPE
39: ,added VARCHAR2(1)
40: );
41:
42: TYPE block_table IS TABLE OF

Line 52: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

48:
49: g_block_exist_for_ap varchar2(1);
50:
51: FUNCTION get_creation_date(
52: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
53: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE
54: )
55: RETURN DATE
56: IS

Line 53: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE

49: g_block_exist_for_ap varchar2(1);
50:
51: FUNCTION get_creation_date(
52: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
53: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE
54: )
55: RETURN DATE
56: IS
57: CURSOR c_creation_date(

Line 58: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

54: )
55: RETURN DATE
56: IS
57: CURSOR c_creation_date(
58: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
59: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE
60: )
61: IS
62: SELECT creation_date

Line 59: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE

55: RETURN DATE
56: IS
57: CURSOR c_creation_date(
58: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
59: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE
60: )
61: IS
62: SELECT creation_date
63: FROM hxc_time_building_blocks

Line 63: FROM hxc_time_building_blocks

59: ,p_app_ovn hxc_time_building_blocks.object_version_number%TYPE
60: )
61: IS
62: SELECT creation_date
63: FROM hxc_time_building_blocks
64: WHERE time_building_block_id = p_app_id
65: AND object_version_number = p_app_ovn;
66:
67: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;

Line 67: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;

63: FROM hxc_time_building_blocks
64: WHERE time_building_block_id = p_app_id
65: AND object_version_number = p_app_ovn;
66:
67: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;
68: BEGIN
69: OPEN c_creation_date(
70: p_app_id => p_app_id
71: ,p_app_ovn => p_app_ovn

Line 88: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

84: --timecard p_timecard_id and also fall between p_start_time
85: --and p_stop_time of an application period
86:
87: PROCEDURE get_detail_blocks(
88: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
89: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
90: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
91: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
92: ,p_detail_blocks IN OUT NOCOPY block_table

Line 89: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

85: --and p_stop_time of an application period
86:
87: PROCEDURE get_detail_blocks(
88: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
89: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
90: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
91: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
92: ,p_detail_blocks IN OUT NOCOPY block_table
93: ,p_new_detail_blocks IN OUT NOCOPY hxc_block_table_type

Line 90: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE

86:
87: PROCEDURE get_detail_blocks(
88: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
89: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
90: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
91: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
92: ,p_detail_blocks IN OUT NOCOPY block_table
93: ,p_new_detail_blocks IN OUT NOCOPY hxc_block_table_type
94: )

Line 91: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

87: PROCEDURE get_detail_blocks(
88: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
89: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
90: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
91: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
92: ,p_detail_blocks IN OUT NOCOPY block_table
93: ,p_new_detail_blocks IN OUT NOCOPY hxc_block_table_type
94: )
95: IS

Line 97: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

93: ,p_new_detail_blocks IN OUT NOCOPY hxc_block_table_type
94: )
95: IS
96: CURSOR c_detail_blocks(
97: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
98: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
99: ,p_start_time hxc_time_building_blocks.start_time%TYPE
100: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
101: )

Line 98: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

94: )
95: IS
96: CURSOR c_detail_blocks(
97: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
98: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
99: ,p_start_time hxc_time_building_blocks.start_time%TYPE
100: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
101: )
102: IS

Line 99: ,p_start_time hxc_time_building_blocks.start_time%TYPE

95: IS
96: CURSOR c_detail_blocks(
97: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
98: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
99: ,p_start_time hxc_time_building_blocks.start_time%TYPE
100: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
101: )
102: IS
103: SELECT

Line 100: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE

96: CURSOR c_detail_blocks(
97: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
98: ,p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
99: ,p_start_time hxc_time_building_blocks.start_time%TYPE
100: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
101: )
102: IS
103: SELECT
104: details.TIME_BUILDING_BLOCK_ID,

Line 129: FROM hxc_time_building_blocks days

125: 'N' CHANGED,
126: 'N' PROCESS,
127: details.APPLICATION_SET_ID,
128: details.TRANSLATION_DISPLAY_KEY
129: FROM hxc_time_building_blocks days
130: ,hxc_time_building_blocks details
131: WHERE days.parent_building_block_id = p_timecard_id
132: AND days.parent_building_block_ovn = p_timecard_ovn
133: AND days.scope = 'DAY'

Line 130: ,hxc_time_building_blocks details

126: 'N' PROCESS,
127: details.APPLICATION_SET_ID,
128: details.TRANSLATION_DISPLAY_KEY
129: FROM hxc_time_building_blocks days
130: ,hxc_time_building_blocks details
131: WHERE days.parent_building_block_id = p_timecard_id
132: AND days.parent_building_block_ovn = p_timecard_ovn
133: AND days.scope = 'DAY'
134: AND TRUNC(days.start_time) BETWEEN TRUNC(p_start_time) AND TRUNC(p_stop_time)

Line 214: p_detail_id hxc_time_building_blocks.time_building_block_id%TYPE

210: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;
211: l_block_index PLS_INTEGER;
212:
213: CURSOR c_block_attributes(
214: p_detail_id hxc_time_building_blocks.time_building_block_id%TYPE
215: ,p_detail_ovn hxc_time_building_blocks.object_version_number%TYPE
216: )
217: IS
218: select a.time_attribute_id

Line 215: ,p_detail_ovn hxc_time_building_blocks.object_version_number%TYPE

211: l_block_index PLS_INTEGER;
212:
213: CURSOR c_block_attributes(
214: p_detail_id hxc_time_building_blocks.time_building_block_id%TYPE
215: ,p_detail_ovn hxc_time_building_blocks.object_version_number%TYPE
216: )
217: IS
218: select a.time_attribute_id
219: ,au.time_building_block_id building_block_id

Line 341: (p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

337:
338: END get_detail_attributes;
339:
340: Function same_block
341: (p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
342: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
343: p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
344: ) return boolean is
345:

Line 342: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

338: END get_detail_attributes;
339:
340: Function same_block
341: (p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
342: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
343: p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
344: ) return boolean is
345:
346: cursor c_block

Line 343: p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

339:
340: Function same_block
341: (p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
342: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
343: p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
344: ) return boolean is
345:
346: cursor c_block
347: (p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,

Line 347: (p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,

343: p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
344: ) return boolean is
345:
346: cursor c_block
347: (p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,
348: p_block_id in hxc_time_building_blocks.time_building_block_id%TYPE
349: ) is
350: select max(time_building_block_ovn)
351: from hxc_ap_detail_links

Line 348: p_block_id in hxc_time_building_blocks.time_building_block_id%TYPE

344: ) return boolean is
345:
346: cursor c_block
347: (p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,
348: p_block_id in hxc_time_building_blocks.time_building_block_id%TYPE
349: ) is
350: select max(time_building_block_ovn)
351: from hxc_ap_detail_links
352: where application_period_id = p_app_id

Line 356: (p_block1_id in hxc_time_building_blocks.time_building_block_id%TYPE,

352: where application_period_id = p_app_id
353: and time_building_block_id = p_block_id;
354:
355: cursor c_test_translation_key
356: (p_block1_id in hxc_time_building_blocks.time_building_block_id%TYPE,
357: p_block1_ovn in hxc_time_building_blocks.object_version_number%TYPE,
358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE
359: ) is
360: select tbb2.object_version_number

Line 357: p_block1_ovn in hxc_time_building_blocks.object_version_number%TYPE,

353: and time_building_block_id = p_block_id;
354:
355: cursor c_test_translation_key
356: (p_block1_id in hxc_time_building_blocks.time_building_block_id%TYPE,
357: p_block1_ovn in hxc_time_building_blocks.object_version_number%TYPE,
358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE
359: ) is
360: select tbb2.object_version_number
361: from hxc_time_building_blocks tbb1,

Line 358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE

354:
355: cursor c_test_translation_key
356: (p_block1_id in hxc_time_building_blocks.time_building_block_id%TYPE,
357: p_block1_ovn in hxc_time_building_blocks.object_version_number%TYPE,
358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE
359: ) is
360: select tbb2.object_version_number
361: from hxc_time_building_blocks tbb1,
362: hxc_time_building_blocks tbb2

Line 361: from hxc_time_building_blocks tbb1,

357: p_block1_ovn in hxc_time_building_blocks.object_version_number%TYPE,
358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE
359: ) is
360: select tbb2.object_version_number
361: from hxc_time_building_blocks tbb1,
362: hxc_time_building_blocks tbb2
363: where tbb1.time_building_block_id = p_block1_id
364: and tbb1.time_building_block_id = tbb2.time_building_block_id
365: and tbb1.object_version_number = p_block1_ovn

Line 362: hxc_time_building_blocks tbb2

358: p_block2_ovn in hxc_time_building_blocks.object_version_number%TYPE
359: ) is
360: select tbb2.object_version_number
361: from hxc_time_building_blocks tbb1,
362: hxc_time_building_blocks tbb2
363: where tbb1.time_building_block_id = p_block1_id
364: and tbb1.time_building_block_id = tbb2.time_building_block_id
365: and tbb1.object_version_number = p_block1_ovn
366: and tbb2.object_version_number = p_block2_ovn

Line 411: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

407:
408: End same_block;
409:
410: function no_blocks(
411: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
412: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
413: )
414:
415: RETURN NUMBER

Line 412: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

408: End same_block;
409:
410: function no_blocks(
411: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
412: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
413: )
414:
415: RETURN NUMBER
416: IS

Line 418: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

414:
415: RETURN NUMBER
416: IS
417: CURSOR c_no_blocks(
418: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
419: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
420: )
421: IS
422: SELECT count(p_app_id)

Line 419: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

415: RETURN NUMBER
416: IS
417: CURSOR c_no_blocks(
418: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
419: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
420: )
421: IS
422: SELECT count(p_app_id)
423: FROM hxc_ap_detail_links apdetail

Line 424: ,hxc_time_building_blocks days

420: )
421: IS
422: SELECT count(p_app_id)
423: FROM hxc_ap_detail_links apdetail
424: ,hxc_time_building_blocks days
425: ,hxc_time_building_blocks details
426: WHERE apdetail.application_period_id = p_app_id
427: AND days.parent_building_block_id = p_timecard_id
428: AND details.parent_building_block_id = days.time_building_block_id

Line 425: ,hxc_time_building_blocks details

421: IS
422: SELECT count(p_app_id)
423: FROM hxc_ap_detail_links apdetail
424: ,hxc_time_building_blocks days
425: ,hxc_time_building_blocks details
426: WHERE apdetail.application_period_id = p_app_id
427: AND days.parent_building_block_id = p_timecard_id
428: AND details.parent_building_block_id = days.time_building_block_id
429: AND details.time_building_block_id = apdetail.time_building_block_id

Line 434: from hxc_time_building_blocks details2

430: AND details.object_version_number = apdetail.time_building_block_ovn
431: AND details.date_to <> hr_general.end_of_time
432: and not exists(
433: select 1
434: from hxc_time_building_blocks details2
435: where details2.time_building_block_id = details.time_building_block_id
436: and details2.date_to = hr_general.end_of_time
437: );
438:

Line 453: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

449: FUNCTION changed(
450: p_detail_blocks IN OUT NOCOPY block_table
451: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
452: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
453: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
454: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
455: )
456: RETURN BOOLEAN
457: IS

Line 454: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

450: p_detail_blocks IN OUT NOCOPY block_table
451: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
452: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
453: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
454: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
455: )
456: RETURN BOOLEAN
457: IS
458: l_block_index NUMBER;

Line 555: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

551: END IF;
552: END changed;
553:
554: PROCEDURE remove_ap_detail_links(
555: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
556: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
557: )
558: IS
559: CURSOR c_detail_blocks(

Line 556: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

552: END changed;
553:
554: PROCEDURE remove_ap_detail_links(
555: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
556: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
557: )
558: IS
559: CURSOR c_detail_blocks(
560: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

Line 560: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

556: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
557: )
558: IS
559: CURSOR c_detail_blocks(
560: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
561: )
562: IS
563: SELECT details.time_building_block_id
564: ,details.object_version_number

Line 565: FROM hxc_time_building_blocks days

561: )
562: IS
563: SELECT details.time_building_block_id
564: ,details.object_version_number
565: FROM hxc_time_building_blocks days
566: ,hxc_time_building_blocks details
567: WHERE days.parent_building_block_id = p_timecard_id
568: AND details.parent_building_block_id = days.time_building_block_id
569: AND days.scope = 'DAY'

Line 566: ,hxc_time_building_blocks details

562: IS
563: SELECT details.time_building_block_id
564: ,details.object_version_number
565: FROM hxc_time_building_blocks days
566: ,hxc_time_building_blocks details
567: WHERE days.parent_building_block_id = p_timecard_id
568: AND details.parent_building_block_id = days.time_building_block_id
569: AND days.scope = 'DAY'
570: AND details.scope = 'DETAIL';

Line 573: p_app_period hxc_time_building_blocks.time_building_block_id%TYPE

569: AND days.scope = 'DAY'
570: AND details.scope = 'DETAIL';
571:
572: CURSOR c_old_blocks(
573: p_app_period hxc_time_building_blocks.time_building_block_id%TYPE
574: )
575: IS
576: SELECT details.time_building_block_id
577: ,details.object_version_number

Line 579: ,hxc_time_building_blocks details

575: IS
576: SELECT details.time_building_block_id
577: ,details.object_version_number
578: FROM hxc_ap_detail_links apdetail
579: ,hxc_time_building_blocks details
580: WHERE apdetail.application_period_id = p_app_period
581: AND apdetail.time_building_block_id = details.time_building_block_id
582: AND apdetail.time_building_block_ovn = details.object_version_number
583: AND details.date_to <> hr_general.end_of_time;

Line 586: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;

582: AND apdetail.time_building_block_ovn = details.object_version_number
583: AND details.date_to <> hr_general.end_of_time;
584:
585:
586: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
587: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
588: BEGIN
589: OPEN c_detail_blocks(p_timecard_id);
590:

Line 587: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;

583: AND details.date_to <> hr_general.end_of_time;
584:
585:
586: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
587: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
588: BEGIN
589: OPEN c_detail_blocks(p_timecard_id);
590:
591: LOOP

Line 667: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

663: PROCEDURE link_ap_details(
664: p_detail_blocks IN OUT NOCOPY block_table
665: ,p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
666: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
667: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
668: )
669: IS
670: l_block_index NUMBER;
671: BEGIN

Line 716: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

712: END link_ap_details;
713:
714: PROCEDURE link_ap_details_all(
715: p_detail_blocks IN OUT NOCOPY block_table
716: ,p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
717: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
718: )
719: IS
720: l_block_index NUMBER;

Line 944: l_approval_status hxc_time_building_blocks.approval_status%type;

940: l_appl_period_bb_ovn number;
941: l_tc_resource_id number;
942: l_period_start_date date;
943: l_period_end_date date;
944: l_approval_status hxc_time_building_blocks.approval_status%type;
945: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
946: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
947: l_wf_item_type varchar2(500) := NULL;
948: l_is_blank varchar2(10);

Line 945: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;

941: l_tc_resource_id number;
942: l_period_start_date date;
943: l_period_end_date date;
944: l_approval_status hxc_time_building_blocks.approval_status%type;
945: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
946: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
947: l_wf_item_type varchar2(500) := NULL;
948: l_is_blank varchar2(10);
949: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.update_appl_period';

Line 946: l_creation_date hxc_time_building_blocks.creation_date%TYPE;

942: l_period_start_date date;
943: l_period_end_date date;
944: l_approval_status hxc_time_building_blocks.approval_status%type;
945: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
946: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
947: l_wf_item_type varchar2(500) := NULL;
948: l_is_blank varchar2(10);
949: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.update_appl_period';
950:

Line 1187: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

1183: result IN OUT NOCOPY varchar2
1184: )
1185: IS
1186: CURSOR c_current_period(
1187: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1188: )
1189: IS
1190: SELECT *
1191: FROM hxc_app_period_summary

Line 1195: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

1191: FROM hxc_app_period_summary
1192: WHERE application_period_id = p_app_id;
1193:
1194: CURSOR c_timecards(
1195: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1196: )
1197: IS
1198: SELECT timecard_id
1199: FROM hxc_tc_ap_links

Line 1203: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

1199: FROM hxc_tc_ap_links
1200: WHERE application_period_id = p_app_id;
1201:
1202: CURSOR c_ap_details(
1203: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1204: )
1205: IS
1206: SELECT time_building_block_id
1207: ,time_building_block_ovn

Line 1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

1209: WHERE application_period_id = p_app_id;
1210:
1211:
1212: l_current_period hxc_app_period_summary%rowtype;
1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;

Line 1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;

1210:
1211:
1212: l_current_period hxc_app_period_summary%rowtype;
1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;

Line 1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;

1211:
1212: l_current_period hxc_app_period_summary%rowtype;
1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;

Line 1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

1212: l_current_period hxc_app_period_summary%rowtype;
1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;

1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;

Line 1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;

1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;

Line 1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;

1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;
1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;

1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1217: l_new_appl_bb_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1218: l_period_start_date hxc_time_building_blocks.start_time%TYPE;
1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;
1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
1224: l_creation_date hxc_time_building_blocks.creation_date%TYPE;

Line 1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

1219: l_period_end_date hxc_time_building_blocks.stop_time%TYPE;
1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;
1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
1224: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
1225:
1226: l_proc VARCHAR2(150) := 'create_next_period';
1227: BEGIN

Line 1224: l_creation_date hxc_time_building_blocks.creation_date%TYPE;

1220: l_tc_resource_id hxc_time_building_blocks.resource_id%TYPE;
1221: l_attribute approval_attribute;
1222: t_attributes hxc_time_attributes_api.timecard;
1223: l_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
1224: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
1225:
1226: l_proc VARCHAR2(150) := 'create_next_period';
1227: BEGIN
1228: g_debug:=hr_utility.debug_enabled;

Line 1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE

1426:
1427: ------------------------- get_approval_period_id --------------------------
1428: --
1429: FUNCTION get_approval_period_id(
1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE

Line 1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE

1428: --
1429: FUNCTION get_approval_period_id(
1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1435: )
1436: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE

Line 1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE

1429: FUNCTION get_approval_period_id(
1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1435: )
1436: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE
1437: IS

Line 1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE

1430: p_resource_id in HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE
1431: ,p_time_recipient_id in HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1435: )
1436: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE
1437: IS
1438:

Line 1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1541:
1542:
1543: PROCEDURE get_application_period(
1544: p_app_period_func IN VARCHAR2
1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE

1542:
1543: PROCEDURE get_application_period(
1544: p_app_period_func IN VARCHAR2
1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods

Line 1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE

1544: p_app_period_func IN VARCHAR2
1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE

Line 1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE

1545: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1546: ,p_day IN hxc_time_building_blocks.start_time%TYPE
1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE
1553: )

Line 1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE

1547: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE
1553: )
1554: IS
1555: l_period_start_date date;

Line 1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE

1548: ,p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
1549: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1550: ,p_assignment_periods IN hxc_timecard_utilities.periods
1551: ,p_period_start OUT NOCOPY hxc_time_building_blocks.start_time%TYPE
1552: ,p_period_end OUT NOCOPY hxc_time_building_blocks.stop_time%TYPE
1553: )
1554: IS
1555: l_period_start_date date;
1556: l_period_end_date date;

Line 1721: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

1717: END;
1718:
1719:
1720: FUNCTION has_details(
1721: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1722: )
1723: RETURN BOOLEAN
1724: IS
1725: CURSOR c_details(

Line 1726: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE

1722: )
1723: RETURN BOOLEAN
1724: IS
1725: CURSOR c_details(
1726: p_app_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1727: )
1728: IS
1729: SELECT details.time_building_block_id
1730: FROM hxc_ap_detail_links details

Line 1731: ,hxc_time_building_blocks blocks

1727: )
1728: IS
1729: SELECT details.time_building_block_id
1730: FROM hxc_ap_detail_links details
1731: ,hxc_time_building_blocks blocks
1732: WHERE details.application_period_id = p_app_id
1733: AND details.time_building_block_id = blocks.time_building_block_id
1734: AND details.time_building_block_ovn = blocks.object_version_number
1735: AND blocks.date_to = hr_general.end_of_time;

Line 1737: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;

1733: AND details.time_building_block_id = blocks.time_building_block_id
1734: AND details.time_building_block_ovn = blocks.object_version_number
1735: AND blocks.date_to = hr_general.end_of_time;
1736:
1737: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1738: BEGIN
1739: OPEN c_details(p_app_id);
1740: FETCH c_details INTO l_detail_id;
1741: IF c_details%NOTFOUND

Line 1752: Procedure get_detail_links(p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,

1748: CLOSE c_details;
1749: RETURN TRUE;
1750: END has_details;
1751:
1752: Procedure get_detail_links(p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,
1753: p_timecard_id in hxc_time_building_blocks.time_building_block_id%TYPE,
1754: p_blocks out nocopy block_table )
1755: IS
1756: Cursor c_detail_links IS

Line 1753: p_timecard_id in hxc_time_building_blocks.time_building_block_id%TYPE,

1749: RETURN TRUE;
1750: END has_details;
1751:
1752: Procedure get_detail_links(p_app_id in hxc_time_building_blocks.time_building_block_id%TYPE,
1753: p_timecard_id in hxc_time_building_blocks.time_building_block_id%TYPE,
1754: p_blocks out nocopy block_table )
1755: IS
1756: Cursor c_detail_links IS
1757: select time_building_block_id, time_building_block_ovn

Line 1762: from hxc_time_building_blocks detail,

1758: from hxc_ap_detail_links
1759: where application_period_id = p_app_id
1760: and time_building_block_id
1761: not in ( select detail.time_building_block_id
1762: from hxc_time_building_blocks detail,
1763: hxc_time_building_blocks day
1764: where detail.parent_building_block_id = day.time_building_block_id
1765: and detail.parent_building_block_ovn = day.object_version_number
1766: and day.scope = 'DAY'

Line 1763: hxc_time_building_blocks day

1759: where application_period_id = p_app_id
1760: and time_building_block_id
1761: not in ( select detail.time_building_block_id
1762: from hxc_time_building_blocks detail,
1763: hxc_time_building_blocks day
1764: where detail.parent_building_block_id = day.time_building_block_id
1765: and detail.parent_building_block_ovn = day.object_version_number
1766: and day.scope = 'DAY'
1767: and detail.scope = 'DETAIL'

Line 1787: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE)

1783: Close c_detail_links;
1784: End get_detail_links;
1785:
1786: Procedure create_removed_links(p_removed_blocks block_table,
1787: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE)
1788:
1789: IS
1790: Cursor c_detail_exists (p_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
1791: p_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1790: Cursor c_detail_exists (p_app_id hxc_time_building_blocks.time_building_block_id%TYPE,

1786: Procedure create_removed_links(p_removed_blocks block_table,
1787: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE)
1788:
1789: IS
1790: Cursor c_detail_exists (p_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
1791: p_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
1792: ) is
1793: select 1
1794: from hxc_ap_detail_links

Line 1791: p_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE

1787: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE)
1788:
1789: IS
1790: Cursor c_detail_exists (p_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
1791: p_time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
1792: ) is
1793: select 1
1794: from hxc_ap_detail_links
1795: where application_period_id = p_app_id

Line 1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

1855:
1856: PROCEDURE generate_app_period(
1857: p_item_type IN wf_item_types.name%type
1858: ,p_item_key IN wf_item_attribute_values.item_key%type
1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE

Line 1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1856: PROCEDURE generate_app_period(
1857: p_item_type IN wf_item_types.name%type
1858: ,p_item_key IN wf_item_attribute_values.item_key%type
1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

Line 1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE

1857: p_item_type IN wf_item_types.name%type
1858: ,p_item_key IN wf_item_attribute_values.item_key%type
1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1865: ,p_approval_comp IN approval_comp

Line 1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE

1858: ,p_item_key IN wf_item_attribute_values.item_key%type
1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE
1863: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
1864: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1865: ,p_approval_comp IN approval_comp
1866: ,p_tc_resubmitted IN VARCHAR2

Line 1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE

1870: )
1871: IS
1872:
1873: CURSOR c_app_period(
1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE

Line 1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE

1871: IS
1872:
1873: CURSOR c_app_period(
1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE

Line 1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE

1872:
1873: CURSOR c_app_period(
1874: p_resource_id hxc_time_building_blocks.resource_id%TYPE
1875: ,p_start_time hxc_time_building_blocks.start_time%TYPE
1876: ,p_stop_time hxc_time_building_blocks.stop_time%TYPE
1877: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
1878: ,p_recipient_sequence IN hxc_approval_comps.approval_order%TYPE
1879: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
1880: ,p_category_sequence hxc_approval_comps.approval_order%TYPE

Line 1900: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

1896: --following added may12 for hr supervisor
1897: ORDER BY application_period_id asc;
1898:
1899: CURSOR c_tc_ap_link(
1900: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
1901: ,p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
1902: )
1903: IS
1904: SELECT 'Y'

Line 1901: ,p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE

1897: ORDER BY application_period_id asc;
1898:
1899: CURSOR c_tc_ap_link(
1900: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
1901: ,p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
1902: )
1903: IS
1904: SELECT 'Y'
1905: FROM hxc_tc_ap_links

Line 1915: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)

1911: select approver_id
1912: from hxc_app_period_summary
1913: where application_period_id = p_app_period_id;
1914:
1915: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
1916: is
1917: select adl.time_building_block_id,
1918: adl.time_building_block_ovn
1919: from hxc_ap_detail_links adl

Line 1922: cursor get_max_ovn(p_bb_id in hxc_time_building_blocks.time_building_block_id%type)

1918: adl.time_building_block_ovn
1919: from hxc_ap_detail_links adl
1920: where adl.application_period_id = p_application_period_id;
1921:
1922: cursor get_max_ovn(p_bb_id in hxc_time_building_blocks.time_building_block_id%type)
1923: is
1924: select max(object_version_number)
1925: from hxc_time_building_blocks
1926: where time_building_block_id = p_bb_id;

Line 1925: from hxc_time_building_blocks

1921:
1922: cursor get_max_ovn(p_bb_id in hxc_time_building_blocks.time_building_block_id%type)
1923: is
1924: select max(object_version_number)
1925: from hxc_time_building_blocks
1926: where time_building_block_id = p_bb_id;
1927:
1928: cursor get_item_key(p_bb_id in number)
1929: is

Line 1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

1931: from hxc_app_period_summary
1932: where application_period_id = p_bb_id;
1933:
1934:
1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;

Line 1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;

1932: where application_period_id = p_bb_id;
1933:
1934:
1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

Line 1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;

1933:
1934:
1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;

Line 1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;

Line 1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;

1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
1945: l_first_app_period BOOLEAN;

Line 1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;

1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
1945: l_first_app_period BOOLEAN;
1946: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;

Line 1962: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,

1958: i number;
1959: l_max_ovn number;
1960: l_item_key number ;
1961: l_blank varchar2(2) := 'N';
1962: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,
1963: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);
1964:
1965:
1966: TYPE tab_type IS TABLE OF rec_type INDEX BY BINARY_INTEGER;

Line 1963: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);

1959: l_max_ovn number;
1960: l_item_key number ;
1961: l_blank varchar2(2) := 'N';
1962: type rec_type is record(p_id hxc_time_building_blocks.time_building_block_id%TYPE,
1963: p_ovn hxc_time_building_blocks.time_building_block_id%TYPE);
1964:
1965:
1966: TYPE tab_type IS TABLE OF rec_type INDEX BY BINARY_INTEGER;
1967:

Line 2036: --should also end date them from hxc_time_building_blocks

2032:
2033: l_first_app_period := FALSE;
2034:
2035: ELSE
2036: --should also end date them from hxc_time_building_blocks
2037: --remove them from hxc_app_period_summary
2038: --from hxc_tc_ap_links and hxc_ap_detail_links
2039: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);
2040:

Line 2457: FROM hxc_time_building_blocks day1,

2453: -- choosing that style.
2454: --
2455: cursor csr_get_appr_style is
2456: SELECT day1.approval_style_id
2457: FROM hxc_time_building_blocks day1,
2458: hxc_time_building_blocks timecard
2459: WHERE day1.resource_id = p_resource_id
2460: AND day1.scope = 'DAY'
2461: AND day1.start_time BETWEEN p_period_start_date AND p_period_end_date

Line 2458: hxc_time_building_blocks timecard

2454: --
2455: cursor csr_get_appr_style is
2456: SELECT day1.approval_style_id
2457: FROM hxc_time_building_blocks day1,
2458: hxc_time_building_blocks timecard
2459: WHERE day1.resource_id = p_resource_id
2460: AND day1.scope = 'DAY'
2461: AND day1.start_time BETWEEN p_period_start_date AND p_period_end_date
2462: AND day1.date_to = hr_general.end_of_time

Line 2527: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

2523: funcmode IN varchar2,
2524: result IN OUT NOCOPY varchar2) is
2525: --
2526: cursor csr_get_app_set_from_tc
2527: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
2528: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type) is
2529: select to_char(application_set_id)
2530: from hxc_time_building_blocks
2531: where time_building_block_id = p_timecard_id

Line 2528: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type) is

2524: result IN OUT NOCOPY varchar2) is
2525: --
2526: cursor csr_get_app_set_from_tc
2527: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
2528: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type) is
2529: select to_char(application_set_id)
2530: from hxc_time_building_blocks
2531: where time_building_block_id = p_timecard_id
2532: and object_version_number = p_timecard_ovn;

Line 2530: from hxc_time_building_blocks

2526: cursor csr_get_app_set_from_tc
2527: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
2528: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type) is
2529: select to_char(application_set_id)
2530: from hxc_time_building_blocks
2531: where time_building_block_id = p_timecard_id
2532: and object_version_number = p_timecard_ovn;
2533: --
2534: cursor csr_get_tc_info(p_bld_blk_id number,

Line 2537: from hxc_time_building_blocks tc

2533: --
2534: cursor csr_get_tc_info(p_bld_blk_id number,
2535: p_ovn number) is
2536: select tc.resource_id, tc.start_time, tc.stop_time
2537: from hxc_time_building_blocks tc
2538: where tc.time_building_block_id = p_bld_blk_id
2539: and tc.object_version_number = p_ovn;
2540: --
2541: cursor csr_get_apps(p_app_set varchar2) is

Line 2559: from hxc_time_building_blocks day

2555: select day.time_building_block_id,
2556: day.start_time,
2557: day.stop_time,
2558: day.object_version_number
2559: from hxc_time_building_blocks day
2560: where day.parent_building_block_id = p_tc_bld_blk_id
2561: and day.parent_building_block_ovn = p_tc_ovn
2562: and day.scope = 'DAY'
2563: and day.object_version_number = (select max(day2.object_version_number)

Line 2564: from hxc_time_building_blocks day2

2560: where day.parent_building_block_id = p_tc_bld_blk_id
2561: and day.parent_building_block_ovn = p_tc_ovn
2562: and day.scope = 'DAY'
2563: and day.object_version_number = (select max(day2.object_version_number)
2564: from hxc_time_building_blocks day2
2565: where day.time_building_block_id =
2566: day2.time_building_block_id)
2567: order by 2;
2568: --

Line 2678: cursor c_app_overlap_data_set(l_app_start_date hxc_time_building_blocks.start_time%type,

2674: WHERE parent_comp_id = p_comp_id
2675: AND parent_comp_ovn = p_comp_ovn
2676: ORDER BY time_category_id desc;
2677:
2678: cursor c_app_overlap_data_set(l_app_start_date hxc_time_building_blocks.start_time%type,
2679: l_app_stop_date hxc_time_building_blocks.start_time%type,
2680: l_tc_start_time hxc_time_building_blocks.start_time%type )
2681: is
2682: select '1' from hxc_data_sets

Line 2679: l_app_stop_date hxc_time_building_blocks.start_time%type,

2675: AND parent_comp_ovn = p_comp_ovn
2676: ORDER BY time_category_id desc;
2677:
2678: cursor c_app_overlap_data_set(l_app_start_date hxc_time_building_blocks.start_time%type,
2679: l_app_stop_date hxc_time_building_blocks.start_time%type,
2680: l_tc_start_time hxc_time_building_blocks.start_time%type )
2681: is
2682: select '1' from hxc_data_sets
2683: where (((l_app_start_date between start_date and end_date) and (l_app_start_date

Line 2680: l_tc_start_time hxc_time_building_blocks.start_time%type )

2676: ORDER BY time_category_id desc;
2677:
2678: cursor c_app_overlap_data_set(l_app_start_date hxc_time_building_blocks.start_time%type,
2679: l_app_stop_date hxc_time_building_blocks.start_time%type,
2680: l_tc_start_time hxc_time_building_blocks.start_time%type )
2681: is
2682: select '1' from hxc_data_sets
2683: where (((l_app_start_date between start_date and end_date) and (l_app_start_date 2684: or l_app_stop_date between start_date and end_date)

Line 2693: l_processed_app_start hxc_time_building_blocks.start_time%TYPE;

2689: l_default_comp approval_comp;
2690: l_count NUMBER;
2691: l_dummy NUMBER;
2692:
2693: l_processed_app_start hxc_time_building_blocks.start_time%TYPE;
2694: l_processed_app_stop hxc_time_building_blocks.stop_time%TYPE;
2695: l_gen_app_period boolean;
2696:
2697: BEGIN

Line 2694: l_processed_app_stop hxc_time_building_blocks.stop_time%TYPE;

2690: l_count NUMBER;
2691: l_dummy NUMBER;
2692:
2693: l_processed_app_start hxc_time_building_blocks.start_time%TYPE;
2694: l_processed_app_stop hxc_time_building_blocks.stop_time%TYPE;
2695: l_gen_app_period boolean;
2696:
2697: BEGIN
2698:

Line 3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

3173: --
3174:
3175:
3176: FUNCTION chk_app_approved(
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE

Line 3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE

3174:
3175:
3176: FUNCTION chk_app_approved(
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE

Line 3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE

3175:
3176: FUNCTION chk_app_approved(
3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE

Line 3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE

3186: IS
3187:
3188: CURSOR csr_chk(
3189: p_date DATE
3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE

Line 3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE

3187:
3188: CURSOR csr_chk(
3189: p_date DATE
3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE

Line 3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE

3188: CURSOR csr_chk(
3189: p_date DATE
3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE

Line 3296: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

3292: End has_valid_assign;
3293:
3294: FUNCTION is_submitted(
3295: p_day IN DATE
3296: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3297: )
3298: RETURN BOOLEAN
3299: IS
3300: CURSOR c_submitted(

Line 3302: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

3298: RETURN BOOLEAN
3299: IS
3300: CURSOR c_submitted(
3301: p_day IN DATE
3302: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3303: )
3304: IS
3305: SELECT 'Y'
3306: FROM hxc_time_building_blocks day

Line 3306: FROM hxc_time_building_blocks day

3302: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3303: )
3304: IS
3305: SELECT 'Y'
3306: FROM hxc_time_building_blocks day
3307: ,hxc_time_building_blocks tc
3308: WHERE TRUNC(day.start_time) = p_day
3309: AND day.scope = 'DAY'
3310: AND day.approval_status = 'SUBMITTED'

Line 3307: ,hxc_time_building_blocks tc

3303: )
3304: IS
3305: SELECT 'Y'
3306: FROM hxc_time_building_blocks day
3307: ,hxc_time_building_blocks tc
3308: WHERE TRUNC(day.start_time) = p_day
3309: AND day.scope = 'DAY'
3310: AND day.approval_status = 'SUBMITTED'
3311: AND day.resource_id = p_resource_id

Line 3387: from hxc_time_building_blocks tc

3383: p_ovn number
3384: )
3385: IS
3386: select tc.resource_id, tc.start_time, tc.stop_time,tc.last_updated_by
3387: from hxc_time_building_blocks tc
3388: where tc.time_building_block_id = p_bld_blk_id
3389: and tc.object_version_number = p_ovn;
3390:
3391:

Line 3912: p_app_id IN hxc_time_building_blocks.time_building_block_id

3908: -----------------------------------------new procedures
3909:
3910: /*
3911: FUNCTION get_approval_style(
3912: p_app_id IN hxc_time_building_blocks.time_building_block_id
3913: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
3914: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3915: IS
3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;

Line 3913: ,p_app_ovn IN hxc_time_building_blocks.object_version_number

3909:
3910: /*
3911: FUNCTION get_approval_style(
3912: p_app_id IN hxc_time_building_blocks.time_building_block_id
3913: ,p_app_ovn IN hxc_time_building_blocks.object_version_number
3914: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3915: IS
3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
3917:

Line 3919: p_app_id IN hxc_time_building_blocks.time_building_block_id

3915: IS
3916: l_approval_style hxc_approval_styles.approval_style_id%TYPE;
3917:
3918: CURSOR c_approval_style(
3919: p_app_id IN hxc_time_building_blocks.time_building_block_id
3920: )
3921: IS
3922: SELECT tc.approval_style_id
3923: FROM hxc_timecard_summary tc

Line 3945: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3941: */
3942:
3943:
3944: FUNCTION get_approval_style(
3945: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3946: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3947: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3948: IS
3949: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;

Line 3946: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE

3942:
3943:
3944: FUNCTION get_approval_style(
3945: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3946: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
3947: ) RETURN hxc_approval_styles.approval_style_id%TYPE
3948: IS
3949: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
3950: /*

Line 3952: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

3948: IS
3949: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE := NULL;
3950: /*
3951: CURSOR c_approval_style(
3952: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
3953: )
3954: IS
3955: select approval_style_id
3956: from hxc_timecard_summary

Line 4324: hxc_time_building_blocks htb

4320: is
4321: select hac.approval_comp_id
4322: from hxc_approval_comps hac,
4323: hxc_approval_styles has,
4324: hxc_time_building_blocks htb
4325: where htb.time_building_block_id =p_bb_id
4326: and htb.object_version_number = p_bb_ovn
4327: and htb.approval_style_id = has.approval_style_id
4328: and has.approval_style_id = hac.APPROVAL_STYLE_ID

Line 4537: --jxtan in new implementation, comment is save in hxc_time_building_blocks

4533:
4534: if g_debug then
4535: hr_utility.set_location(l_proc, 110);
4536: end if;
4537: --jxtan in new implementation, comment is save in hxc_time_building_blocks
4538: UPDATE hxc_time_building_blocks
4539: SET comment_text = substr(l_exception, 1, 2000)
4540: WHERE time_building_block_id = l_app_bld_blk_id
4541: AND object_version_number = l_app_ovn;

Line 4538: UPDATE hxc_time_building_blocks

4534: if g_debug then
4535: hr_utility.set_location(l_proc, 110);
4536: end if;
4537: --jxtan in new implementation, comment is save in hxc_time_building_blocks
4538: UPDATE hxc_time_building_blocks
4539: SET comment_text = substr(l_exception, 1, 2000)
4540: WHERE time_building_block_id = l_app_bld_blk_id
4541: AND object_version_number = l_app_ovn;
4542:

Line 4650: from hxc_time_building_blocks day,

4646: select day.resource_id,
4647: day.time_building_block_id,
4648: day.approval_style_id,
4649: max(day.object_version_number)
4650: from hxc_time_building_blocks day,
4651: hxc_time_building_blocks app
4652: where app.time_building_block_id = p_app_bld_blk_id
4653: and app.object_version_number = p_app_ovn
4654: and app.scope = 'APPLICATION_PERIOD'

Line 4651: hxc_time_building_blocks app

4647: day.time_building_block_id,
4648: day.approval_style_id,
4649: max(day.object_version_number)
4650: from hxc_time_building_blocks day,
4651: hxc_time_building_blocks app
4652: where app.time_building_block_id = p_app_bld_blk_id
4653: and app.object_version_number = p_app_ovn
4654: and app.scope = 'APPLICATION_PERIOD'
4655: and app.resource_id = day.resource_id

Line 4982: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE

4978: END find_approval_rule;
4979: --
4980: --
4981: FUNCTION was_approved(
4982: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4983: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4984: )
4985: RETURN BOOLEAN
4986: IS

Line 4983: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE

4979: --
4980: --
4981: FUNCTION was_approved(
4982: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4983: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4984: )
4985: RETURN BOOLEAN
4986: IS
4987: CURSOR c_was_approved(

Line 4988: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE

4984: )
4985: RETURN BOOLEAN
4986: IS
4987: CURSOR c_was_approved(
4988: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4989: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4990: )
4991: IS
4992: SELECT 'Y'

Line 4989: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE

4985: RETURN BOOLEAN
4986: IS
4987: CURSOR c_was_approved(
4988: p_app_period_id IN hxc_time_building_blocks.time_building_block_id%TYPE
4989: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4990: )
4991: IS
4992: SELECT 'Y'
4993: FROM hxc_time_building_blocks

Line 4993: FROM hxc_time_building_blocks

4989: ,p_app_period_ovn IN hxc_time_building_blocks.object_version_number%TYPE
4990: )
4991: IS
4992: SELECT 'Y'
4993: FROM hxc_time_building_blocks
4994: WHERE time_building_block_id = p_app_period_id
4995: AND object_version_number < p_app_period_ovn
4996: AND approval_status = 'APPROVED';
4997:

Line 5014: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

5010:
5011: END was_approved;
5012:
5013: FUNCTION same_no_blocks(
5014: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5015: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5016: )
5017: RETURN BOOLEAN
5018: IS

Line 5015: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE

5011: END was_approved;
5012:
5013: FUNCTION same_no_blocks(
5014: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5015: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5016: )
5017: RETURN BOOLEAN
5018: IS
5019: CURSOR c_no_blocks(

Line 5020: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

5016: )
5017: RETURN BOOLEAN
5018: IS
5019: CURSOR c_no_blocks(
5020: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5021: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5022: )
5023: IS
5024: SELECT COUNT(*)

Line 5021: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE

5017: RETURN BOOLEAN
5018: IS
5019: CURSOR c_no_blocks(
5020: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5021: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5022: )
5023: IS
5024: SELECT COUNT(*)
5025: FROM hxc_time_building_blocks

Line 5025: FROM hxc_time_building_blocks

5021: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5022: )
5023: IS
5024: SELECT COUNT(*)
5025: FROM hxc_time_building_blocks
5026: START WITH time_building_block_id = p_timecard_id
5027: AND object_version_number = p_timecard_ovn
5028: CONNECT by prior time_building_block_id =
5029: parent_building_block_id

Line 5034: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

5030: and prior object_version_number =
5031: parent_building_block_ovn;
5032:
5033: CURSOR c_old_tc(
5034: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5035: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5036: )
5037: IS
5038: SELECT object_version_number

Line 5035: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE

5031: parent_building_block_ovn;
5032:
5033: CURSOR c_old_tc(
5034: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
5035: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5036: )
5037: IS
5038: SELECT object_version_number
5039: FROM hxc_time_building_blocks

Line 5039: FROM hxc_time_building_blocks

5035: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE
5036: )
5037: IS
5038: SELECT object_version_number
5039: FROM hxc_time_building_blocks
5040: WHERE time_building_block_id = p_timecard_id
5041: AND approval_status = 'SUBMITTED'
5042: AND object_version_number < p_timecard_ovn
5043: ORDER BY object_version_number desc;

Line 5047: l_previous_tc_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;

5043: ORDER BY object_version_number desc;
5044:
5045: l_current_tc_count NUMBER;
5046: l_old_tc_count NUMBER;
5047: l_previous_tc_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
5048: BEGIN
5049: OPEN c_old_tc(p_timecard_id, p_timecard_ovn);
5050: FETCH c_old_tc INTO l_previous_tc_ovn;
5051: CLOSE c_old_tc;

Line 5120: FROM hxc_time_building_blocks

5116: order by dar.start_date;
5117:
5118: CURSOR csr_get_tc_dates ( p_bb_id NUMBER, p_bb_ovn NUMBER )IS
5119: SELECT start_time, stop_time
5120: FROM hxc_time_building_blocks
5121: WHERE time_building_block_id = p_bb_id
5122: AND object_version_number = p_bb_ovn;
5123: --
5124: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;

Line 5149: l_appl_period_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

5145: l_changed varchar2(10);
5146: l_cnt number;
5147: l_resubmit varchar2(10);
5148: l_bb_new varchar2(10);
5149: l_appl_period_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
5150: l_appl_period_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
5151: -- l_item_key wf_items.item_key%type;
5152: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.execute_appr_rule';
5153: --

Line 5150: l_appl_period_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;

5146: l_cnt number;
5147: l_resubmit varchar2(10);
5148: l_bb_new varchar2(10);
5149: l_appl_period_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
5150: l_appl_period_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
5151: -- l_item_key wf_items.item_key%type;
5152: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.execute_appr_rule';
5153: --
5154: BEGIN

Line 5304: -- Check to see if any values in hxc_time_building_blocks have

5300: RETURN;
5301: END IF;
5302:
5303: --
5304: -- Check to see if any values in hxc_time_building_blocks have
5305: -- changed for the submitted timecard.
5306: --
5307: IF l_bb_new = 'YES' THEN
5308: l_bld_blk_changed := TRUE;

Line 5325: -- timecard, if nothing in hxc_time_building_blocks has changed.

5321: END IF;
5322: END IF;
5323: --
5324: -- Check to see if the mappings have changed for the submitted
5325: -- timecard, if nothing in hxc_time_building_blocks has changed.
5326: --
5327: IF l_bld_blk_changed THEN
5328: --
5329: if g_debug then

Line 5625: l_return hxc_time_building_blocks.resource_id%TYPE;

5621: --
5622: FUNCTION get_override(p_timecard_bb_id NUMBER
5623: ,p_timecard_ovn NUMBER) RETURN NUMBER IS
5624: --
5625: l_return hxc_time_building_blocks.resource_id%TYPE;
5626: --
5627: cursor csr_get_override_id is
5628: select to_number(ta.attribute10)
5629: from hxc_time_attributes ta,

Line 5631: hxc_time_building_blocks tbb

5627: cursor csr_get_override_id is
5628: select to_number(ta.attribute10)
5629: from hxc_time_attributes ta,
5630: hxc_time_attribute_usages tau,
5631: hxc_time_building_blocks tbb
5632: where tbb.time_building_block_id = p_timecard_bb_id
5633: and tbb.object_version_number = p_timecard_ovn
5634: and tbb.time_building_block_id = tau.time_building_block_id
5635: and tbb.object_version_number = tau.time_building_block_ovn