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

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

Line: 42


   SELECT  'ANYTHING'
     FROM  jtf_rs_resource_extns
     WHERE resource_id = cv_cm_resource_id;

Line: 243


  ,p_mode             IN  VARCHAR2 := 'INSERT'
  ,x_return_status    OUT NOCOPY VARCHAR2
)
IS


BEGIN

   x_return_status := FND_API.g_ret_sts_success;

Line: 276


x_Lead_Owner_rec.last_update_date           := FND_API.G_MISS_DATE;

Line: 277


x_Lead_Owner_rec.last_updated_by            := FND_API.G_MISS_NUM;

Line: 280


x_Lead_Owner_rec.last_update_login          := FND_API.G_MISS_NUM;

Line: 285


x_Lead_Owner_rec.program_update_date        := FND_API.G_MISS_DATE;

Line: 302


   SELECT *
     FROM  AS_SALES_LEAD_OWNERS
     WHERE Lead_Owner_id = p_Lead_Owner_rec.Lead_Owner_id;

Line: 336


IF p_Lead_Owner_rec.program_update_date    = FND_API.G_MISS_DATE THEN
   x_complete_rec.program_update_date    := l_Lead_Owner_rec.program_update_date;

Line: 542


   SELECT AS_SALES_LEAD_OWNERS_S.NEXTVAL FROM DUAL;

Line: 546


   SELECT  'ANYTHING'
     FROM  AS_SALES_LEAD_OWNERS
     WHERE Lead_Owner_id = cv_Lead_Owner_id;

Line: 599


  AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': insert');

Line: 626


  INSERT INTO AS_SALES_LEAD_OWNERS (
       lead_Owner_id
      ,category
      ,country
      ,from_postal_code
      ,to_postal_code
      ,CM_resource_id
      ,referral_type
      ,owner_flag
      ,last_update_date
      ,last_updated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,request_id
      ,program_application_id
      ,program_id
      ,program_update_date
      ,object_version_number
       )
    VALUES (
       l_Lead_Owner_rec.Lead_Owner_id
      ,l_Lead_Owner_rec.category
      ,l_Lead_Owner_rec.country
      ,l_Lead_Owner_rec.from_postal_code
      ,l_Lead_Owner_rec.to_postal_code
      ,l_Lead_Owner_rec.CM_resource_id
      ,l_Lead_Owner_rec.referral_type
      ,l_Lead_Owner_rec.owner_flag
      ,SYSDATE                                -- LAST_UPDATE_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- LAST_UPDATED_BY
      ,SYSDATE                                -- CREATION_DATE
      ,NVL(FND_GLOBAL.user_id,-1)             -- CREATED_BY
      ,NVL(FND_GLOBAL.conc_login_id,-1)       -- LAST_UPDATE_LOGIN
      ,l_Lead_Owner_rec.request_id
      ,l_Lead_Owner_rec.program_application_id
      ,l_Lead_Owner_rec.program_id
      ,l_Lead_Owner_rec.program_update_date
      ,l_object_version_number                -- object_version_number
      );

Line: 734


PROCEDURE Delete_Lead_Owner(
   p_api_version       IN  NUMBER
  ,p_init_msg_list     IN  VARCHAR2 := FND_API.g_false
  ,p_commit            IN  VARCHAR2 := FND_API.g_false

  ,x_return_status     OUT NOCOPY VARCHAR2
  ,x_msg_count         OUT NOCOPY NUMBER
  ,x_msg_data          OUT NOCOPY VARCHAR2

  ,p_Lead_Owner_id       IN  NUMBER
  ,p_object_version     IN  NUMBER

)
IS

   l_api_version CONSTANT NUMBER       := 1.0;

Line: 750


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

Line: 756


   SAVEPOINT Delete_Lead_Owner;

Line: 776


   AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': delete');

Line: 778


   DELETE FROM AS_SALES_LEAD_OWNERS
     WHERE Lead_Owner_id = p_Lead_Owner_id
     AND   object_version_number = p_object_version;

Line: 807


      ROLLBACK TO Delete_Lead_Owner;

Line: 816


      ROLLBACK TO Delete_Lead_Owner;

Line: 825


      ROLLBACK TO Delete_Lead_Owner;

Line: 839


END Delete_Lead_Owner;

Line: 868


   SELECT  Lead_Owner_id
     FROM  AS_SALES_LEAD_OWNERS
     WHERE Lead_Owner_id = p_Lead_Owner_id
     AND   object_version_number = p_object_version
   FOR UPDATE OF Lead_Owner_id NOWAIT;

Line: 970


PROCEDURE Update_Lead_Owner(
   p_api_version       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_Lead_Owner_rec     IN  Lead_Owner_rec_type

)
IS

   l_api_version CONSTANT NUMBER := 1.0;

Line: 985


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

Line: 990


   l_mode            VARCHAR2(30) := 'UPDATE';

Line: 996


   SAVEPOINT Update_Lead_Owner;

Line: 1030


         p_validation_mode => JTF_PLSQL_API.g_update,
         x_return_status   => l_return_status
      );

Line: 1061


   AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': update');

Line: 1063


   UPDATE AS_SALES_LEAD_OWNERS SET
       category			  = l_Lead_Owner_rec.category
      ,country 			  = l_Lead_Owner_rec.country
      ,from_postal_code           = l_Lead_Owner_rec.from_postal_code
      ,to_postal_code             = l_Lead_Owner_rec.to_postal_code
      ,cm_resource_id             = l_Lead_Owner_rec.CM_resource_id
      ,referral_type              = l_Lead_Owner_rec.referral_type
      ,owner_flag                 = l_Lead_Owner_rec.owner_flag
      ,last_update_date           = SYSDATE
      ,last_updated_by            = NVL(FND_GLOBAL.user_id,-1)
      ,last_update_login          = NVL(FND_GLOBAL.conc_login_id,-1)
      ,request_id                 = l_Lead_Owner_rec.request_id
      ,program_application_id     = l_Lead_Owner_rec.program_application_id
      ,program_id                 = l_Lead_Owner_rec.program_id
      ,program_update_date        = l_Lead_Owner_rec.program_update_date
      ,object_version_number      = l_Lead_Owner_rec.object_version_number + 1
   WHERE Lead_Owner_id = l_Lead_Owner_rec.Lead_Owner_id
   AND   object_version_number = l_Lead_Owner_rec.object_version_number;

Line: 1108


      ROLLBACK TO Update_Lead_Owner;

Line: 1117


      ROLLBACK TO Update_Lead_Owner;

Line: 1126


      ROLLBACK TO Update_Lead_Owner;

Line: 1140


END Update_Lead_Owner;

Line: 1176


     SELECT aso.cm_resource_id, aso.owner_flag
     FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
     WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
     AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
     AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
     AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;

Line: 1184


     SELECT aso.cm_resource_id, aso.owner_flag
     FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
     WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
     AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
--     AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);

Line: 1362


     SELECT aso.cm_resource_id, aso.owner_flag
     FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
     WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
     AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
     AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
     AND ASO.CATEGORY = 'IMMATURED'
     AND ASO.OWNER_FLAG = 'Y';

Line: 1371


     SELECT aso.cm_resource_id, aso.owner_flag
     FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
     WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
     AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
--     AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);