APPS.PO_DOC_NUMBERING_PKG SQL Statements

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

Line: 48

   SELECT  END_USER_COLUMN_NAME
   FROM    FND_DESCR_FLEX_COLUMN_USAGES
   WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
   AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 75

    SELECT pha.clm_document_number INTO l_idv_number
    FROM po_headers_draft_all phda, po_headers_all pha
    WHERE phda.po_header_id = p_doc_header_id
    AND phda.clm_source_document_id = pha.po_header_id;

Line: 83

          SELECT pha2.clm_document_number INTO l_idv_number
          FROM po_headers_all pha1, po_headers_all pha2
          WHERE pha1.po_header_id = p_doc_header_id
          AND pha1.clm_source_document_id = pha2.po_header_id;

Line: 189

   select ags.ATTR_GROUP_NAME
   into l_attr_group_name
   from ego_attr_groups_v ags
   where ags.attr_group_id = l_attrb_grp_id;

Line: 336

      SELECT c_ext_attr40 INTO x_doc_number
      FROM po_req_headers_ext_b
      WHERE requisition_header_id = p_doc_header_id
      AND   attr_group_id = l_attrb_grp_id;

Line: 343

      SELECT c_ext_attr40 INTO x_doc_number
      FROM po_headers_all_ext_b
      WHERE po_header_id = p_doc_header_id
      AND draft_id = p_draft_id
      AND attr_group_id = l_attrb_grp_id;

Line: 351

      SELECT c_ext_attr40 INTO x_doc_number
      FROM pon_auction_headers_ext_b
      WHERE auction_header_id = p_doc_header_id
      AND attr_group_id = l_attrb_grp_id;

Line: 506

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING';

Line: 515

    SELECT lookup_code
    FROM (
        SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
        and enabled_flag = 'Y'
        and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);

Line: 536

    SELECT To_Char(SYSDATE,'YY')
    INTO x_fiscal_year
    FROM dual;

Line: 541

      SELECT lookup_code
      INTO x_agency_identifier
      FROM (
          SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_AGENCY_IDENTIFIER'
              and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
      WHERE ROWNUM=1;

Line: 586

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 607

     SELECT to_number(lookup_code)
     INTO min_code
     FROM fnd_lookup_values
     WHERE meaning = x_min_value
     AND language = userenv ('LANG')
     AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 614

     SELECT to_number(lookup_code)
     INTO max_code
     FROM fnd_lookup_values
     WHERE meaning = x_max_value
     AND language = userenv ('LANG')
     AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 621

     l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
                ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
                ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                ' AND flv.language = userenv (''LANG'')' ||
                ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 634

     SELECT meaning
     INTO x_serial_number
     FROM fnd_lookup_values
     WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
     AND language = userenv ('LANG')
     AND to_number(lookup_code) = Nvl(l_lookup_code, min_code)  --
     AND to_number(lookup_code) <= max_code;   --

Line: 770

      select count(*) INTO l_cnt
      from po_req_headers_ext_b
      WHERE C_EXT_ATTR40 = x_document_number
      AND  requisition_header_id <> x_requisition_header_id;

Line: 822

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING';

Line: 864

     /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 887

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 894

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 901

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 914

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code)  --
         AND to_number(lookup_code) <= max_code;   --

Line: 1016

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='NA';

Line: 1037

    SELECT To_Char(SYSDATE,'YY')
    INTO x_fiscal_year
    FROM dual;

Line: 1042

      SELECT lookup_code
      INTO x_agency_identifier
      FROM (
          SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_AGENCY_IDENTIFIER'
              and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
      WHERE ROWNUM=1;

Line: 1061

      SELECT lookup_code
      INTO x_allowed_range
      FROM (
          SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
              and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
      WHERE ROWNUM=1;

Line: 1092

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 1114

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1121

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1128

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE  prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 1141

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code)  --
         AND to_number(lookup_code) <= max_code;   --

Line: 1258

      select count(*) INTO l_cnt
      from PON_AUCTION_HEADERS_EXT_B
      WHERE C_EXT_ATTR40 = x_document_number
      AND  auction_header_id <> x_auction_header_id;

Line: 1310

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='NA';

Line: 1346

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 1368

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1375

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1382

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE  prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
                    ' AND prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 1396

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;     --

Line: 1484

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='NA';

Line: 1506

    SELECT To_Char(SYSDATE,'YY')
    INTO x_fiscal_year
    FROM dual;

Line: 1511

      SELECT lookup_code
      INTO x_agency_identifier
      FROM (
          SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_AGENCY_IDENTIFIER'
              and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
      WHERE ROWNUM=1;

Line: 1530

      SELECT lookup_code
      INTO x_allowed_range
      FROM (
          SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
              and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
      WHERE ROWNUM=1;

Line: 1561

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 1582

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1589

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1596

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb..C_EXT_ATTR1 = '''||x_prefix ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 1609

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;    --

Line: 1725

      select count(*) INTO l_cnt
      from PO_HEADERS_ALL_EXT_B
      WHERE C_EXT_ATTR40 = x_document_number
      AND  po_header_id <> x_order_header_id;

Line: 1778

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='NA';

Line: 1814

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
              ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
              ' and prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 1835

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1842

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 1849

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 1862

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;    --

Line: 1941

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Modification'
      AND puatu.attribute2='NA';

Line: 1955

    SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 1969

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR2))  '||
               ' FROM PO_HEADERS_ALL_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
               ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
               ' and C_EXT_ATTR7 not like ''%X%'' ';

Line: 2032

  select count(*) INTO l_cnt
  from PO_HEADERS_ALL_EXT_B
  WHERE C_EXT_ATTR40 = x_document_number
  AND  draft_id <> p_draft_id
  AND po_header_id <> p_po_header_id;

Line: 2077

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1 ='Modification'
      AND puatu.attribute2='NA';

Line: 2091

    SELECT document_number INTO x_base_doc_number
    FROM pon_auction_headers_all
    WHERE auction_header_id = p_base_auction_header_id;

Line: 2106

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR2))  '||
               ' FROM PON_AUCTION_HEADERS_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
               ' and ATTR_GROUP_ID in ('||l_where_cls||')';

Line: 2166

  select count(*) INTO l_cnt
  from PON_AUCTION_HEADERS_EXT_B
  WHERE C_EXT_ATTR40 = x_document_number
  AND  AUCTION_HEADER_ID <> p_auction_header_id;

Line: 2220

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1 ='Base Document'
      AND puatu.attribute2='NA';

Line: 2231

    SELECT lookup_code
    FROM (
        SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
        and enabled_flag = 'Y'
        and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);

Line: 2256

      SELECT PEI_INFORMATION2
      INTO x_dodaac
      FROM per_people_extra_info pei, fnd_user fu
      WHERE pei.information_type = 'CLM_CONTACT_TITLE'
        AND pei.person_id= fu.employee_id
        AND fu.user_id = fnd_global.user_id;

Line: 2272

    SELECT To_Char(SYSDATE,'YY')
    INTO x_fiscal_year
    FROM dual;

Line: 2278

        SELECT lookup_code
        INTO x_instrument_type
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_INSTRUMENT_TYPE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 2299

        SELECT lookup_code
        INTO x_allowed_range
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 2346

      /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
              ' ( select min(to_number(lookup_code)) from ( '||
              ' SELECT lookup_code FROM po_lookup_codes '||
              ' WHERE to_number(lookup_code) BETWEEN '||
              ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
              ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
              ' minus '||
              ' SELECT distinct plc.lookup_code FROM '||
              ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
              ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
              ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
              ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
              ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
              ' and prheb.C_EXT_ATTR3 = '''||x_instrument_type ||''''||
              ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
              ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 2367

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2374

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2381

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
                    ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
                    ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 2394

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;     --

Line: 2431

	  /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
                  ' ( select min(to_number(lookup_code)) from ( '||
                  ' SELECT lookup_code FROM po_lookup_codes '||
                  ' WHERE to_number(lookup_code) BETWEEN '||
                  ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                    x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                  ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                    x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                  ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
                  ' minus '||
                  ' SELECT distinct plc.lookup_code FROM '||
                  ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
                  ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                  ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
                  ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
                  ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
                  ' and prheb.C_EXT_ATTR3 = '''||x_instrument_type ||''''||
                  ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
                  ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 2452

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2459

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2466

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
                    ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
                    ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 2479

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;   --

Line: 2631

        select count(*) INTO l_cnt
        from PON_AUCTION_HEADERS_EXT_B
        WHERE C_EXT_ATTR40 = x_document_number
        AND  auction_header_id <> x_auction_header_id;

Line: 2764

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1 ='Base Document'
      AND puatu.attribute2='NA';  */

Line: 2775

    SELECT lookup_code
    FROM (
        SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
        and enabled_flag = 'Y'
        and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);

Line: 2797

    SELECT attr_group_id
    INTO  l_cur_attr_group_id
    FROM ego_attr_groups_v
    WHERE ATTR_GROUP_NAME = 'DOD_AWD'
    AND attr_group_type='PO_HEADER_EXT_ATTRS';

Line: 2809

        SELECT PEI_INFORMATION2
        INTO x_dodaac
        FROM per_people_extra_info pei, fnd_user fu
        WHERE pei.information_type = 'CLM_CONTACT_TITLE'
          AND pei.person_id= fu.employee_id
          AND fu.user_id = fnd_global.user_id;

Line: 2828

      SELECT To_Char(SYSDATE,'YY')
      INTO x_fiscal_year
      FROM dual;

Line: 2834

          SELECT lookup_code
          INTO x_instrument_type
          FROM (
              SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_INSTRUMENT_TYPE'
                  and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
          WHERE ROWNUM=1;

Line: 2855

          SELECT lookup_code
          INTO x_allowed_range
          FROM (
              SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
                  and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
          WHERE ROWNUM=1;

Line: 2900

	/*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
                ' ( select min(to_number(lookup_code)) from ( '||
                ' SELECT lookup_code FROM po_lookup_codes '||
                ' WHERE to_number(lookup_code) BETWEEN '||
                ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                  x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                  x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
                ' minus '||
                ' SELECT distinct plc.lookup_code FROM '||
                ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
                ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                ' and ( prheb.C_EXT_ATTR7 = plc.displayed_field  OR  SubStr(prheb.C_EXT_ATTR40,-4) = plc.displayed_field)' ||
                ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
                ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
                ' and prheb.C_EXT_ATTR3 = '''||x_instrument_type ||''''||
                ' and prheb.attr_group_id =  '|| l_cur_attr_group_id  ||' ))' ||
                ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 2921

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2928

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 2935

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
                    ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
                    ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_cur_attr_group_id || ')';

Line: 2948

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;    --

Line: 2959

	 -- If you delete a document, you will not be able to reuse the same serial number again.
	 -- The next serial number generated would always be the max serial number that exists in the system + 1.

        --EXECUTE IMMEDIATE l_query INTO x_serial_number ;

Line: 2991

	  /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
                ' ( select min(to_number(lookup_code)) from ( '||
                ' SELECT lookup_code FROM po_lookup_codes '||
                ' WHERE to_number(lookup_code) BETWEEN '||
                ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                  x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
                  x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
                ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
                ' minus '||
                ' SELECT distinct plc.lookup_code FROM '||
                ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
                ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                ' and ( prheb.C_EXT_ATTR7 = plc.displayed_field  OR  SubStr(prheb.C_EXT_ATTR40,-4) = plc.displayed_field)' ||
                ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
                ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
                ' and prheb.C_EXT_ATTR3 = '''||x_instrument_type ||''''||
                ' and prheb.attr_group_id =  '|| l_cur_attr_group_id ||' ))' ||
                ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 3012

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3019

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3026

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
                    ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
                    ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_cur_attr_group_id || ')';

Line: 3039

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;    --

Line: 3195

        select count(*) INTO l_cnt
        from PO_HEADERS_ALL_EXT_B
        WHERE C_EXT_ATTR40 = x_document_number
        AND  po_header_id <> x_order_header_id;

Line: 3351

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='Y';

Line: 3362

    SELECT lookup_code
    FROM (
        SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
        and enabled_flag = 'Y'
        and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code);

Line: 3389

        SELECT lookup_code
        INTO x_allowed_range
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_ALLOWED_RANGE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 3431

    /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
            ' ( select min(to_number(lookup_code)) from ( '||
            ' SELECT lookup_code FROM po_lookup_codes '||
            ' WHERE to_number(lookup_code) BETWEEN '||
            ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
              x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
            ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
              x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
            ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
            ' minus '||
            ' SELECT distinct plc.lookup_code FROM '||
            ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
            ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
            ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
            ' and prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
            ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
            ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 3450

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3457

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3464

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 3475

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;   --

Line: 3511

	  /*l_query :=' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
            ' ( select min(to_number(lookup_code)) from ( '||
            ' SELECT lookup_code FROM po_lookup_codes '||
            ' WHERE to_number(lookup_code) BETWEEN '||
            ' (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
              x_min_value||'''and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
            ' and (SELECT to_number(lookup_code) FROM po_lookup_codes WHERE displayed_field='''||
              x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
            ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
            ' minus '||
            ' SELECT distinct plc.lookup_code FROM '||
            ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
            ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
            ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
            ' and prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
            ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
            ' AND lookup_type = ''PO_CLM_SERIAL_NUM_CONSTANTS'' ';*/

Line: 3530

         SELECT to_number(lookup_code)
         INTO min_code
         FROM fnd_lookup_values
         WHERE meaning = x_min_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3537

         SELECT to_number(lookup_code)
         INTO max_code
         FROM fnd_lookup_values
         WHERE meaning = x_max_value
         AND language = userenv ('LANG')
         AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';

Line: 3544

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND to_number(flv.lookup_code) between ' ||  min_code || ' AND ' || max_code ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 3555

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
         AND to_number(lookup_code) <= max_code;   --

Line: 3654

        select count(*) INTO l_cnt
        from PO_HEADERS_ALL_EXT_B
        WHERE C_EXT_ATTR40 = x_document_number
        AND  po_header_id <> x_order_header_id;

Line: 3828

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Base Document'
      AND puatu.attribute2='N';

Line: 3852

    SELECT PEI_INFORMATION3
    INTO x_call_order_number
    FROM per_people_extra_info pei, fnd_user fu
    WHERE pei.information_type = 'CLM_CONTACT_TITLE'
      AND pei.person_id= fu.employee_id
      AND fu.user_id = fnd_global.user_id;

Line: 3880

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR7))  '||
               ' FROM PO_HEADERS_ALL_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_source_doc_number||''' ' ||
               ' and C_EXT_ATTR2 ='''|| x_call_order_number ||''' ' ||
               ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
               ' and C_EXT_ATTR7 not like ''%X%'' ';

Line: 3960

        select count(*) INTO l_cnt
        from PO_HEADERS_ALL_EXT_B
        WHERE C_EXT_ATTR40 = x_document_number
        AND  po_header_id <> x_order_header_id;

Line: 4099

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1 ='Modification'
      AND puatu.attribute2='NA';

Line: 4119

    SELECT document_number INTO x_base_doc_number
    FROM pon_auction_headers_all
    WHERE auction_header_id = p_base_auction_header_id;

Line: 4141

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR7))  '||
               ' FROM PON_AUCTION_HEADERS_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
               ' and C_EXT_ATTR2 ='''||x_control_char||''' '||
               ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
               ' and C_EXT_ATTR7 not like ''%X%'' ';

Line: 4210

    select count(*) INTO l_cnt
    from PON_AUCTION_HEADERS_EXT_B
    WHERE C_EXT_ATTR40 = x_document_number
    AND  AUCTION_HEADER_ID <> p_auction_header_id;

Line: 4294

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Modification'
      AND puatu.attribute2='Y';

Line: 4315

    SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 4322

        SELECT lookup_code
        INTO x_modif_type
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_MODIFICATION_TYPE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 4367

    /*l_query := ' select displayed_field from po_lookup_codes where to_number(lookup_code) in'||
          ' ( select min(to_number(lookup_code)) from ( '||
          ' SELECT lookup_code FROM po_lookup_codes '||
          ' WHERE lookup_type='''||l_lookup_const||''' '||
          ' minus '||
          ' SELECT distinct plc.lookup_code FROM '||
          ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
          ' WHERE plc.lookup_type='''||l_lookup_const||''''||
          ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
          ' and prheb.C_EXT_ATTR1 = '''||x_base_doc_number ||''''||
          ' and prheb.C_EXT_ATTR2 = '''||x_control_char ||''''||
          ' and prheb.C_EXT_ATTR3 = '''||x_modif_type ||''''||
          ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||
          ' AND lookup_type = '''||l_lookup_const||''' ';*/

Line: 4383

         l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
                    ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
                    ' WHERE prheb.C_EXT_ATTR1 = '''||x_base_doc_number ||''''||
                    ' AND prheb.C_EXT_ATTR2 = '''||x_control_char ||''''||
                    ' AND prheb.C_EXT_ATTR3 = '''||x_modif_type ||''''||
                    ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
                    ' AND flv.lookup_type='''||l_lookup_const||''''||
                    ' AND flv.language = userenv (''LANG'')' ||
                    ' AND prheb.attr_group_id in (' || l_where_cls || ')';

Line: 4395

         SELECT meaning
         INTO x_serial_number
         FROM fnd_lookup_values
         WHERE lookup_type = l_lookup_const
         AND language = userenv ('LANG')
         AND to_number(lookup_code) = Nvl(l_lookup_code, 1); --

Line: 4462

    select count(*) INTO l_cnt
    from PO_HEADERS_ALL_EXT_B
    WHERE C_EXT_ATTR40 = x_document_number
    AND  draft_id <> p_draft_id
    AND po_header_id <> p_po_header_id;

Line: 4636

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Modification'
      AND puatu.attribute2='NA';

Line: 4659

    SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 4666

        SELECT lookup_code
        INTO x_modif_type
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_MODIFICATION_TYPE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 4685

        SELECT lookup_code
        INTO x_modif_code
        FROM (
            SELECT * FROM po_lookup_codes where lookup_type = 'PO_CLM_MODIFICATION_CODE'
                and enabled_flag = 'Y' and trunc(nvl(inactive_date, sysdate)) >= trunc(sysdate) order by lookup_code)
        WHERE ROWNUM=1;

Line: 4720

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR7))  '||
               ' FROM PO_HEADERS_ALL_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
               ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
               ' and C_EXT_ATTR7 not like ''%X%'' ';

Line: 4786

    select count(*) INTO l_cnt
    from PO_HEADERS_ALL_EXT_B
    WHERE C_EXT_ATTR40 = x_document_number
    AND  draft_id <> p_draft_id
    AND po_header_id <> p_po_header_id;

Line: 4874

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='Modification'
      AND puatu.attribute2='NA';

Line: 4901

    l_query :=' SELECT Max(To_Number(C_EXT_ATTR13))  '||
              ' FROM PO_HEADERS_ALL_EXT_B '||
              ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
              ' and C_EXT_ATTR10 = '''||x_modif_type||''' ' ||
              ' and ATTR_GROUP_ID in ('||l_where_cls||') ';

Line: 4920

   SELECT
      Nvl(po_core_s.Retrieveoptionvalue(org_id,
                     po_core_s.g_undef_cont_act_col),
          'N')
   INTO l_isUCAEnabled
   FROM   po_headers_merge_v
   WHERE  po_header_id = p_po_header_id
          AND draft_id = p_draft_id;

Line: 4930

        SELECT 'Z'
           INTO   l_uca_special_character
        FROM   po_line_ucas
        WHERE  po_header_id = p_po_header_id
          AND def_draft_id = p_draft_id
          AND ROWNUM = 1;

Line: 5018

   SELECT  END_USER_COLUMN_NAME
   FROM    FND_DESCR_FLEX_COLUMN_USAGES
   WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
   AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 5025

 SELECT puatu.ATTRIBUTE_GROUP_ID, ags.ATTR_GROUP_NAME
 INTO   l_attr_group_id, l_attr_group_name
 FROM PO_UDA_AG_TEMPLATE_USAGES puatu,
      po_uda_ag_templates puat,
      ego_attr_groups_v ags,
      po_headers_all_ext_b phaeb
 WHERE puat.ENTITY_CODE=p_ag_type
    AND phaeb.po_header_id = p_po_header_id
    AND phaeb.draft_id = p_po_draft_id
    AND phaeb.attr_group_id = puatu.attribute_group_id
    AND puat.document_level='HEADER'
    AND puat.template_id = p_uda_template_id
    AND puat.template_id = puatu.template_id
    AND puatu.attribute_category='DOCUMENT_NUMBERING'
    AND puatu.attribute1='Modification'
    AND puatu.attribute_group_id = ags.attr_group_id;

Line: 5141

  SELECT c_ext_attr40
  INTO l_doc_number
  FROM po_headers_all_ext_b
  WHERE po_header_id = p_po_header_id
  AND   draft_id = p_po_draft_id
  AND   attr_group_id = l_attr_group_id;

Line: 5148

  UPDATE po_drafts
  SET modification_number = l_doc_number
  WHERE draft_id = p_po_draft_id;

Line: 5154

  UPDATE po_line_ucas
  SET    undef_clm_document_number = l_doc_number
  WHERE  po_header_id = p_po_header_id
  AND    undef_draft_id = p_po_draft_id;

Line: 5183

  SELECT clm_document_number
  INTO l_source_doc_number
  FROM po_headers_all
  WHERE po_header_id = p_idv_number;

Line: 5190

    SELECT PEI_INFORMATION2
    INTO l_user_def_dodaac
    FROM per_people_extra_info pei, fnd_user fu
    WHERE pei.information_type = 'CLM_CONTACT_TITLE'
      AND pei.person_id= fu.employee_id
      AND fu.user_id = fnd_global.user_id;

Line: 5245

SELECT  END_USER_COLUMN_NAME
FROM    FND_DESCR_FLEX_COLUMN_USAGES
WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 5255

    SELECT uda_template_id, clm_source_document_id, org_id
    INTO l_template_id, l_clm_source_document_id, l_org_id
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 5264

      SELECT uda_template_id INTO l_template_id
      FROM po_headers_draft_all
      WHERE po_header_id = p_po_header_id
      AND   draft_id = p_draft_id;

Line: 5284

    SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
    INTO l_attrb_grp_id, l_attr_group_name
    FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
    WHERE usages.template_id = l_template_id
    AND usages.ATTRIBUTE1=l_context_usage
    AND usages.ATTRIBUTE2=l_source_org_owned
-- bug 13054072 Attribute3 needs to be added here as there may be records that have org_id as well as DEFAULT values in Attribute3 column
    AND usages.ATTRIBUTE3=To_Char(l_org_id)
    AND usages.ATTRIBUTE_CATEGORY='DOCUMENT_NUMBERING'
    AND usages.attribute_group_id = ags.attr_group_id;

Line: 5300

    SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
    INTO l_attrb_grp_id, l_attr_group_name
    FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
    WHERE usages.template_id = l_template_id
    AND usages.ATTRIBUTE1=l_context_usage
    AND usages.ATTRIBUTE2=l_source_org_owned
    AND usages.ATTRIBUTE3='DEFAULT'
    AND usages.ATTRIBUTE_CATEGORY='DOCUMENT_NUMBERING'
    AND usages.attribute_group_id = ags.attr_group_id;

Line: 5411

  SELECT MODIFICATION_NUMBER
  INTO l_latest_mod_number
  FROM po_drafts
  WHERE DRAFT_ID = (SELECT Max(DRAFT_ID)
                    FROM po_drafts
                    WHERE DOCUMENT_ID = p_document_id);

Line: 5429

    SELECT SEGMENT1
    INTO l_base_po_number
    FROM PO_HEADERS_ALL
    WHERE PO_HEADER_ID = p_document_id;

Line: 5476

    SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
    from PO_UDA_AG_TEMPLATE_USAGES puatu,
        po_uda_ag_templates puat
    WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
      AND puat.document_level='HEADER'
      AND puat.template_id = puatu.template_id
      AND puatu.attribute_category='DOCUMENT_NUMBERING'
      AND puatu.attribute1='PAR'
      AND puatu.attribute2='NA';

Line: 5509

    SELECT CLM_DOCUMENT_NUMBER, TYPE_LOOKUP_CODE, ORG_ID, CLM_SOURCE_DOCUMENT_ID, STYLE_ID
    INTO x_base_doc_number, x_doc_sub_type, x_org_id, l_src_doc_id, x_style_id
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 5517

        SELECT CLM_DOCUMENT_NUMBER
        INTO  x_source_doc_number
        FROM po_headers_all
        WHERE po_header_id = l_src_doc_id;

Line: 5564

    l_query := ' SELECT Max(To_Number(C_EXT_ATTR7))  '||
               ' FROM PO_HEADERS_ALL_EXT_B '||
               ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
               ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
               ' and C_EXT_ATTR7 not like ''%X%'' ';

Line: 5652

  UPDATE PON_BID_HEADERS
  SET    order_number = p_clm_document_number
  WHERE  po_header_id = p_document_id;

Line: 5657

    PO_LOG.stmt(d_module, d_progress, 'No. of records updated in PON_BID_HEADERS:  ', SQL%ROWCOUNT);

Line: 5662

  UPDATE PON_BID_ITEM_PRICES
  SET    order_number = p_clm_document_number
  WHERE  po_header_id = p_document_id;

Line: 5667

    PO_LOG.stmt(d_module, d_progress, 'No. of records updated in PON_BID_ITEM_PRICES:  ', SQL%ROWCOUNT);