APPS.AMS_CPYUTILITY_PVT SQL Statements

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

Line: 59

        SELECT   deliverable_name
        FROM     ams_deliverables_vl
        WHERE  deliverable_id = p_deliverable_id;

Line: 85

          SELECT   event_header_name
          FROM     ams_event_headers_vl
          WHERE  event_header_id = p_event_header_id;

Line: 110

          SELECT   offer_code
          FROM     ams_act_offers
          WHERE  activity_offer_id = p_offer_id;

Line: 137

          SELECT DISTINCT   (category_name)
          FROM     ams_act_products_v
          WHERE  category_id = p_category_id;

Line: 142

        SELECT  concatenated_segments
	  FROM  MTL_CATEGORIES_b_kfv
         WHERE  category_id = p_category_id;

Line: 168

          SELECT   message_name
          FROM     ams_messages_vl
          WHERE  message_id = p_message_id;

Line: 193

          SELECT   event_offer_name
          FROM     ams_event_offers_vl
          WHERE  event_offer_id = p_event_offering_id;

Line: 218

       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
          FROM jtf_loc_hierarchies_vl lh
          WHERE  location_hierarchy_id = p_geo_hierarchy_id
             AND location_type_code = p_geo_area_type;

Line: 230

    /* dbiswas changed the following select clause and replaced with the decode select clause above
       for sql repository performance issue bug # 3631235
         SELECT   geo_area_name
          FROM     ams_act_geo_areas_v
          WHERE  geo_hierarchy_id = p_geo_hierarchy_id
             AND geo_type_code = p_geo_area_type;

Line: 259

          SELECT  full_name
          FROM    ams_jtf_rs_emp_v
          WHERE  resource_id = p_resource_id;

Line: 284

          SELECT   cell_name
          FROM     ams_cells_vl
          WHERE  cell_id = p_cell_id;

Line: 309

          SELECT DISTINCT   (file_name)
          FROM     jtf_amv_attachments
          WHERE  attachment_id = p_act_attachment_id;

Line: 332

        SELECT   category_name
          FROM     ams_categories_tl
          WHERE  category_id = p_category_id;

Line: 379

      g_log_mesg_txt.delete;

Line: 380

      g_log_mesg_type.delete;

Line: 381

      g_act_used_by.delete;

Line: 382

      g_act_used_id.delete;

Line: 393

   PROCEDURE insert_log_mesg (x_transaction_id OUT NOCOPY NUMBER)
   IS
   PRAGMA AUTONOMOUS_TRANSACTION;

Line: 397

   SELECT ams_Act_logs_transaction_id_s.nextval
    into x_transaction_id
    FROM DUAL;

Line: 404

            INSERT INTO ams_act_logs
                        (
                                       activity_log_id,
                                       last_update_date,
                                       last_updated_by,
                                       creation_date,
                                       created_by,
                                       last_update_login,
                                       act_log_used_by_id,
                                       arc_act_log_used_by,
                                       log_transaction_id,
                                       log_message_text,
                                       log_message_type
                                    )
                 VALUES (
                    ams_act_logs_s.nextval,
                    SYSDATE,
                    fnd_global.user_id,
                    SYSDATE,
                    fnd_global.user_id,
                    fnd_global.conc_login_id,
                    g_act_used_id (i),
                    g_act_used_by (i),
                    x_transaction_id,
                    g_log_mesg_txt (i),
                    g_log_mesg_type (i)
                 );

Line: 438

   END insert_log_mesg;

Line: 455

       SELECT actual_exec_end_date ,actual_exec_start_date
       INTO end_date,start_date
       FROM AMS_CAMPAIGNS_VL
       WHERE campaign_id = p_activity_id;

Line: 463

       SELECT event_end_date,event_start_date
       INTO end_date,start_date
       FROM AMS_EVENT_OFFERS_VL
       WHERE event_offer_id = p_activity_id;

Line: 470

       SELECT active_to_date,active_from_date
       INTO end_date,start_date
       FROM AMS_EVENT_HEADERS_VL
       WHERE event_header_id = p_activity_id;

Line: 530

        SELECT COUNT(1) from ams_campaign_schedules_vl
        WHERE campaign_id = p_camp_id;

Line: 533

        SELECT COUNT(1) from ams_act_messages
        WHERE message_used_by_id = p_obj_id
        AND message_used_by = p_obj_type;

Line: 537

        SELECT COUNT(1)
        FROM ams_object_associations
        WHERE master_object_id = p_obj_id
        AND master_object_type = p_obj_type ;

Line: 542

        SELECT COUNT(1)
        FROM ams_act_products
        WHERE act_product_used_by_id = p_obj_id
        AND arc_act_product_used_by = p_obj_type;

Line: 547

        SELECT COUNT(1)
        FROM ams_act_geo_areas
        WHERE act_geo_area_used_by_id = p_obj_id
        AND arc_act_geo_area_used_by = p_obj_type;

Line: 552

        SELECT COUNT(1)
        FROM fnd_attached_documents
        WHERE entity_name = p_obj_type
        AND   pk1_value = p_obj_id ;

Line: 557

        SELECT COUNT(1)
        FROM ams_act_market_segments
        WHERE act_market_segment_used_by_id = p_obj_id
        AND arc_act_market_segment_used_by = p_obj_type;

Line: 562

        SELECT COUNT(1)
        FROM  AMS_ACT_PARTNERS
        WHERE act_partner_used_by_id = p_obj_id
        AND arc_act_partner_used_by = p_obj_type;