The following lines contain the word 'select', 'insert', 'update' or 'delete':
PA_TIMELINE_TIME_SCALE_PKG.delete_row( x_return_status,
x_msg_count,
x_msg_data);
PA_TIMELINE_TIME_SCALE_PKG.insert_row(TmpTimeScaleTabTyp,
x_return_status,
x_msg_count,
x_msg_data
);
/* ( SELECT DECODE(exp_cycle_start_day_code,1,8,exp_cycle_start_day_code) -1
INTO x_week_ending_day_index
FROM pa_implementations_all
WHERE NVL(org_id,-99) = NVL(p_org_id,-99);
SELECT TO_CHAR(TO_DATE('01-01-1950','DD-MM-YYYY') + NVL(x_week_ending_day_index,0)-1,'Day')
INTO x_week_ending_day
FROM sys.dual;
SELECT NEXT_DAY(p_given_date-1,x_week_ending_day)
INTO x_week_ending
FROM sys.dual;
SELECT TO_CHAR(TO_DATE('01-01-1950','DD-MM-YYYY') + NVL(x_week_ending_day_index,0)-1,'Day')
INTO x_week_ending_day
FROM sys.dual;
SELECT NEXT_DAY(p_given_date -1,x_week_ending_day)
INTO x_week_ending
FROM sys.dual;
x_WeekDatesRangeTab.delete; -- Delete the table contents so that the Unexp. state wrong data cant be used further
SELECT color_pattern_code
INTO lv_color_pattern
FROM pa_timeline_colors
WHERE lookup_code = p_lookup_code
AND lookup_type = l_lookup_type;