[Home] [Help]
4024: -- Put the monday..sunday hours in the l_hours_db_table table which stores the data base values of the
4025: -- schedule records. Also find out the monday..sunday hours to be passed to change_work_pattern
4026: /* Start of Addition for bug 4068167 */
4027: Begin
4028: 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;
4029: END;
4030: /* End of addition for bug 4068167 */
4031:
4032: IF l_sch_record_tab.COUNT > 0 THEN
4756: /* To incorporate the difference between PA weekday numbers and */
4757: /* session parameter dependent weekday numbers.*/
4758: Select (to_number(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_global_week_start_day - 1)),'D')))
4759: into l_global_week_start_day_new
4760: from dual;
4761: /* Code ends for Bug 5622389 */
4762:
4763: -- Get the next_day-7 for the given date
4764:
4765: BEGIN
4766: /*Commented for the bug 3648827
4767: 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
4768: INTO l_actual_display_start_date
4769: FROM dual;*/
4770: /*Added the below code for bug 3648827*/
4771: SELECT to_char(p_display_start_date,'D') INTO l_display_start_day FROM dual;
4772: END;
4773:
4767: 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
4768: INTO l_actual_display_start_date
4769: FROM dual;*/
4770: /*Added the below code for bug 3648827*/
4771: SELECT to_char(p_display_start_date,'D') INTO l_display_start_day FROM dual;
4772: END;
4773:
4774: /*Added the code for the bug 3648827*/
4775: /* Changed l_global_week_start_day to l_global_week_start_day_new for Bug 5622389*/
4901: */
4902:
4903: SELECT MOD(l_where_to_place_counter,10)
4904: INTO l_counter_mod
4905: FROM dual;
4906:
4907: IF (l_counter_mod = 0 ) THEN
4908:
4909: FOR j in 1 .. 2 LOOP