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_APP_PERIOD_SUMMARY_API dependencies on HXC_APP_PERIOD_SUMMARY

Line 1: package body hxc_app_period_summary_api as

1: package body hxc_app_period_summary_api as
2: /* $Header: hxcapsumapi.pkb 120.2.12010000.1 2008/07/28 11:04:41 appldev ship $ */
3: Procedure delete_app_period
4: (p_application_period_id in hxc_app_period_summary.application_period_id%type
5: ) is

Line 4: (p_application_period_id in hxc_app_period_summary.application_period_id%type

1: package body hxc_app_period_summary_api as
2: /* $Header: hxcapsumapi.pkb 120.2.12010000.1 2008/07/28 11:04:41 appldev ship $ */
3: Procedure delete_app_period
4: (p_application_period_id in hxc_app_period_summary.application_period_id%type
5: ) is
6:
7: Begin
8:

Line 24: hxc_app_period_summary_pkg.delete_summary_row

20:
21: --
22: -- 3. Remove the application period summary row itself
23: --
24: hxc_app_period_summary_pkg.delete_summary_row
25: (p_app_period_id => p_application_period_id);
26:
27: End delete_app_period;
28:

Line 30: (p_application_period_id in hxc_app_period_summary.application_period_id%type

26:
27: End delete_app_period;
28:
29: procedure app_period_clean_up
30: (p_application_period_id in hxc_app_period_summary.application_period_id%type
31: ,p_mode in varchar2
32: ) is
33:
34: cursor app_period_info

Line 35: (p_id in hxc_app_period_summary.application_period_id%type) is

31: ,p_mode in varchar2
32: ) is
33:
34: cursor app_period_info
35: (p_id in hxc_app_period_summary.application_period_id%type) is
36: select tbb.resource_id
37: ,tbb.start_time
38: ,tbb.stop_time
39: ,ta.attribute1 time_recipient_id

Line 49: (p_resource_id in hxc_app_period_summary.resource_id%type

45: and tau.time_attribute_id = ta.time_attribute_id
46: and ta.attribute_category = 'APPROVAL';
47:
48: cursor app_periods_to_remove
49: (p_resource_id in hxc_app_period_summary.resource_id%type
50: ,p_start_time in hxc_app_period_summary.start_time%type
51: ,p_stop_time in hxc_app_period_summary.stop_time%type
52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is
53: select application_period_id

Line 50: ,p_start_time in hxc_app_period_summary.start_time%type

46: and ta.attribute_category = 'APPROVAL';
47:
48: cursor app_periods_to_remove
49: (p_resource_id in hxc_app_period_summary.resource_id%type
50: ,p_start_time in hxc_app_period_summary.start_time%type
51: ,p_stop_time in hxc_app_period_summary.stop_time%type
52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is
53: select application_period_id
54: from hxc_app_period_summary

Line 51: ,p_stop_time in hxc_app_period_summary.stop_time%type

47:
48: cursor app_periods_to_remove
49: (p_resource_id in hxc_app_period_summary.resource_id%type
50: ,p_start_time in hxc_app_period_summary.start_time%type
51: ,p_stop_time in hxc_app_period_summary.stop_time%type
52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is
53: select application_period_id
54: from hxc_app_period_summary
55: where resource_id = p_resource_id

Line 52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is

48: cursor app_periods_to_remove
49: (p_resource_id in hxc_app_period_summary.resource_id%type
50: ,p_start_time in hxc_app_period_summary.start_time%type
51: ,p_stop_time in hxc_app_period_summary.stop_time%type
52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is
53: select application_period_id
54: from hxc_app_period_summary
55: where resource_id = p_resource_id
56: and start_time <= p_stop_time

Line 54: from hxc_app_period_summary

50: ,p_start_time in hxc_app_period_summary.start_time%type
51: ,p_stop_time in hxc_app_period_summary.stop_time%type
52: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type) is
53: select application_period_id
54: from hxc_app_period_summary
55: where resource_id = p_resource_id
56: and start_time <= p_stop_time
57: and stop_time >= p_start_time
58: and time_recipient_id = p_time_recipient_id;

Line 60: l_resource_id hxc_app_period_summary.resource_id%type;

56: and start_time <= p_stop_time
57: and stop_time >= p_start_time
58: and time_recipient_id = p_time_recipient_id;
59:
60: l_resource_id hxc_app_period_summary.resource_id%type;
61: l_start_time hxc_app_period_summary.start_time%type;
62: l_stop_time hxc_app_period_summary.stop_time%type;
63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;
64:

Line 61: l_start_time hxc_app_period_summary.start_time%type;

57: and stop_time >= p_start_time
58: and time_recipient_id = p_time_recipient_id;
59:
60: l_resource_id hxc_app_period_summary.resource_id%type;
61: l_start_time hxc_app_period_summary.start_time%type;
62: l_stop_time hxc_app_period_summary.stop_time%type;
63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;
64:
65: Begin

Line 62: l_stop_time hxc_app_period_summary.stop_time%type;

58: and time_recipient_id = p_time_recipient_id;
59:
60: l_resource_id hxc_app_period_summary.resource_id%type;
61: l_start_time hxc_app_period_summary.start_time%type;
62: l_stop_time hxc_app_period_summary.stop_time%type;
63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;
64:
65: Begin
66:

Line 63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;

59:
60: l_resource_id hxc_app_period_summary.resource_id%type;
61: l_start_time hxc_app_period_summary.start_time%type;
62: l_stop_time hxc_app_period_summary.stop_time%type;
63: l_time_recipient_id hxc_app_period_summary.time_recipient_id%type;
64:
65: Begin
66:
67: if(p_mode = hxc_timecard_summary_pkg.c_normal_mode) then

Line 86: (p_application_period_id in hxc_app_period_summary.application_period_id%type

82:
83: End app_period_clean_up;
84:
85: procedure app_period_create
86: (p_application_period_id in hxc_app_period_summary.application_period_id%type
87: ,p_mode in varchar2 default hxc_timecard_summary_pkg.c_normal_mode
88: ) is
89:
90: Begin

Line 98: hxc_app_period_summary_pkg.insert_summary_row

94: app_period_clean_up(p_application_period_id,p_mode);
95: --
96: -- 2. Create the application period summary row
97: --
98: hxc_app_period_summary_pkg.insert_summary_row
99: (p_app_period_id => p_application_period_id
100: ,p_approval_item_type => NULL
101: ,p_approval_process_name => NULL
102: ,p_approval_item_key => NULL

Line 131: (p_application_period_id in hxc_app_period_summary.application_period_id%type

127: --
128: End app_period_create;
129:
130: procedure app_period_create
131: (p_application_period_id in hxc_app_period_summary.application_period_id%type
132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

Line 132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type

128: End app_period_create;
129:
130: procedure app_period_create
131: (p_application_period_id in hxc_app_period_summary.application_period_id%type
132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type

Line 133: ,p_approval_status in hxc_app_period_summary.approval_status%type

129:
130: procedure app_period_create
131: (p_application_period_id in hxc_app_period_summary.application_period_id%type
132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type

Line 134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type

130: procedure app_period_create
131: (p_application_period_id in hxc_app_period_summary.application_period_id%type
132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type

Line 135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type

131: (p_application_period_id in hxc_app_period_summary.application_period_id%type
132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

Line 136: ,p_start_time in hxc_app_period_summary.start_time%type

132: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

Line 137: ,p_stop_time in hxc_app_period_summary.stop_time%type

133: ,p_approval_status in hxc_app_period_summary.approval_status%type
134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type

Line 138: ,p_resource_id in hxc_app_period_summary.resource_id%type

134: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type

Line 139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type

135: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type

Line 140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type

136: ,p_start_time in hxc_app_period_summary.start_time%type
137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

Line 141: ,p_creation_date in hxc_app_period_summary.creation_date%type

137: ,p_stop_time in hxc_app_period_summary.stop_time%type
138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null

Line 142: ,p_notification_status in hxc_app_period_summary.notification_status%type

138: ,p_resource_id in hxc_app_period_summary.resource_id%type
139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
146: ) is

Line 143: ,p_approver_id in hxc_app_period_summary.approver_id%type

139: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
146: ) is
147:

Line 144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type

140: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
146: ) is
147:
148: cursor c_get_data_set_id(p_application_period_id number, p_application_period_ovn number) is

Line 145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null

141: ,p_creation_date in hxc_app_period_summary.creation_date%type
142: ,p_notification_status in hxc_app_period_summary.notification_status%type
143: ,p_approver_id in hxc_app_period_summary.approver_id%type
144: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
146: ) is
147:
148: cursor c_get_data_set_id(p_application_period_id number, p_application_period_ovn number) is
149: select data_set_id from hxc_time_building_blocks

Line 168: hxc_app_period_summary_pkg.insert_summary_row

164: open c_get_data_set_id(p_application_period_id, p_application_period_ovn);
165: fetch c_get_data_set_id into l_data_set_id;
166: close c_get_data_set_id;
167:
168: hxc_app_period_summary_pkg.insert_summary_row
169: (p_application_period_id => p_application_period_id
170: ,p_application_period_ovn=> p_application_period_ovn
171: ,p_approval_status => p_approval_status
172: ,p_time_recipient_id => p_time_recipient_id

Line 210: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

206: --
207: End app_period_create;
208:
209: Procedure app_period_delete
210: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is
211:
212: Begin
213:
214: delete_app_period(p_application_period_id);

Line 353: FROM hxc_app_period_summary aps

349: SELECT aps.start_time
350: ,aps.stop_time
351: ,aps.approval_status
352: ,aps.time_category_id
353: FROM hxc_app_period_summary aps
354: WHERE aps.resource_id = p_resource_id
355: AND aps.time_recipient_id = p_time_recipient_id
356: AND aps.start_time <= p_stop_date
357: AND aps.stop_time >= p_start_date

Line 457: end hxc_app_period_summary_api;

453: p_valid_periods := mergePeriods(p_valid_periods,l_invalid_periods);
454:
455: End get_valid_periods;
456:
457: end hxc_app_period_summary_api;