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.PV_PRGM_CONTRACTS_PVT SQL Statements

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

Line: 78


       SELECT PV_PROGRAM_CONTRACTS_S.NEXTVAL
        FROM dual;

Line: 84


      SELECT  'X'
      FROM PV_PROGRAM_CONTRACTS
      WHERE program_contracts_id = l_id;

Line: 168


           l_prgm_contracts_rec.last_update_date      := SYSDATE;

Line: 169


           l_prgm_contracts_rec.last_updated_by       := FND_GLOBAL.user_id;

Line: 172


           l_prgm_contracts_rec.last_update_login     := FND_GLOBAL.conc_login_id;

Line: 211


      PV_PRGM_CONTRACTS_PKG.Insert_Row(
           px_program_contracts_id  => l_prgm_contracts_rec.program_contracts_id
          ,p_program_id             => l_prgm_contracts_rec.program_id
          ,p_geo_hierarchy_id       => l_prgm_contracts_rec.geo_hierarchy_id
          ,p_contract_id            => l_prgm_contracts_rec.contract_id
          ,p_last_update_date       => l_prgm_contracts_rec.last_update_date
          ,p_last_updated_by        => l_prgm_contracts_rec.last_updated_by
          ,p_creation_date          => l_prgm_contracts_rec.creation_date
          ,p_created_by             => l_prgm_contracts_rec.created_by
          ,p_last_update_login      => l_prgm_contracts_rec.last_update_login
          ,p_object_version_number  => l_object_version_number
          ,p_member_type_code        => l_prgm_contracts_rec.member_type_code
          );

Line: 290


PROCEDURE Update_Prgm_Contracts(
     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_prgm_contracts_rec         IN   prgm_contracts_rec_type
    )

IS

CURSOR c_get_Prgm_Contracts(cv_program_contracts_id NUMBER) IS
    SELECT *
    FROM  PV_PROGRAM_CONTRACTS
    WHERE program_contracts_id = cv_program_contracts_id;

Line: 310


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

Line: 323


      SAVEPOINT UPDATE_Prgm_Contracts_PVT;

Line: 349


         FND_MESSAGE.set_token('MODE','Update');

Line: 392


            ,p_validation_mode        => JTF_PLSQL_API.g_update
            ,p_prgm_contracts_rec     => p_prgm_contracts_rec
            ,x_return_status          => x_return_status
            ,x_msg_count              => x_msg_count
            ,x_msg_data               => x_msg_data
            );

Line: 415


      Pvx_Utility_Pvt.debug_message('Private API: '||l_full_name||' - Calling update table handler');

Line: 419


      PV_PRGM_CONTRACTS_PKG.Update_Row(
           p_program_contracts_id    => l_tar_prgm_contracts_rec.program_contracts_id
          ,p_program_id              => l_tar_prgm_contracts_rec.program_id
          ,p_geo_hierarchy_id        => l_tar_prgm_contracts_rec.geo_hierarchy_id
          ,p_contract_id             => l_tar_prgm_contracts_rec.contract_id
          ,p_last_update_date        => SYSDATE
          ,p_last_updated_by         => FND_GLOBAL.user_id
          ,p_last_update_login       => FND_GLOBAL.conc_login_id
          ,p_object_version_number   => l_tar_prgm_contracts_rec.object_version_number
          ,p_member_type_code         => l_tar_prgm_contracts_rec.member_type_code
          );

Line: 451


     ROLLBACK TO UPDATE_Prgm_Contracts_PVT;

Line: 461


     ROLLBACK TO UPDATE_Prgm_Contracts_PVT;

Line: 471


     ROLLBACK TO UPDATE_Prgm_Contracts_PVT;

Line: 484


END Update_Prgm_Contracts;

Line: 486


PROCEDURE Delete_Prgm_Contracts(
     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_program_contracts_id       IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

IS

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

Line: 510


      SAVEPOINT DELETE_Prgm_Contracts_PVT;

Line: 540


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

Line: 544


      PV_PRGM_CONTRACTS_PKG.Delete_Row(
          p_program_contracts_id  => p_program_contracts_id
          ,p_object_version_number => p_object_version_number
          );

Line: 568


     ROLLBACK TO DELETE_Prgm_Contracts_PVT;

Line: 578


     ROLLBACK TO DELETE_Prgm_Contracts_PVT;

Line: 588


     ROLLBACK TO DELETE_Prgm_Contracts_PVT;

Line: 601


END Delete_Prgm_Contracts;

Line: 623


   SELECT program_contracts_id
   FROM PV_PROGRAM_CONTRACTS
   WHERE program_contracts_id = px_program_contracts_id
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 753


      select DECODE(LH.LOCATION_TYPE_CODE, 'AREA1', LH.AREA1_NAME, 'AREA2',LH.AREA2_NAME,
                    'COUNTRY', LH.COUNTRY_NAME, 'CREGION', LH.COUNTRY_REGION_NAME,
                    'STATE', LH.STATE_NAME, 'SREGION', LH.STATE_REGION_NAME, 'CITY', LH.CITY_NAME,
                    'POSTAL_CODE', LH.POSTAL_CODE_START||'-'||LH.POSTAL_CODE_END, to_char(LOCATION_HIERARCHY_ID))
      from JTF_LOC_HIERARCHIES_VL LH
      where LOCATION_HIERARCHY_ID = l_loc_hie_id;

Line: 761


      SELECT program_contracts_id
      FROM pv_program_contracts
      WHERE program_id = cv_program_id
            and geo_hierarchy_id = cv_geo_hierarchy_id
            and member_type_code = cv_member_type_code;

Line: 894


      IF p_prgm_contracts_rec.last_update_date = Fnd_Api.g_miss_date
       OR p_prgm_contracts_rec.last_update_date IS NULL THEN
         Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 897


         Fnd_Message.set_token('COLUMN','LAST_UPDATE_DATE');

Line: 904


      IF p_prgm_contracts_rec.last_updated_by = Fnd_Api.g_miss_num
       OR p_prgm_contracts_rec.last_updated_by IS NULL THEN
         Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 907


         Fnd_Message.set_token('COLUMN','LAST_UPDATED_BY');

Line: 934


      IF p_prgm_contracts_rec.last_update_login = Fnd_Api.g_miss_num
       OR p_prgm_contracts_rec.last_update_login IS NULL THEN
         Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

Line: 937


         Fnd_Message.set_token('COLUMN','LAST_UPDATE_LOGIN');

Line: 1218


      SELECT *
      FROM PV_PROGRAM_CONTRACTS
      WHERE program_contracts_id = p_prgm_contracts_rec.program_contracts_id;

Line: 1265


   IF p_prgm_contracts_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_prgm_contracts_rec.last_update_date;

Line: 1271


   IF p_prgm_contracts_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_prgm_contracts_rec.last_updated_by;

Line: 1289


   IF p_prgm_contracts_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_prgm_contracts_rec.last_update_login;