APPS.GLXJEENT_PKG SQL Statements

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

Line: 49

    gl_je_sources_pkg.select_columns(default_je_source,
				     user_default_je_source,
				     effective_date_rule_code,
				     frozen_source_flag,
				     journal_approval_flag);

Line: 61

        gl_period_statuses_pkg.select_columns(
	  101,
	  default_ledger_id,
          default_period_name,
	  period_status,
	  default_start_date,
	  default_end_date,
	  default_period_num,
	  default_period_year);

Line: 85

      gl_je_categories_pkg.select_columns(default_je_category,
				          user_default_je_category);

Line: 102

            gl_period_statuses_pkg.select_columns(
              x_application_id => 101,
              x_ledger_id => default_ledger_id,
              x_period_name => default_reversal_period,
              x_closing_status => period_status,
              x_start_date => default_reversal_start_date,
              x_end_date => default_reversal_end_date,
              x_period_num => period_num,
              x_period_year => period_year);

Line: 136

    gl_daily_conv_types_pkg.select_columns(
      default_conversion_type,
      user_default_conversion_type);

Line: 141

    gl_daily_conv_types_pkg.select_columns(
      'EMU FIXED',
      user_fixed_conversion_type);

Line: 167

    SELECT period_set_name, accounted_period_type
    INTO   acct_cal_name, acc_period_type
    FROM   gl_ledgers
    WHERE  ledger_id = x_lgr_id;

Line: 172

    SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date
    INTO   x_period_name, x_period_status, x_start_date, x_end_date
    FROM   gl_date_period_map map, gl_period_statuses ps
    WHERE  map.period_set_name = acct_cal_name
    AND    map.period_type = acc_period_type
    AND    map.accounting_date = x_accounting_date
    AND    ps.application_id = 101
    AND    ps.ledger_id = x_lgr_id
    AND    ps.period_name = map.period_name;

Line: 191

        SELECT 1
        INTO dummy
        FROM gl_period_statuses ps1
        WHERE ps1.application_id = 101
        AND   ps1.ledger_id = x_arg_id
        AND   ps1.period_name = x_period_name
        AND EXISTS
          (SELECT 'later open'
           FROM gl_period_statuses ps2
           WHERE ps2.application_id = 101
           AND   ps2.ledger_id = ps1.ledger_id
           AND   ps2.effective_period_num > ps1.effective_period_num
           AND   ps2.closing_status IN ('O', 'C', 'P'));

Line: 212

      SELECT 1
      INTO dummy
      FROM dual
      WHERE EXISTS
      (SELECT 'not latest'
       FROM gl_period_statuses ps1, gl_period_statuses ps2
       WHERE ps1.application_id = 101
       AND   ps1.ledger_id IN (SELECT ledger_id
                               FROM gl_je_headers
                               WHERE je_batch_id = x_arg_id)
       AND   ps1.period_name = x_period_name
       AND   ps2.application_id = 101
       AND   ps2.ledger_id = ps1.ledger_id
       AND   ps2.effective_period_num > ps1.effective_period_num
       AND   ps2.closing_status IN ('O', 'C', 'P'));

Line: 243

    SELECT 'default good'
    INTO dummy
    FROM  gl_ledgers lgr, gl_period_statuses ps, gl_access_set_ledgers acc
    WHERE lgr.ledger_id = x_ledger_id
    AND   (   (x_average_journal_flag = 'N')
           OR (lgr.consolidation_ledger_flag = 'Y'))
    AND   ps.application_id = 101
    AND   ps.ledger_id = lgr.ledger_id
    AND   ps.period_name = x_period_name
    AND   ps.closing_status IN ('O', 'F')
    AND   acc.access_set_id = x_access_set_id
    AND   acc.ledger_id = lgr.ledger_id
    AND   acc.access_privilege_code IN ('B', 'F')
    AND   ps.end_date between nvl(acc.start_date, ps.end_date-1)
                      and nvl(acc.end_date, ps.end_date+1);

Line: 275

      SELECT period_name, start_date, end_date, period_year, period_num
      FROM   gl_periods per
      WHERE  period_set_name = x_period_set_name
      AND    period_type = x_period_type
      AND    NOT EXISTS
        (SELECT 'unopened ledger'
         FROM gl_je_headers jeh,
              gl_period_statuses ps
         WHERE jeh.je_batch_id = x_je_batch_id
         AND   (jeh.display_alc_journal_flag IS NULL
                or jeh.display_alc_journal_flag = 'Y')
         AND   ps.application_id = 101
         AND   ps.ledger_id = jeh.ledger_id
         AND   ps.period_name = per.period_name
         AND   ps.closing_status <> 'O')
      ORDER BY period_year * 10000 + period_num DESC;

Line: 293

      SELECT period_name, start_date, end_date, period_year, period_num
      FROM   gl_periods per
      WHERE  period_set_name = x_period_set_name
      AND    period_type = x_period_type
      AND    NOT EXISTS
        (SELECT 'unopened ledger'
         FROM gl_je_headers jeh,
              gl_period_statuses ps
         WHERE jeh.je_batch_id = x_je_batch_id
         AND   (jeh.display_alc_journal_flag IS NULL
                or jeh.display_alc_journal_flag = 'Y')
         AND   ps.application_id = 101
         AND   ps.ledger_id = jeh.ledger_id
         AND   ps.period_name = per.period_name
         AND   ps.closing_status NOT IN ('O', 'F'))
      ORDER BY period_year * 10000 + period_num ASC;