APPS.PA_TIMELINE_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

	 PA_TIMELINE_TIME_SCALE_PKG.delete_row( x_return_status,
		 x_msg_count,
		 x_msg_data);

Line: 187

		PA_TIMELINE_TIME_SCALE_PKG.insert_row(TmpTimeScaleTabTyp,
																					x_return_status,
																					x_msg_count,
																					x_msg_data
																				 );

Line: 260

       /* ( 	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);

Line: 265

        	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;

Line: 269

        	SELECT NEXT_DAY(p_given_date-1,x_week_ending_day)
          	INTO x_week_ending
          	FROM sys.dual;

Line: 280

        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;

Line: 286

        SELECT NEXT_DAY(p_given_date -1,x_week_ending_day)
        INTO x_week_ending
        FROM sys.dual;

Line: 471

	   x_WeekDatesRangeTab.delete; -- Delete the table contents so that the Unexp. state wrong data cant be used further

Line: 526

    		SELECT color_pattern_code
      		  INTO lv_color_pattern
      		  FROM pa_timeline_colors
      		 WHERE lookup_code = p_lookup_code
           AND lookup_type = l_lookup_type;