APPS.POR_ITEM_ATTRIBUTES_PKG SQL Statements

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

Line: 21

      PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line: 41

      PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line: 50

      PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line: 57

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

Line: 102

    SELECT requisition_header_id,
           requisition_line_id,
           created_by
      FROM po_requisition_lines_all
     WHERE requisition_header_id = p_req_header_id;

Line: 111

  PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 113

  select hrtl2.location_code into l_template_name
  from hr_locations_all_tl hrtl1, hr_locations_all_tl hrtl2
  where hrtl1.location_id = hrtl2.location_id
  and hrtl2.language = userenv('LANG')
  and hrtl1.location_code = l_profile_value
  and hrtl1.language in
      ( select language_code
        FROM fnd_languages
        WHERE installed_flag in ( 'B', 'I'))
  and rownum = 1 ;

Line: 135

  PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 141

    SELECT NVL(MAX(seq_num), 0)
    INTO l_seq_num
    FROM fnd_attached_documents
    WHERE pk1_value = to_char(l_requisition_line_id)
      AND entity_name = 'REQ_LINES';

Line: 151

    PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 161

    PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 173

      PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 178

       select attached_document_id
       into l_attachment_id
       -- for bug 14537896
       from fnd_attached_documents fad,
            fnd_documents_tl fdt
       where pk1_value=to_char(l_requisition_line_id)
       --  and pk2_value='ONE_TIME_LOCATION';

Line: 195

      fnd_webattch.update_attachment(
		seq_num			=> l_seq_num		,
		category_id		=> p_category_id	,
		document_description	=> 'POR:' || l_template_name	,
		datatype_id		=> 2			,
		text			=> l_text		,
		file_name		=> l_file_name		,
		url			=> NULL			,
		function_name		=> 'PO_POXRQERQ'	,
		entity_name		=> 'REQ_LINES'		,
		pk1_value		=> l_requisition_line_id	,
		pk2_value		=> 'ONE_TIME_LOCATION'		,
		pk3_value		=> NULL		,
		pk4_value		=> NULL		,
		pk5_value		=> NULL		,
		media_id		=> NULL		,
		user_id			=> l_created_by ,
		ATTACHED_DOCUMENT_ID    => l_attachment_id);

Line: 247

    PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 256

    PO_WF_DEBUG_PKG.insert_debug(p_wf_item_type,p_wf_item_key,l_progress);

Line: 290

  SELECT attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15
    INTO l_a1, l_a2, l_a3, l_a4, l_a5,
         l_a6, l_a7, l_a8, l_a9, l_a10,
         l_a11, l_a12, l_a13, l_a14, l_a15
    FROM por_item_attribute_values
   WHERE item_type = p_item_type
     AND requisition_header_id = p_requisition_header_id
     AND requisition_line_id = p_requisition_line_id;

Line: 315

             This is done to avoid insertion of unnecessary
             line feeds in the attachments even when the values are
             null. These line feeds in the attachment was causing
             blank lines to be printed in Printed Purchase Order report
*/

 l_text := append_if_not_null(l_text,l_a1,l_a2,l_a3,l_a4,l_a5,
                                     l_a6,l_a7,l_a8,l_a9,l_a10,
                                     l_a11,l_a12,l_a13,l_a14,l_a15);