DBA Data[Home] [Help]

APPS.IEX_STATUS_RULE_PVT SQL Statements

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

Line: 61

    SELECT status_rule_Name
      FROM iex_cust_status_rules
     WHERE STATUS_RULE_Name = IN_STATUS_RULE_Name;
Line: 123

    SELECT status_rule_Name
      FROM iex_cust_status_rules
     WHERE STATUS_RULE_Name = IN_STATUS_RULE_Name and status_rule_id <> IN_Status_Rule_ID;
Line: 187

          SELECT iex_cust_status_rules_s.nextval
            FROM sys.dual;
Line: 266

      IEX_STATUS_RULE_PKG.insert_row(
          x_rowid                          => l_rowid
        , p_status_rule_id                 => x_status_rule_id
        , p_status_rule_name                     => l_status_rule_rec.status_rule_name
        , p_status_rule_description              => l_status_rule_rec.status_rule_description
        , p_start_date                  => l_status_rule_rec.start_date
        , p_end_date                    => l_status_rule_rec.end_date
--        , p_jtf_object_code             => l_status_rule_rec.jtf_object_code
        , 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.USER_ID
		, p_object_version_number          => 1.0
		);
Line: 337

Procedure Update_Status_Rule(p_api_version             IN NUMBER,
                       p_init_msg_list           IN VARCHAR2,
                       p_commit                  IN VARCHAR2,
                       P_STATUS_RULE_REC               IN  IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE,
                       x_dup_status              OUT NOCOPY VARCHAR2,
                       x_return_status           OUT NOCOPY VARCHAR2,
                       x_msg_count               OUT NOCOPY NUMBER,
                       x_msg_data                OUT NOCOPY VARCHAR2)

IS
    CURSOR C_get_Status_Rule_Rec (IN_STATUS_RULE_ID NUMBER) is
       SELECT  ROWID,
               STATUS_RULE_ID,
               STATUS_RULE_NAME,
               STATUS_RULE_DESCRIPTION,
               START_DATE,
               END_DATE,
--               JTF_OBJECT_CODE,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               CREATION_DATE,
               CREATED_BY ,
               LAST_UPDATE_LOGIN,
			   OBJECT_VERSION_NUMBER
         from iex_cust_status_rules
        where status_rule_id = in_status_rule_id
        FOR UPDATE NOWAIT;
Line: 365

    l_api_name                    CONSTANT VARCHAR2(30) := 'Update_Status_Rule';
Line: 379

      SAVEPOINT UPDATE_STATUS_RULE_PVT;
Line: 415

         l_status_rule_ref_rec.LAST_UPDATE_DATE,
         l_status_rule_ref_rec.LAST_UPDATED_BY,
         l_status_rule_ref_rec.CREATION_DATE,
         l_status_rule_ref_rec.CREATED_BY,
         l_status_rule_ref_rec.LAST_UPDATE_LOGIN,
		 l_status_rule_ref_rec.OBJECT_VERSION_NUMBER;
Line: 425

            FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
Line: 436

      IF (l_status_rule_rec.last_update_date is NULL)
      THEN
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
Line: 441

              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
Line: 470

      IEX_STATUS_RULE_PKG.update_row(
          x_rowid                          => l_rowid
        , p_status_rule_id                       => l_status_rule_rec.status_rule_id
        , p_status_rule_name                     => l_status_rule_rec.status_rule_name
        , p_status_rule_description              => l_status_rule_rec.status_rule_description
        , p_start_date                  => l_status_rule_rec.start_date
        , p_end_date                    => l_status_rule_rec.end_date
--        , p_jtf_object_code             => l_status_rule_rec.jtf_object_code
        , p_last_update_date               => sysdate
        , p_last_updated_by                => FND_GLOBAL.USER_ID
        , p_creation_date                  => l_status_rule_rec.creation_date
        , p_created_by                     => l_status_rule_rec.created_by
        , p_last_update_login              => FND_GLOBAL.USER_ID
		, p_object_version_number          => l_status_rule_rec.object_version_number);
Line: 509

              ROLLBACK TO UPDATE_STATUS_RULE_PVT;
Line: 517

              ROLLBACK TO UPDATE_STATUS_RULE_PVT;
Line: 525

              ROLLBACK TO UPDATE_STATUS_RULE_PVT;
Line: 532

END Update_Status_Rule;
Line: 536

Procedure Delete_Status_Rule(p_api_version       IN NUMBER,
                       p_init_msg_list           IN VARCHAR2,
                       p_commit                  IN VARCHAR2,
                       P_STATUS_RULE_ID          IN NUMBER,
                       x_return_status           OUT NOCOPY VARCHAR2,
                       x_msg_count               OUT NOCOPY NUMBER,
                       x_msg_data                OUT NOCOPY VARCHAR2)

IS
    CURSOR C_GET_STATUS_RULE (IN_STATUS_RULE_ID NUMBER) IS
      SELECT rowid
        FROM IEX_CUST_STATUS_RULES
       WHERE STATUS_RULE_ID = IN_STATUS_RULE_ID;
Line: 551

	 SELECT Status_Rule_line_ID
         FROM iex_cu_sts_rl_lines
        WHERE STATUS_RULE_ID = IN_STATUS_RULE_ID;
Line: 556

    l_api_name              CONSTANT VARCHAR2(30) := 'Delete_Status_Rule';
Line: 566

      SAVEPOINT DELETE_STATUS_RULE_PVT;
Line: 598

            FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
Line: 608

      IEX_STATUS_RULE_PKG.Delete_Row(
             x_rowid  => l_rowid);
Line: 634

              ROLLBACK TO DELETE_STATUS_RULE_PVT;
Line: 642

              ROLLBACK TO DELETE_STATUS_RULE_PVT;
Line: 650

              ROLLBACK TO DELETE_STATUS_RULE_PVT;
Line: 657

END Delete_Status_Rule;
Line: 671

          SELECT iex_cu_sts_rl_lines_s.nextval
            FROM sys.dual;
Line: 721

      IEX_status_rule_line_PKG.insert_row(
          x_rowid                         => l_rowid
        , p_status_rule_line_id             => x_status_rule_line_id
        , p_delinquency_status            => l_status_rule_line_rec.delinquency_status
        , p_priority                      => l_status_rule_line_rec.priority
	   , p_enabled_flag                  => l_status_rule_line_rec.enabled_flag
        , p_status_rule_id                => l_status_rule_line_rec.status_rule_id
        , 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.USER_ID
		, p_object_version_number         => 1.0);
Line: 786

Procedure Update_status_rule_line(p_api_version             IN NUMBER,
                                p_init_msg_list           IN VARCHAR2,
                                p_commit                  IN VARCHAR2,
                                p_status_rule_line_Rec      IN IEX_STATUS_RULE_PUB.status_rule_line_REC_Type,
                                x_return_status           OUT NOCOPY VARCHAR2,
                                x_msg_count               OUT NOCOPY NUMBER,
                                x_msg_data                OUT NOCOPY VARCHAR2)

IS
    CURSOR C_get_status_rule_line_Rec (IN_status_rule_line_ID NUMBER) is
       select  ROWID,
               status_rule_line_ID,
               delinquency_status,
               priority,
			ENABLED_FLAG,
               Status_Rule_line_ID,
               LAST_UPDATE_DATE,
               LAST_UPDATED_BY,
               CREATION_DATE,
               CREATED_BY ,
               LAST_UPDATE_LOGIN,
			   OBJECT_VERSION_NUMBER
         from iex_cu_sts_rl_lines
        where status_rule_line_id = in_status_rule_line_id
        FOR UPDATE NOWAIT;
Line: 812

    l_api_name                    CONSTANT VARCHAR2(30) := 'Update_status_rule_line';
Line: 825

      SAVEPOINT UPDATE_status_rule_line_PVT;
Line: 859

         l_status_rule_line_ref_rec.LAST_UPDATE_DATE,
         l_status_rule_line_ref_rec.LAST_UPDATED_BY,
         l_status_rule_line_ref_rec.CREATION_DATE,
         l_status_rule_line_ref_rec.CREATED_BY,
         l_status_rule_line_ref_rec.LAST_UPDATE_LOGIN,
		 l_status_rule_line_ref_Rec.OBJECT_VERSION_NUMBER;
Line: 869

            FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
Line: 880

      IF (l_status_rule_line_rec.last_update_date is NULL)
      THEN
          IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
          THEN
              FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
Line: 885

              FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
Line: 909

      iex_status_rule_line_PKG.update_row(
          x_rowid                          => l_rowid
        , p_status_rule_line_id              => l_status_rule_line_rec.status_rule_line_id
        , p_last_update_date               => sysdate
        , p_last_updated_by                => FND_GLOBAL.USER_ID
        , p_creation_date                  => l_status_rule_line_rec.CREATION_DATE
        , p_created_by                     => l_status_rule_line_rec.CREATED_BY
        , p_last_update_login              => FND_GLOBAL.USER_ID
        , p_delinquency_status                      => l_status_rule_line_rec.delinquency_status
        , p_priority                     => l_status_rule_line_rec.priority
        , p_enabled_flag                 => l_status_rule_line_rec.enabled_flag
        , p_status_rule_id                  => l_status_rule_line_rec.status_rule_id
		, p_object_version_number          => l_status_rule_line_rec.object_version_number);
Line: 947

              ROLLBACK To UPDATE_status_rule_line_PVT;
Line: 954

              ROLLBACK To UPDATE_status_rule_line_PVT;
Line: 961

              ROLLBACK To UPDATE_status_rule_line_PVT;
Line: 966

END Update_status_rule_line;
Line: 970

Procedure Delete_status_rule_line(p_api_version             IN NUMBER,
                                p_init_msg_list           IN VARCHAR2,
                                p_commit                  IN VARCHAR2,
                                p_Status_Rule_id          IN NUMBER,
                                p_status_rule_line_id     IN NUMBER,
                                x_return_status           OUT NOCOPY VARCHAR2,
                                x_msg_count               OUT NOCOPY NUMBER,
                                x_msg_data                OUT NOCOPY VARCHAR2)

IS
    CURSOR C_GET_status_rule_line (IN_status_rule_line_ID NUMBER) IS
     SELECT rowid
         FROM iex_cu_sts_rl_lines
        WHERE status_rule_line_ID = IN_status_rule_line_ID;
Line: 986

    l_api_name              CONSTANT VARCHAR2(30) := 'Delete_status_rule_line';
Line: 995

      SAVEPOINT DELETE_status_rule_line_PUB;
Line: 1026

            FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
Line: 1037

      iex_status_rule_line_PKG.Delete_Row(x_rowid  => l_rowid);
Line: 1062

              ROLLBACK To DELETE_status_rule_line_PVT;
Line: 1069

              ROLLBACK To DELETE_status_rule_line_PVT;
Line: 1076

              ROLLBACK To DELETE_status_rule_line_PVT;
Line: 1081

END Delete_status_rule_line;