APPS.GR_WF_UTIL_PVT SQL Statements

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

Line: 88

  select  ecx_trigger_id_s.NEXTVAL
  from    dual;

Line: 105

     SELECT DISTINCT PARTY_ID, PARTY_TYPE
     INTO   party_id, party_type
     FROM   ECX_TP_HEADERS
     WHERE  PARTY_SITE_ID = l_party_site_id;

Line: 150

     select name
     into   i_to_system_name
     from   wf_systems
     where  guid = wf_core.translate('WF_SYSTEM_GUID');

Line: 241

      INSERT INTO gr_items_requested
                  (
                   MESSAGE_ICN,
                   ORGANIZATION,
                   FROM_ITEM,
                   TO_ITEM )
      VALUES
                  (
                   p_MESSAGE_ICN,
                   p_ORGN_ID,
                   p_FROM_ITEM,
                   p_TO_ITEM);

Line: 293

      SELECT concatenated_segments, description
      FROM   mtl_system_items_kfv
      WHERE organization_id = p_orgn_id
      AND   inventory_item_id = p_item_id
      AND   hazardous_material_flag = 'Y';

Line: 360

        SELECT formula_no, formula_vers
        FROM   fm_form_mst_b
        WHERE  formula_id = p_formula_id;

Line: 485

      SELECT USER_NAME
      INTO   l_performer
      FROM   FND_USER
      WHERE  USER_ID = p_user;

Line: 558

      SELECT application_id
      INTO   l_application_id
      FROM   fnd_application
      WHERE  application_short_name='GR';

Line: 571

         SELECT USER_NAME
         INTO   l_user
         FROM   FND_USER
         WHERE  USER_ID = approvers(1).user_id;

Line: 610

      SELECT b.label_code
      FROM   gr_labels_b b,
	     gr_labels_tl t
      WHERE  b.label_code        = t.label_code
      AND    t.label_description = p_tech_parm_name
      AND    b.tech_parm         = '1';

Line: 765

	    SELECT DISTINCT PARTY_ID, PARTY_TYPE
		INTO   l_party_id, l_party_type
		FROM   ECX_TP_HEADERS
		WHERE  PARTY_SITE_ID = l_party_site_id;

Line: 844

      SELECT  gr_item_information_seq.nextval
      INTO    l_event_key
      FROM    DUAL;

Line: 859

     l_parameter_list.DELETE;

Line: 998

     SELECT d.property_name, DECODE(b.property_type_indicator, 'A', a.alpha_value, 'D', a.date_value, 'N', a.number_value, 'F', a.alpha_value ) property_value,
            d.property_value  Proposed_value
     FROM   gr_inv_item_properties a, gr_properties_b b, gr_xml_properties_map c, gr_prop_chng_temp d
     WHERE  a.property_id       = b.property_id
     AND    a.property_id       = c.property_id
     AND    b.property_id       = c.property_id
     AND    a.label_code        = c.field_name_code
     AND    a.inventory_item_id = ( select inventory_item_id from mtl_system_items_kfv where organization_id =v_orgn_id and concatenated_segments =d.item_code )
     AND    a.organization_id   = d.orgn_id
     AND    c.xml_element       = d.property_name
     AND    d.item_code         = V_item_code
     AND    d.orgn_id           = V_orgn_id
     AND    c.xml_element       = V_element_name
     AND    d.message_icn       =  p_message_icn
    UNION ALL
     SELECT a.property_name, NULL property_value, a.property_value Proposed_value
     FROM   gr_prop_chng_temp a, gr_xml_properties_map b, mtl_system_items_kfv c
     WHERE  (c.inventory_item_id, c.organization_id, b.field_name_code, b.property_id ) NOT IN (select INVENTORY_ITEM_ID , ORGANIZATION_ID , label_code, property_id from
gr_inv_item_properties)
     AND    a.property_name    = b.xml_element
     AND    a.property_name    = V_element_name
     AND    a.item_code        = V_item_code
     AND    a.orgn_id          = V_orgn_id
     AND    a.item_code        = c.concatenated_segments
     AND    a.orgn_id          = c.organization_id
     AND    a.message_icn      = p_message_icn;

Line: 1027

     SELECT property_name, NULL property_value, property_value Proposed_value
     FROM   gr_prop_chng_temp
     WHERE  property_name NOT IN (SELECT xml_element FROM gr_xml_properties_map)
     AND    property_name      = V_element_name
     AND    item_code          = V_item_code
     AND    orgn_id            = V_orgn_id
     AND    message_icn =  p_message_icn;

Line: 1036

     SELECT a.orgn_id, nvl(c.organization_code, ' ') orgn_code, a.item_code, b.description item_name, a.property_name
     FROM   gr_prop_chng_temp a, mtl_system_items_kfv  b, mtl_parameters c
     WHERE  a.orgn_id         =  b.organization_id
     AND    a.orgn_id         =  c.organization_id
     AND    b.organization_id =  c.organization_id
     AND    a.item_code       =  b.concatenated_segments
     AND    a.message_icn     =  p_message_icn;

Line: 1048

      SELECT  gr_item_information_seq.nextval
      INTO    l_item_code_seq
      FROM    DUAL;

Line: 1158

      select item_code into l_item_code from gr_item_General_v where rownum=1;

Line: 1169

	  delete from gr_prop_chng_temp where message_icn = p_message_icn;

Line: 1217

      INSERT INTO gr_prop_chng_temp
                  (
                   MESSAGE_ICN,
                   ORGN_ID,
                   ITEM_CODE,
                   PROPERTY_NAME,
                   PROPERTY_VALUE)
      VALUES
                  (
                   p_MESSAGE_ICN,
                   p_ORGN_ID,
                   p_ITEM_CODE,
                   p_PROPERTY_NAME,
                   p_PROPERTY_VALUE);

Line: 1312

      SELECT organization, from_item, to_item
      FROM  gr_items_requested
      WHERE message_icn = p_message_icn;

Line: 1363

      SELECT USER_NAME
      INTO   l_performer
      FROM   FND_USER
      WHERE  USER_ID = l_user_id;

Line: 1373

     select concatenated_segments into l_from_item from mtl_system_items_kfv where rownum=1;

Line: 1385

      delete from gr_items_requested where message_icn = p_message_icn;