APPS.EDR_EINITIALS_PVT SQL Statements

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

Line: 72

  SELECT PSIG_DOCUMENT INTO X_ERECORD_TEXT
  FROM EDR_PSIG_DOCUMENTS
  WHERE DOCUMENT_ID = L_ERECORD_ID;

Line: 106

  SELECT COUNT(*) INTO X_ERECORD_COUNT FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;

Line: 118

  SELECT STATUS INTO L_ERECORD_STATUS FROM EDR_PROCESS_ERECORDS_T WHERE ERES_PROCESS_ID = P_PROCESS_ID;

Line: 133

  SELECT WF_ITEM_TYPE,WF_ITEM_KEY INTO X_ITEMTYPE,X_ITEMKEY
  FROM EDR_PROCESS_ERECORDS_T
  WHERE ERES_PROCESS_ID = P_PROCESS_ID;

Line: 237

  SELECT ORIGINAL_RECIPIENT,
         SIGNATURE_OVERRIDING_COMMENTS
  FROM   EDR_ESIGNATURES
  WHERE  EVENT_ID     = L_EVENT_ID
  AND    SIGNATURE_ID = P_SIGNATURE_ID;

Line: 272

      UPDATE EDR_ESIGNATURES
        SET USER_NAME             = P_SIGNER_NAME,
            SIGNATURE_TYPE        = P_SIGNER_TYPE,
            SIGNATURE_TIMESTAMP   = SYSDATE,
            SIGNATURE_STATUS      = P_SIGNER_RESPONSE,
            SIGNER_COMMENTS       = P_SIGNER_COMMENTS,
            ORIGINAL_RECIPIENT    = P_SIGNER_NAME,
            SIGNATURE_REASON_CODE = P_SIGNING_REASON

        WHERE SIGNATURE_ID        = L_SIGNATURE_ID;

Line: 326

      UPDATE EDR_ESIGNATURES
        SET  SIGNATURE_TYPE        = P_SIGNER_TYPE,
             SIGNATURE_TIMESTAMP   = SYSDATE,
             SIGNATURE_STATUS      = P_SIGNER_RESPONSE,
             SIGNER_COMMENTS       = P_SIGNER_COMMENTS,
             SIGNATURE_REASON_CODE = P_SIGNING_REASON

        WHERE SIGNATURE_ID       = L_SIGNATURE_ID;

Line: 430

                             P_UPDATE_ORES_TEMP_TABLES IN  VARCHAR2,
                             X_ERECORD_STATUS          OUT NOCOPY VARCHAR2)

IS

PRAGMA AUTONOMOUS_TRANSACTION;

Line: 445

  SELECT ERECORD_SIGNATURE_STATUS
  FROM   EDR_ERECORDS
  WHERE  EVENT_ID = L_EVENT_ID;

Line: 473

  IF P_UPDATE_ORES_TEMP_TABLES = FND_API.G_TRUE THEN
    UPDATE EDR_PROCESS_ERECORDS_T
      SET STATUS = X_ERECORD_STATUS
      WHERE ERECORD_ID = L_ERECORD_ID;

Line: 506

                           P_UPDATE_ORES_TEMP_TABLES IN VARCHAR2)
IS

L_ERECORD_ID NUMBER;

Line: 535

  IF P_UPDATE_ORES_TEMP_TABLES = FND_API.G_TRUE THEN
    UPDATE EDR_PROCESS_ERECORDS_T
      SET STATUS = EDR_CONSTANTS_GRP.G_ERROR_STATUS
    WHERE ERECORD_ID = L_ERECORD_ID;

Line: 540

    UPDATE EDR_ERESMANAGER_T
      SET OVERALL_STATUS = EDR_CONSTANTS_GRP.G_ERROR_STATUS
    WHERE ERES_PROCESS_ID IN (SELECT ERES_PROCESS_ID
                              FROM   EDR_PROCESS_ERECORDS_T
                              WHERE  ERECORD_ID = L_ERECORD_ID);