APPS.AMS_UTILITY_PVT SQL Statements

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

Line: 194

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 255

    l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;

Line: 302

      SELECT 1 FROM fnd_lookup_values lkup
        WHERE lkup.LOOKUP_TYPE = p_lookup_type
          AND lkup.LOOKUP_CODE = p_lookup_code
          AND lkup.view_application_id = p_view_app_id
          AND lkup.ENABLED_FLAG = 'Y'
          AND lkup.language = USERENV('LANG')
          AND lkup.security_group_id = to_number(decode(substrb(userenv('CLIENT_INFO'),55,1
                                                               ), ' ', '0'
                                                                 , NULL, '0'
                                                                 , substrb(userenv('CLIENT_INFO'),55,10
                                                                          )
                                                        )
                                                 );

Line: 356

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 539

   SELECT ams_act_logs_s.NEXTVAL,
          ams_act_logs_transaction_id_s.NEXTVAL
     FROM DUAL;

Line: 544

   SELECT rowid
     FROM ams_act_logs
    WHERE activity_log_id = l_my_log_id;

Line: 566

   INSERT INTO ams_act_logs (
      activity_log_id
      -- standard who columns
      ,last_update_date
      ,last_updated_by
      ,creation_date
      ,created_by
      ,last_update_login
      ,object_version_number
      ,act_log_used_by_id
      ,arc_act_log_used_by
      ,log_transaction_id
      ,log_message_text
      ,log_message_level
      ,log_message_type
      ,description
      ,budget_id
      ,threshold_id
      ,notification_creation_date
   )
   VALUES (
       NVL(p_activity_log_id,l_act_log_id)
      -- standard who columns
      ,SYSDATE
      ,FND_GLOBAL.User_Id
      ,SYSDATE
      ,FND_GLOBAL.User_Id
      ,FND_GLOBAL.Conc_Login_Id
      ,1                 -- Object Version Number
      ,p_log_used_by_id
      ,p_arc_log_used_by
      ,NVL(p_transaction_id,l_log_tran_id)
      ,p_msg_data
      ,p_msg_level
      ,p_msg_type
      ,p_desc
      ,p_budget_id
      ,p_threshold_id
      ,p_notification_creat_date
   ) ;

Line: 766

   SELECT source_code,source_code_for_id INTO x_source_code,x_source_id
     FROM ams_source_codes
    WHERE arc_source_code_for = UPPER(p_activity_type)
      AND source_code_for_id  = UPPER(p_activity_id);

Line: 816

   SELECT campaign_name
     FROM ams_campaigns_vl
    WHERE campaign_id = p_object_id;

Line: 822

  SELECT c.campaign_name
  FROM   ams_campaigns_vl c,
         ams_campaign_schedules s
  WHERE s.campaign_schedule_id = p_object_id
  AND   s.campaign_id          = c.campaign_id;

Line: 829

   SELECT deliverable_name
     FROM ams_deliverables_vl
    WHERE deliverable_id = p_object_id;

Line: 834

   SELECT event_header_name
     FROM ams_event_headers_vl
    WHERE event_header_id = p_object_id;

Line: 839

   SELECT event_offer_name
     FROM ams_event_offers_vl
    WHERE event_offer_id = p_object_id;

Line: 844

      SELECT short_name
      FROM   ozf_funds_all_vl
      WHERE  fund_id = p_object_id;

Line: 849

      SELECT party_name
      FROM   hz_parties
      WHERE  party_id = p_object_id;

Line: 988

      SELECT meaning
      FROM   ams_lookups
      WHERE  lookup_type = UPPER (p_lookup_type)
      AND    lookup_code = UPPER (p_lookup_code);

Line: 1034

select NAME
 from  FND_TIMEZONES_VL
 where UPGRADE_TZ_ID = l_time_id;

Line: 1082

select NAME
 from  FND_TIMEZONES_VL
 where UPGRADE_TZ_ID = l_time_id;

Line: 1310

      SELECT meaning
      FROM   ams_lookups
      WHERE  lookup_type = UPPER (p_lookup_type)
      AND    lookup_code = UPPER (p_lookup_code);

Line: 1341

      SELECT full_name
      FROM   ams_jtf_rs_emp_v
      WHERE  resource_id = p_resource_id;

Line: 1376

   SELECT area2_code
   FROM   jtf_loc_hierarchies_vl
   WHERE  location_hierarchy_id = p_country_id;

Line: 1381

   SELECT B.area2_code
   FROM   ams_campaigns_vl A, jtf_loc_hierarchies_vl B
   WHERE  A.campaign_id = p_object_id
   AND    A.city_id = B.location_hierarchy_id;

Line: 1428

      SELECT padded_concatenated_segments
      FROM   mtl_system_items_kfv
      WHERE  inventory_item_id = p_prod_id
      AND    organization_id = p_org_id;

Line: 1434

      SELECT category_concat_segs
      FROM   mtl_categories_v
      WHERE  category_id = p_prod_id;

Line: 1475

   SELECT qlh.name
   FROM   qp_list_headers_vl qlh, qp_list_lines qll
   WHERE  qll.list_header_id = qlh.list_header_id
   AND    qll.list_line_id = p_price_list_line_id;

Line: 1506

   SELECT unit_of_measure_tl
   FROM   mtl_units_of_measure
   WHERE  uom_code = p_uom_code;

Line: 1537

   SELECT meaning
   FROM   qp_lookups
   WHERE  lookup_type = UPPER(p_lookup_type)
   AND    lookup_code = UPPER(p_lookup_code);

Line: 1568

      SELECT resource_id
      FROM   ams_jtf_rs_emp_v
      WHERE  user_id = p_user_id;

Line: 1672

   SELECT system_status_code
   FROM   ams_user_statuses_vl
   WHERE  user_status_id = p_user_status_id
   AND    enabled_flag = 'Y';

Line: 1705

   SELECT user_status_id
   FROM   ams_user_statuses_vl
   WHERE  system_status_type = p_status_type
   AND    system_status_code = p_status_code
   AND    default_flag = 'Y'
   AND    enabled_flag = 'Y';

Line: 1747

   SELECT theme_approval_flag, budget_approval_flag
   FROM   ams_status_order_rules
   WHERE  system_status_type = l_status_type
   AND    current_status_code = l_old_status_code
   AND    next_status_code = l_new_status_code;

Line: 1806

   SELECT attr_available_flag
   FROM   ams_custom_setup_attr
   WHERE  custom_setup_id = p_custom_setup_id
   -- Following line is added by ptendulk on 19-Jun-2001
   AND    object_attribute = p_approval_type ;

Line: 1854

   SELECT theme_approval_flag, budget_approval_flag
   FROM   ams_status_order_rules
   WHERE  system_status_type = l_status_type
   AND    current_status_code = l_old_status_code
   AND    next_status_code = l_new_status_code;

Line: 1939

      SELECT   gs.set_of_books_id
              ,gs.currency_code
      FROM     gl_sets_of_books gs
              ,org_organization_definitions org
      WHERE  gs.mrc_sob_type_code = 'P'
         AND org.set_of_books_id = gs.set_of_books_id
         AND org.operating_unit = p_org_id;

Line: 1950

      SELECT gs.set_of_books_id
      ,      gs.currency_code
      FROM   gl_sets_of_books gs
      ,      ozf_sys_parameters_all org
      WHERE  org.set_of_books_id = gs.set_of_books_id
      AND    org.org_id = p_org_id;

Line: 1960

      SELECT   (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
      FROM     dual;

Line: 2125

      SELECT   gs.set_of_books_id
              ,gs.currency_code
      FROM     gl_sets_of_books gs
              ,org_organization_definitions org
      WHERE  org.set_of_books_id = gs.set_of_books_id
         AND org.operating_unit = p_org_id;

Line: 2135

      SELECT  gs.set_of_books_id
      ,       gs.currency_code
      FROM   gl_sets_of_books gs
      ,      ozf_sys_parameters_all org
      WHERE  org.set_of_books_id = gs.set_of_books_id
      AND    org.org_id = p_org_id;

Line: 2145

      SELECT   (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
      FROM     dual;

Line: 2390

   SELECT employee_id , user_id, category
   FROM ams_jtf_rs_emp_v
   WHERE resource_id = p_resource_id ;

Line: 2545

   SELECT 1 FROM DUAL
   WHERE EXISTS (SELECT * FROM ams_status_order_rules
                 WHERE current_status_code = p_current_status
                 AND   next_status_code = p_next_status
                 AND   system_status_type = p_status_type ) ;

Line: 2644

SELECT 	deliverable_name
FROM 	ams_deliverables_vl
WHERE 	deliverable_id = p_delv_id;

Line: 2650

SELECT  campaign_name
FROM    ams_campaigns_vl
WHERE   campaign_id = p_camp_id;

Line: 2656

SELECT  schedule_name
FROM    ams_campaign_schedules_vl
WHERE   schedule_id = p_csch_id;

Line: 2742

           SELECT user_id
           FROM   ams_jtf_rs_emp_v
           WHERE  resource_id = p_resource_id;

Line: 2790

        SELECT APPLICATION_ID
        FROM FND_APPLICATION_VL
        WHERE APPLICATION_SHORT_NAME = p_app_short_name;

Line: 2795

        SELECT ATTRIBUTE_LABEL_LONG FROM AK_REGION_ITEMS_VL
        WHERE REGION_APPLICATION_ID = p_app_id
        AND REGION_CODE = p_region_code
        AND ATTRIBUTE_CODE LIKE 'AMS%RULE%'
        AND REGION_VALIDATION_API_PKG = p_type
        AND SORTBY_VIEW_ATTRIBUTE_NAME = p_obj_status
        AND DEFAULT_VALUE_VARCHAR2 = p_obj_attribute;

Line: 2804

        SELECT ATTRIBUTE_LABEL_LONG FROM AK_ATTRIBUTES_VL
        WHERE APPLICATION_SHORT_NAME = p_app_short_name
        AND ATTRIBUTE_CODE = p_attribute_code;