eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_SCORE_PUB SQL Statements

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

Line: 152


Procedure Update_Score
	   (p_api_version             IN NUMBER := 1.0,
            p_init_msg_list           IN VARCHAR2 ,
            p_commit                  IN VARCHAR2 ,
            P_SCORE_TBL               IN IEX_SCORE_PUB.SCORE_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_Score';

Line: 173


      SAVEPOINT UPDATE_SCORE_PUB;

Line: 191


      iex_score_pvt.WriteLog('iexpscrb:UpdateScore:Start');

Line: 206


          IEX_SCORE_PVT.Update_Score(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_rec                => l_score_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: 235


      iex_score_pvt.WriteLog('iexpscrb:UpdateScore:End');

Line: 244


              ROLLBACK TO UPDATE_SCORE_PUB;

Line: 252


              ROLLBACK TO UPDATE_SCORE_PUB;

Line: 260


              ROLLBACK TO UPDATE_SCORE_PUB;

Line: 267


END Update_Score;

Line: 271


Procedure Delete_Score
           (p_api_version             IN NUMBER := 1.0,
            p_init_msg_list           IN VARCHAR2 ,
            p_commit                  IN VARCHAR2 ,
            P_SCORE_ID_TBL            IN IEX_SCORE_PUB.SCORE_ID_TBL,
            x_return_status           OUT NOCOPY VARCHAR2,
            x_msg_count               OUT NOCOPY NUMBER,
            x_msg_data                OUT NOCOPY VARCHAR2)

IS

    l_score_id              NUMBER;

Line: 283


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

Line: 291


      SAVEPOINT DELETE_SCORE_PUB;

Line: 309


      iex_score_pvt.WriteLog('iexpscrb:DeleteScore:Start');

Line: 319


      iex_score_pvt.WriteLog('iexpscrb:DeleteScore:scrcnt='||p_score_id_tbl.count);

Line: 323


         iex_score_pvt.WriteLog('iexpscrb:DeleteScore:scoreId='||l_score_id);

Line: 325


         IEX_SCORE_PVT.Delete_Score(
              p_api_version              => p_api_version
            , p_init_msg_list            => p_init_msg_list
            , p_commit                   => p_commit
            , p_score_id                 => l_score_id
            , x_return_status            => x_return_status
            , x_msg_count                => x_msg_count
            , x_msg_data                 => x_msg_data
            );

Line: 354


      iex_score_pvt.WriteLog('iexpscrb:DeleteScore:End');

Line: 362


              ROLLBACK TO DELETE_SCORE_PUB;

Line: 369


              ROLLBACK TO DELETE_SCORE_PUB;

Line: 376


              ROLLBACK TO DELETE_SCORE_PUB;

Line: 383


END Delete_Score;

Line: 503


Procedure Update_SCORE_COMP
            ( p_api_version             IN NUMBER := 1.0,
              p_init_msg_list           IN VARCHAR2 ,
              p_commit                  IN VARCHAR2 ,
              p_SCORE_COMP_TBL          IN IEX_SCORE_PUB.SCORE_COMP_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) := 'Update_Score_Comp';

Line: 524


      SAVEPOINT UPDATE_Score_Comp_PUB;

Line: 542


      iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: Start');

Line: 553


      iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: scrcompcnt='||p_score_comp_tbl.count);

Line: 559


         IEX_SCORE_PVT.Update_Score_Comp(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_comp_rec           => l_score_comp_rec
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
         );

Line: 587


      iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: End');

Line: 597


              ROLLBACK TO UPDATE_SCORE_COMP_PUB;

Line: 605


              ROLLBACK TO UPDATE_SCORE_COMP_PUB;

Line: 613


              ROLLBACK TO UPDATE_SCORE_COMP_PUB;

Line: 620


END Update_Score_Comp;

Line: 624


Procedure Delete_SCORE_COMP
            ( p_api_version             IN NUMBER := 1.0,
              p_init_msg_list           IN VARCHAR2,
              p_commit                  IN VARCHAR2,
              p_SCORE_ID                IN NUMBER,
              p_SCORE_COMP_ID_TBL       IN IEX_SCORE_PUB.SCORE_COMP_ID_TBL,
              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_Score_COMP';

Line: 644


      SAVEPOINT DELETE_SCORE_COMP_PUB;

Line: 662


      iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: Start');

Line: 676


         iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: scorecompid='||l_score_comp_id);

Line: 678


         IEX_SCORE_PVT.Delete_Score_Comp(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_id                 => p_score_id
          , p_score_comp_id            => l_score_comp_id
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
         );

Line: 707


      iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: End');

Line: 715


              ROLLBACK TO DELETE_SCORE_COMP_PUB;

Line: 723


              ROLLBACK TO DELETE_SCORE_COMP_PUB;

Line: 731


              ROLLBACK TO DELETE_SCORE_COMP_PUB;

Line: 738


END Delete_Score_Comp;

Line: 861


Procedure Update_SCORE_COMP_TYPE
            ( p_api_version             IN NUMBER := 1.0,
              p_init_msg_list           IN VARCHAR2 ,
              p_commit                  IN VARCHAR2 ,
              p_SCORE_COMP_TYPE_TBL     IN IEX_SCORE_PUB.SCORE_COMP_TYPE_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_Score_Comp_TYPE';

Line: 883


      SAVEPOINT UPDATE_Score_Comp_TYPE_PUB;

Line: 901


      iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');

Line: 911


      iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: scrcomptypecnt='||p_score_comp_type_tbl.count);

Line: 917


         IEX_SCORE_PVT.Update_Score_Comp_Type(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_comp_type_rec      => l_score_comp_type_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: 946


      iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');

Line: 956


              ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;

Line: 964


              ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;

Line: 972


              ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;

Line: 979


END Update_Score_Comp_Type;

Line: 984


Procedure Delete_Score_Comp_Type
           (p_api_version             IN NUMBER := 1.0,
            p_init_msg_list           IN VARCHAR2 ,
            p_commit                  IN VARCHAR2 ,
            p_SCORE_COMP_TYPE_TBL     IN IEX_SCORE_PUB.SCORE_COMP_TYPE_TBL_TYPE,
            x_return_status           OUT NOCOPY VARCHAR2,
            x_msg_count               OUT NOCOPY NUMBER,
            x_msg_data                OUT NOCOPY VARCHAR2)

IS

    l_score_comp_type_id    NUMBER ;

Line: 996


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

Line: 1004


      SAVEPOINT DELETE_SCORE_COMP_TYPE_PUB;

Line: 1022


      iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');

Line: 1036


         iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: scrcomptypeid='||l_score_comp_type_id);

Line: 1039


         IEX_SCORE_PVT.Delete_Score_comp_type(
              p_api_version              => p_api_version
            , p_init_msg_list            => p_init_msg_list
            , p_commit                   => p_commit
            , p_score_comp_type_id       => l_score_comp_type_id
            , x_return_status            => x_return_status
            , x_msg_count                => x_msg_count
            , x_msg_data                 => x_msg_data
            );

Line: 1068


      iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');

Line: 1076


              ROLLBACK To DELETE_Score_Comp_TYPE_PUB;

Line: 1084


              ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;

Line: 1092


              ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;

Line: 1099


END Delete_Score_comp_type;

Line: 1209


              ROLLBACK To DELETE_Score_Comp_DET_PUB;

Line: 1217


              ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;

Line: 1225


              ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;

Line: 1236


Procedure Update_SCORE_COMP_DET
            ( p_api_version             IN NUMBER := 1.0,
              p_init_msg_list           IN VARCHAR2 ,
              p_commit                  IN VARCHAR2 ,
              p_SCORE_COMP_Det_TBL      IN IEX_SCORE_PUB.SCORE_COMP_DET_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) := 'Update_Score_Comp_DET';

Line: 1256


      SAVEPOINT UPDATE_Score_Comp_PUB_DET;

Line: 1290


          IEX_SCORE_PVT.Update_Score_Comp_DET(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_comp_det_rec       => l_score_comp_det_rec
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
          );

Line: 1327


              ROLLBACK To UPDATE_Score_Comp_DET_PUB;

Line: 1335


              ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;

Line: 1343


              ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;

Line: 1350


END Update_Score_Comp_DET;

Line: 1354


Procedure Delete_SCORE_COMP_DET
            ( p_api_version             IN NUMBER := 1.0,
              p_init_msg_list           IN VARCHAR2 ,
              p_commit                  IN VARCHAR2 ,
              p_SCORE_COMP_ID           IN NUMBER,
              p_SCORE_COMP_DET_ID_TBL   IN IEX_SCORE_PUB.SCORE_COMP_DET_ID_TBL,
              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_Score_COMP_DET';

Line: 1374


      SAVEPOINT DELETE_SCORE_COMP_DET_PUB;

Line: 1408


          IEX_SCORE_PVT.Delete_Score_Comp_Det(
            p_api_version              => p_api_version
          , p_init_msg_list            => p_init_msg_list
          , p_commit                   => p_commit
          , p_score_comp_id            => p_score_comp_id
          , p_score_comp_Det_id        => l_score_comp_det_id
          , x_return_status            => x_return_status
          , x_msg_count                => x_msg_count
          , x_msg_data                 => x_msg_data
          );

Line: 1444


              ROLLBACK To DELETE_Score_Comp_DET_PUB;

Line: 1452


              ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;

Line: 1460


              ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;

Line: 1467


END Delete_Score_Comp_Det;