67:
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
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
79: ,tbb.resource_id
80: ,tbb.start_time
81: ,tbb.stop_time
89: ,ta1.attribute4 notification_status
90: ,decode(ta1.attribute3,'NA',0,to_number(ta1.attribute3)) approver_id
91: ,tbb.object_version_number application_period_ovn
92: ,tbb.data_set_id
93: from hxc_time_building_blocks tbb, hxc_time_attribute_usages tau, hxc_time_attributes ta1
94: where tbb.time_building_block_id = p_id
95: and tbb.date_to = hr_general.end_of_time
96: and tbb.scope = 'APPLICATION_PERIOD'
97: and tau.time_building_block_id = tbb.time_building_block_id
157: close c_app_period_info;
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
169: null;
170:
171: End update_summary_row;
172:
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;