APPS.OZF_REASON_PVT SQL Statements

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

Line: 115

      OZF_reason_codes_All_PKG.Insert_Row(
          px_REASON_CODE_ID  => l_REASON_CODE_ID,
          px_OBJECT_VERSION_NUMBER  => l_object_version_number,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_REASON_CODE  => p_reason_rec.REASON_CODE,
          p_START_DATE_ACTIVE  => p_reason_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE  => p_reason_rec.END_DATE_ACTIVE,
          p_ATTRIBUTE_CATEGORY  => p_reason_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => p_reason_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => p_reason_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => p_reason_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => p_reason_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => p_reason_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => p_reason_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => p_reason_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => p_reason_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => p_reason_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => p_reason_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => p_reason_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => p_reason_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => p_reason_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => p_reason_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => p_reason_rec.ATTRIBUTE15,
          p_NAME         => p_reason_rec.NAME,
          p_DESCRIPTION  => p_reason_rec.DESCRIPTION,
          px_ORG_ID      => l_org_id,
          p_REASON_TYPE  => p_reason_rec.REASON_TYPE,
          p_ADJUSTMENT_REASON_CODE  => p_reason_rec.ADJUSTMENT_REASON_CODE,
	  p_INVOICING_REASON_CODE  => p_reason_rec.INVOICING_REASON_CODE,
          px_ORDER_TYPE_ID     => p_reason_rec.ORDER_TYPE_ID,
          p_PARTNER_ACCESS_FLAG     => p_reason_rec.PARTNER_ACCESS_FLAG
	  );

Line: 211

PROCEDURE Update_reason(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,

    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2,

    P_reason_Rec     IN    reason_Rec_Type,
    X_Object_Version_Number      OUT NOCOPY  NUMBER
    )

 IS

Cursor C_Get_reason(l_REASON_CODE_ID Number) IS
    SELECT REASON_CODE_ID,
           OBJECT_VERSION_NUMBER,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           REASON_CODE,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE,
           ATTRIBUTE_CATEGORY,
           ATTRIBUTE1,
           ATTRIBUTE2,
           ATTRIBUTE3,
           ATTRIBUTE4,
           ATTRIBUTE5,
           ATTRIBUTE6,
           ATTRIBUTE7,
           ATTRIBUTE8,
           ATTRIBUTE9,
           ATTRIBUTE10,
           ATTRIBUTE11,
           ATTRIBUTE12,
           ATTRIBUTE13,
           ATTRIBUTE14,
           ATTRIBUTE15,
           NAME,
           DESCRIPTION,
           ORG_ID,
           REASON_TYPE,
           ADJUSTMENT_REASON_CODE,
	   INVOICING_REASON_CODE,
           ORDER_TYPE_ID,
	   PARTNER_ACCESS_FLAG
    FROM  ozf_reason_codes_ALL_VL
    WHERE REASON_CODE_ID = l_REASON_CODE_ID;

Line: 265

l_api_name                CONSTANT VARCHAR2(30) := 'Update_reason';

Line: 277

      SAVEPOINT UPDATE_Reason_PVT;

Line: 305

         OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 312

               l_ref_reason_rec.LAST_UPDATE_DATE,
               l_ref_reason_rec.LAST_UPDATED_BY,
               l_ref_reason_rec.CREATION_DATE,
               l_ref_reason_rec.CREATED_BY,
               l_ref_reason_rec.LAST_UPDATE_LOGIN,
               l_ref_reason_rec.REASON_CODE,
               l_ref_reason_rec.START_DATE_ACTIVE,
               l_ref_reason_rec.END_DATE_ACTIVE,
               l_ref_reason_rec.ATTRIBUTE_CATEGORY,
               l_ref_reason_rec.ATTRIBUTE1,
               l_ref_reason_rec.ATTRIBUTE2,
               l_ref_reason_rec.ATTRIBUTE3,
               l_ref_reason_rec.ATTRIBUTE4,
               l_ref_reason_rec.ATTRIBUTE5,
               l_ref_reason_rec.ATTRIBUTE6,
               l_ref_reason_rec.ATTRIBUTE7,
               l_ref_reason_rec.ATTRIBUTE8,
               l_ref_reason_rec.ATTRIBUTE9,
               l_ref_reason_rec.ATTRIBUTE10,
               l_ref_reason_rec.ATTRIBUTE11,
               l_ref_reason_rec.ATTRIBUTE12,
               l_ref_reason_rec.ATTRIBUTE13,
               l_ref_reason_rec.ATTRIBUTE14,
               l_ref_reason_rec.ATTRIBUTE15,
               l_ref_reason_rec.NAME,
               l_ref_reason_rec.DESCRIPTION,
               l_ref_reason_rec.ORG_ID,
               l_ref_reason_rec.REASON_TYPE,
               l_ref_reason_rec.ADJUSTMENT_REASON_CODE,
	       l_ref_reason_rec.INVOICING_REASON_CODE,
               l_ref_reason_rec.ORDER_TYPE_ID,
	       l_ref_reason_rec.PARTNER_ACCESS_FLAG;

Line: 423

         OZF_UTILITY_PVT.debug_message('Private API:Calling update table handler');

Line: 429

      OZF_reason_codes_All_PKG.Update_Row(
          p_REASON_CODE_ID  => l_reason_rec.REASON_CODE_ID,
          p_OBJECT_VERSION_NUMBER  => l_object_version_number,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_REASON_CODE  => l_reason_rec.REASON_CODE,
          p_START_DATE_ACTIVE  => l_reason_rec.START_DATE_ACTIVE,
          p_END_DATE_ACTIVE  => l_reason_rec.END_DATE_ACTIVE,
          p_ATTRIBUTE_CATEGORY  => l_reason_rec.ATTRIBUTE_CATEGORY,
          p_ATTRIBUTE1  => l_reason_rec.ATTRIBUTE1,
          p_ATTRIBUTE2  => l_reason_rec.ATTRIBUTE2,
          p_ATTRIBUTE3  => l_reason_rec.ATTRIBUTE3,
          p_ATTRIBUTE4  => l_reason_rec.ATTRIBUTE4,
          p_ATTRIBUTE5  => l_reason_rec.ATTRIBUTE5,
          p_ATTRIBUTE6  => l_reason_rec.ATTRIBUTE6,
          p_ATTRIBUTE7  => l_reason_rec.ATTRIBUTE7,
          p_ATTRIBUTE8  => l_reason_rec.ATTRIBUTE8,
          p_ATTRIBUTE9  => l_reason_rec.ATTRIBUTE9,
          p_ATTRIBUTE10  => l_reason_rec.ATTRIBUTE10,
          p_ATTRIBUTE11  => l_reason_rec.ATTRIBUTE11,
          p_ATTRIBUTE12  => l_reason_rec.ATTRIBUTE12,
          p_ATTRIBUTE13  => l_reason_rec.ATTRIBUTE13,
          p_ATTRIBUTE14  => l_reason_rec.ATTRIBUTE14,
          p_ATTRIBUTE15  => l_reason_rec.ATTRIBUTE15,
          p_NAME  => l_reason_rec.NAME,
          p_DESCRIPTION  => l_reason_rec.DESCRIPTION,
          p_ORG_ID  => l_reason_rec.ORG_ID,
          p_REASON_TYPE  => l_reason_rec.REASON_TYPE,
          p_ADJUSTMENT_REASON_CODE  => l_reason_rec.ADJUSTMENT_REASON_CODE,
	  p_INVOICING_REASON_CODE  => l_reason_rec.INVOICING_REASON_CODE,
          p_ORDER_TYPE_ID  => l_reason_rec.ORDER_TYPE_ID,
          p_PARTNER_ACCESS_FLAG  => l_reason_rec.PARTNER_ACCESS_FLAG
	  );

Line: 487

    ROLLBACK TO UPDATE_Reason_PVT;

Line: 496

    ROLLBACK TO UPDATE_Reason_PVT;

Line: 505

    ROLLBACK TO UPDATE_Reason_PVT;

Line: 517

End Update_reason;

Line: 520

PROCEDURE Delete_reason(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2,
    P_REASON_CODE_ID  IN  NUMBER,
    P_Object_Version_Number      IN   NUMBER
    )
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_reason';

Line: 538

select reason_code_id
from   ozf_claims_all
where  reason_code_id = p_id;

Line: 544

      SAVEPOINT DELETE_Reason_PVT;

Line: 575

         OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 591

      OZF_reason_codes_All_PKG.Delete_Row(
          p_REASON_CODE_ID  => p_REASON_CODE_ID);

Line: 616

    ROLLBACK TO DELETE_Reason_PVT;

Line: 625

    ROLLBACK TO DELETE_Reason_PVT;

Line: 634

    ROLLBACK TO DELETE_Reason_PVT;

Line: 646

End Delete_reason;

Line: 675

PROCEDURE Update_actions(
    P_Api_Version_Number         IN  NUMBER,
    P_Init_Msg_List              IN  VARCHAR2   := FND_API.G_FALSE,
    P_Commit                     IN  VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN  NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    P_action_Tbl                 IN  action_Tbl_Type
)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_actions';

Line: 698

CURSOR C2 IS SELECT OZF_REASONS_S.nextval FROM sys.dual;

Line: 701

IS    SELECT COUNT(REASON_TYPE_ID)
      FROM OZF_REASONS
      WHERE REASON_TYPE_ID = l_reason_type_id;

Line: 707

 SELECT object_version_number
 ,      task_template_group_id
 ,      active_flag
 ,      default_flag
 FROM   ozf_reasons
 WHERE  reason_type_id = p_id;

Line: 717

      SAVEPOINT UPDATE_Actions_PVT;

Line: 792

            INSERT INTO ozf_reasons (
              REASON_TYPE_ID,
              OBJECT_VERSION_NUMBER,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_LOGIN,
              REASON_CODE_ID,
	      TASK_TEMPLATE_GROUP_ID,
	      ACTIVE_FLAG,
         DEFAULT_FLAG
            ) VALUES (
	      l_reason_type_id,
	      l_object_version_number,
	      SYSDATE,
	      FND_GLOBAL.USER_ID,
	      SYSDATE,
              FND_GLOBAL.USER_ID,
              FND_GLOBAL.CONC_LOGIN_ID,
              p_action_tbl(i).reason_code_id,
              l_task_template_group_id,
              l_active_flag,
              l_default_flag
            );

Line: 821

                 FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_INSERT_ERROR');

Line: 855

              UPDATE ozf_reasons
	           SET OBJECT_VERSION_NUMBER = l_object_version_number
              ,   LAST_UPDATE_DATE      = SYSDATE
              ,   LAST_UPDATED_BY       = FND_GLOBAL.USER_ID
              ,   LAST_UPDATE_LOGIN     = FND_GLOBAL.CONC_LOGIN_ID
              ,   REASON_CODE_ID        = p_action_tbl(i).reason_code_id
              ,   TASK_TEMPLATE_GROUP_ID= p_action_tbl(i).task_template_group_id
	           ,   ACTIVE_FLAG           = p_action_tbl(i).active_flag
              ,   default_flag        = p_action_tbl(i).default_flag
	      WHERE  reason_type_id = l_reason_type_id;

Line: 869

                  FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_ACTION_UPDATE_ERROR');

Line: 874

	  END IF; -- end update

Line: 876

	END IF; -- end create and update modes

Line: 901

    ROLLBACK TO UPDATE_Actions_PVT;

Line: 910

    ROLLBACK TO UPDATE_Actions_PVT;

Line: 919

    ROLLBACK TO UPDATE_Actions_PVT;

Line: 931

End Update_Actions;

Line: 961

PROCEDURE Delete_action(
    P_Api_Version_Number         IN  NUMBER,
    P_Init_Msg_List              IN  VARCHAR2   := FND_API.G_FALSE,
    P_Commit                     IN  VARCHAR2   := FND_API.G_FALSE,
    p_validation_level           IN  NUMBER     := FND_API.G_VALID_LEVEL_FULL,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    P_reason_type_id             IN  NUMBER,
    p_object_version_number       IN  NUMBER
)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_action';

Line: 979

      SAVEPOINT DELETE_Action_PVT;

Line: 1010

         OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 1014

      DELETE FROM ozf_reasons
      WHERE  reason_type_id = p_reason_type_id
      AND    object_version_number = p_object_version_number;

Line: 1049

    ROLLBACK TO DELETE_Action_PVT;

Line: 1058

    ROLLBACK TO DELETE_Action_PVT;

Line: 1067

    ROLLBACK TO DELETE_Action_PVT;

Line: 1079

End Delete_action;

Line: 1174

SELECT * FROM ozf_reason_codes_all_b
WHERE reason_code_id = cv_reason_id;

Line: 1204

  IF P_reason_Rec.last_update_login         = FND_API.G_MISS_NUM  THEN
     x_complete_rec.last_update_login       := NULL;

Line: 1207

  IF P_reason_Rec.last_update_login          IS NULL THEN
     x_complete_rec.last_update_login       := l_reason_rec.last_update_login;

Line: 1425

                 p_validation_mode   => JTF_PLSQL_API.g_update,
                 x_return_status     => x_return_status
              );

Line: 1526

      SELECT 1
      FROM oe_transaction_types_vl
      WHERE transaction_type_id = cv_id;