APPS.AMS_TRACKING_PVT SQL Statements

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

Line: 23

     SELECT COUNT(MSITE_ID) into l_count FROM IBE_MSITES_B where MSITE_ID = p_minisite_id;

Line: 35

/* PROCEDURE insert_log_mesg (p_mesg IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;

Line: 39

 insert into raghu_table values (p_mesg, sysdate);

Line: 80

    SELECT NVL(display_rule_id,0) FROM jtf_amv_attachments WHERE
    attachment_id = p_webcontent_id;

Line: 84

    select p.action_param_value
    from ams_ctds a, ams_ctd_param_values p
    where a.ctd_id = p.ctd_id
    and p.action_param_id in (21,31,41, 61)
    and a.ctd_id = p_webcontent_id;

Line: 199

   select source_code_id,arc_source_code_for  into code_id,obj_type  from  ams_source_codes  ascd where (ascd.source_code=p_track_rec.obj_src_code);

Line: 208

       select distinct owner_user_id, activity_id, activity_type_code into l_resource_id, l_activity_id, l_activity_type from AMS_CAMPAIGN_SCHEDULES_B csched
	   where (csched.source_code=p_track_rec.obj_src_code);

Line: 214

       select owner_user_id into l_resource_id from ams_event_offers_all_b eve  where (eve.source_code=p_track_rec.obj_src_code);

Line: 223

   /* insert_log_mesg('l_resource_id' || l_resource_id);

Line: 224

   insert_log_mesg('l_activity_id' || l_activity_id);

Line: 225

   insert_log_mesg('l_activity_type' || l_activity_type); */

Line: 277

   SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_interaction_id FROM dual;

Line: 505

    select display_url, link_to
    into x_redirect_url, x_action_parameter_code
    from jtf_amv_attachments
    where attachment_id = p_web_content_id;

Line: 534

     SELECT source_code_id FROM ams_source_codes
     WHERE source_code = p_code;