[Home] [Help]
4595: END change_work_pattern_duration;
4596:
4597: -- Procedure : populate_work_pattern_table
4598: -- Purpose : This procedure is called from self service for populating the global temp table
4599: -- : pa_work_pattern_temp_table for the given assignment start date and assignment
4600: -- : end date. The data will be populated for 14 days starting with Global week start day
4601: -- : <= p_display_start_date. p_status_code is optional, if it is not given then it will
4602: -- : fetch all the assignments irrespective of the assignment schedule status.
4603: -- : Finally it returns the actual start date depending on the global week start date
4792:
4793: x_show_start_date := l_actual_display_start_date;
4794:
4795: IF p_delete_flag = 'Y' then
4796: DELETE FROM pa_work_pattern_temp_table;
4797: END IF;
4798:
4799: --If more than 25 resources than raise error. In phase2 we plan to have this for multiple resources
4800: l_count := p_resource_id_tbl.COUNT;
5216: END LOOP; -- j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5217: END LOOP;-- l_temp IN c_quantity_cursor(l_resource_id_tbl(i)) LOOP
5218: END LOOP;--i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
5219:
5220: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5221:
5222: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5223: INSERT INTO pa_work_pattern_temp_table
5224: (
5219:
5220: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5221:
5222: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5223: INSERT INTO pa_work_pattern_temp_table
5224: (
5225: PROJECT_ID ,
5226: PROJECT_NAME,
5227: ASSIGNMENT_NAME,