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

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

Line: 30


PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 34


 insert into raghu_table values (p_mesg,sysdate);

Line: 101


      SELECT AMS_WEB_TRACKING_S.NEXTVAL
      FROM dual;

Line: 105


      SELECT 1
      FROM AMS_WEB_TRACKING
      WHERE web_tracking_id = l_id;

Line: 177


	--insert_log_mesg('Local variable initialization');

Line: 201


      Ams_Web_Track_Pkg.Insert_Row(
          px_web_tracking_id  => l_web_tracking_id,
          p_schedule_id  => p_web_track_rec.schedule_id,
          p_party_id  => p_web_track_rec.party_id,
          p_placement_id  => p_web_track_rec.placement_id,
          p_content_item_id  => p_web_track_rec.content_item_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,
          px_object_version_number  => l_object_version_number,
          p_attribute_category  => p_web_track_rec.attribute_category,
          p_attribute1  => p_web_track_rec.attribute1,
          p_attribute2  => p_web_track_rec.attribute2,
          p_attribute3  => p_web_track_rec.attribute3,
          p_attribute4  => p_web_track_rec.attribute4,
          p_attribute5  => p_web_track_rec.attribute5,
          p_attribute6  => p_web_track_rec.attribute6,
          p_attribute7  => p_web_track_rec.attribute7,
          p_attribute8  => p_web_track_rec.attribute8,
          p_attribute9  => p_web_track_rec.attribute9,
          p_attribute10  => p_web_track_rec.attribute10,
          p_attribute11  => p_web_track_rec.attribute11,
          p_attribute12  => p_web_track_rec.attribute12,
          p_attribute13  => p_web_track_rec.attribute13,
          p_attribute14  => p_web_track_rec.attribute14,
          p_attribute15  => p_web_track_rec.attribute15
);

Line: 232


	  --insert_log_mesg('Web Tracking Id ::::'||x_web_tracking_id);

Line: 261


	 --insert_log_mesg('AMS_API_RESOURCE_LOCKED');

Line: 334


PROCEDURE Update_Web_Track(
    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_web_track_rec               IN    web_track_rec_type
    )

 IS


CURSOR c_get_web_track(web_tracking_id NUMBER) IS
    SELECT *
    FROM  AMS_WEB_TRACKING
    WHERE  web_tracking_id = p_web_track_rec.web_tracking_id;

Line: 357


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

Line: 368


      SAVEPOINT update_web_track_pvt;

Line: 397


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

Line: 404


  AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Web_Track') ;

Line: 418


 p_token_value  => 'Last_Update_Date') ;

Line: 441


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

Line: 454


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

Line: 457


      Ams_Web_Track_Pkg.Update_Row(
          p_web_tracking_id  => p_web_track_rec.web_tracking_id,
          p_schedule_id  => p_web_track_rec.schedule_id,
          p_party_id  => p_web_track_rec.party_id,
          p_placement_id  => p_web_track_rec.placement_id,
          p_content_item_id  => p_web_track_rec.content_item_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_web_track_rec.object_version_number,
          p_attribute_category  => p_web_track_rec.attribute_category,
          p_attribute1  => p_web_track_rec.attribute1,
          p_attribute2  => p_web_track_rec.attribute2,
          p_attribute3  => p_web_track_rec.attribute3,
          p_attribute4  => p_web_track_rec.attribute4,
          p_attribute5  => p_web_track_rec.attribute5,
          p_attribute6  => p_web_track_rec.attribute6,
          p_attribute7  => p_web_track_rec.attribute7,
          p_attribute8  => p_web_track_rec.attribute8,
          p_attribute9  => p_web_track_rec.attribute9,
          p_attribute10  => p_web_track_rec.attribute10,
          p_attribute11  => p_web_track_rec.attribute11,
          p_attribute12  => p_web_track_rec.attribute12,
          p_attribute13  => p_web_track_rec.attribute13,
          p_attribute14  => p_web_track_rec.attribute14,
          p_attribute15  => p_web_track_rec.attribute15
);

Line: 511


     ROLLBACK TO UPDATE_Web_Track_PVT;

Line: 521


     ROLLBACK TO UPDATE_Web_Track_PVT;

Line: 531


     ROLLBACK TO UPDATE_Web_Track_PVT;

Line: 543


End Update_Web_Track;

Line: 580


PROCEDURE Delete_Web_Track(
    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_web_tracking_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 599


      SAVEPOINT delete_web_track_pvt;

Line: 631


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

Line: 634


      Ams_Web_Track_Pkg.Delete_Row(
          p_web_tracking_id  => p_web_tracking_id,
          p_object_version_number => p_object_version_number     );

Line: 664


     ROLLBACK TO DELETE_Web_Track_PVT;

Line: 674


     ROLLBACK TO DELETE_Web_Track_PVT;

Line: 684


     ROLLBACK TO DELETE_Web_Track_PVT;

Line: 696


End Delete_Web_Track;

Line: 895


	--insert_log_mesg(p_web_track_rec.placement_id);

Line: 1033


      SELECT *
      FROM ams_web_tracking
      WHERE web_tracking_id = p_web_track_rec.web_tracking_id;

Line: 1071


   IF p_web_track_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_web_track_rec.last_update_date;

Line: 1076


   IF p_web_track_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_web_track_rec.last_updated_by;

Line: 1091


   IF p_web_track_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_web_track_rec.last_update_login;

Line: 1243


	--insert_log_mesg('Check_web_track_Items');

Line: 1249


	--insert_log_mesg('done Check_web_track_Items');

Line: 1250


	--insert_log_mesg(x_return_status);

Line: 1259


	 --insert_log_mesg('before Default_Web_Track_Items');

Line: 1263


	--insert_log_mesg('before Complete_web_track_Rec');

Line: 1448


      SELECT ams_web_recomms_s.NEXTVAL
      FROM dual;

Line: 1452


      SELECT 1
      FROM AMS_WEB_RECOMMS
      WHERE web_recomm_id = l_id;

Line: 1540


      Ams_Web_Recomms_Pkg.Insert_Row(
          px_web_recomm_id  => l_web_recomm_id,
          p_web_tracking_id  => p_web_recomms_rec.web_tracking_id,
          p_recomm_object_id  => p_web_recomms_rec.recomm_object_id,
          p_recomm_type  => p_web_recomms_rec.recomm_type,
          p_rule_id  => p_web_recomms_rec.rule_id,
          p_offer_id  => p_web_recomms_rec.offer_id,
          p_offer_src_code  => p_web_recomms_rec.offer_src_code,
          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,
          px_object_version_number  => l_object_version_number,
          p_attribute_category  => p_web_recomms_rec.attribute_category,
          p_attribute1  => p_web_recomms_rec.attribute1,
          p_attribute2  => p_web_recomms_rec.attribute2,
          p_attribute3  => p_web_recomms_rec.attribute3,
          p_attribute4  => p_web_recomms_rec.attribute4,
          p_attribute5  => p_web_recomms_rec.attribute5,
          p_attribute6  => p_web_recomms_rec.attribute6,
          p_attribute7  => p_web_recomms_rec.attribute7,
          p_attribute8  => p_web_recomms_rec.attribute8,
          p_attribute9  => p_web_recomms_rec.attribute9,
          p_attribute10  => p_web_recomms_rec.attribute10,
          p_attribute11  => p_web_recomms_rec.attribute11,
          p_attribute12  => p_web_recomms_rec.attribute12,
          p_attribute13  => p_web_recomms_rec.attribute13,
          p_attribute14  => p_web_recomms_rec.attribute14,
          p_attribute15  => p_web_recomms_rec.attribute15
);

Line: 1671


PROCEDURE Update_Web_Recomms(
    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_web_recomms_rec               IN    web_recomms_rec_type
    )

 IS


CURSOR c_get_web_recomms(web_recomm_id NUMBER) IS
    SELECT *
    FROM  AMS_WEB_RECOMMS
    WHERE  web_recomm_id = p_web_recomms_rec.web_recomm_id;

Line: 1694


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

Line: 1705


      SAVEPOINT update_web_recomms_pvt;

Line: 1734


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

Line: 1741


  AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Web_Recomms') ;

Line: 1755


 p_token_value  => 'Last_Update_Date') ;

Line: 1777


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

Line: 1790


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

Line: 1793


      Ams_Web_Recomms_Pkg.Update_Row(
          p_web_recomm_id  => p_web_recomms_rec.web_recomm_id,
          p_web_tracking_id  => p_web_recomms_rec.web_tracking_id,
          p_recomm_object_id  => p_web_recomms_rec.recomm_object_id,
          p_recomm_type  => p_web_recomms_rec.recomm_type,
          p_rule_id  => p_web_recomms_rec.rule_id,
          p_offer_id  => p_web_recomms_rec.offer_id,
          p_offer_src_code  => p_web_recomms_rec.offer_src_code,
          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_web_recomms_rec.object_version_number,
          p_attribute_category  => p_web_recomms_rec.attribute_category,
          p_attribute1  => p_web_recomms_rec.attribute1,
          p_attribute2  => p_web_recomms_rec.attribute2,
          p_attribute3  => p_web_recomms_rec.attribute3,
          p_attribute4  => p_web_recomms_rec.attribute4,
          p_attribute5  => p_web_recomms_rec.attribute5,
          p_attribute6  => p_web_recomms_rec.attribute6,
          p_attribute7  => p_web_recomms_rec.attribute7,
          p_attribute8  => p_web_recomms_rec.attribute8,
          p_attribute9  => p_web_recomms_rec.attribute9,
          p_attribute10  => p_web_recomms_rec.attribute10,
          p_attribute11  => p_web_recomms_rec.attribute11,
          p_attribute12  => p_web_recomms_rec.attribute12,
          p_attribute13  => p_web_recomms_rec.attribute13,
          p_attribute14  => p_web_recomms_rec.attribute14,
          p_attribute15  => p_web_recomms_rec.attribute15
);

Line: 1849


     ROLLBACK TO UPDATE_Web_Recomms_PVT;

Line: 1859


     ROLLBACK TO UPDATE_Web_Recomms_PVT;

Line: 1869


     ROLLBACK TO UPDATE_Web_Recomms_PVT;

Line: 1881


End Update_Web_Recomms;

Line: 1918


PROCEDURE Delete_Web_Recomms(
    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_web_recomm_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

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

Line: 1937


      SAVEPOINT delete_web_recomms_pvt;

Line: 1969


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

Line: 1972


      Ams_Web_Recomms_Pkg.Delete_Row(
          p_web_recomm_id  => p_web_recomm_id,
          p_object_version_number => p_object_version_number     );

Line: 2002


     ROLLBACK TO DELETE_Web_Recomms_PVT;

Line: 2012


     ROLLBACK TO DELETE_Web_Recomms_PVT;

Line: 2022


     ROLLBACK TO DELETE_Web_Recomms_PVT;

Line: 2034


End Delete_Web_Recomms;

Line: 2332


      SELECT *
      FROM ams_web_recomms
      WHERE web_recomm_id = p_web_recomms_rec.web_recomm_id;

Line: 2380


   IF p_web_recomms_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_web_recomms_rec.last_update_date;

Line: 2385


   IF p_web_recomms_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_web_recomms_rec.last_updated_by;

Line: 2400


   IF p_web_recomms_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_web_recomms_rec.last_update_login;

Line: 2757


	 --insert_log_mesg(p_web_track_rec.schedule_id);

Line: 2766


			--insert_log_mesg('Calling Create_Web_Track ::::');

Line: 2777


		--insert_log_mesg('Done Create_Web_Track ::::');

Line: 2778


	--dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );

Line: 2779


	--insert_log_mesg('l_web_tracking_id');

Line: 2780


	--insert_log_mesg('Web Tracking Id ::::'||l_web_tracking_id);

Line: 2790


	--dbms_output.put_line('after inserting into AMS_WEB_TRACKING '||l_web_tracking_id );

Line: 2798


	--insert_log_mesg('RECORD POPULATED');

Line: 2843


	--insert_log_mesg('Schedule Type ::::'||p_web_track_rec.schedule_type);

Line: 2885


       	--insert_log_mesg('Return Status ::::'||x_return_status);

Line: 2888


		--insert_log_mesg(p_commit);

Line: 2896


	--insert_log_mesg('FINALLY DONE ::::');

Line: 2903


	 --insert_log_mesg(x_return_status);