1: package body hxc_app_period_summary_pkg as
2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
1: package body hxc_app_period_summary_pkg as
2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
2: /* $Header: hxcapsum.pkb 120.1 2005/06/30 12:11:17 jdupont noship $ */
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
3:
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
4: procedure insert_summary_row
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
5: (p_application_period_id in hxc_app_period_summary.application_period_id%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
6: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
7: ,p_approval_status in hxc_app_period_summary.approval_status%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
8: ,p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
9: ,p_time_category_id in hxc_app_period_summary.time_category_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
10: ,p_start_time in hxc_app_period_summary.start_time%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
11: ,p_stop_time in hxc_app_period_summary.stop_time%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
12: ,p_resource_id in hxc_app_period_summary.resource_id%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
13: ,p_recipient_sequence in hxc_app_period_summary.recipient_sequence%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
14: ,p_category_sequence in hxc_app_period_summary.category_sequence%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
15: ,p_creation_date in hxc_app_period_summary.creation_date%type
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
16: ,p_notification_status in hxc_app_period_summary.notification_status%type
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:
17: ,p_approver_id in hxc_app_period_summary.approver_id%type
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:
25: Begin
18: ,p_approval_comp_id in hxc_app_period_summary.approval_comp_id%type
19: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
20: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
21: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
22: ,p_data_set_id in hxc_app_period_summary.data_set_id%type
23: ) is
24:
25: Begin
26:
23: ) is
24:
25: Begin
26:
27: insert into hxc_app_period_summary
28: (application_period_id
29: ,application_period_ovn
30: ,approval_status
31: ,time_recipient_id
68: End;
69:
70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:
69:
70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:
77: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
70: procedure insert_summary_row
71: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
72: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
73: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
74: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
75: ) is
76:
77: cursor c_app_period_info(p_id in hxc_time_building_blocks.time_building_block_id%type) is
78: select tbb.time_building_block_id application_period_id
111: open c_app_period_info(p_app_period_id);
112: fetch c_app_period_info into l_app_summary_row;
113:
114: if(c_app_period_info%found) then
115: insert into hxc_app_period_summary
116: (application_period_id
117: ,application_period_ovn
118: ,approval_status
119: ,time_recipient_id
158:
159: End insert_summary_row;
160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:
159: End insert_summary_row;
160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:
167: Begin
160:
161: procedure update_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type
162: ,p_approval_item_type in hxc_app_period_summary.approval_item_type%type
163: ,p_approval_process_name in hxc_app_period_summary.approval_process_name%type
164: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type
165: ) is
166:
167: Begin
168:
173: procedure delete_summary_row(p_app_period_id in hxc_time_building_blocks.time_building_block_id%type) is
174:
175: Begin
176:
177: delete from hxc_app_period_summary where application_period_id = p_app_period_id;
178:
179: Exception
180: When others then
181: FND_MESSAGE.set_name('HXC','HXC_NO_APP_PERIOD_ID');
182: FND_MESSAGE.raise_error;
183:
184: End delete_summary_row;
185:
186: end hxc_app_period_summary_pkg;