[Home] [Help]
4504: -- Put the monday..sunday hours in the l_hours_db_table table which stores the data base values of the
4505: -- schedule records. Also find out the monday..sunday hours to be passed to change_work_pattern
4506: /* Start of Addition for bug 4068167 */
4507: Begin
4508: select decode(l_global_week_start_day,1,1,2,0,3,6,4,5,5,4,6,3,7,2,0) into l_days_to_inc from dual;
4509: END;
4510: /* End of addition for bug 4068167 */
4511:
4512: IF l_sch_record_tab.COUNT > 0 THEN
5236: /* To incorporate the difference between PA weekday numbers and */
5237: /* session parameter dependent weekday numbers.*/
5238: Select (to_number(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_global_week_start_day - 1)),'D')))
5239: into l_global_week_start_day_new
5240: from dual;
5241: /* Code ends for Bug 5622389 */
5242:
5243: -- Get the next_day-7 for the given date
5244:
5245: BEGIN
5246: /*Commented for the bug 3648827
5247: SELECT next_day(p_display_start_date,decode(l_global_week_start_day,1,'SUNDAY',2,'MONDAY',3,'TUESDAY',4,'WEDNESDAY',5,'THURSDAY',6,'FRIDAY',7,'SATURDAY'))-7
5248: INTO l_actual_display_start_date
5249: FROM dual;*/
5250: /*Added the below code for bug 3648827*/
5251: SELECT to_char(p_display_start_date,'D') INTO l_display_start_day FROM dual;
5252: END;
5253:
5247: SELECT next_day(p_display_start_date,decode(l_global_week_start_day,1,'SUNDAY',2,'MONDAY',3,'TUESDAY',4,'WEDNESDAY',5,'THURSDAY',6,'FRIDAY',7,'SATURDAY'))-7
5248: INTO l_actual_display_start_date
5249: FROM dual;*/
5250: /*Added the below code for bug 3648827*/
5251: SELECT to_char(p_display_start_date,'D') INTO l_display_start_day FROM dual;
5252: END;
5253:
5254: /*Added the code for the bug 3648827*/
5255: /* Changed l_global_week_start_day to l_global_week_start_day_new for Bug 5622389*/
5381: */
5382:
5383: SELECT MOD(l_where_to_place_counter,10)
5384: INTO l_counter_mod
5385: FROM dual;
5386:
5387: IF (l_counter_mod = 0 ) THEN
5388:
5389: FOR j in 1 .. 2 LOOP