APPS.QP_LIST_UPGRADE_UTIL_PVT SQL Statements

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

Line: 27

procedure insert_line_distribution
(
l_worker in number,
l_start_line  IN  Number,
l_end_line    IN  Number,
l_type_var    IN  Varchar2
)
is
Begin

       insert into qp_upg_lines_distribution
       (
           worker,
           start_line_id,
           end_line_id,
           alloted_flag,
           line_type,
           creation_date
       )
       values
       (
           l_worker,
           l_start_line,
           l_end_line,
           'N',
           l_type_var,
           sysdate
       );

Line: 56

end insert_line_distribution;

Line: 67

      select
          price_list_line_id
      from
          so_price_list_lines_115
      where  price_list_line_id not in ( select list_line_id
                                          from qp_LIST_lines )
      order by price_list_line_id;

Line: 90

      delete from qp_upg_lines_distribution
      where line_type = v_type;

Line: 96

                select
                     count(*),
                     nvl(min(price_list_line_id),0),
                     nvl(max(price_list_line_id),0)
                into
                     l_total_lines,
                     l_min_line,
                     l_max_line
                from
                     so_price_list_lines_115
                where  price_list_line_id not in ( select list_line_id
                                                from qp_LIST_lines );

Line: 117

                insert_line_distribution
                (
                    l_worker             => 1,
                    l_start_line  => l_min_line,
                    l_end_line    => l_max_line,
                    l_type_var         => 'PLL'
                );

Line: 150

                     insert_line_distribution
                     (
                       l_worker             => l_worker_count,
                       l_start_line  => l_min_line,
                       l_end_line    => l_max_line,
                       l_type_var         => 'PLL'
                     );

Line: 167

                     insert_line_distribution
                     (
                       l_worker             => l_worker_count,
                       l_start_line  => l_min_line,
                       l_end_line    => l_max_line,
                       l_type_var         => 'PLL'
                     );

Line: 202

      DELETE from
	 QP_UPG_LINES_DISTRIBUTION
	 where line_type = v_type;

Line: 209

                SELECT
                     NVL(MIN(PRICE_LIST_LINE_ID),0),
                     NVL(MAX(PRICE_LIST_LINE_ID),0)
                INTO
                     L_MIN_LINE,
                     L_MAX_LINE
                FROM
                     SO_PRICE_LIST_LINES_115;

Line: 236

                qp_modifier_upgrade_util_pvt.insert_line_distribution
                (
                    l_worker             => i,
                    l_start_line  => l_worker_start,
                    l_end_line    => l_worker_end,
                    l_type_var         => 'PLL'
                );

Line: 322

TYPE LAST_UPDATE_DATE_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line: 323

TYPE LAST_UPDATED_BY_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line: 324

TYPE LAST_UPDATE_LOGIN_TAB IS TABLE OF QP_LIST_HEADERS_B.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

Line: 362

LAST_UPDATE_DATE_T	LAST_UPDATE_DATE_TAB;

Line: 363

LAST_UPDATED_BY_T	LAST_UPDATED_BY_TAB;

Line: 364

LAST_UPDATE_LOGIN_T	LAST_UPDATE_LOGIN_TAB;

Line: 377

 SELECT COMMENTS,
        CONTEXT,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CURRENCY_CODE,
        SHIP_METHOD_CODE,
        FREIGHT_TERMS_CODE,
        PRICE_LIST_ID,
        START_DATE_ACTIVE,
        END_DATE_ACTIVE,
        TERMS_ID,
        ROUNDING_FACTOR,
        REQUEST_ID,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        --NAME,
        --DESCRIPTION,
        PRICE_LIST_ID,
        SECONDARY_PRICE_LIST_ID,
        NULL
FROM so_price_lists_b prl
WHERE not exists ( select 'x'
         	     from qp_discount_mapping dm
		     where dm.old_discount_id = prl.price_list_id
			and   dm.new_type in ('P','Z'))

AND  not exists ( select 'x'
			from qp_list_headers_b lh
			where lh.list_header_id = prl.price_list_id );

Line: 424

 SELECT COMMENTS,
        CONTEXT,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        CURRENCY_CODE,
        SHIP_METHOD_CODE,
        FREIGHT_TERMS_CODE,
        PRICE_LIST_ID,
        START_DATE_ACTIVE,
        END_DATE_ACTIVE,
        TERMS_ID,
        ROUNDING_FACTOR,
        REQUEST_ID,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        --NAME,
        --DESCRIPTION,
        PRICE_LIST_ID,
        SECONDARY_PRICE_LIST_ID,
        'AGR'
FROM SO_PRICE_LISTS_B PRL
WHERE PRL.PRICE_LIST_ID IN ( SELECT PRICE_LIST_ID
                         FROM SO_AGREEMENTS_B)
AND NOT EXISTS ( SELECT NULL
             FROM QP_DISCOUNT_MAPPING
             WHERE OLD_DISCOUNT_ID = PRL.PRICE_LIST_ID
             AND NEW_TYPE = 'P');

Line: 469

 SELECT price_list_id, secondary_price_list_id
   FROM so_price_lists_b spl
  WHERE secondary_price_list_id is not null
  and exists ( select list_header_id
               from qp_LIST_headers_b
               where list_header_id = spl.secondary_price_list_id )
  and exists ( select list_header_id
               from qp_LIST_headers_b
               where list_header_id = spl.price_list_id );

Line: 480

select price_list_id, secondary_price_list_id
from so_price_lists_b spl
where secondary_price_list_id is not null
and secondary_price_list_id not in ( select list_header_id
                                       from qp_LIST_headers_b );

Line: 487

select price_list_id
from so_price_lists_b
where price_list_id not in ( select list_header_id
                             from qp_LIST_headers_b );

Line: 530

        LAST_UPDATE_DATE_T,
        LAST_UPDATED_BY_T,
        LAST_UPDATE_LOGIN_T,
        --NAME_T,
        --DESCRIPTION_T,
        OLD_PRICE_LIST_ID_T,
        SEC_PRICE_LIST_ID_T,
        AGR_TYPE_T;

Line: 559

       select qp_list_headers_b_s.nextval
       into new_price_list_id
       from dual;

Line: 619

      INSERT
      INTO qp_LIST_headers_b
		(COMMENTS,
             CONTEXT,
             ATTRIBUTE1,
             ATTRIBUTE2,
             ATTRIBUTE3,
             ATTRIBUTE4,
             ATTRIBUTE5,
             ATTRIBUTE6,
             ATTRIBUTE7,
             ATTRIBUTE8,
             ATTRIBUTE9,
             ATTRIBUTE10,
             ATTRIBUTE11,
             ATTRIBUTE12,
             ATTRIBUTE13,
             ATTRIBUTE14,
             ATTRIBUTE15,
             CURRENCY_CODE,
             SHIP_METHOD_CODE,
             FREIGHT_TERMS_CODE,
             LIST_HEADER_ID,
             START_DATE_ACTIVE,
             END_DATE_ACTIVE,
             AUTOMATIC_FLAG,
             LIST_TYPE_CODE,
             TERMS_ID,
             ROUNDING_FACTOR,
             REQUEST_ID,
             CREATION_DATE,
             CREATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN,
             ASK_FOR_FLAG,
             SOURCE_SYSTEM_CODE,
             ACTIVE_FLAG)
      VALUES (COMMENTS_T(K),
           CONTEXT_T(K),
           ATTRIBUTE1_T(K),
           ATTRIBUTE2_T(K),
           ATTRIBUTE3_T(K),
           ATTRIBUTE4_T(K),
           ATTRIBUTE5_T(K),
           ATTRIBUTE6_T(K),
           ATTRIBUTE7_T(K),
           ATTRIBUTE8_T(K),
           ATTRIBUTE9_T(K),
           ATTRIBUTE10_T(K),
           ATTRIBUTE11_T(K),
           ATTRIBUTE12_T(K),
           ATTRIBUTE13_T(K),
           ATTRIBUTE14_T(K),
           ATTRIBUTE15_T(K),
           CURRENCY_T(K),
           SHIP_METHOD_CODE_T(K),
           FREIGHT_TERMS_CODE_T(K),
           PRICE_LIST_ID_T(K),
           START_DATE_ACTIVE_T(K),
           END_DATE_ACTIVE_T(K),
           'N',
           'PRL',
           TERMS_ID_T(K),
           ROUNDING_FACTOR_T(K),
           REQUEST_ID_T(K),
           CREATION_DATE_T(K),
           CREATED_BY_T(K),
           LAST_UPDATE_DATE_T(K),
           LAST_UPDATED_BY_T(K),
           LAST_UPDATE_LOGIN_T(K),
           'N',
           'QP',
           'Y');

Line: 708

      insert
	 into qp_LIST_HEADERS_TL
	     (LAST_UPDATE_LOGIN,
            NAME,
            DESCRIPTION,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LIST_HEADER_ID,
            LANGUAGE,
            SOURCE_LANG,
            VERSION_NO)
      select LAST_UPDATE_LOGIN_T(K),
           ptl.NAME,
           ptl.description,
           CREATION_DATE_T(K),
           CREATED_BY_T(K),
           LAST_UPDATE_DATE_T(K),
           LAST_UPDATED_BY_T(K),
           PRICE_LIST_ID_T(K),
           L.LANGUAGE_CODE,
           userenv('LANG'),
           '1'
      from so_price_lists_tl ptl,
           FND_LANGUAGES L
      where ptl.price_list_id = price_list_id_T(K)
	 and   ptl.language = l.language_code
	 and L.INSTALLED_FLAG in ('I', 'B')
  	 and NOT EXISTS (
					 SELECT NULL
  			     	 FROM   qp_list_headers_tl ptl
			           WHERE  ptl.list_header_id = price_list_id_T(K)
			           AND    ptl.language  = l.language_code);

Line: 756

  /* insert into qp_discount_mapping table for the rows that were
     just now inserted */

	--dbms_output.put_line('pr2.6');

Line: 771

         INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,
                                         OLD_DISCOUNT_LINE_ID,
		                         NEW_LIST_HEADER_ID,
                                         NEW_LIST_LINE_ID,
                                         OLD_PRICE_BREAK_LINES_LOW,
		                         OLD_PRICE_BREAK_LINES_HIGH,
                                         OLD_METHOD_TYPE_CODE,
                                         OLD_PRICE_BREAK_PERCENT,
		                         OLD_PRICE_BREAK_AMOUNT,
                                         OLD_PRICE_BREAK_PRICE,
                                         NEW_TYPE,
                                         PRICING_CONTEXT)
         VALUES (new_prc_list_maps(l_prc_list_map_index).old_price_list_id,
                NULL,
                new_prc_list_maps(l_prc_list_map_index).new_list_header_id,
                NULL,
		NULL,
                NULL,
                NULL,
                NULL,
		NULL,
                NULL,
                'P',
                NULL);

Line: 923

          INSERT INTO qp_QUALIFIERS (
		      QUALIFIER_ID,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
		      LAST_UPDATE_LOGIN,
                LIST_HEADER_ID,
                COMPARISON_OPERATOR_CODE,
                QUALIFIER_CONTEXT,
		      QUALIFIER_ATTRIBUTE,
                QUALIFIER_ATTR_VALUE,
                QUALIFIER_GROUPING_NO,
                EXCLUDER_FLAG,
			 QUALIFIER_DATATYPE,
			 QUALIFIER_PRECEDENCE,
			 QUALIFIER_ATTR_VALUE_TO
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,ORIG_SYS_QUALIFIER_REF
     ,ORIG_SYS_LINE_REF
     ,ORIG_SYS_HEADER_REF
     )
      select
		      QP_QUALIFIERS_S.nextval,
                sysdate,
                1,
                sysdate,
                1,
		      1,
                l_secondary_price_list_id,
                '=',
		      l_context,
                l_attribute,
                l_price_list_id,
                -1, -- for bug 2021623 qp_qualifier_group_no_s.nextval,
		      'N',
		      l_datatype,
		      l_precedence,
                NULL
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,to_char(QP_QUALIFIERS_S.currval)
     ,null
     ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)
                from dual
         WHERE NOT EXISTS ( select null
                            from qp_qualifiers
                            where qualifier_context = 'MODLIST'
                            and   qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
                            and   qualifier_attr_value = to_char(l_price_list_id)
                            and   comparison_operator_code = '='
--                            and   qualifier_grouping_no = -2
                            and   list_header_id = l_secondary_price_list_id
                            and   qualifier_rule_id is null
                            and  qualifier_attr_value_to is null );

Line: 998

              INSERT INTO qp_QUALIFIERS (
		      QUALIFIER_ID,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
		      LAST_UPDATE_LOGIN,
                LIST_HEADER_ID,
                COMPARISON_OPERATOR_CODE,
                QUALIFIER_CONTEXT,
		      QUALIFIER_ATTRIBUTE,
                QUALIFIER_ATTR_VALUE,
                QUALIFIER_GROUPING_NO,
                EXCLUDER_FLAG,
			 QUALIFIER_DATATYPE,
			 QUALIFIER_PRECEDENCE,
			 QUALIFIER_ATTR_VALUE_TO)
               select
		      QP_QUALIFIERS_S.nextval,
                sysdate,
                1,
                sysdate,
                1,
		      1,
                prc_list_maps(l_price_list_id).secondary_price_list_id,
                '=',
		      l_context,
                l_attribute,
                prc_list_maps(l_price_list_id).new_list_header_id,
                qp_qualifier_group_no_s.nextval,
		      'N',
		      l_datatype,
		      l_precedence,
                NULL
                from dual
         WHERE NOT EXISTS ( select null
                            from qp_qualifiers
                            where qualifier_context = 'MODLIST'
                            and   qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
                            and   qualifier_attr_value = prc_list_maps(l_price_list_id).new_list_header_id
                            and   comparison_operator_code = '='
                            and   qualifier_grouping_no = -2
                            and   list_header_id = prc_list_maps(l_price_list_id).secondary_price_list_id
                            and   qualifier_rule_id is null
                            and  qualifier_attr_value_to is null );

Line: 1185

TYPE last_update_date_tab is table of
        SO_PRICE_LIST_LINES_115.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line: 1187

TYPE last_updated_by_tab is table of
        SO_PRICE_LIST_LINES_115.last_updated_by%TYPE INDEX BY BINARY_INTEGER;

Line: 1189

TYPE last_update_login_tab is table of
        SO_PRICE_LIST_LINES_115.last_update_login%TYPE INDEX BY BINARY_INTEGER;

Line: 1194

TYPE program_update_date_tab is table of
        SO_PRICE_LIST_LINES_115.program_update_date%TYPE INDEX BY BINARY_INTEGER;

Line: 1265

type attr_last_update_date_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line: 1266

type attr_last_updated_by_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line: 1267

type attr_last_update_login_tab is table of QP_PRICING_ATTRIBUTES.LAST_UPDATE_LOGIN%TYPE INDEX BY BINARY_INTEGER;

Line: 1270

type attr_program_update_date_tab is table of QP_PRICING_ATTRIBUTES.PROGRAM_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line: 1294

last_update_dates		last_update_date_tab;

Line: 1295

last_updated_bys		last_updated_by_tab;

Line: 1296

last_update_logins		last_update_login_tab;

Line: 1299

program_update_dates		program_update_date_tab;

Line: 1347

attr_last_update_dates          attr_last_update_date_tab;

Line: 1348

attr_last_updated_bys           attr_last_updated_by_tab;

Line: 1349

attr_last_update_logins         attr_last_update_login_tab;

Line: 1352

attr_program_update_dates       attr_program_update_date_tab;

Line: 1381

 SELECT
  price_list_line_id,
  creation_date,
  created_by,
  last_update_date,
  last_updated_by,
  last_update_login,
  program_application_id,
  program_id,
  program_update_date,
  request_id,
  price_list_id,
  inventory_item_id,
  unit_code,
  method_code,
  list_price,
  pricing_rule_id,
  reprice_flag,
  pricing_context,
  pricing_attribute1,
  pricing_attribute2,
  pricing_attribute3,
  pricing_attribute4,
  pricing_attribute5,
  pricing_attribute6,
  pricing_attribute7,
  pricing_attribute8,
  pricing_attribute9,
  pricing_attribute10,
  pricing_attribute11,
  pricing_attribute12,
  pricing_attribute13,
  pricing_attribute14,
  pricing_attribute15,
  start_date_active,
  end_date_active,
  context,
  attribute1,
  attribute2,
  attribute3,
  attribute4,
  attribute5,
  attribute6,
  attribute7,
  attribute8,
  attribute9,
  attribute10,
  attribute11,
  attribute12,
  attribute13,
  attribute14,
  attribute15,
  price_list_line_id,
  NULL,
  3
from so_price_list_lines_115 prl
where prl.price_list_id in ( select list_header_id
                             from qp_LIST_headers_b
                             where list_type_code = 'PRL')
and not exists ( select null
                 from qp_LIST_lines
                 where list_line_id = prl.price_list_line_id )
and prl.price_list_line_id between l_min_line and l_max_line;

Line: 1448

SELECT
  prl.price_list_line_id,
  prl.creation_date,
  prl.created_by,
  prl.last_update_date,
  prl.last_updated_by,
  prl.last_update_login,
  prl.program_application_id,
  prl.program_id,
  prl.program_update_date,
  prl.request_id,
  prl.price_list_id,
  prl.inventory_item_id,
  prl.unit_code,
  prl.method_code,
  prl.list_price,
  prl.pricing_rule_id,
  prl.reprice_flag,
  prl.pricing_context,
  prl.pricing_attribute1,
  prl.pricing_attribute2,
  prl.pricing_attribute3,
  prl.pricing_attribute4,
  prl.pricing_attribute5,
  prl.pricing_attribute6,
  prl.pricing_attribute7,
  prl.pricing_attribute8,
  prl.pricing_attribute9,
  prl.pricing_attribute10,
  prl.pricing_attribute11,
  prl.pricing_attribute12,
  prl.pricing_attribute13,
  prl.pricing_attribute14,
  prl.pricing_attribute15,
  prl.start_date_active,
  prl.end_date_active,
  prl.context,
  prl.attribute1,
  prl.attribute2,
  prl.attribute3,
  prl.attribute4,
  prl.attribute5,
  prl.attribute6,
  prl.attribute7,
  prl.attribute8,
  prl.attribute9,
  prl.attribute10,
  prl.attribute11,
  prl.attribute12,
  prl.attribute13,
  prl.attribute14,
  prl.attribute15,
  prl.price_list_line_id,
  'AGR',
  3
from qp_list_headers_b qph,
     so_price_list_lines_115 prl
where prl.price_list_id = qph.list_header_id
and prl.price_list_id in ( select price_list_id
                           from so_agreements_b)
and not exists ( select null
                 from qp_LIST_lines
                 where list_line_id = prl.price_list_line_id )
comment start
and not exists ( select null
                 from qp_discount_mapping
                 where old_discount_line_id = prl.price_list_line_id
                 and new_type = 'P')
comment end
and prl.price_list_line_id between l_min_line and l_max_line;

Line: 1524

select distinct price_list_id
from so_agreements_b;

Line: 1528

select old_discount_id, new_list_header_id
from qp_discount_mapping
where new_type = 'P'
and old_discount_line_id is null;

Line: 1536

 SELECT DISTINCT secondary_price_list_id
   FROM SO_PRICE_LISTS_B where secondary_price_list_id IS NOT NULL;

Line: 1592

     select start_line_id,
            end_line_id
     into v_min_line,
          v_max_line
     from qp_upg_lines_distribution
     where worker = l_worker
	and line_type = 'PLL';

Line: 1680

  last_update_dates,
  last_updated_bys,
  last_update_logins,
  program_application_ids,
  program_ids,
  program_update_dates,
  request_ids,
  price_list_ids,
  inventory_item_ids,
  unit_codes,
  method_codes,
  list_prices,
  pricing_rule_ids,
  reprice_flags,
  pricing_contexts,
  pricing_attribute1s,
  pricing_attribute2s,
  pricing_attribute3s,
  pricing_attribute4s,
  pricing_attribute5s,
  pricing_attribute6s,
  pricing_attribute7s,
  pricing_attribute8s,
  pricing_attribute9s,
  pricing_attribute10s,
  pricing_attribute11s,
  pricing_attribute12s,
  pricing_attribute13s,
  pricing_attribute14s,
  pricing_attribute15s,
  start_date_actives,
  end_date_actives,
  contexts,
  attribute1s,
  attribute2s,
  attribute3s,
  attribute4s,
  attribute5s,
  attribute6s,
  attribute7s,
  attribute8s,
  attribute9s,
  attribute10s,
  attribute11s,
  attribute12s,
  attribute13s,
  attribute14s,
  attribute15s,
  old_price_list_line_ids,
  agr_types,
  qualification_ind;

Line: 1763

        select qp_list_lines_s.nextval
        into new_prc_list_line_id
        from dual;

Line: 1820

  insert into qp_LIST_lines(
  LIST_LINE_ID,
  LIST_LINE_NO,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN,
  PROGRAM_APPLICATION_ID,
  PROGRAM_ID,
  PROGRAM_UPDATE_DATE,
  REQUEST_ID,
  LIST_HEADER_ID,
  LIST_LINE_TYPE_CODE,
  START_DATE_ACTIVE, /* START_DATE_EFFECTIVE */
  END_DATE_ACTIVE,   /* END_DATE_EFFECTIVE */
  AUTOMATIC_FLAG,
  MODIFIER_LEVEL_CODE,
  LIST_PRICE,
  LIST_PRICE_UOM_CODE,
  PRIMARY_UOM_FLAG,
  INVENTORY_ITEM_ID,
  ORGANIZATION_ID,
  RELATED_ITEM_ID,
  RELATIONSHIP_TYPE_ID,
  SUBSTITUTION_CONTEXT,
  SUBSTITUTION_ATTRIBUTE,
  SUBSTITUTION_VALUE,
  REVISION,
  REVISION_DATE,
  REVISION_REASON_CODE,
  CONTEXT,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15,
  COMMENTS,
  PRICE_BREAK_TYPE_CODE,
  PERCENT_PRICE,
  EFFECTIVE_PERIOD_UOM,
  NUMBER_EFFECTIVE_PERIODS,
  OPERAND,
  ARITHMETIC_OPERATOR,
  OVERRIDE_FLAG,
  PRINT_ON_INVOICE_FLAG,
  REBATE_TRANSACTION_TYPE_CODE,
  ESTIM_ACCRUAL_RATE,
  PRICE_BY_FORMULA_ID,
  GENERATE_USING_FORMULA_ID,
  PRICING_PHASE_ID,
  PRICING_GROUP_SEQUENCE,
  ACCRUAL_FLAG,
  PRODUCT_PRECEDENCE,
  INCOMPATIBILITY_GRP_CODE,
  QUALIFICATION_IND
  --ENH Upgrade BOAPI for orig_sys...ref RAVI
  ,ORIG_SYS_LINE_REF
  ,ORIG_SYS_HEADER_REF
  )
values(
  price_list_line_ids(K),
  price_list_line_ids(K),
  creation_dates(K),
  created_bys(K),
  last_update_dates(K),
  last_updated_bys(K),
  last_update_logins(K),
  program_application_ids(K),
  program_ids(K),
  program_update_dates(K),
  request_ids(K),
  price_list_ids(K),
  'PLL',
  start_date_actives(K), /* no need to do nvl */
  end_date_actives(K),
  'Y',
  'LINE',
  DECODE(method_codes(K), 'AMNT',list_prices(K),NULL),
  unit_codes(K),
  l_primary_uom_flag,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  NULL,
  contexts(K),
  attribute1s(K),
  attribute2s(K),
  attribute3s(K),
  attribute4s(K),
  attribute5s(K),
  attribute6s(K),
  attribute7s(K),
  attribute8s(K),
  attribute9s(K),
  attribute10s(K),
  attribute11s(K),
  attribute12s(K),
  attribute13s(K),
  attribute14s(K),
  attribute15s(K),
  NULL,
  NULL,
  DECODE(method_codes(K), 'PERC', list_prices(K), NULL),
  NULL,
  NULL,
  list_prices(K),
  DECODE(method_codes(K), 'PERC', 'PERCENT_PRICE',
								'AMNT', 'UNIT_PRICE', NULL),
  NULL,
  'N',
  NULL,
  NULL,
  NULL,
  pricing_rule_ids(K),
  1,
  0,
  'N',
  l_prod_precedence,
  'EXCL',
  qualification_ind(k)
  --ENH Upgrade BOAPI for orig_sys...ref RAVI
  ,to_char(price_list_line_ids(K))
  ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=price_list_ids(K))
 );

Line: 1983

    /* delete the attr_ tables */

        attr_creation_dates.delete;

Line: 1986

        attr_created_bys.delete;

Line: 1987

        attr_last_update_dates.delete;

Line: 1988

        attr_last_updated_bys.delete;

Line: 1989

        attr_last_update_logins.delete;

Line: 1990

        attr_program_application_ids.delete;

Line: 1991

        attr_program_ids.delete;

Line: 1992

        attr_program_update_dates.delete;

Line: 1993

        attr_request_ids.delete;

Line: 1994

        attr_list_line_ids.delete;

Line: 1995

        attr_excluder_flags.delete;

Line: 1996

        attr_accumulate_flags.delete;

Line: 1997

        attr_product_attr_contexts.delete;

Line: 1998

        attr_product_attributes.delete;

Line: 1999

        attr_product_attr_values.delete;

Line: 2000

        attr_product_uom_codes.delete;

Line: 2001

        attr_comparison_operator_codes.delete;

Line: 2002

        attr_pricing_contexts.delete;

Line: 2003

        attr_pricing_attrs.delete;

Line: 2004

        attr_pricing_attr_value_froms.delete;

Line: 2005

        attr_pricing_attr_value_tos.delete;

Line: 2006

        prc_datatypes.delete;

Line: 2019

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2020

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2021

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2024

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2064

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2065

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2066

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2069

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2097

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2098

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2099

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2102

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2150

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2151

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2152

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2155

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2204

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2205

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2206

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2209

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2257

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2258

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2259

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2262

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2310

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2311

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2312

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2315

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2363

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2364

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2365

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2368

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2416

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2417

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2418

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2421

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2469

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2470

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2471

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2474

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2522

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2523

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2524

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2527

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2575

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2576

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2577

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2580

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2628

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2629

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2630

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2633

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2679

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2680

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2681

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2684

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2730

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2731

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2732

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2735

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2783

        attr_last_update_dates(attr_count) := last_update_dates(K);

Line: 2784

        attr_last_updated_bys(attr_count) := last_updated_bys(K);

Line: 2785

        attr_last_update_logins(attr_count) := last_update_logins(K);

Line: 2788

        attr_program_update_dates(attr_count) := program_update_dates(K);

Line: 2838

 INSERT INTO QP_PRICING_ATTRIBUTES
 (PRICING_ATTRIBUTE_ID,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN,
  PROGRAM_APPLICATION_ID,
  PROGRAM_ID,
  PROGRAM_UPDATE_DATE,
  REQUEST_ID,
  LIST_LINE_ID,
  EXCLUDER_FLAG,
  ACCUMULATE_FLAG,
  PRODUCT_ATTRIBUTE_CONTEXT,
  PRODUCT_ATTRIBUTE,
  PRODUCT_ATTR_VALUE,
  PRODUCT_UOM_CODE,
  PRICING_ATTRIBUTE_CONTEXT,
  PRICING_ATTRIBUTE,
  PRICING_ATTR_VALUE_FROM,
  PRICING_ATTR_VALUE_TO,
  ATTRIBUTE_GROUPING_NO,
  COMPARISON_OPERATOR_CODE,
  PRICING_ATTRIBUTE_DATATYPE,
  PRODUCT_ATTRIBUTE_DATATYPE
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,ORIG_SYS_PRICING_ATTR_REF
     ,ORIG_SYS_LINE_REF
     ,ORIG_SYS_HEADER_REF)
  VALUES
  (
   QP_PRICING_ATTRIBUTES_S.nextval,
   attr_creation_dates(J),
   attr_created_bys(J),
   attr_last_update_dates(J),
   attr_last_updated_bys(J),
   attr_last_update_logins(J),
   attr_program_application_ids(J),
   attr_program_ids(J),
   attr_program_update_dates(J),
   attr_request_ids(J),
   attr_list_line_ids(J),
   attr_excluder_flags(J),
   attr_accumulate_flags(J),
   attr_product_attr_contexts(J),
   attr_product_attributes(J),
   attr_product_attr_values(J),
   attr_product_uom_codes(J),
   attr_pricing_contexts(J),
   attr_pricing_attrs(J),
   attr_pricing_attr_value_froms(J),
   attr_pricing_attr_value_tos(J),
   1 ,
   attr_comparison_operator_codes(J),
   prc_datatypes(J),
   l_prod_datatype
     --ENH Upgrade BOAPI for orig_sys...ref RAVI
     ,to_char(QP_PRICING_ATTRIBUTES_S.currval)
     ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
     ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=attr_list_line_ids(J))
   );

Line: 2921

  /* insert into qp_discount_mapping table for the rows that were
     just now inserted */

--    qp_util.log_error(NULL, NULL, NULL, NULL, NULL, NULL, NULL,
--			    NULL, 'MAIN-8', v_errortext, 'PRICE_LISTS');

Line: 2930

         INSERT INTO QP_DISCOUNT_MAPPING(OLD_DISCOUNT_ID,
                                         OLD_DISCOUNT_LINE_ID,
		                         NEW_LIST_HEADER_ID,
                                         NEW_LIST_LINE_ID,
                                         OLD_PRICE_BREAK_LINES_LOW,
		                         OLD_PRICE_BREAK_LINES_HIGH,
                                         OLD_METHOD_TYPE_CODE,
                                         OLD_PRICE_BREAK_PERCENT,
		                         OLD_PRICE_BREAK_AMOUNT,
                                         OLD_PRICE_BREAK_PRICE,
                                         NEW_TYPE,
                                         PRICING_CONTEXT)
         VALUES (new_prc_list_maps(l_prc_list_map_index).old_price_list_id,
                new_prc_list_maps(l_prc_list_map_index).old_price_list_line_id,
                new_prc_list_maps(l_prc_list_map_index).new_list_header_id,
                new_prc_list_maps(l_prc_list_map_index).new_list_line_id,
		NULL,
                NULL,
                NULL,
                NULL,
		NULL,
                NULL,
                'P',
                NULL);

Line: 2968

/* vivek   prc_list_maps.delete;  vivek */