APPS.GL_MOVEMERGE_REQUESTS_PKG SQL Statements

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

Line: 26

      SELECT gl_movemerge_requests_s.NEXTVAL
      FROM dual;

Line: 58

      SELECT 1
      FROM DUAL
      WHERE EXISTS (SELECT 1
                    FROM gl_movemerge_accounts
                    WHERE movemerge_request_id = mm_id);

Line: 83

  PROCEDURE delete_all_accounts (mm_id IN NUMBER) IS
  BEGIN
    DELETE FROM gl_movemerge_accounts
    WHERE movemerge_request_id = mm_id;

Line: 94

          'gl_movemerge_requests_pkg.delete_all_accounts');

Line: 96

  END delete_all_accounts;

Line: 105

     SELECT 1
     FROM DUAL
     WHERE EXISTS (SELECT 1
                   FROM  gl_movemerge_requests
                   WHERE name = X_name
		   AND   chart_of_accounts_id = X_coaid);

Line: 113

     SELECT 1
     FROM DUAL
     WHERE EXISTS (SELECT 1
                   FROM  gl_movemerge_requests r1, gl_movemerge_requests r2
                   WHERE r1.name = X_name
		   AND   r1.chart_of_accounts_id = X_coaid
		   AND   r1.rowid <> X_rowid
		   AND   r2.rowid = X_rowid
		   AND   nvl(r1.original_movemerge_request_id, -1)
                           <> nvl(r2.original_movemerge_request_id, -1)
                   AND   nvl(r1.ledger_id,-1) <> nvl(r2.ledger_id,-1));

Line: 158

  PROCEDURE pre_insert(X_rowid VARCHAR2,
		       X_coaid NUMBER,
                       X_name VARCHAR2) IS
  BEGIN
    check_unique_name(X_rowid, X_coaid, X_name);

Line: 163

  END pre_insert;

Line: 202

           SELECT rel.target_ledger_name
           FROM gl_ledgers lgr, gl_ledger_relationships rel, gl_ledgers alc
           WHERE lgr.ledger_id = ledgerid
           AND rel.source_ledger_id = lgr.ledger_id
           AND rel.target_ledger_category_code = 'ALC'
           AND  rel.relationship_type_code <> 'BALANCE'
           AND  rel.application_id = 101
           AND  alc.ledger_id = rel.target_ledger_id
           AND  nvl(alc.latest_opened_period_name,'X') <> nvl(lgr.latest_opened_period_name,'X')
           ORDER BY target_ledger_name;

Line: 240

           SELECT  object_type_code
           FROM    gl_ledgers led
           WHERE   led.ledger_id = ledgerid;

Line: 245

           SELECT ledger_id
           FROM gl_ledger_set_assignments
           WHERE ledger_set_id = ledgerid;