APPS.PO_DOC_UDA_UTIL SQL Statements

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

Line: 39

     select distinct(attribute_category) from po_uda_ag_template_usages
     where template_id = p_template_id;

Line: 54

      SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all
      WHERE po_header_id = p_po_header_id;

Line: 123

     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
     WHERE template_id = p_template_id;

Line: 143

        SELECT CONTRACT_TYPE, CLM_IDC_TYPE
        INTO l_contract_type ,l_clm_idc_type
        FROM po_lines_all
        WHERE po_line_id = p_po_line_id;

Line: 155

        SELECT CONTRACT_TYPE, CLM_IDC_TYPE
        INTO l_contract_type ,l_clm_idc_type
        FROM po_lines_draft_all
        WHERE po_line_id = p_po_line_id
        AND draft_id = p_draft_id;

Line: 233

     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
     WHERE template_id = p_template_id;

Line: 309

     SELECT ATTRIBUTE_GROUP_ID
       FROM po_uda_ag_template_usages
      WHERE template_id    = l_template_id
    AND ATTRIBUTE_CATEGORY IN ('ADDRESS', 'DOCUMENT_NUMBERING','MODIFICATIONS');

Line: 320

   SELECT uda_template_id
     INTO l_template_id
     FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 333

     SELECT attr_group_name
       INTO l_attr_group_name
       FROM EGO_ATTR_GROUPS_V
      WHERE ATTR_GROUP_TYPE = 'PO_HEADER_EXT_ATTRS'
    AND ATTR_GROUP_ID       = c_get_add_agids_tbl_rec.ATTRIBUTE_GROUP_ID;

Line: 376

   SELECT po_line_id BULK COLLECT
     INTO l_po_line_ids
     FROM po_lines_draft_all
    WHERE po_header_id = p_po_header_id
  AND draft_id         = p_draft_id;

Line: 384

     SELECT uda_template_id
       INTO l_template_id
       FROM po_lines_all
      WHERE po_line_id = l_po_line_ids(i);

Line: 394

    SELECT  CONTRACT_TYPE, CLM_IDC_TYPE
    INTO    l_drft_contract_type, l_drft_idc_type
    FROM    po_lines_draft_all
    WHERE   PO_LINE_ID = l_po_line_ids(i)
    AND     DRAFT_ID = p_draft_id;

Line: 400

    SELECT  CONTRACT_TYPE, CLM_IDC_TYPE
    INTO    l_base_contract_type, l_base_idc_type
    FROM    po_lines_all
    WHERE   PO_LINE_ID = l_po_line_ids(i);

Line: 406

        DELETE FROM PO_LINES_ALL_EXT_TL WHERE extension_id  IN (SELECT extension_id FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1);

Line: 407

        DELETE FROM PO_LINES_ALL_EXT_B WHERE PO_LINE_ID = l_po_line_ids(i) AND DRAFT_ID = -1;

Line: 432

     SELECT line_location_id BULK COLLECT
       INTO l_po_line_location_ids
       FROM po_line_locations_draft_all
     WHERE po_line_id = l_po_line_ids(i)
     AND draft_id       = p_draft_id;

Line: 440

       SELECT uda_template_id
         INTO l_template_id
         FROM po_line_locations_all
        WHERE line_location_id = l_po_line_location_ids(j);

Line: 508

 SELECT ACT.ATTR_GROUP_ID
 FROM EGO_ACTION_DISPLAYS_B EAD, EGO_ACTIONS_b ACT ,EGO_MAPPINGS_B B
 WHERE ACT.action_id = ead.action_id
 AND EAD.EXECUTION_METHOD = 'XLE'
 AND B.MAPPED_OBJ_PK1_VAL = ACT.ACTION_ID
 AND B.MAPPED_TO_GROUP_TYPE = 'E'
 AND B.MAPPED_ATTRIBUTE = p_external_param
 AND ACT.CLASSIFICATION_CODE = p_template_id;

Line: 560

 SELECT ACT.ATTR_GROUP_ID
 FROM EGO_ACTION_DISPLAYS_B EAD, EGO_ACTIONS_b ACT ,EGO_MAPPINGS_B B
 WHERE ACT.action_id = ead.action_id
 AND EAD.EXECUTION_METHOD = 'XD'
 AND B.MAPPED_OBJ_PK1_VAL = ACT.ACTION_ID
 AND B.MAPPED_TO_GROUP_TYPE = 'E'
 AND B.MAPPED_ATTRIBUTE = p_external_param
 AND ACT.CLASSIFICATION_CODE = p_template_id;