APPS.PA_FP_PERIOD_MASKS_UTILS SQL Statements

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

Line: 36

      SELECT   'Y'
      INTO     l_exists
      FROM     pa_period_masks_tl
      WHERE    UPPER(name) = UPPER(p_name)
      AND      p_period_mask_id <> period_mask_id
      AND      ROWNUM < 2;

Line: 119

     /* SELECT              num_of_periods
      BULK COLLECT INTO   l_num_of_periods
      FROM                pa_fp_period_mask_tmp; */

Line: 205

   SELECT from_anchor_position,num_of_periods FROM
   pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;

Line: 208

   SELECT from_anchor_position,num_of_periods FROM
   pa_fp_period_mask_tmp WHERE from_anchor_position < 0 ORDER BY from_anchor_position;

Line: 231

    DELETE FROM pa_fp_period_mask_tmp;

Line: 233

             PA_DEBUG.g_err_stage := 'Before inserting into temporary table';

Line: 237

        INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
                    VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));

Line: 240

             PA_DEBUG.g_err_stage := 'After inserting into temporary table';

Line: 243

    select count(*) into l_count
    from pa_fp_period_mask_tmp
    where  anchor_period_flag = 'Y';

Line: 247

       update pa_fp_period_mask_tmp set
       anchor_period_flag = 'Y' where
       from_anchor_position = 1;

Line: 251

     SELECT    from_anchor_position,num_of_periods
     INTO      l_from_anchor_position,l_first_no_of_pds
     FROM      pa_fp_period_mask_tmp
     WHERE     anchor_period_flag = 'Y';

Line: 255

     UPDATE  pa_fp_period_mask_tmp
     SET from_anchor_position = from_anchor_position - l_from_anchor_position;

Line: 258

     UPDATE   pa_fp_period_mask_tmp
     SET      from_anchor_start  = 0, from_anchor_end  = num_of_periods  - 1
     WHERE    anchor_period_flag = 'Y';

Line: 270

         UPDATE pa_fp_period_mask_tmp
         SET from_anchor_start  = l_tmp, from_anchor_end  = l_tmp_end
         WHERE from_anchor_position = succ_pd_rec.from_anchor_position;

Line: 288

         UPDATE pa_fp_period_mask_tmp
         SET from_anchor_start = l_tmp, from_anchor_end = l_tmp_end
         WHERE from_anchor_position = prec_pd_rec.from_anchor_position;

Line: 301

             PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';

Line: 304

	INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
         anchor_period_flag,
         from_anchor_start,from_anchor_end,from_anchor_position)
	VALUES (0,'N',-99999,-99999,-99999);

Line: 308

	INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
         anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
	VALUES (0,'N',99999,99999,99999);

Line: 312

             PA_DEBUG.g_err_stage := 'After inserting additional records in the temporary table';

Line: 315

        INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,
                                 num_of_periods,
                                    anchor_period_flag,
                                          from_anchor_start,
                             from_anchor_end,
         from_anchor_position)
      (SELECT p_period_mask_id,
                        trunc(num_of_periods),
                     anchor_period_flag,
                                    from_anchor_start,
                            from_anchor_end,
                     from_anchor_position FROM pa_fp_period_mask_tmp);

Line: 361

FUNCTION IS_DELETE_ALLOWED
   (p_period_mask_id  IN pa_period_masks_b.period_mask_id%TYPE)
   RETURN VARCHAR2 is
  l_count NUMBER := 0;

Line: 368

      select 1
      into l_count
      from dual
      where exists(
      SELECT 1
      FROM  pa_proj_fp_options
      WHERE  cost_period_mask_id = p_period_mask_id);

Line: 386

      select 1
      into l_count
      from dual
      where exists(
      SELECT 1
      FROM  pa_proj_fp_options
      WHERE  rev_period_mask_id = p_period_mask_id);

Line: 404

      select 1
      into l_count
      from dual
      where exists(
      SELECT 1
      FROM  pa_proj_fp_options
      WHERE  all_period_mask_id = p_period_mask_id);

Line: 424

END IS_DELETE_ALLOWED;