APPS.PV_PRGM_PMT_MODE_PVT SQL Statements

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

Line: 49

  SELECT  lkp.MEANING
  FROM  oe_lookups lkp,
    PV_PROGRAM_PAYMENT_MODE pay_mode
  WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
    AND pay_mode.PROGRAM_ID = cv_program_id
    AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
    AND lkp.lookup_type = 'PAYMENT TYPE';

Line: 58

  SELECT  lkp.MEANING
  FROM  pv_lookups lkp,
    PV_PROGRAM_PAYMENT_MODE pay_mode
  WHERE lkp.LOOKUP_CODE = cv_program_payment_mode
    AND pay_mode.PROGRAM_ID = cv_program_id
    AND pay_mode.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
    AND lkp.lookup_type = 'PV_PAYMENT_TYPE';

Line: 110

  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) GEO_AREA_NAME,
          LH.LOCATION_TYPE_NAME LOCATION_TYPE_NAME
  FROM  PV_PROGRAM_PAYMENT_MODE PPPMNT,
      JTF_LOC_HIERARCHIES_VL LH
  WHERE   PPPMNT.PROGRAM_ID = cv_program_id
  AND   PPPMNT.GEO_HIERARCHY_ID = cv_program_geo_hierarchy_id
  AND   PPPMNT.MODE_OF_PAYMENT = cv_program_payment_mode
  AND   LH.LOCATION_HIERARCHY_ID = PPPMNT.GEO_HIERARCHY_ID
  AND   PPPMNT.mode_type = 'PAYMENT';

Line: 189

      SELECT PV_PROGRAM_PAYMENT_MODE_S.NEXTVAL
      FROM dual;

Line: 195

      SELECT  'X'
      FROM PV_PROGRAM_PAYMENT_MODE
      WHERE program_payment_mode_id = l_id;

Line: 201

      select PROGRAM_PAYMENT_MODE_ID, object_version_number, MODE_OF_PAYMENT
      from PV_PROGRAM_PAYMENT_MODE
      where GEO_HIERARCHY_ID = l_id
      AND MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');

Line: 269

             Update_Prgm_Pmt_Mode(
               l_api_version_number,
               p_init_msg_list,
               p_commit,
               p_validation_level,
               x_return_status,
               x_msg_count,
               x_msg_data,
               l_prgm_pmt_mode_rec);

Line: 316

              l_prgm_pmt_mode_rec.last_update_date        := SYSDATE;

Line: 317

              l_prgm_pmt_mode_rec.last_updated_by         := FND_GLOBAL.user_id;

Line: 320

              l_prgm_pmt_mode_rec.last_update_login       := FND_GLOBAL.conc_login_id;

Line: 358

         PV_PRGM_PMT_MODE_PKG.Insert_Row(
              px_program_payment_mode_id  => l_prgm_pmt_mode_rec.program_payment_mode_id
             ,p_program_id                => l_prgm_pmt_mode_rec.program_id
             ,p_geo_hierarchy_id          => l_prgm_pmt_mode_rec.geo_hierarchy_id
             ,p_mode_of_payment           => l_prgm_pmt_mode_rec.mode_of_payment
             ,p_last_update_date          => l_prgm_pmt_mode_rec.last_update_date
             ,p_last_updated_by           => l_prgm_pmt_mode_rec.last_updated_by
             ,p_creation_date             => l_prgm_pmt_mode_rec.creation_date
             ,p_created_by                => l_prgm_pmt_mode_rec.created_by
             ,p_last_update_login         => l_prgm_pmt_mode_rec.last_update_login
             ,p_object_version_number     => l_object_version_number
             ,p_mode_type           => l_prgm_pmt_mode_rec.mode_type
             );

Line: 436

PROCEDURE Update_Prgm_Pmt_Mode(
     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_pmt_mode_rec          IN   prgm_pmt_mode_rec_type
    )

IS

 CURSOR c_get_prgm_pmt_mode(cv_program_payment_mode_id NUMBER) IS
    SELECT *
    FROM  PV_PROGRAM_PAYMENT_MODE
    WHERE PROGRAM_PAYMENT_MODE_ID = cv_program_payment_mode_id;

Line: 456

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

Line: 464

  l_update                             BOOLEAN := true;

Line: 467

      select GEO_HIERARCHY_ID, MODE_OF_PAYMENT
      from PV_PROGRAM_PAYMENT_MODE
      where PROGRAM_PAYMENT_MODE_ID = l_id
      and MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');

Line: 473

      select GEO_HIERARCHY_ID, MODE_OF_PAYMENT, PROGRAM_PAYMENT_MODE_ID, object_version_number
      from PV_PROGRAM_PAYMENT_MODE
      where GEO_HIERARCHY_ID = l_id
      and MODE_OF_PAYMENT in ('PO_NUM_DISABLED', 'PO_NUM_ENABLED');

Line: 486

      SAVEPOINT Update_Prgm_Pmt_Mode_PVT;

Line: 512

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

Line: 551

                  Delete_Prgm_Pmt_Mode(
                      p_api_version_number        => l_api_version_number
                     ,p_init_msg_list             => FND_API.G_FALSE
                     ,p_commit                    => FND_API.G_FALSE
                     ,p_validation_level          => FND_API.G_VALID_LEVEL_FULL
                     ,x_return_status             => x_return_status
                     ,x_msg_count                 => x_msg_count
                     ,x_msg_data                  => x_msg_data
                     ,p_program_payment_mode_id   => y.program_payment_mode_id
                     ,p_object_version_number     => y.object_version_number
                   );

Line: 564

                     PVX_UTILITY_PVT.debug_message('X_return_status from delete api to delete the duplicate record ' || x_return_status);

Line: 565

                     PVX_UTILITY_PVT.debug_message('x_msg_count from delete api to delete the duplicate record  ' || x_msg_count);

Line: 566

                     PVX_UTILITY_PVT.debug_message('x_msg_data from delete api to delete the duplicate record  ' || x_msg_data);

Line: 577

                l_update := false;

Line: 583

     if(l_update) then



      IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
          -- Debug message
           IF (PV_DEBUG_HIGH_ON) THEN

           PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Prgm_Pmt_Mode');

Line: 599

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

Line: 622

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

Line: 626

      PV_PRGM_PMT_MODE_PKG.Update_Row(
           p_program_payment_mode_id  => l_tar_prgm_pmt_mode_rec.program_payment_mode_id
          ,p_program_id               => l_tar_prgm_pmt_mode_rec.program_id
          ,p_geo_hierarchy_id         => l_tar_prgm_pmt_mode_rec.geo_hierarchy_id
          ,p_mode_of_payment          => l_tar_prgm_pmt_mode_rec.mode_of_payment
          ,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_pmt_mode_rec.object_version_number
	  ,p_mode_type          => l_tar_prgm_pmt_mode_rec.mode_type
          );

Line: 659

     ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;

Line: 669

     ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;

Line: 679

     ROLLBACK TO Update_Prgm_Pmt_Mode_PVT;

Line: 691

End Update_Prgm_Pmt_Mode;

Line: 695

PROCEDURE Delete_Prgm_Pmt_Mode(
     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_payment_mode_id    IN   NUMBER
    ,p_object_version_number      IN   NUMBER
    )

 IS
l_api_name                  CONSTANT VARCHAR2(30) := 'Delete_Prgm_Pmt_Mode';

Line: 718

      SAVEPOINT Delete_Prgm_Pmt_Mode_PVT;

Line: 748

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

Line: 752

      PV_PRGM_PMT_MODE_PKG.Delete_Row(
           p_program_payment_mode_id  => p_program_payment_mode_id
          ,p_object_version_number    => p_object_version_number
          );

Line: 776

     ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;

Line: 786

     ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;

Line: 796

     ROLLBACK TO Delete_Prgm_Pmt_Mode_PVT;

Line: 809

End Delete_Prgm_Pmt_Mode;

Line: 832

   SELECT program_payment_mode_id
   FROM PV_PROGRAM_PAYMENT_MODE
   WHERE program_payment_mode_id = p_program_payment_mode_id
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 965

      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)),
                    LH.LOCATION_TYPE_NAME LOCATION_TYPE_NAME
      from JTF_LOC_HIERARCHIES_VL LH
      where LOCATION_HIERARCHY_ID = l_loc_hie_id;

Line: 975

      select meaning from pv_lookups
      where lookup_type = 'PV_PAYMENT_TYPE'
      and lookup_code = l_payment_code;

Line: 1129

      IF p_prgm_pmt_mode_rec.last_update_date = FND_API.g_miss_date OR
         p_prgm_pmt_mode_rec.last_update_date IS NULL THEN
         FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

Line: 1132

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

Line: 1139

      IF p_prgm_pmt_mode_rec.last_updated_by = FND_API.g_miss_num OR
         p_prgm_pmt_mode_rec.last_updated_by IS NULL THEN
         FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

Line: 1142

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

Line: 1174

      IF p_prgm_pmt_mode_rec.last_update_login = FND_API.g_miss_num OR
         p_prgm_pmt_mode_rec.last_update_login IS NULL THEN
         FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

Line: 1177

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

Line: 1448

      SELECT *
      FROM PV_PROGRAM_PAYMENT_MODE
      WHERE program_payment_mode_id = p_prgm_pmt_mode_rec.program_payment_mode_id;

Line: 1508

   IF p_prgm_pmt_mode_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_prgm_pmt_mode_rec.last_update_date;

Line: 1515

   IF p_prgm_pmt_mode_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_prgm_pmt_mode_rec.last_updated_by;

Line: 1536

   IF p_prgm_pmt_mode_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_prgm_pmt_mode_rec.last_update_login;

Line: 1556

    ,p_validation_mode            IN   VARCHAR2       := JTF_PLSQL_API.G_UPDATE
    ,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) := 'Validate_Prgm_Pmt_Mode';