DBA Data[Home] [Help]

APPS.IEX_STATUS_RULE_PUB SQL Statements

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

Line: 162

Procedure Update_Status_Rule
	   (p_api_version             IN NUMBER,
            p_init_msg_list           IN VARCHAR2,
            p_commit                  IN VARCHAR2,
            p_status_rule_tbl         IN iex_status_rule_pub.status_rule_tbl_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
    l_api_name                    CONSTANT VARCHAR2(30) := 'Update_Status_Rule';
Line: 182

      SAVEPOINT Update_Status_Rule_PUB;
Line: 212

      IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Update_Status_Rule');
Line: 218

          IEX_STATUS_RULE_PVT.Update_Status_Rule(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_status_rule_rec          => l_status_rule_rec
          , x_dup_status               => x_dup_status
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
          );
Line: 258

              ROLLBACK TO Update_Status_Rule_PUB;
Line: 276

              ROLLBACK TO Update_Status_Rule_PUB;
Line: 294

              ROLLBACK TO Update_Status_Rule_PUB;
Line: 311

END Update_Status_Rule;
Line: 315

Procedure Delete_Status_Rule
           (p_api_version             IN NUMBER,
            p_init_msg_list           IN VARCHAR2,
            p_commit                  IN VARCHAR2,
            p_status_rule_id_tbl             IN iex_status_rule_pub.status_rule_id_TBL_type,
            x_return_status           OUT NOCOPY VARCHAR2,
            x_msg_count               OUT NOCOPY NUMBER,
            x_msg_data                OUT NOCOPY VARCHAR2)

IS

    l_status_rule_id              NUMBER;
Line: 327

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

      SAVEPOINT Delete_Status_Rule_PUB;
Line: 364

      IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Delete_Status_Rule');
Line: 370

         IEX_STATUS_RULE_PVT.Delete_Status_Rule(
              p_api_version              => p_api_version
            , p_init_msg_list            => p_init_msg_list
            , p_commit                   => p_commit
            , p_status_rule_id                  => l_status_rule_id
            , x_return_status            => l_return_status
            , x_msg_count                => l_msg_count
            , x_msg_data                 => l_msg_data
            );
Line: 409

              ROLLBACK TO Delete_Status_Rule_PUB;
Line: 426

              ROLLBACK TO Delete_Status_Rule_PUB;
Line: 443

              ROLLBACK TO Delete_Status_Rule_PUB;
Line: 460

END Delete_Status_Rule;
Line: 584

Procedure Update_Status_Rule_Line
            ( p_api_version             IN NUMBER,
              p_init_msg_list           IN VARCHAR2,
              p_commit                  IN VARCHAR2,
              p_status_rule_line_TBL      IN iex_status_rule_pub.status_rule_line_tbl_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
    l_api_name                  CONSTANT VARCHAR2(30) := 'Update_Status_Rule_Line';
Line: 605

      SAVEPOINT Update_Status_Rule_Line_PUB;
Line: 634

      IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Update_Status_Rule_Line');
Line: 640

          IEX_STATUS_RULE_PVT.Update_Status_Rule_Line(
            p_api_version              => p_api_version
          , p_init_msg_list            => FND_API.G_FALSE
          , p_commit                   => p_commit
          , p_status_rule_line_rec       => l_status_rule_line_rec
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
          );
Line: 678

              ROLLBACK To Update_Status_Rule_Line_PUB;
Line: 686

              ROLLBACK TO Update_Status_Rule_Line_PUB;
Line: 694

              ROLLBACK TO Update_Status_Rule_Line_PUB;
Line: 701

END Update_Status_Rule_Line;
Line: 705

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_TBL IN iex_status_rule_pub.status_rule_line_ID_TBL_type,
              x_return_status           OUT NOCOPY VARCHAR2,
              x_msg_count               OUT NOCOPY NUMBER,
              x_msg_data                OUT NOCOPY VARCHAR2)

IS
    l_api_name                    CONSTANT VARCHAR2(30) := 'Delete_Status_Rule_Line';
Line: 725

      SAVEPOINT Delete_Status_Rule_Line_PUB;
Line: 754

      IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Delete_Status_Rule_Line');
Line: 760

          IEX_STATUS_RULE_PVT.Delete_Status_Rule_Line(
            p_api_version              => p_api_version
          , p_init_msg_list            => FND_API.G_FALSE
          , p_commit                   => p_commit
          , p_status_rule_id           => p_status_rule_id
          , p_status_rule_line_id        => l_status_rule_line_id
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
          );
Line: 797

              ROLLBACK To Delete_Status_Rule_Line_PUB;
Line: 805

              ROLLBACK TO Delete_Status_Rule_Line_PUB;
Line: 813

              ROLLBACK TO Delete_Status_Rule_Line_PUB;
Line: 820

END Delete_Status_Rule_Line;