The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT distinct ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
, orig_sys_discount_ref
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
-- , INVOICED_AMOUNT
, LOCK_CONTROL
INTO
x_header_adj_rec.ATTRIBUTE1
,x_header_adj_rec.ATTRIBUTE10
,x_header_adj_rec.ATTRIBUTE11
,x_header_adj_rec.ATTRIBUTE12
,x_header_adj_rec.ATTRIBUTE13
,x_header_adj_rec.ATTRIBUTE14
,x_header_adj_rec.ATTRIBUTE15
,x_header_adj_rec.ATTRIBUTE2
,x_header_adj_rec.ATTRIBUTE3
,x_header_adj_rec.ATTRIBUTE4
,x_header_adj_rec.ATTRIBUTE5
,x_header_adj_rec.ATTRIBUTE6
,x_header_adj_rec.ATTRIBUTE7
,x_header_adj_rec.ATTRIBUTE8
,x_header_adj_rec.ATTRIBUTE9
,x_header_adj_rec.AUTOMATIC_FLAG
,x_header_adj_rec.CONTEXT
,x_header_adj_rec.CREATED_BY
,x_header_adj_rec.CREATION_DATE
,x_header_adj_rec.DISCOUNT_ID
,x_header_adj_rec.DISCOUNT_LINE_ID
,x_header_adj_rec.HEADER_ID
,x_header_adj_rec.LAST_UPDATED_BY
,x_header_adj_rec.LAST_UPDATE_DATE
,x_header_adj_rec.LAST_UPDATE_LOGIN
,x_header_adj_rec.LINE_ID
,x_header_adj_rec.PERCENT
,x_header_adj_rec.PRICE_ADJUSTMENT_ID
,x_header_adj_rec.PROGRAM_APPLICATION_ID
,x_header_adj_rec.PROGRAM_ID
,x_header_adj_rec.PROGRAM_UPDATE_DATE
,x_header_adj_rec.REQUEST_ID
,x_header_adj_rec.LIST_HEADER_ID
,x_header_adj_rec.LIST_LINE_ID
,x_header_adj_rec.LIST_LINE_TYPE_CODE
,x_header_adj_rec.MODIFIER_MECHANISM_TYPE_CODE
,x_header_adj_rec.MODIFIED_FROM
,x_header_adj_rec.MODIFIED_TO
,x_header_adj_rec.UPDATED_FLAG
,x_header_adj_rec.UPDATE_ALLOWED
,x_header_adj_rec.APPLIED_FLAG
,x_header_adj_rec.CHANGE_REASON_CODE
,x_header_adj_rec.CHANGE_REASON_TEXT
,x_header_adj_rec.operand
,x_header_adj_rec.arithmetic_operator
,x_header_adj_rec.COST_ID
,x_header_adj_rec.TAX_CODE
,x_header_adj_rec.TAX_EXEMPT_FLAG
,x_header_adj_rec.TAX_EXEMPT_NUMBER
,x_header_adj_rec.TAX_EXEMPT_REASON_CODE
,x_header_adj_rec.PARENT_ADJUSTMENT_ID
,x_header_adj_rec.INVOICED_FLAG
,x_header_adj_rec.ESTIMATED_FLAG
,x_header_adj_rec.INC_IN_SALES_PERFORMANCE
,x_header_adj_rec.SPLIT_ACTION_CODE
,x_header_adj_rec.ADJUSTED_AMOUNT
,x_header_adj_rec.PRICING_PHASE_ID
,x_header_adj_rec.CHARGE_TYPE_CODE
,x_header_adj_rec.CHARGE_SUBTYPE_CODE
,x_header_adj_rec.list_line_no
,x_header_adj_rec.source_system_code
,x_header_adj_rec.benefit_qty
,x_header_adj_rec.benefit_uom_code
,x_header_adj_rec.print_on_invoice_flag
,x_header_adj_rec.expiration_date
,x_header_adj_rec.rebate_transaction_type_code
,x_header_adj_rec.rebate_transaction_reference
,x_header_adj_rec.rebate_payment_system_code
,x_header_adj_rec.redeemed_date
,x_header_adj_rec.redeemed_flag
,x_header_adj_rec.accrual_flag
,x_header_adj_rec.range_break_quantity
,x_header_adj_rec.accrual_conversion_rate
,x_header_adj_rec.pricing_group_sequence
,x_header_adj_rec.modifier_level_code
,x_header_adj_rec.price_break_type_code
,x_header_adj_rec.substitution_attribute
,x_header_adj_rec.proration_type_code
,x_header_adj_rec.CREDIT_OR_CHARGE_FLAG
,x_header_adj_rec.INCLUDE_ON_RETURNS_FLAG
,x_header_adj_rec.AC_ATTRIBUTE1
,x_header_adj_rec.AC_ATTRIBUTE10
,x_header_adj_rec.AC_ATTRIBUTE11
,x_header_adj_rec.AC_ATTRIBUTE12
,x_header_adj_rec.AC_ATTRIBUTE13
,x_header_adj_rec.AC_ATTRIBUTE14
,x_header_adj_rec.AC_ATTRIBUTE15
,x_header_adj_rec.AC_ATTRIBUTE2
,x_header_adj_rec.AC_ATTRIBUTE3
,x_header_adj_rec.AC_ATTRIBUTE4
,x_header_adj_rec.AC_ATTRIBUTE5
,x_header_adj_rec.AC_ATTRIBUTE6
,x_header_adj_rec.AC_ATTRIBUTE7
,x_header_adj_rec.AC_ATTRIBUTE8
,x_header_adj_rec.AC_ATTRIBUTE9
,x_header_adj_rec.AC_CONTEXT
,x_header_adj_rec.orig_sys_discount_ref
,x_header_adj_rec.OPERAND_PER_PQTY
,x_header_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
-- ,x_header_adj_rec.INVOICED_AMOUNT
,x_header_adj_rec.LOCK_CONTROL
FROM OE_PRICE_ADJS_HISTORY
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
and HEADER_ID = p_header_id
AND LINE_ID IS NULL
and version_number = p_version
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
SELECT distinct ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
, orig_sys_discount_ref
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
-- , INVOICED_AMOUNT
, LOCK_CONTROL
INTO
x_header_adj_rec.ATTRIBUTE1
,x_header_adj_rec.ATTRIBUTE10
,x_header_adj_rec.ATTRIBUTE11
,x_header_adj_rec.ATTRIBUTE12
,x_header_adj_rec.ATTRIBUTE13
,x_header_adj_rec.ATTRIBUTE14
,x_header_adj_rec.ATTRIBUTE15
,x_header_adj_rec.ATTRIBUTE2
,x_header_adj_rec.ATTRIBUTE3
,x_header_adj_rec.ATTRIBUTE4
,x_header_adj_rec.ATTRIBUTE5
,x_header_adj_rec.ATTRIBUTE6
,x_header_adj_rec.ATTRIBUTE7
,x_header_adj_rec.ATTRIBUTE8
,x_header_adj_rec.ATTRIBUTE9
,x_header_adj_rec.AUTOMATIC_FLAG
,x_header_adj_rec.CONTEXT
,x_header_adj_rec.CREATED_BY
,x_header_adj_rec.CREATION_DATE
,x_header_adj_rec.DISCOUNT_ID
,x_header_adj_rec.DISCOUNT_LINE_ID
,x_header_adj_rec.HEADER_ID
,x_header_adj_rec.LAST_UPDATED_BY
,x_header_adj_rec.LAST_UPDATE_DATE
,x_header_adj_rec.LAST_UPDATE_LOGIN
,x_header_adj_rec.LINE_ID
,x_header_adj_rec.PERCENT
,x_header_adj_rec.PRICE_ADJUSTMENT_ID
,x_header_adj_rec.PROGRAM_APPLICATION_ID
,x_header_adj_rec.PROGRAM_ID
,x_header_adj_rec.PROGRAM_UPDATE_DATE
,x_header_adj_rec.REQUEST_ID
,x_header_adj_rec.LIST_HEADER_ID
,x_header_adj_rec.LIST_LINE_ID
,x_header_adj_rec.LIST_LINE_TYPE_CODE
,x_header_adj_rec.MODIFIER_MECHANISM_TYPE_CODE
,x_header_adj_rec.MODIFIED_FROM
,x_header_adj_rec.MODIFIED_TO
,x_header_adj_rec.UPDATED_FLAG
,x_header_adj_rec.UPDATE_ALLOWED
,x_header_adj_rec.APPLIED_FLAG
,x_header_adj_rec.CHANGE_REASON_CODE
,x_header_adj_rec.CHANGE_REASON_TEXT
,x_header_adj_rec.operand
,x_header_adj_rec.arithmetic_operator
,x_header_adj_rec.COST_ID
,x_header_adj_rec.TAX_CODE
,x_header_adj_rec.TAX_EXEMPT_FLAG
,x_header_adj_rec.TAX_EXEMPT_NUMBER
,x_header_adj_rec.TAX_EXEMPT_REASON_CODE
,x_header_adj_rec.PARENT_ADJUSTMENT_ID
,x_header_adj_rec.INVOICED_FLAG
,x_header_adj_rec.ESTIMATED_FLAG
,x_header_adj_rec.INC_IN_SALES_PERFORMANCE
,x_header_adj_rec.SPLIT_ACTION_CODE
,x_header_adj_rec.ADJUSTED_AMOUNT
,x_header_adj_rec.PRICING_PHASE_ID
,x_header_adj_rec.CHARGE_TYPE_CODE
,x_header_adj_rec.CHARGE_SUBTYPE_CODE
,x_header_adj_rec.list_line_no
,x_header_adj_rec.source_system_code
,x_header_adj_rec.benefit_qty
,x_header_adj_rec.benefit_uom_code
,x_header_adj_rec.print_on_invoice_flag
,x_header_adj_rec.expiration_date
,x_header_adj_rec.rebate_transaction_type_code
,x_header_adj_rec.rebate_transaction_reference
,x_header_adj_rec.rebate_payment_system_code
,x_header_adj_rec.redeemed_date
,x_header_adj_rec.redeemed_flag
,x_header_adj_rec.accrual_flag
,x_header_adj_rec.range_break_quantity
,x_header_adj_rec.accrual_conversion_rate
,x_header_adj_rec.pricing_group_sequence
,x_header_adj_rec.modifier_level_code
,x_header_adj_rec.price_break_type_code
,x_header_adj_rec.substitution_attribute
,x_header_adj_rec.proration_type_code
,x_header_adj_rec.CREDIT_OR_CHARGE_FLAG
,x_header_adj_rec.INCLUDE_ON_RETURNS_FLAG
,x_header_adj_rec.AC_ATTRIBUTE1
,x_header_adj_rec.AC_ATTRIBUTE10
,x_header_adj_rec.AC_ATTRIBUTE11
,x_header_adj_rec.AC_ATTRIBUTE12
,x_header_adj_rec.AC_ATTRIBUTE13
,x_header_adj_rec.AC_ATTRIBUTE14
,x_header_adj_rec.AC_ATTRIBUTE15
,x_header_adj_rec.AC_ATTRIBUTE2
,x_header_adj_rec.AC_ATTRIBUTE3
,x_header_adj_rec.AC_ATTRIBUTE4
,x_header_adj_rec.AC_ATTRIBUTE5
,x_header_adj_rec.AC_ATTRIBUTE6
,x_header_adj_rec.AC_ATTRIBUTE7
,x_header_adj_rec.AC_ATTRIBUTE8
,x_header_adj_rec.AC_ATTRIBUTE9
,x_header_adj_rec.AC_CONTEXT
,x_header_adj_rec.orig_sys_discount_ref
,x_header_adj_rec.OPERAND_PER_PQTY
,x_header_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
-- ,x_header_adj_rec.INVOICED_AMOUNT
,x_header_adj_rec.LOCK_CONTROL
FROM OE_PRICE_ADJUSTMENTS
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
and HEADER_ID = p_header_id AND LINE_ID IS NULL ;
oe_debug_pub.add(' before finding deleted new_modifier_list');
x_header_adj_changed_attr_tbl(ind).current_value := 'DELETE';
x_header_adj_changed_attr_tbl(ind).next_value := 'DELETE';
SELECT distinct price_adjustment_id
from oe_price_adjs_history
where header_id = p_header_id
and line_id is null
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version)
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL -- it will be null for TAX and COST
union
SELECT price_adjustment_id
from oe_price_adjustments
where header_id=p_header_id
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL
and line_id is null;
SELECT distinct price_adjustment_id
from oe_price_adjs_history
where header_id = p_header_id
and line_id is null
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version);
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, line_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
, orig_sys_discount_ref
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
-- , INVOICED_AMOUNT
, LOCK_CONTROL
INTO
x_line_adj_rec.ATTRIBUTE1
,x_line_adj_rec.ATTRIBUTE10
,x_line_adj_rec.ATTRIBUTE11
,x_line_adj_rec.ATTRIBUTE12
,x_line_adj_rec.ATTRIBUTE13
,x_line_adj_rec.ATTRIBUTE14
,x_line_adj_rec.ATTRIBUTE15
,x_line_adj_rec.ATTRIBUTE2
,x_line_adj_rec.ATTRIBUTE3
,x_line_adj_rec.ATTRIBUTE4
,x_line_adj_rec.ATTRIBUTE5
,x_line_adj_rec.ATTRIBUTE6
,x_line_adj_rec.ATTRIBUTE7
,x_line_adj_rec.ATTRIBUTE8
,x_line_adj_rec.ATTRIBUTE9
,x_line_adj_rec.AUTOMATIC_FLAG
,x_line_adj_rec.CONTEXT
,x_line_adj_rec.CREATED_BY
,x_line_adj_rec.CREATION_DATE
,x_line_adj_rec.DISCOUNT_ID
,x_line_adj_rec.DISCOUNT_LINE_ID
,x_line_adj_rec.line_ID
,x_line_adj_rec.LAST_UPDATED_BY
,x_line_adj_rec.LAST_UPDATE_DATE
,x_line_adj_rec.LAST_UPDATE_LOGIN
,x_line_adj_rec.LINE_ID
,x_line_adj_rec.PERCENT
,x_line_adj_rec.PRICE_ADJUSTMENT_ID
,x_line_adj_rec.PROGRAM_APPLICATION_ID
,x_line_adj_rec.PROGRAM_ID
,x_line_adj_rec.PROGRAM_UPDATE_DATE
,x_line_adj_rec.REQUEST_ID
,x_line_adj_rec.LIST_HEADER_ID
,x_line_adj_rec.LIST_LINE_ID
,x_line_adj_rec.LIST_LINE_TYPE_CODE
,x_line_adj_rec.MODIFIER_MECHANISM_TYPE_CODE
,x_line_adj_rec.MODIFIED_FROM
,x_line_adj_rec.MODIFIED_TO
,x_line_adj_rec.UPDATED_FLAG
,x_line_adj_rec.UPDATE_ALLOWED
,x_line_adj_rec.APPLIED_FLAG
,x_line_adj_rec.CHANGE_REASON_CODE
,x_line_adj_rec.CHANGE_REASON_TEXT
,x_line_adj_rec.operand
,x_line_adj_rec.arithmetic_operator
,x_line_adj_rec.COST_ID
,x_line_adj_rec.TAX_CODE
,x_line_adj_rec.TAX_EXEMPT_FLAG
,x_line_adj_rec.TAX_EXEMPT_NUMBER
,x_line_adj_rec.TAX_EXEMPT_REASON_CODE
,x_line_adj_rec.PARENT_ADJUSTMENT_ID
,x_line_adj_rec.INVOICED_FLAG
,x_line_adj_rec.ESTIMATED_FLAG
,x_line_adj_rec.INC_IN_SALES_PERFORMANCE
,x_line_adj_rec.SPLIT_ACTION_CODE
,x_line_adj_rec.ADJUSTED_AMOUNT
,x_line_adj_rec.PRICING_PHASE_ID
,x_line_adj_rec.CHARGE_TYPE_CODE
,x_line_adj_rec.CHARGE_SUBTYPE_CODE
,x_line_adj_rec.list_line_no
,x_line_adj_rec.source_system_code
,x_line_adj_rec.benefit_qty
,x_line_adj_rec.benefit_uom_code
,x_line_adj_rec.print_on_invoice_flag
,x_line_adj_rec.expiration_date
,x_line_adj_rec.rebate_transaction_type_code
,x_line_adj_rec.rebate_transaction_reference
,x_line_adj_rec.rebate_payment_system_code
,x_line_adj_rec.redeemed_date
,x_line_adj_rec.redeemed_flag
,x_line_adj_rec.accrual_flag
,x_line_adj_rec.range_break_quantity
,x_line_adj_rec.accrual_conversion_rate
,x_line_adj_rec.pricing_group_sequence
,x_line_adj_rec.modifier_level_code
,x_line_adj_rec.price_break_type_code
,x_line_adj_rec.substitution_attribute
,x_line_adj_rec.proration_type_code
,x_line_adj_rec.CREDIT_OR_CHARGE_FLAG
,x_line_adj_rec.INCLUDE_ON_RETURNS_FLAG
,x_line_adj_rec.AC_ATTRIBUTE1
,x_line_adj_rec.AC_ATTRIBUTE10
,x_line_adj_rec.AC_ATTRIBUTE11
,x_line_adj_rec.AC_ATTRIBUTE12
,x_line_adj_rec.AC_ATTRIBUTE13
,x_line_adj_rec.AC_ATTRIBUTE14
,x_line_adj_rec.AC_ATTRIBUTE15
,x_line_adj_rec.AC_ATTRIBUTE2
,x_line_adj_rec.AC_ATTRIBUTE3
,x_line_adj_rec.AC_ATTRIBUTE4
,x_line_adj_rec.AC_ATTRIBUTE5
,x_line_adj_rec.AC_ATTRIBUTE6
,x_line_adj_rec.AC_ATTRIBUTE7
,x_line_adj_rec.AC_ATTRIBUTE8
,x_line_adj_rec.AC_ATTRIBUTE9
,x_line_adj_rec.AC_CONTEXT
,x_line_adj_rec.orig_sys_discount_ref
,x_line_adj_rec.OPERAND_PER_PQTY
,x_line_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
-- ,x_line_adj_rec.INVOICED_AMOUNT
,x_line_adj_rec.LOCK_CONTROL
FROM OE_PRICE_ADJS_HISTORY
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
and header_ID = p_header_id
and version_number = p_version
AND LINE_ID IS NOT NULL
AND (PHASE_CHANGE_FLAG = p_phase_change_flag
OR (nvl(p_phase_change_flag, 'NULL') <> 'Y'
AND VERSION_FLAG = 'Y'));
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, line_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_ATTRIBUTE1
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_CONTEXT
, orig_sys_discount_ref
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
-- , INVOICED_AMOUNT
, LOCK_CONTROL
INTO
x_line_adj_rec.ATTRIBUTE1
,x_line_adj_rec.ATTRIBUTE10
,x_line_adj_rec.ATTRIBUTE11
,x_line_adj_rec.ATTRIBUTE12
,x_line_adj_rec.ATTRIBUTE13
,x_line_adj_rec.ATTRIBUTE14
,x_line_adj_rec.ATTRIBUTE15
,x_line_adj_rec.ATTRIBUTE2
,x_line_adj_rec.ATTRIBUTE3
,x_line_adj_rec.ATTRIBUTE4
,x_line_adj_rec.ATTRIBUTE5
,x_line_adj_rec.ATTRIBUTE6
,x_line_adj_rec.ATTRIBUTE7
,x_line_adj_rec.ATTRIBUTE8
,x_line_adj_rec.ATTRIBUTE9
,x_line_adj_rec.AUTOMATIC_FLAG
,x_line_adj_rec.CONTEXT
,x_line_adj_rec.CREATED_BY
,x_line_adj_rec.CREATION_DATE
,x_line_adj_rec.DISCOUNT_ID
,x_line_adj_rec.DISCOUNT_LINE_ID
,x_line_adj_rec.line_ID
,x_line_adj_rec.LAST_UPDATED_BY
,x_line_adj_rec.LAST_UPDATE_DATE
,x_line_adj_rec.LAST_UPDATE_LOGIN
,x_line_adj_rec.LINE_ID
,x_line_adj_rec.PERCENT
,x_line_adj_rec.PRICE_ADJUSTMENT_ID
,x_line_adj_rec.PROGRAM_APPLICATION_ID
,x_line_adj_rec.PROGRAM_ID
,x_line_adj_rec.PROGRAM_UPDATE_DATE
,x_line_adj_rec.REQUEST_ID
,x_line_adj_rec.LIST_HEADER_ID
,x_line_adj_rec.LIST_LINE_ID
,x_line_adj_rec.LIST_LINE_TYPE_CODE
,x_line_adj_rec.MODIFIER_MECHANISM_TYPE_CODE
,x_line_adj_rec.MODIFIED_FROM
,x_line_adj_rec.MODIFIED_TO
,x_line_adj_rec.UPDATED_FLAG
,x_line_adj_rec.UPDATE_ALLOWED
,x_line_adj_rec.APPLIED_FLAG
,x_line_adj_rec.CHANGE_REASON_CODE
,x_line_adj_rec.CHANGE_REASON_TEXT
,x_line_adj_rec.operand
,x_line_adj_rec.arithmetic_operator
,x_line_adj_rec.COST_ID
,x_line_adj_rec.TAX_CODE
,x_line_adj_rec.TAX_EXEMPT_FLAG
,x_line_adj_rec.TAX_EXEMPT_NUMBER
,x_line_adj_rec.TAX_EXEMPT_REASON_CODE
,x_line_adj_rec.PARENT_ADJUSTMENT_ID
,x_line_adj_rec.INVOICED_FLAG
,x_line_adj_rec.ESTIMATED_FLAG
,x_line_adj_rec.INC_IN_SALES_PERFORMANCE
,x_line_adj_rec.SPLIT_ACTION_CODE
,x_line_adj_rec.ADJUSTED_AMOUNT
,x_line_adj_rec.PRICING_PHASE_ID
,x_line_adj_rec.CHARGE_TYPE_CODE
,x_line_adj_rec.CHARGE_SUBTYPE_CODE
,x_line_adj_rec.list_line_no
,x_line_adj_rec.source_system_code
,x_line_adj_rec.benefit_qty
,x_line_adj_rec.benefit_uom_code
,x_line_adj_rec.print_on_invoice_flag
,x_line_adj_rec.expiration_date
,x_line_adj_rec.rebate_transaction_type_code
,x_line_adj_rec.rebate_transaction_reference
,x_line_adj_rec.rebate_payment_system_code
,x_line_adj_rec.redeemed_date
,x_line_adj_rec.redeemed_flag
,x_line_adj_rec.accrual_flag
,x_line_adj_rec.range_break_quantity
,x_line_adj_rec.accrual_conversion_rate
,x_line_adj_rec.pricing_group_sequence
,x_line_adj_rec.modifier_level_code
,x_line_adj_rec.price_break_type_code
,x_line_adj_rec.substitution_attribute
,x_line_adj_rec.proration_type_code
,x_line_adj_rec.CREDIT_OR_CHARGE_FLAG
,x_line_adj_rec.INCLUDE_ON_RETURNS_FLAG
,x_line_adj_rec.AC_ATTRIBUTE1
,x_line_adj_rec.AC_ATTRIBUTE10
,x_line_adj_rec.AC_ATTRIBUTE11
,x_line_adj_rec.AC_ATTRIBUTE12
,x_line_adj_rec.AC_ATTRIBUTE13
,x_line_adj_rec.AC_ATTRIBUTE14
,x_line_adj_rec.AC_ATTRIBUTE15
,x_line_adj_rec.AC_ATTRIBUTE2
,x_line_adj_rec.AC_ATTRIBUTE3
,x_line_adj_rec.AC_ATTRIBUTE4
,x_line_adj_rec.AC_ATTRIBUTE5
,x_line_adj_rec.AC_ATTRIBUTE6
,x_line_adj_rec.AC_ATTRIBUTE7
,x_line_adj_rec.AC_ATTRIBUTE8
,x_line_adj_rec.AC_ATTRIBUTE9
,x_line_adj_rec.AC_CONTEXT
,x_line_adj_rec.orig_sys_discount_ref
,x_line_adj_rec.OPERAND_PER_PQTY
,x_line_adj_rec.ADJUSTED_AMOUNT_PER_PQTY
-- ,x_line_adj_rec.INVOICED_AMOUNT
,x_line_adj_rec.LOCK_CONTROL
FROM OE_PRICE_ADJUSTMENTS
WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
and header_ID = p_header_id
AND LINE_ID IS NOT NULL;
oe_debug_pub.add(' before finding deleted new_modifier_list');
x_line_adj_changed_attr_tbl(ind).current_value := 'DELETE';
x_line_adj_changed_attr_tbl(ind).next_value := 'DELETE';
SELECT distinct price_adjustment_id,line_id
from oe_price_adjs_history
where header_id = p_header_id
and line_id is not null
--and phase_change_flag = p_transaction_phase_code
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL
and version_number in (p_prior_version,p_current_version,p_next_version)
union
SELECT price_adjustment_id,line_id
from oe_price_adjustments
where header_id=p_header_id
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL
and line_id is not null;
SELECT distinct price_adjustment_id,line_id
from oe_price_adjs_history
where header_id = p_header_id
and line_id is not null
and list_line_type_code <> 'FREIGHT_CHARGE'
and list_header_id IS NOT NULL
--and phase_change_flag = p_transaction_phase_code
and version_number in (p_prior_version,p_current_version,p_next_version);
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual;
select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
select oe_order_misc_pub.get_concat_hist_line_number(l_line_id,p_current_version) into x_line_number from dual; -- bug 9299752
CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl
where application_id=660
and descriptive_flexfield_name= p_descriptive_flexfield_name
and application_column_name =p_application_column_name
and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');
select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
where APPLICATION_ID = p_application_id
and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
and descriptive_flexfield_name= p_descriptive_flexfield_name
and application_column_name =p_application_column_name;