APPS.AZW_UTIL SQL Statements

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

Line: 10

procedure UpdateDocUrl(
  p_itemtype in varchar2,
  p_workflow in varchar2) IS
  proc_version   wf_process_activities.process_version%TYPE;

Line: 23

    select activity_item_type, activity_name
    from wf_process_activities
    start with (process_item_type = p_itemtype
                and   process_version = proc_version
                and   process_name = p_workflow)
    connect by (prior  activity_name = process_name
                and prior activity_item_type = process_item_type);

Line: 32

            select text_default
            from wf_message_attributes_vl
            where message_type = act_itemtype
            and   message_name = mesg_name
            and   name         = 'AZW_IA_APPSNAME';

Line: 39

            select text_default
            from wf_message_attributes_vl
            where message_type = act_itemtype
            and   message_name = mesg_name
            and   name         = 'AZW_IA_TARGET';

Line: 46

	  select max(process_version) into proc_version
	  from wf_process_activities
	  where process_item_type = p_itemtype
	  and   process_name      = p_workflow;

Line: 57

	     fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 58

	     fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');

Line: 66

	    select type into act_type
	    from wf_activities
	    where item_type = act_itemtype
	    and   name      = act_name
	    and   end_date is NULL;

Line: 78

	         fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 79

	         fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');

Line: 85

	      select message into mesg_name
	      from wf_activities
	      where item_type = act_itemtype
	      and   name      = act_name
	      and   end_date is NULL;

Line: 97

	         fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 98

	         fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');

Line: 113

	         fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 129

	         fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 137

	      update wf_message_attributes
	      set text_default = url
	      where message_type = act_itemtype
	      and   message_name = mesg_name
	      and   name         = 'AZW_IA_DOC';

Line: 149

	         fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 150

	         fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');

Line: 166

	 fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

Line: 169

End UpdateDocUrl;

Line: 237

  	select application_id
  	from fnd_product_installations
  	where to_char(application_id) = LTRIM(RTRIM(c_word))
  	and (status = 'I' or status ='S');

Line: 280

	SELECT COUNT(*)
        INTO v_count_installed
        FROM fnd_product_installations
        WHERE application_id = prod_id
        AND   status = 'I' OR status = 'S';

Line: 317

     SELECT sql_statement
     INTO   sqlstatement
     FROM   az_contexts_sql
     WHERE  context = ctx_type
     AND    purpose = 'VALIDATE';

Line: 389

  select root_activity into act_name
  from wf_items
  where item_type = itemtype
  and   item_key  = itemkey;

Line: 394

  select waav.TEXT_DEFAULT into context_type
  from wf_activity_attributes_vl waav
  where waav.activity_item_type = itemtype
    AND act_name = waav.activity_name
    AND waav.NAME = 'AZW_IA_CTXTYP'
    AND waav.activity_version =
	 (select max(waav.activity_version)
	  from wf_activity_attributes_vl waav
	  where waav.activity_item_type = itemtype
	  AND act_name = waav.activity_name
	  AND waav.NAME = 'AZW_IA_CTXTYP'
	  );

Line: 412

    select name into context
    from per_business_groups
    where BUSINESS_GROUP_ID = bg_id;

Line: 419

    select name into context
    from HR_OPERATING_UNITS
    where ORGANIZATION_ID = ou_id;

Line: 521

    select wpa.instance_label, wpa.process_name, wias.notification_id
    from wf_item_activity_statuses wias,
         wf_process_activities wpa
    where wias.item_type = itemtype
    and wias.item_key = itemkey
    and wias.notification_id is not null
    and wias.process_activity = wpa.instance_id
    order by wias.begin_date desc;

Line: 548

    select wn.user_comment into comment
    from wf_notifications wn
    where wn.notification_id = pre_notification_id;

Line: 560

    update wf_notifications
    set user_comment = comment
    where notification_id = cur_notification_id;