APPS.PA_PERIODS_PKG SQL Statements

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

Line: 22

    SELECT
            period_name
    ,       start_date
    ,       end_date
    ,       gl_period_name
      FROM
            pa_periods_copy_v;

Line: 32

      x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';

Line: 34

      SELECT set_of_books_id, period_set_name
        INTO X_sob_id , l_imp_period_set_name
        FROM pa_implementations;

Line: 45

        x_stage := 'INSERT INTO PA_PERIODS';

Line: 46

        INSERT INTO pa_periods (
           period_name
        ,  last_update_date
        ,  last_updated_by
        ,  creation_date
        ,  created_by
        ,  last_update_login
        ,  start_date
        ,  end_date
        ,  status
        ,  gl_period_name
        ,  current_pa_period_flag
        ,  org_id ) -- 12i MOAC changes
        VALUES (
           xperiod.period_name
        ,  TRUNC(sysdate)
        ,  X_user_id
        ,  TRUNC(sysdate)
        ,  X_user_id
        ,  X_login_id
        ,  xperiod.start_date
        ,  xperiod.end_date
        ,  'N'    /* Never Opened */
        ,  xperiod.gl_period_name
        ,  NULL
        ,  l_org_id ); -- 12i MOAC changes

Line: 73

        x_stage := 'INSERT INTO GL_PERIOD_STATUSES';

Line: 74

        gl_period_statuses_pkg.insert_ps_api(
           275
        ,  X_sob_id
        ,  xperiod.period_name
        ,  'O'
        --Bug 3065754
        --,  NULL
        ,  l_imp_period_set_name
        ,  X_user_id
        ,  X_login_id );

Line: 85

/* Bug 2579245: Inserting record in gl_period_statuses*/
/*	gl_period_statuses_pkg.insert_ps_api(
           275
        ,  X_sob_id
        ,  xperiod.gl_period_name
        ,  'O'
        ,  NULL
        ,  X_user_id
        ,  X_login_id );  Bug# 3271356:reverting fix of 2579245*/

Line: 128

    SELECT
            period_name
    ,       start_date
    ,       end_date
    ,       closing_status
      FROM
            gl_period_statuses gps
      WHERE gps.application_id = 8721
      and   gps.adjustment_period_flag = 'N'
      and   gps.set_of_books_id = p_sob_id
      and   not exists (
            SELECT NULL
            FROM PA_PERIODS pp
            WHERE PP.PERIOD_NAME = GPS.PERIOD_NAME );

Line: 145

      x_stage := 'SELECT FROM PA_IMPLEMENTATIONS';

Line: 146

      SELECT set_of_books_id
        INTO X_sob_id
        FROM pa_implementations;

Line: 157

        x_stage := 'INSERT INTO PA_PERIODS';

Line: 158

        INSERT INTO pa_periods (
           period_name
        ,  last_update_date
        ,  last_updated_by
        ,  creation_date
        ,  created_by
        ,  last_update_login
        ,  start_date
        ,  end_date
        ,  status
        ,  gl_period_name
        ,  current_pa_period_flag
        ,  org_id) -- 12i MOAC changes
        VALUES (
           xperiod.period_name
        ,  TRUNC(sysdate)
        ,  X_user_id
        ,  TRUNC(sysdate)
        ,  X_user_id
        ,  X_login_id
        ,  xperiod.start_date
        ,  xperiod.end_date
        ,  xperiod.closing_status
        ,  xperiod.period_name
        ,  NULL
        ,  l_org_id); -- 12i MOAC changes

Line: 187

/*	x_stage := 'UPDATE GL_PERIOD_STATUSES';

Line: 188

	UPDATE gl_period_statuses
	SET    closing_status = 'O'
	WHERE  application_id = 8721
	AND    set_of_books_id = X_sob_id
	AND    period_name = xperiod.period_name;  Commented for Bug 3271356*/

Line: 231

   SELECT  period_name
         FROM  PA_PERIODS_ALL prd,
               PA_IMPLEMENTATIONS_ALL imp,
               GL_SETS_OF_BOOKS sob
        WHERE  (period_name = p_period_name
           OR  gl_period_name = p_period_name)
          AND  prd.org_id  = imp.org_id           /* Removed the NVL check for bug 6811046*/
          AND  imp.set_of_books_id = sob.set_of_books_id
          AND  sob.period_set_name = p_period_set_name
          AND  rownum =1;

Line: 251

      SELECT  COUNT(*)
        into  l_rec_count
         FROM  PA_PERIODS_ALL prd,
               PA_IMPLEMENTATIONS_ALL imp
        WHERE ( period_name = p_period_name
          OR  gl_period_name =p_period_name)
          AND  prd.org_id  = imp.org_id           /* Removed the NVL check for bug 6811046*/
          AND period_set_name = p_period_set_name --added this condition for the bug 4119508
          AND rownum =1;

Line: 271

     SELECT COUNT(*)
       INTO l_rec_count
       FROM pa_time_cal_name cal,  /* Modified for bug 12979524 */
            pji_time_cal_period prd
      WHERE cal.period_set_name = p_period_set_name
        AND prd.name = p_period_name
        AND prd.calendar_id = cal.calendar_id
        AND ROWNUM =1;