[Home] [Help]
5075: END change_work_pattern_duration;
5076:
5077: -- Procedure : populate_work_pattern_table
5078: -- Purpose : This procedure is called from self service for populating the global temp table
5079: -- : pa_work_pattern_temp_table for the given assignment start date and assignment
5080: -- : end date. The data will be populated for 14 days starting with Global week start day
5081: -- : <= p_display_start_date. p_status_code is optional, if it is not given then it will
5082: -- : fetch all the assignments irrespective of the assignment schedule status.
5083: -- : Finally it returns the actual start date depending on the global week start date
5272:
5273: x_show_start_date := l_actual_display_start_date;
5274:
5275: IF p_delete_flag = 'Y' then
5276: DELETE FROM pa_work_pattern_temp_table;
5277: END IF;
5278:
5279: --If more than 25 resources than raise error. In phase2 we plan to have this for multiple resources
5280: l_count := p_resource_id_tbl.COUNT;
5696: END LOOP; -- j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5697: END LOOP;-- l_temp IN c_quantity_cursor(l_resource_id_tbl(i)) LOOP
5698: END LOOP;--i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
5699:
5700: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5701:
5702: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5703: INSERT INTO pa_work_pattern_temp_table
5704: (
5699:
5700: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5701:
5702: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5703: INSERT INTO pa_work_pattern_temp_table
5704: (
5705: PROJECT_ID ,
5706: PROJECT_NAME,
5707: ASSIGNMENT_NAME,