APPS.PA_PAXBAUPD_XMLP_PKG SQL Statements

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

Line: 30

      SELECT
        MEANING
      INTO NDF
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
        AND LOOKUP_TYPE = 'MESSAGE';

Line: 48

        SELECT
          MEANING
        INTO NDF
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';

Line: 66

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 80

  FUNCTION CF_UPDATE_FLAGFORMULA(UPDATE_FLAG IN VARCHAR2) RETURN VARCHAR2 IS
    TMP_YN_FLAG VARCHAR2(80);

Line: 83

    SELECT
      MEANING
    INTO TMP_YN_FLAG
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = UPDATE_FLAG;

Line: 91

  END CF_UPDATE_FLAGFORMULA;

Line: 96

    SELECT
      MEANING
    INTO TMP_YN_FLAG
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = RECALCULATE_FLAG;

Line: 142

  PROCEDURE INSERT_ROW1(X_ROWID IN OUT NOCOPY VARCHAR2
                      ,X_BATCH_ID IN OUT NOCOPY NUMBER
                      ,X_CREATION_DATE IN DATE
                      ,X_CREATED_BY IN NUMBER
                      ,X_LAST_UPDATED_BY IN NUMBER
                      ,X_LAST_UPDATE_DATE IN DATE
                      ,X_LAST_UPDATE_LOGIN IN NUMBER
                      ,X_BATCH_NAME IN VARCHAR2
                      ,X_BATCH_STATUS_CODE IN VARCHAR2
                      ,X_DESCRIPTION IN VARCHAR2
                      ,X_PROJECT_ATTRIBUTE IN VARCHAR2
                      ,X_EFFECTIVE_DATE IN DATE
                      ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
                      ,X_ATTRIBUTE1 IN VARCHAR2
                      ,X_ATTRIBUTE2 IN VARCHAR2
                      ,X_ATTRIBUTE3 IN VARCHAR2
                      ,X_ATTRIBUTE4 IN VARCHAR2
                      ,X_ATTRIBUTE5 IN VARCHAR2
                      ,X_ATTRIBUTE6 IN VARCHAR2
                      ,X_ATTRIBUTE7 IN VARCHAR2
                      ,X_ATTRIBUTE8 IN VARCHAR2
                      ,X_ATTRIBUTE9 IN VARCHAR2
                      ,X_ATTRIBUTE10 IN VARCHAR2
                      ,X_ATTRIBUTE11 IN VARCHAR2
                      ,X_ATTRIBUTE12 IN VARCHAR2
                      ,X_ATTRIBUTE13 IN VARCHAR2
                      ,X_ATTRIBUTE14 IN VARCHAR2
                      ,X_ATTRIBUTE15 IN VARCHAR2) IS
  BEGIN
    begin
        INSERT_ROW(X_ROWID, X_BATCH_ID, X_CREATION_DATE, X_CREATED_BY, X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE,
	X_LAST_UPDATE_LOGIN, X_BATCH_NAME, X_BATCH_STATUS_CODE, X_DESCRIPTION, X_PROJECT_ATTRIBUTE, X_EFFECTIVE_DATE,
	X_ATTRIBUTE_CATEGORY, X_ATTRIBUTE1, X_ATTRIBUTE2, X_ATTRIBUTE3, X_ATTRIBUTE4, X_ATTRIBUTE5, X_ATTRIBUTE6,
	X_ATTRIBUTE7, X_ATTRIBUTE8, X_ATTRIBUTE9, X_ATTRIBUTE10, X_ATTRIBUTE11, X_ATTRIBUTE12, X_ATTRIBUTE13, X_ATTRIBUTE14, X_ATTRIBUTE15);

Line: 178

  END INSERT_ROW;

Line: 180

  PROCEDURE UPDATE_ROW(X_ROWID IN VARCHAR2
                      ,X_LAST_UPDATED_BY IN NUMBER
                      ,X_LAST_UPDATE_DATE IN DATE
                      ,X_LAST_UPDATE_LOGIN IN NUMBER
                      ,X_BATCH_NAME IN VARCHAR2
                      ,X_BATCH_STATUS_CODE IN VARCHAR2
                      ,X_REJECTION_CODE IN VARCHAR2
                      ,X_DESCRIPTION IN VARCHAR2
                      ,X_PROJECT_ATTRIBUTE IN VARCHAR2
                      ,X_EFFECTIVE_DATE IN DATE
                      ,X_PROCESS_RUN_BY IN NUMBER
                      ,X_PROCESS_RUN_DATE IN DATE
                      ,X_ATTRIBUTE_CATEGORY IN VARCHAR2
                      ,X_ATTRIBUTE1 IN VARCHAR2
                      ,X_ATTRIBUTE2 IN VARCHAR2
                      ,X_ATTRIBUTE3 IN VARCHAR2
                      ,X_ATTRIBUTE4 IN VARCHAR2
                      ,X_ATTRIBUTE5 IN VARCHAR2
                      ,X_ATTRIBUTE6 IN VARCHAR2
                      ,X_ATTRIBUTE7 IN VARCHAR2
                      ,X_ATTRIBUTE8 IN VARCHAR2
                      ,X_ATTRIBUTE9 IN VARCHAR2
                      ,X_ATTRIBUTE10 IN VARCHAR2
                      ,X_ATTRIBUTE11 IN VARCHAR2
                      ,X_ATTRIBUTE12 IN VARCHAR2
                      ,X_ATTRIBUTE13 IN VARCHAR2
                      ,X_ATTRIBUTE14 IN VARCHAR2
                      ,X_ATTRIBUTE15 IN VARCHAR2) IS
  BEGIN
    begin
        PA_MU_BATCHES_V_PKG.UPDATE_ROW(X_ROWID, X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE, X_LAST_UPDATE_LOGIN, X_BATCH_NAME,
	X_BATCH_STATUS_CODE, X_REJECTION_CODE, X_DESCRIPTION, X_PROJECT_ATTRIBUTE, X_EFFECTIVE_DATE, X_PROCESS_RUN_BY,
	X_PROCESS_RUN_DATE, X_ATTRIBUTE_CATEGORY, X_ATTRIBUTE1, X_ATTRIBUTE2, X_ATTRIBUTE3, X_ATTRIBUTE4, X_ATTRIBUTE5,
	X_ATTRIBUTE6, X_ATTRIBUTE7, X_ATTRIBUTE8, X_ATTRIBUTE9, X_ATTRIBUTE10, X_ATTRIBUTE11, X_ATTRIBUTE12, X_ATTRIBUTE13,
	X_ATTRIBUTE14, X_ATTRIBUTE15);

Line: 216

  END UPDATE_ROW;

Line: 252

  PROCEDURE DELETE_ROW(X_ROWID IN VARCHAR2) IS
  BEGIN
    begin
        PA_MU_BATCHES_V_PKG.DELETE_ROW(X_ROWID);

Line: 257

  END DELETE_ROW;