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_TAP_ACCESS_TERRS_PVT SQL Statements

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

Line: 161


      Pv_Tap_Access_Terrs_Pkg.Insert_Row(
          p_partner_access_id  => p_tap_access_terrs_rec.partner_access_id,
          p_terr_id  => p_tap_access_terrs_rec.terr_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          p_object_version_number  =>  l_object_version_number,
          p_request_id  => p_tap_access_terrs_rec.request_id,
          p_program_application_id  => p_tap_access_terrs_rec.program_application_id,
          p_program_id  => p_tap_access_terrs_rec.program_id,
          p_program_update_date  => p_tap_access_terrs_rec.program_update_date,
	  x_return_status => x_return_status);

Line: 286


PROCEDURE Update_Tap_Access_Terrs(
    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_tap_access_terrs_rec       IN   tap_access_terrs_rec_type
    )
 IS

CURSOR c_get_territory_accesses(cv_partner_access_id NUMBER,cv_terr_id NUMBER) IS
    SELECT *
    FROM  PV_TAP_ACCESS_TERRS
    WHERE  partner_access_id = cv_partner_access_id
    AND  terr_id = cv_terr_id;

Line: 304


L_API_NAME            CONSTANT VARCHAR2(30) := 'Update_Tap_Access_Terrs';

Line: 318


      SAVEPOINT Update_Tap_Access_Terrs_Pvt;

Line: 347


         PVX_Utility_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 358


             p_message_name => 'API_MISSING_UPDATE_TARGET',
             p_token_name   => 'INFO',
             p_token_value  => 'Territory_Accesses') ;

Line: 402


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

Line: 416


         PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 420


      Pv_Tap_Access_Terrs_Pkg.Update_Row(
          p_partner_access_id  => p_tap_access_terrs_rec.partner_access_id,
          p_terr_id  => p_tap_access_terrs_rec.terr_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  => p_tap_access_terrs_rec.object_version_number,
          p_request_id  => p_tap_access_terrs_rec.request_id,
          p_program_application_id  => p_tap_access_terrs_rec.program_application_id,
          p_program_id  => p_tap_access_terrs_rec.program_id,
          p_program_update_date  => p_tap_access_terrs_rec.program_update_date,
	      x_return_status => x_return_status);

Line: 472


     ROLLBACK TO Update_Tap_Access_Terrs_Pvt;

Line: 483


     ROLLBACK TO Update_Tap_Access_Terrs_Pvt;

Line: 494


     ROLLBACK TO Update_Tap_Access_Terrs_Pvt;

Line: 508


End Update_Tap_Access_Terrs;

Line: 545


PROCEDURE Delete_Tap_Access_Terrs(
    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_partner_access_id	         IN  NUMBER,
    p_terr_id                    IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Tap_Access_Terrs';

Line: 565


      SAVEPOINT Delete_Tap_Access_Terrs;

Line: 596


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

Line: 601


      Pv_Tap_Access_Terrs_Pkg.Delete_Row(
          p_partner_access_id => p_partner_access_id,
          p_terr_id  => p_terr_id,
          p_object_version_number => p_object_version_number ,
	      x_return_status => x_return_status    );

Line: 646


     ROLLBACK TO DELETE_Territory_Accesses_Pvt;

Line: 657


     ROLLBACK TO Delete_Tap_Access_Terrs_Pvt;

Line: 668


     ROLLBACK TO Delete_Tap_Access_Terrs_Pvt;

Line: 683


End Delete_Tap_Access_Terrs;

Line: 846


  SELECT 'Y'
  FROM   PV_TAP_ACCESS_TERRS
  WHERE  partner_access_id = cv_partner_access_id
  AND    terr_id  = cv_terr_id;

Line: 920


     SELECT 'Y'
     FROM pv_partner_accesses
     WHERE partner_access_id = cv_partner_access_id;

Line: 926


     SELECT 'Y'
     FROM jtf_terr_all
     WHERE terr_id = cv_terr_id
     AND  nvl(end_date_active , sysdate) >= sysdate;

Line: 1007


      SELECT *
      FROM pv_tap_access_terrs
      WHERE partner_access_id = p_tap_access_terrs_rec.partner_access_id
      AND terr_id = p_tap_access_terrs_rec.terr_id;

Line: 1032


   IF p_tap_access_terrs_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_tap_access_terrs_rec.last_update_date;

Line: 1037


   IF p_tap_access_terrs_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_tap_access_terrs_rec.last_updated_by;

Line: 1052


   IF p_tap_access_terrs_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_tap_access_terrs_rec.last_update_login;

Line: 1072


   IF p_tap_access_terrs_rec.program_update_date IS NULL THEN
      x_complete_rec.program_update_date := l_tap_access_terrs_rec.program_update_date;

Line: 1085


   IF p_tap_access_terrs_rec.last_update_login IS NULL OR p_tap_access_terrs_rec.last_update_login = FND_API.G_MISS_NUM THEN
            l_tap_access_terrs_rec.last_update_login := FND_GLOBAL.user_id ;

Line: 1089


   IF p_tap_access_terrs_rec.last_update_date IS NULL OR p_tap_access_terrs_rec.last_update_date = FND_API.G_MISS_DATE THEN
            l_tap_access_terrs_rec.last_update_date := sysdate;

Line: 1093


   IF p_tap_access_terrs_rec.last_updated_by IS NULL OR p_tap_access_terrs_rec.last_updated_by = FND_API.G_MISS_NUM THEN
            l_tap_access_terrs_rec.last_updated_by := FND_GLOBAL.user_id  ;