The following lines contain the word 'select', 'insert', 'update' or 'delete':
select quote_expiration_date
from aso_quote_headers_all
where quote_header_id = c_quote_header_id;
select quote_header_id
from ibe_active_quotes
where quote_header_id = c_quote_header_id
and party_id = c_party_id
and cust_account_id = c_cust_account_id
and record_type = 'CART';
SELECT aq.quote_header_id
INTO l_quote_header_id
FROM IBE_ACTIVE_QUOTES AQ
where party_id = p_party_id
and cust_account_id = p_cust_account_id
and record_type = 'CART';
SELECT COUNT(*)
INTO x_number_of_lines
FROM aso_quote_lines
WHERE quote_header_id = l_quote_header_id;
SELECT quote_header_id, order_id INTO l_quote_header_id, l_order_id
FROM aso_quote_headers
WHERE quote_header_id = p_quote_header_id;
FUNCTION getQuoteLastUpdateDate(
p_quote_header_id IN NUMBER
) RETURN DATE
IS
CURSOR c_getLastUpdateDate(c_qte_header_id NUMBER) IS
SELECT last_update_date FROM ASO_QUOTE_HEADERS
WHERE quote_header_id = c_qte_header_id;
l_last_update_date date := FND_API.G_MISS_DATE;
IBE_UTIL.Debug('getQuoteLastUpdateDate: starts');
OPEN c_getLastUpdateDate(p_quote_header_id);
FETCH c_getLastUpdateDate into l_last_update_date;
CLOSE c_getLastUpdateDate;
IBE_UTIL.Debug('getQuoteLastUpdateDate: ends');
RETURN l_last_update_date;
END getQuoteLastUpdateDate;
SELECT APA.price_attribute_id
,APA.creation_date
,APA.created_by
,APA.last_update_date
,APA.last_updated_by
,APA.last_update_login
,APA.request_id
,APA.program_application_id
,APA.program_id
,APA.program_update_date
,APA.quote_header_id
,APA.quote_line_id
,APA.flex_title
,APA.pricing_context
,APA.pricing_attribute1
,APA.pricing_attribute2
,APA.pricing_attribute3
,APA.pricing_attribute4
,APA.pricing_attribute5
,APA.pricing_attribute6
,APA.pricing_attribute7
,APA.pricing_attribute8
,APA.pricing_attribute9
,APA.pricing_attribute10
,APA.pricing_attribute11
,APA.pricing_attribute12
,APA.pricing_attribute13
,APA.pricing_attribute14
,APA.pricing_attribute15
,APA.pricing_attribute16
,APA.pricing_attribute17
,APA.pricing_attribute18
,APA.pricing_attribute19
,APA.pricing_attribute20
,APA.pricing_attribute21
,APA.pricing_attribute22
,APA.pricing_attribute23
,APA.pricing_attribute24
,APA.pricing_attribute25
,APA.pricing_attribute26
,APA.pricing_attribute27
,APA.pricing_attribute28
,APA.pricing_attribute29
,APA.pricing_attribute30
,APA.pricing_attribute31
,APA.pricing_attribute32
,APA.pricing_attribute33
,APA.pricing_attribute34
,APA.pricing_attribute35
,APA.pricing_attribute36
,APA.pricing_attribute37
,APA.pricing_attribute38
,APA.pricing_attribute39
,APA.pricing_attribute40
,APA.pricing_attribute41
,APA.pricing_attribute42
,APA.pricing_attribute43
,APA.pricing_attribute44
,APA.pricing_attribute45
,APA.pricing_attribute46
,APA.pricing_attribute47
,APA.pricing_attribute48
,APA.pricing_attribute49
,APA.pricing_attribute50
,APA.pricing_attribute51
,APA.pricing_attribute52
,APA.pricing_attribute53
,APA.pricing_attribute54
,APA.pricing_attribute55
,APA.pricing_attribute56
,APA.pricing_attribute57
,APA.pricing_attribute58
,APA.pricing_attribute59
,APA.pricing_attribute50
,APA.pricing_attribute51
,APA.pricing_attribute52
,APA.pricing_attribute53
,APA.pricing_attribute54
,APA.pricing_attribute55
,APA.pricing_attribute56
,APA.pricing_attribute57
,APA.pricing_attribute58
,APA.pricing_attribute59
,APA.pricing_attribute60
,APA.pricing_attribute61
,APA.pricing_attribute62
,APA.pricing_attribute63
,APA.pricing_attribute64
,APA.pricing_attribute65
,APA.pricing_attribute66
,APA.pricing_attribute67
,APA.pricing_attribute68
,APA.pricing_attribute69
,APA.pricing_attribute70
,APA.pricing_attribute71
,APA.pricing_attribute72
,APA.pricing_attribute73
,APA.pricing_attribute74
,APA.pricing_attribute75
,APA.pricing_attribute76
,APA.pricing_attribute77
,APA.pricing_attribute78
,APA.pricing_attribute79
,APA.pricing_attribute80
,APA.pricing_attribute81
,APA.pricing_attribute82
,APA.pricing_attribute83
,APA.pricing_attribute84
,APA.pricing_attribute85
,APA.pricing_attribute86
,APA.pricing_attribute87
,APA.pricing_attribute88
,APA.pricing_attribute89
,APA.pricing_attribute90
,APA.pricing_attribute91
,APA.pricing_attribute92
,APA.pricing_attribute93
,APA.pricing_attribute94
,APA.pricing_attribute95
,APA.pricing_attribute96
,APA.pricing_attribute97
,APA.pricing_attribute98
,APA.pricing_attribute99
,APA.pricing_attribute100
,APA.context
,APA.attribute1
,APA.attribute2
,APA.attribute3
,APA.attribute4
,APA.attribute5
,APA.attribute6
,APA.attribute7
,APA.attribute8
,APA.attribute9
,APA.attribute10
,APA.attribute11
,APA.attribute12
,APA.attribute13
,APA.attribute14
,APA.attribute15
FROM aso_price_attributes APA
WHERE APA.quote_line_id = p_quote_line_id;
,l_ln_price_attributes_rec.last_update_date
,l_ln_price_attributes_rec.last_updated_by
,l_ln_price_attributes_rec.last_update_login
,l_ln_price_attributes_rec.request_id
,l_ln_price_attributes_rec.program_application_id
,l_ln_price_attributes_rec.program_id
,l_ln_price_attributes_rec.program_update_date
,l_ln_price_attributes_rec.quote_header_id
,l_ln_price_attributes_rec.quote_line_id
,l_ln_price_attributes_rec.flex_title
,l_ln_price_attributes_rec.pricing_context
,l_ln_price_attributes_rec.pricing_attribute1
,l_ln_price_attributes_rec.pricing_attribute2
,l_ln_price_attributes_rec.pricing_attribute3
,l_ln_price_attributes_rec.pricing_attribute4
,l_ln_price_attributes_rec.pricing_attribute5
,l_ln_price_attributes_rec.pricing_attribute6
,l_ln_price_attributes_rec.pricing_attribute7
,l_ln_price_attributes_rec.pricing_attribute8
,l_ln_price_attributes_rec.pricing_attribute9
,l_ln_price_attributes_rec.pricing_attribute10
,l_ln_price_attributes_rec.pricing_attribute11
,l_ln_price_attributes_rec.pricing_attribute12
,l_ln_price_attributes_rec.pricing_attribute13
,l_ln_price_attributes_rec.pricing_attribute14
,l_ln_price_attributes_rec.pricing_attribute15
,l_ln_price_attributes_rec.pricing_attribute16
,l_ln_price_attributes_rec.pricing_attribute17
,l_ln_price_attributes_rec.pricing_attribute18
,l_ln_price_attributes_rec.pricing_attribute19
,l_ln_price_attributes_rec.pricing_attribute20
,l_ln_price_attributes_rec.pricing_attribute21
,l_ln_price_attributes_rec.pricing_attribute22
,l_ln_price_attributes_rec.pricing_attribute23
,l_ln_price_attributes_rec.pricing_attribute24
,l_ln_price_attributes_rec.pricing_attribute25
,l_ln_price_attributes_rec.pricing_attribute26
,l_ln_price_attributes_rec.pricing_attribute27
,l_ln_price_attributes_rec.pricing_attribute28
,l_ln_price_attributes_rec.pricing_attribute29
,l_ln_price_attributes_rec.pricing_attribute30
,l_ln_price_attributes_rec.pricing_attribute31
,l_ln_price_attributes_rec.pricing_attribute32
,l_ln_price_attributes_rec.pricing_attribute33
,l_ln_price_attributes_rec.pricing_attribute34
,l_ln_price_attributes_rec.pricing_attribute35
,l_ln_price_attributes_rec.pricing_attribute36
,l_ln_price_attributes_rec.pricing_attribute37
,l_ln_price_attributes_rec.pricing_attribute38
,l_ln_price_attributes_rec.pricing_attribute39
,l_ln_price_attributes_rec.pricing_attribute40
,l_ln_price_attributes_rec.pricing_attribute41
,l_ln_price_attributes_rec.pricing_attribute42
,l_ln_price_attributes_rec.pricing_attribute43
,l_ln_price_attributes_rec.pricing_attribute44
,l_ln_price_attributes_rec.pricing_attribute45
,l_ln_price_attributes_rec.pricing_attribute46
,l_ln_price_attributes_rec.pricing_attribute47
,l_ln_price_attributes_rec.pricing_attribute48
,l_ln_price_attributes_rec.pricing_attribute49
,l_ln_price_attributes_rec.pricing_attribute50
,l_ln_price_attributes_rec.pricing_attribute51
,l_ln_price_attributes_rec.pricing_attribute52
,l_ln_price_attributes_rec.pricing_attribute53
,l_ln_price_attributes_rec.pricing_attribute54
,l_ln_price_attributes_rec.pricing_attribute55
,l_ln_price_attributes_rec.pricing_attribute56
,l_ln_price_attributes_rec.pricing_attribute57
,l_ln_price_attributes_rec.pricing_attribute58
,l_ln_price_attributes_rec.pricing_attribute59
,l_ln_price_attributes_rec.pricing_attribute50
,l_ln_price_attributes_rec.pricing_attribute51
,l_ln_price_attributes_rec.pricing_attribute52
,l_ln_price_attributes_rec.pricing_attribute53
,l_ln_price_attributes_rec.pricing_attribute54
,l_ln_price_attributes_rec.pricing_attribute55
,l_ln_price_attributes_rec.pricing_attribute56
,l_ln_price_attributes_rec.pricing_attribute57
,l_ln_price_attributes_rec.pricing_attribute58
,l_ln_price_attributes_rec.pricing_attribute59
,l_ln_price_attributes_rec.pricing_attribute60
,l_ln_price_attributes_rec.pricing_attribute61
,l_ln_price_attributes_rec.pricing_attribute62
,l_ln_price_attributes_rec.pricing_attribute63
,l_ln_price_attributes_rec.pricing_attribute64
,l_ln_price_attributes_rec.pricing_attribute65
,l_ln_price_attributes_rec.pricing_attribute66
,l_ln_price_attributes_rec.pricing_attribute67
,l_ln_price_attributes_rec.pricing_attribute68
,l_ln_price_attributes_rec.pricing_attribute69
,l_ln_price_attributes_rec.pricing_attribute70
,l_ln_price_attributes_rec.pricing_attribute71
,l_ln_price_attributes_rec.pricing_attribute72
,l_ln_price_attributes_rec.pricing_attribute73
,l_ln_price_attributes_rec.pricing_attribute74
,l_ln_price_attributes_rec.pricing_attribute75
,l_ln_price_attributes_rec.pricing_attribute76
,l_ln_price_attributes_rec.pricing_attribute77
,l_ln_price_attributes_rec.pricing_attribute78
,l_ln_price_attributes_rec.pricing_attribute79
,l_ln_price_attributes_rec.pricing_attribute80
,l_ln_price_attributes_rec.pricing_attribute81
,l_ln_price_attributes_rec.pricing_attribute82
,l_ln_price_attributes_rec.pricing_attribute83
,l_ln_price_attributes_rec.pricing_attribute84
,l_ln_price_attributes_rec.pricing_attribute85
,l_ln_price_attributes_rec.pricing_attribute86
,l_ln_price_attributes_rec.pricing_attribute87
,l_ln_price_attributes_rec.pricing_attribute88
,l_ln_price_attributes_rec.pricing_attribute89
,l_ln_price_attributes_rec.pricing_attribute90
,l_ln_price_attributes_rec.pricing_attribute91
,l_ln_price_attributes_rec.pricing_attribute92
,l_ln_price_attributes_rec.pricing_attribute93
,l_ln_price_attributes_rec.pricing_attribute94
,l_ln_price_attributes_rec.pricing_attribute95
,l_ln_price_attributes_rec.pricing_attribute96
,l_ln_price_attributes_rec.pricing_attribute97
,l_ln_price_attributes_rec.pricing_attribute98
,l_ln_price_attributes_rec.pricing_attribute99
,l_ln_price_attributes_rec.pricing_attribute100
,l_ln_price_attributes_rec.context
,l_ln_price_attributes_rec.attribute1
,l_ln_price_attributes_rec.attribute2
,l_ln_price_attributes_rec.attribute3
,l_ln_price_attributes_rec.attribute4
,l_ln_price_attributes_rec.attribute5
,l_ln_price_attributes_rec.attribute6
,l_ln_price_attributes_rec.attribute7
,l_ln_price_attributes_rec.attribute8
,l_ln_price_attributes_rec.attribute9
,l_ln_price_attributes_rec.attribute10
,l_ln_price_attributes_rec.attribute11
,l_ln_price_attributes_rec.attribute12
,l_ln_price_attributes_rec.attribute13
,l_ln_price_attributes_rec.attribute14
,l_ln_price_attributes_rec.attribute15
;
SELECT lae.LINE_ATTRIBUTE_ID
,lae.CREATION_DATE
,lae.CREATED_BY
,lae.LAST_UPDATE_DATE
,lae.LAST_UPDATED_BY
,lae.LAST_UPDATE_LOGIN
,lae.REQUEST_ID
,lae.PROGRAM_APPLICATION_ID
,lae.PROGRAM_ID
,lae.PROGRAM_UPDATE_DATE
,lae.APPLICATION_ID
,lae.QUOTE_LINE_ID
,lae.ATTRIBUTE_TYPE_CODE
,lae.NAME
,lae.VALUE
,lae.VALUE_TYPE
,lae.STATUS
,lae.START_DATE_ACTIVE
,lae.END_DATE_ACTIVE
-- ,lae.QUOTE_HEADER_ID
-- ,lae.QUOTE_SHIPMENT_ID
-- ,lae.SECURITY_GROUP_ID
-- ,lae.OBJECT_VERSION_NUMBER
From ASO_QUOTE_LINE_ATTRIBS_EXT lae
Where lae.QUOTE_LINE_ID = p_quote_line_id;
,l_line_attr_ext_rec.LAST_UPDATE_DATE
,l_line_attr_ext_rec.LAST_UPDATED_BY
,l_line_attr_ext_rec.LAST_UPDATE_LOGIN
,l_line_attr_ext_rec.REQUEST_ID
,l_line_attr_ext_rec.PROGRAM_APPLICATION_ID
,l_line_attr_ext_rec.PROGRAM_ID
,l_line_attr_ext_rec.PROGRAM_UPDATE_DATE
,l_line_attr_ext_rec.APPLICATION_ID
,l_line_attr_ext_rec.QUOTE_LINE_ID
,l_line_attr_ext_rec.ATTRIBUTE_TYPE_CODE
,l_line_attr_ext_rec.NAME
,l_line_attr_ext_rec.VALUE
,l_line_attr_ext_rec.VALUE_TYPE
,l_line_attr_ext_rec.STATUS
,l_line_attr_ext_rec.START_DATE_ACTIVE
,l_line_attr_ext_rec.END_DATE_ACTIVE
-- ,l_line_attr_ext_rec.QUOTE_HEADER_ID
-- ,l_line_attr_ext_rec.QUOTE_SHIPMENT_ID
-- ,l_line_attr_ext_rec.SECURITY_GROUP_ID
-- ,l_line_attr_ext_rec.OBJECT_VERSION_NUMBER
;
SELECT dl.quote_line_detail_id
,dl.creation_date
,dl.created_by
,dl.last_update_date
,dl.last_updated_by
,dl.last_update_login
,dl.request_id
,dl.program_application_id
,dl.program_id
,dl.program_update_date
,dl.quote_line_id
,dl.config_header_id
,dl.config_revision_num
,dl.config_item_id
,dl.complete_configuration_flag
,dl.valid_configuration_flag
,dl.component_code
,dl.service_coterminate_flag
,dl.service_duration
,dl.service_period
,dl.service_unit_selling_percent
,dl.service_unit_list_percent
,dl.service_number
,dl.unit_percent_base_price
,dl.attribute_category
,dl.attribute1
,dl.attribute2
,dl.attribute3
,dl.attribute4
,dl.attribute5
,dl.attribute6
,dl.attribute7
,dl.attribute8
,dl.attribute9
,dl.attribute10
,dl.attribute11
,dl.attribute12
,dl.attribute13
,dl.attribute14
,dl.attribute15
,dl.service_ref_type_code
,dl.service_ref_order_number
,dl.service_ref_line_number
,dl.service_ref_line_id
,dl.service_ref_system_id
,dl.service_ref_option_numb
,dl.service_ref_shipment_numb
,dl.return_ref_type
,dl.return_ref_header_id
,dl.return_ref_line_id
,dl.return_attribute1
,dl.return_attribute2
,dl.return_attribute3
,dl.return_attribute4
,dl.return_attribute5
,dl.return_attribute6
,dl.return_attribute7
,dl.return_attribute8
,dl.return_attribute9
,dl.return_attribute10
,dl.return_attribute11
,dl.return_attribute12
,dl.return_attribute13
,dl.return_attribute14
,dl.return_attribute15
From ASO_quote_LINE_details dl
Where QUOTE_LINE_ID = p_quote_line_id;
,l_qte_line_dtl_rec.last_update_date
,l_qte_line_dtl_rec.last_updated_by
,l_qte_line_dtl_rec.last_update_login
,l_qte_line_dtl_rec.request_id
,l_qte_line_dtl_rec.program_application_id
,l_qte_line_dtl_rec.program_id
,l_qte_line_dtl_rec.program_update_date
,l_qte_line_dtl_rec.quote_line_id
,l_qte_line_dtl_rec.config_header_id
,l_qte_line_dtl_rec.config_revision_num
,l_qte_line_dtl_rec.config_item_id
,l_qte_line_dtl_rec.complete_configuration_flag
,l_qte_line_dtl_rec.valid_configuration_flag
,l_qte_line_dtl_rec.component_code
,l_qte_line_dtl_rec.service_coterminate_flag
,l_qte_line_dtl_rec.service_duration
,l_qte_line_dtl_rec.service_period
,l_qte_line_dtl_rec.service_unit_selling_percent
,l_qte_line_dtl_rec.service_unit_list_percent
,l_qte_line_dtl_rec.service_number
,l_qte_line_dtl_rec.unit_percent_base_price
,l_qte_line_dtl_rec.attribute_category
,l_qte_line_dtl_rec.attribute1
,l_qte_line_dtl_rec.attribute2
,l_qte_line_dtl_rec.attribute3
,l_qte_line_dtl_rec.attribute4
,l_qte_line_dtl_rec.attribute5
,l_qte_line_dtl_rec.attribute6
,l_qte_line_dtl_rec.attribute7
,l_qte_line_dtl_rec.attribute8
,l_qte_line_dtl_rec.attribute9
,l_qte_line_dtl_rec.attribute10
,l_qte_line_dtl_rec.attribute11
,l_qte_line_dtl_rec.attribute12
,l_qte_line_dtl_rec.attribute13
,l_qte_line_dtl_rec.attribute14
,l_qte_line_dtl_rec.attribute15
,l_qte_line_dtl_rec.service_ref_type_code
,l_qte_line_dtl_rec.service_ref_order_number
,l_qte_line_dtl_rec.service_ref_line_number
,l_qte_line_dtl_rec.service_ref_line_id
,l_qte_line_dtl_rec.service_ref_system_id
,l_qte_line_dtl_rec.service_ref_option_numb
,l_qte_line_dtl_rec.service_ref_shipment_numb
,l_qte_line_dtl_rec.return_ref_type
,l_qte_line_dtl_rec.return_ref_header_id
,l_qte_line_dtl_rec.return_ref_line_id
,l_qte_line_dtl_rec.return_attribute1
,l_qte_line_dtl_rec.return_attribute2
,l_qte_line_dtl_rec.return_attribute3
,l_qte_line_dtl_rec.return_attribute4
,l_qte_line_dtl_rec.return_attribute5
,l_qte_line_dtl_rec.return_attribute6
,l_qte_line_dtl_rec.return_attribute7
,l_qte_line_dtl_rec.return_attribute8
,l_qte_line_dtl_rec.return_attribute9
,l_qte_line_dtl_rec.return_attribute10
,l_qte_line_dtl_rec.return_attribute11
,l_qte_line_dtl_rec.return_attribute12
,l_qte_line_dtl_rec.return_attribute13
,l_qte_line_dtl_rec.return_attribute14
,l_qte_line_dtl_rec.return_attribute15;
SELECT LINE_RELATIONSHIP_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,QUOTE_LINE_ID
,RELATED_QUOTE_LINE_ID
,RELATIONSHIP_TYPE_CODE
,RECIPROCAL_FLAG
From ASO_LINE_RELATIONSHIPS
Where QUOTE_LINE_ID = p_quote_line_id;
,l_line_rltship_rec.LAST_UPDATED_BY
,l_line_rltship_rec.LAST_UPDATE_DATE
,l_line_rltship_rec.LAST_UPDATE_LOGIN
,l_line_rltship_rec.REQUEST_ID
,l_line_rltship_rec.PROGRAM_APPLICATION_ID
,l_line_rltship_rec.PROGRAM_ID
,l_line_rltship_rec.PROGRAM_UPDATE_DATE
,l_line_rltship_rec.QUOTE_LINE_ID
,l_line_rltship_rec.RELATED_QUOTE_LINE_ID
,l_line_rltship_rec.RELATIONSHIP_TYPE_CODE
,l_line_rltship_rec.RECIPROCAL_FLAG;
SELECT PRICE_ADJUSTMENT_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,QUOTE_HEADER_ID
,QUOTE_LINE_ID
,QUOTE_SHIPMENT_ID
,MODIFIER_HEADER_ID
,MODIFIER_LINE_ID
,MODIFIER_LINE_TYPE_CODE
,MODIFIER_MECHANISM_TYPE_CODE
,MODIFIED_FROM
,MODIFIED_TO
,OPERAND
,ARITHMETIC_OPERATOR
,AUTOMATIC_FLAG
,UPDATE_ALLOWABLE_FLAG
,UPDATED_FLAG
,APPLIED_FLAG
,ON_INVOICE_FLAG
,PRICING_PHASE_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ORIG_SYS_DISCOUNT_REF
,CHANGE_SEQUENCE
,UPDATE_ALLOWED
,CHANGE_REASON_CODE
,CHANGE_REASON_TEXT
,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
,CHARGE_TYPE_CODE
,CHARGE_SUBTYPE_CODE
,RANGE_BREAK_QUANTITY
,ACCRUAL_CONVERSION_RATE
,PRICING_GROUP_SEQUENCE
,ACCRUAL_FLAG
,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
,MODIFIER_LEVEL_CODE
,PRICE_BREAK_TYPE_CODE
,SUBSTITUTION_ATTRIBUTE
,PRORATION_TYPE_CODE
,INCLUDE_ON_RETURNS_FLAG
,CREDIT_OR_CHARGE_FLAG
From ASO_PRICE_ADJUSTMENTS
Where QUOTE_LINE_ID = p_quote_line_id;
,l_line_PrcAdj_rec.LAST_UPDATE_DATE
,l_line_PrcAdj_rec.LAST_UPDATED_BY
,l_line_PrcAdj_rec.LAST_UPDATE_LOGIN
,l_line_PrcAdj_rec.PROGRAM_APPLICATION_ID
,l_line_PrcAdj_rec.PROGRAM_ID
,l_line_PrcAdj_rec.PROGRAM_UPDATE_DATE
,l_line_PrcAdj_rec.REQUEST_ID
,l_line_PrcAdj_rec.QUOTE_HEADER_ID
,l_line_PrcAdj_rec.QUOTE_LINE_ID
,l_line_PrcAdj_rec.QUOTE_SHIPMENT_ID
,l_line_PrcAdj_rec.MODIFIER_HEADER_ID
,l_line_PrcAdj_rec.MODIFIER_LINE_ID
,l_line_PrcAdj_rec.MODIFIER_LINE_TYPE_CODE
,l_line_PrcAdj_rec.MODIFIER_MECHANISM_TYPE_CODE
,l_line_PrcAdj_rec.MODIFIED_FROM
,l_line_PrcAdj_rec.MODIFIED_TO
,l_line_PrcAdj_rec.OPERAND
,l_line_PrcAdj_rec.ARITHMETIC_OPERATOR
,l_line_PrcAdj_rec.AUTOMATIC_FLAG
,l_line_PrcAdj_rec.UPDATE_ALLOWABLE_FLAG
,l_line_PrcAdj_rec.UPDATED_FLAG
,l_line_PrcAdj_rec.APPLIED_FLAG
,l_line_PrcAdj_rec.ON_INVOICE_FLAG
,l_line_PrcAdj_rec.PRICING_PHASE_ID
,l_line_PrcAdj_rec.ATTRIBUTE_CATEGORY
,l_line_PrcAdj_rec.ATTRIBUTE1
,l_line_PrcAdj_rec.ATTRIBUTE2
,l_line_PrcAdj_rec.ATTRIBUTE3
,l_line_PrcAdj_rec.ATTRIBUTE4
,l_line_PrcAdj_rec.ATTRIBUTE5
,l_line_PrcAdj_rec.ATTRIBUTE6
,l_line_PrcAdj_rec.ATTRIBUTE7
,l_line_PrcAdj_rec.ATTRIBUTE8
,l_line_PrcAdj_rec.ATTRIBUTE9
,l_line_PrcAdj_rec.ATTRIBUTE10
,l_line_PrcAdj_rec.ATTRIBUTE11
,l_line_PrcAdj_rec.ATTRIBUTE12
,l_line_PrcAdj_rec.ATTRIBUTE13
,l_line_PrcAdj_rec.ATTRIBUTE14
,l_line_PrcAdj_rec.ATTRIBUTE15
,l_line_PrcAdj_rec.ORIG_SYS_DISCOUNT_REF
,l_line_PrcAdj_rec.CHANGE_SEQUENCE
,l_line_PrcAdj_rec.UPDATE_ALLOWED
,l_line_PrcAdj_rec.CHANGE_REASON_CODE
,l_line_PrcAdj_rec.CHANGE_REASON_TEXT
,l_line_PrcAdj_rec.COST_ID
,l_line_PrcAdj_rec.TAX_CODE
,l_line_PrcAdj_rec.TAX_EXEMPT_FLAG
,l_line_PrcAdj_rec.TAX_EXEMPT_NUMBER
,l_line_PrcAdj_rec.TAX_EXEMPT_REASON_CODE
,l_line_PrcAdj_rec.PARENT_ADJUSTMENT_ID
,l_line_PrcAdj_rec.INVOICED_FLAG
,l_line_PrcAdj_rec.ESTIMATED_FLAG
,l_line_PrcAdj_rec.INC_IN_SALES_PERFORMANCE
,l_line_PrcAdj_rec.SPLIT_ACTION_CODE
,l_line_PrcAdj_rec.ADJUSTED_AMOUNT
,l_line_PrcAdj_rec.CHARGE_TYPE_CODE
,l_line_PrcAdj_rec.CHARGE_SUBTYPE_CODE
,l_line_PrcAdj_rec.RANGE_BREAK_QUANTITY
,l_line_PrcAdj_rec.ACCRUAL_CONVERSION_RATE
,l_line_PrcAdj_rec.PRICING_GROUP_SEQUENCE
,l_line_PrcAdj_rec.ACCRUAL_FLAG
,l_line_PrcAdj_rec.LIST_LINE_NO
,l_line_PrcAdj_rec.SOURCE_SYSTEM_CODE
,l_line_PrcAdj_rec.BENEFIT_QTY
,l_line_PrcAdj_rec.BENEFIT_UOM_CODE
,l_line_PrcAdj_rec.PRINT_ON_INVOICE_FLAG
,l_line_PrcAdj_rec.EXPIRATION_DATE
,l_line_PrcAdj_rec.REBATE_TRANSACTION_TYPE_CODE
,l_line_PrcAdj_rec.REBATE_TRANSACTION_REFERENCE
,l_line_PrcAdj_rec.REBATE_PAYMENT_SYSTEM_CODE
,l_line_PrcAdj_rec.REDEEMED_DATE
,l_line_PrcAdj_rec.REDEEMED_FLAG
,l_line_PrcAdj_rec.MODIFIER_LEVEL_CODE
,l_line_PrcAdj_rec.PRICE_BREAK_TYPE_CODE
,l_line_PrcAdj_rec.SUBSTITUTION_ATTRIBUTE
,l_line_PrcAdj_rec.PRORATION_TYPE_CODE
,l_line_PrcAdj_rec.INCLUDE_ON_RETURNS_FLAG
,l_line_PrcAdj_rec.CREDIT_OR_CHARGE_FLAG;
SELECT PRICE_ADJUSTMENT_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,QUOTE_HEADER_ID
,QUOTE_LINE_ID
,QUOTE_SHIPMENT_ID
,MODIFIER_HEADER_ID
,MODIFIER_LINE_ID
,MODIFIER_LINE_TYPE_CODE
,MODIFIER_MECHANISM_TYPE_CODE
,MODIFIED_FROM
,MODIFIED_TO
,OPERAND
,ARITHMETIC_OPERATOR
,AUTOMATIC_FLAG
,UPDATE_ALLOWABLE_FLAG
,UPDATED_FLAG
,APPLIED_FLAG
,ON_INVOICE_FLAG
,PRICING_PHASE_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ORIG_SYS_DISCOUNT_REF
,CHANGE_SEQUENCE
,UPDATE_ALLOWED
,CHANGE_REASON_CODE
,CHANGE_REASON_TEXT
,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
,CHARGE_TYPE_CODE
,CHARGE_SUBTYPE_CODE
,RANGE_BREAK_QUANTITY
,ACCRUAL_CONVERSION_RATE
,PRICING_GROUP_SEQUENCE
,ACCRUAL_FLAG
,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
,MODIFIER_LEVEL_CODE
,PRICE_BREAK_TYPE_CODE
,SUBSTITUTION_ATTRIBUTE
,PRORATION_TYPE_CODE
,INCLUDE_ON_RETURNS_FLAG
,CREDIT_OR_CHARGE_FLAG
From ASO_PRICE_ADJUSTMENTS
Where QUOTE_HEADER_ID = p_quote_hdr_id;
,l_hdr_PrcAdj_rec.LAST_UPDATE_DATE
,l_hdr_PrcAdj_rec.LAST_UPDATED_BY
,l_hdr_PrcAdj_rec.LAST_UPDATE_LOGIN
,l_hdr_PrcAdj_rec.PROGRAM_APPLICATION_ID
,l_hdr_PrcAdj_rec.PROGRAM_ID
,l_hdr_PrcAdj_rec.PROGRAM_UPDATE_DATE
,l_hdr_PrcAdj_rec.REQUEST_ID
,l_hdr_PrcAdj_rec.QUOTE_HEADER_ID
,l_hdr_PrcAdj_rec.QUOTE_LINE_ID
,l_hdr_PrcAdj_rec.QUOTE_SHIPMENT_ID
,l_hdr_PrcAdj_rec.MODIFIER_HEADER_ID
,l_hdr_PrcAdj_rec.MODIFIER_LINE_ID
,l_hdr_PrcAdj_rec.MODIFIER_LINE_TYPE_CODE
,l_hdr_PrcAdj_rec.MODIFIER_MECHANISM_TYPE_CODE
,l_hdr_PrcAdj_rec.MODIFIED_FROM
,l_hdr_PrcAdj_rec.MODIFIED_TO
,l_hdr_PrcAdj_rec.OPERAND
,l_hdr_PrcAdj_rec.ARITHMETIC_OPERATOR
,l_hdr_PrcAdj_rec.AUTOMATIC_FLAG
,l_hdr_PrcAdj_rec.UPDATE_ALLOWABLE_FLAG
,l_hdr_PrcAdj_rec.UPDATED_FLAG
,l_hdr_PrcAdj_rec.APPLIED_FLAG
,l_hdr_PrcAdj_rec.ON_INVOICE_FLAG
,l_hdr_PrcAdj_rec.PRICING_PHASE_ID
,l_hdr_PrcAdj_rec.ATTRIBUTE_CATEGORY
,l_hdr_PrcAdj_rec.ATTRIBUTE1
,l_hdr_PrcAdj_rec.ATTRIBUTE2
,l_hdr_PrcAdj_rec.ATTRIBUTE3
,l_hdr_PrcAdj_rec.ATTRIBUTE4
,l_hdr_PrcAdj_rec.ATTRIBUTE5
,l_hdr_PrcAdj_rec.ATTRIBUTE6
,l_hdr_PrcAdj_rec.ATTRIBUTE7
,l_hdr_PrcAdj_rec.ATTRIBUTE8
,l_hdr_PrcAdj_rec.ATTRIBUTE9
,l_hdr_PrcAdj_rec.ATTRIBUTE10
,l_hdr_PrcAdj_rec.ATTRIBUTE11
,l_hdr_PrcAdj_rec.ATTRIBUTE12
,l_hdr_PrcAdj_rec.ATTRIBUTE13
,l_hdr_PrcAdj_rec.ATTRIBUTE14
,l_hdr_PrcAdj_rec.ATTRIBUTE15
,l_hdr_PrcAdj_rec.ORIG_SYS_DISCOUNT_REF
,l_hdr_PrcAdj_rec.CHANGE_SEQUENCE
,l_hdr_PrcAdj_rec.UPDATE_ALLOWED
,l_hdr_PrcAdj_rec.CHANGE_REASON_CODE
,l_hdr_PrcAdj_rec.CHANGE_REASON_TEXT
,l_hdr_PrcAdj_rec.COST_ID
,l_hdr_PrcAdj_rec.TAX_CODE
,l_hdr_PrcAdj_rec.TAX_EXEMPT_FLAG
,l_hdr_PrcAdj_rec.TAX_EXEMPT_NUMBER
,l_hdr_PrcAdj_rec.TAX_EXEMPT_REASON_CODE
,l_hdr_PrcAdj_rec.PARENT_ADJUSTMENT_ID
,l_hdr_PrcAdj_rec.INVOICED_FLAG
,l_hdr_PrcAdj_rec.ESTIMATED_FLAG
,l_hdr_PrcAdj_rec.INC_IN_SALES_PERFORMANCE
,l_hdr_PrcAdj_rec.SPLIT_ACTION_CODE
,l_hdr_PrcAdj_rec.ADJUSTED_AMOUNT
,l_hdr_PrcAdj_rec.CHARGE_TYPE_CODE
,l_hdr_PrcAdj_rec.CHARGE_SUBTYPE_CODE
,l_hdr_PrcAdj_rec.RANGE_BREAK_QUANTITY
,l_hdr_PrcAdj_rec.ACCRUAL_CONVERSION_RATE
,l_hdr_PrcAdj_rec.PRICING_GROUP_SEQUENCE
,l_hdr_PrcAdj_rec.ACCRUAL_FLAG
,l_hdr_PrcAdj_rec.LIST_LINE_NO
,l_hdr_PrcAdj_rec.SOURCE_SYSTEM_CODE
,l_hdr_PrcAdj_rec.BENEFIT_QTY
,l_hdr_PrcAdj_rec.BENEFIT_UOM_CODE
,l_hdr_PrcAdj_rec.PRINT_ON_INVOICE_FLAG
,l_hdr_PrcAdj_rec.EXPIRATION_DATE
,l_hdr_PrcAdj_rec.REBATE_TRANSACTION_TYPE_CODE
,l_hdr_PrcAdj_rec.REBATE_TRANSACTION_REFERENCE
,l_hdr_PrcAdj_rec.REBATE_PAYMENT_SYSTEM_CODE
,l_hdr_PrcAdj_rec.REDEEMED_DATE
,l_hdr_PrcAdj_rec.REDEEMED_FLAG
,l_hdr_PrcAdj_rec.MODIFIER_LEVEL_CODE
,l_hdr_PrcAdj_rec.PRICE_BREAK_TYPE_CODE
,l_hdr_PrcAdj_rec.SUBSTITUTION_ATTRIBUTE
,l_hdr_PrcAdj_rec.PRORATION_TYPE_CODE
,l_hdr_PrcAdj_rec.INCLUDE_ON_RETURNS_FLAG
,l_hdr_PrcAdj_rec.CREDIT_OR_CHARGE_FLAG;
SELECT PRICE_ADJUSTMENT_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,QUOTE_HEADER_ID
,QUOTE_LINE_ID
,QUOTE_SHIPMENT_ID
,MODIFIER_HEADER_ID
,MODIFIER_LINE_ID
,MODIFIER_LINE_TYPE_CODE
,MODIFIER_MECHANISM_TYPE_CODE
,MODIFIED_FROM
,MODIFIED_TO
,OPERAND
,ARITHMETIC_OPERATOR
,AUTOMATIC_FLAG
,UPDATE_ALLOWABLE_FLAG
,UPDATED_FLAG
,APPLIED_FLAG
,ON_INVOICE_FLAG
,PRICING_PHASE_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ORIG_SYS_DISCOUNT_REF
,CHANGE_SEQUENCE
,UPDATE_ALLOWED
,CHANGE_REASON_CODE
,CHANGE_REASON_TEXT
,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
,CHARGE_TYPE_CODE
,CHARGE_SUBTYPE_CODE
,RANGE_BREAK_QUANTITY
,ACCRUAL_CONVERSION_RATE
,PRICING_GROUP_SEQUENCE
,ACCRUAL_FLAG
,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
,MODIFIER_LEVEL_CODE
,PRICE_BREAK_TYPE_CODE
,SUBSTITUTION_ATTRIBUTE
,PRORATION_TYPE_CODE
,INCLUDE_ON_RETURNS_FLAG
,CREDIT_OR_CHARGE_FLAG
From ASO_PRICE_ADJUSTMENTS
Where QUOTE_HEADER_ID = p_quote_hdr_id
and QUOTE_LINE_ID is not null;
,l_AllLines_PrcAdj_rec.LAST_UPDATE_DATE
,l_AllLines_PrcAdj_rec.LAST_UPDATED_BY
,l_AllLines_PrcAdj_rec.LAST_UPDATE_LOGIN
,l_AllLines_PrcAdj_rec.PROGRAM_APPLICATION_ID
,l_AllLines_PrcAdj_rec.PROGRAM_ID
,l_AllLines_PrcAdj_rec.PROGRAM_UPDATE_DATE
,l_AllLines_PrcAdj_rec.REQUEST_ID
,l_AllLines_PrcAdj_rec.QUOTE_HEADER_ID
,l_AllLines_PrcAdj_rec.QUOTE_LINE_ID
,l_AllLines_PrcAdj_rec.QUOTE_SHIPMENT_ID
,l_AllLines_PrcAdj_rec.MODIFIER_HEADER_ID
,l_AllLines_PrcAdj_rec.MODIFIER_LINE_ID
,l_AllLines_PrcAdj_rec.MODIFIER_LINE_TYPE_CODE
,l_AllLines_PrcAdj_rec.MODIFIER_MECHANISM_TYPE_CODE
,l_AllLines_PrcAdj_rec.MODIFIED_FROM
,l_AllLines_PrcAdj_rec.MODIFIED_TO
,l_AllLines_PrcAdj_rec.OPERAND
,l_AllLines_PrcAdj_rec.ARITHMETIC_OPERATOR
,l_AllLines_PrcAdj_rec.AUTOMATIC_FLAG
,l_AllLines_PrcAdj_rec.UPDATE_ALLOWABLE_FLAG
,l_AllLines_PrcAdj_rec.UPDATED_FLAG
,l_AllLines_PrcAdj_rec.APPLIED_FLAG
,l_AllLines_PrcAdj_rec.ON_INVOICE_FLAG
,l_AllLines_PrcAdj_rec.PRICING_PHASE_ID
,l_AllLines_PrcAdj_rec.ATTRIBUTE_CATEGORY
,l_AllLines_PrcAdj_rec.ATTRIBUTE1
,l_AllLines_PrcAdj_rec.ATTRIBUTE2
,l_AllLines_PrcAdj_rec.ATTRIBUTE3
,l_AllLines_PrcAdj_rec.ATTRIBUTE4
,l_AllLines_PrcAdj_rec.ATTRIBUTE5
,l_AllLines_PrcAdj_rec.ATTRIBUTE6
,l_AllLines_PrcAdj_rec.ATTRIBUTE7
,l_AllLines_PrcAdj_rec.ATTRIBUTE8
,l_AllLines_PrcAdj_rec.ATTRIBUTE9
,l_AllLines_PrcAdj_rec.ATTRIBUTE10
,l_AllLines_PrcAdj_rec.ATTRIBUTE11
,l_AllLines_PrcAdj_rec.ATTRIBUTE12
,l_AllLines_PrcAdj_rec.ATTRIBUTE13
,l_AllLines_PrcAdj_rec.ATTRIBUTE14
,l_AllLines_PrcAdj_rec.ATTRIBUTE15
,l_AllLines_PrcAdj_rec.ORIG_SYS_DISCOUNT_REF
,l_AllLines_PrcAdj_rec.CHANGE_SEQUENCE
,l_AllLines_PrcAdj_rec.UPDATE_ALLOWED
,l_AllLines_PrcAdj_rec.CHANGE_REASON_CODE
,l_AllLines_PrcAdj_rec.CHANGE_REASON_TEXT
,l_AllLines_PrcAdj_rec.COST_ID
,l_AllLines_PrcAdj_rec.TAX_CODE
,l_AllLines_PrcAdj_rec.TAX_EXEMPT_FLAG
,l_AllLines_PrcAdj_rec.TAX_EXEMPT_NUMBER
,l_AllLines_PrcAdj_rec.TAX_EXEMPT_REASON_CODE
,l_AllLines_PrcAdj_rec.PARENT_ADJUSTMENT_ID
,l_AllLines_PrcAdj_rec.INVOICED_FLAG
,l_AllLines_PrcAdj_rec.ESTIMATED_FLAG
,l_AllLines_PrcAdj_rec.INC_IN_SALES_PERFORMANCE
,l_AllLines_PrcAdj_rec.SPLIT_ACTION_CODE
,l_AllLines_PrcAdj_rec.ADJUSTED_AMOUNT
,l_AllLines_PrcAdj_rec.CHARGE_TYPE_CODE
,l_AllLines_PrcAdj_rec.CHARGE_SUBTYPE_CODE
,l_AllLines_PrcAdj_rec.RANGE_BREAK_QUANTITY
,l_AllLines_PrcAdj_rec.ACCRUAL_CONVERSION_RATE
,l_AllLines_PrcAdj_rec.PRICING_GROUP_SEQUENCE
,l_AllLines_PrcAdj_rec.ACCRUAL_FLAG
,l_AllLines_PrcAdj_rec.LIST_LINE_NO
,l_AllLines_PrcAdj_rec.SOURCE_SYSTEM_CODE
,l_AllLines_PrcAdj_rec.BENEFIT_QTY
,l_AllLines_PrcAdj_rec.BENEFIT_UOM_CODE
,l_AllLines_PrcAdj_rec.PRINT_ON_INVOICE_FLAG
,l_AllLines_PrcAdj_rec.EXPIRATION_DATE
,l_AllLines_PrcAdj_rec.REBATE_TRANSACTION_TYPE_CODE
,l_AllLines_PrcAdj_rec.REBATE_TRANSACTION_REFERENCE
,l_AllLines_PrcAdj_rec.REBATE_PAYMENT_SYSTEM_CODE
,l_AllLines_PrcAdj_rec.REDEEMED_DATE
,l_AllLines_PrcAdj_rec.REDEEMED_FLAG
,l_AllLines_PrcAdj_rec.MODIFIER_LEVEL_CODE
,l_AllLines_PrcAdj_rec.PRICE_BREAK_TYPE_CODE
,l_AllLines_PrcAdj_rec.SUBSTITUTION_ATTRIBUTE
,l_AllLines_PrcAdj_rec.PRORATION_TYPE_CODE
,l_AllLines_PrcAdj_rec.INCLUDE_ON_RETURNS_FLAG
,l_AllLines_PrcAdj_rec.CREDIT_OR_CHARGE_FLAG;
SELECT ADJ_RELATIONSHIP_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,QUOTE_LINE_ID
,QUOTE_SHIPMENT_ID
,PRICE_ADJUSTMENT_ID
,RLTD_PRICE_ADJ_ID
From ASO_PRICE_ADJ_RELATIONSHIPS
Where RLTD_PRICE_ADJ_ID = p_price_adjustment_id;
,l_line_PrcAdjRel_rec.LAST_UPDATE_DATE
,l_line_PrcAdjRel_rec.LAST_UPDATED_BY
,l_line_PrcAdjRel_rec.LAST_UPDATE_LOGIN
,l_line_PrcAdjRel_rec.REQUEST_ID
,l_line_PrcAdjRel_rec.PROGRAM_APPLICATION_ID
,l_line_PrcAdjRel_rec.PROGRAM_ID
,l_line_PrcAdjRel_rec.PROGRAM_UPDATE_DATE
,l_line_PrcAdjRel_rec.QUOTE_LINE_ID
,l_line_PrcAdjRel_rec.QUOTE_SHIPMENT_ID
,l_line_PrcAdjRel_rec.PRICE_ADJUSTMENT_ID
,l_line_PrcAdjRel_rec.RLTD_PRICE_ADJ_ID;
SELECT l.QUOTE_LINE_ID
,l.CREATION_DATE
,l.CREATED_BY
,l.LAST_UPDATE_DATE
,l.LAST_UPDATED_BY
,l.LAST_UPDATE_LOGIN
,l.REQUEST_ID
,l.PROGRAM_APPLICATION_ID
,l.PROGRAM_ID
,l.PROGRAM_UPDATE_DATE
,l.QUOTE_HEADER_ID
,l.ORG_ID
,l.LINE_CATEGORY_CODE
,l.ITEM_TYPE_CODE
,l.LINE_NUMBER
,l.START_DATE_ACTIVE
,l.END_DATE_ACTIVE
,l.ORDER_LINE_TYPE_ID
,l.INVOICE_TO_PARTY_SITE_ID
,l.INVOICE_TO_PARTY_ID
,l.ORGANIZATION_ID
,l.INVENTORY_ITEM_ID
,l.QUANTITY
,l.UOM_CODE
,l.MARKETING_SOURCE_CODE_ID
,l.PRICE_LIST_ID
,l.PRICE_LIST_LINE_ID
,l.CURRENCY_CODE
,l.LINE_LIST_PRICE
,l.LINE_ADJUSTED_AMOUNT
,l.LINE_ADJUSTED_PERCENT
,l.LINE_QUOTE_PRICE
,l.RELATED_ITEM_ID
,l.ITEM_RELATIONSHIP_TYPE
,l.ACCOUNTING_RULE_ID
,l.INVOICING_RULE_ID
,l.SPLIT_SHIPMENT_FLAG
,l.BACKORDER_FLAG
,l.ATTRIBUTE_CATEGORY -- bug 6015035, scnagara, Uncommented the code from ATTRIBUTE_CATEGORY to ATTRIBUTE15
,l.ATTRIBUTE1
,l.ATTRIBUTE2
,l.ATTRIBUTE3
,l.ATTRIBUTE4
,l.ATTRIBUTE5
,l.ATTRIBUTE6
,l.ATTRIBUTE7
,l.ATTRIBUTE8
,l.ATTRIBUTE9
,l.ATTRIBUTE10
,l.ATTRIBUTE11
,l.ATTRIBUTE12
,l.ATTRIBUTE13
,l.ATTRIBUTE14
,l.ATTRIBUTE15 --bug# 3395318
,l.pricing_line_type_indicator
From aso_quote_lines l
Where l.QUOTE_HEADER_ID = l_QUOTE_HEADER_ID
Order by l.quote_line_id;
,l_qte_line_rec.LAST_UPDATE_DATE
,l_qte_line_rec.LAST_UPDATED_BY
,l_qte_line_rec.LAST_UPDATE_LOGIN
,l_qte_line_rec.REQUEST_ID
,l_qte_line_rec.PROGRAM_APPLICATION_ID
,l_qte_line_rec.PROGRAM_ID
,l_qte_line_rec.PROGRAM_UPDATE_DATE
,l_qte_line_rec.QUOTE_HEADER_ID
,l_qte_line_rec.ORG_ID
,l_qte_line_rec.LINE_CATEGORY_CODE
,l_qte_line_rec.ITEM_TYPE_CODE
,l_qte_line_rec.LINE_NUMBER
,l_qte_line_rec.START_DATE_ACTIVE
,l_qte_line_rec.END_DATE_ACTIVE
,l_qte_line_rec.ORDER_LINE_TYPE_ID
,l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID
,l_qte_line_rec.INVOICE_TO_PARTY_ID
,l_qte_line_rec.ORGANIZATION_ID
,l_qte_line_rec.INVENTORY_ITEM_ID
,l_qte_line_rec.QUANTITY
,l_qte_line_rec.UOM_CODE
,l_qte_line_rec.MARKETING_SOURCE_CODE_ID
,l_qte_line_rec.PRICE_LIST_ID
,l_qte_line_rec.PRICE_LIST_LINE_ID
,l_qte_line_rec.CURRENCY_CODE
,l_qte_line_rec.LINE_LIST_PRICE
,l_qte_line_rec.LINE_ADJUSTED_AMOUNT
,l_qte_line_rec.LINE_ADJUSTED_PERCENT
,l_qte_line_rec.LINE_QUOTE_PRICE
,l_qte_line_rec.RELATED_ITEM_ID
,l_qte_line_rec.ITEM_RELATIONSHIP_TYPE
,l_qte_line_rec.ACCOUNTING_RULE_ID
,l_qte_line_rec.INVOICING_RULE_ID
,l_qte_line_rec.SPLIT_SHIPMENT_FLAG
,l_qte_line_rec.BACKORDER_FLAG
,l_qte_line_rec.ATTRIBUTE_CATEGORY -- bug 6015035, scnagara, Uncommented the code
,l_qte_line_rec.ATTRIBUTE1 -- from ATTRIBUTE_CATEGORY to ATTRIBUTE15
,l_qte_line_rec.ATTRIBUTE2
,l_qte_line_rec.ATTRIBUTE3
,l_qte_line_rec.ATTRIBUTE4
,l_qte_line_rec.ATTRIBUTE5
,l_qte_line_rec.ATTRIBUTE6
,l_qte_line_rec.ATTRIBUTE7
,l_qte_line_rec.ATTRIBUTE8
,l_qte_line_rec.ATTRIBUTE9
,l_qte_line_rec.ATTRIBUTE10
,l_qte_line_rec.ATTRIBUTE11
,l_qte_line_rec.ATTRIBUTE12
,l_qte_line_rec.ATTRIBUTE13
,l_qte_line_rec.ATTRIBUTE14
,l_qte_line_rec.ATTRIBUTE15 --bug# 3395318
,l_qte_line_rec.pricing_line_type_indicator;
SELECT l.QUOTE_LINE_ID
,l.CREATION_DATE
,l.CREATED_BY
,l.LAST_UPDATE_DATE
,l.LAST_UPDATED_BY
,l.LAST_UPDATE_LOGIN
,l.REQUEST_ID
,l.PROGRAM_APPLICATION_ID
,l.PROGRAM_ID
,l.PROGRAM_UPDATE_DATE
,l.QUOTE_HEADER_ID
,l.ORG_ID
,l.LINE_CATEGORY_CODE
,l.ITEM_TYPE_CODE
,l.LINE_NUMBER
,l.START_DATE_ACTIVE
,l.END_DATE_ACTIVE
,l.ORDER_LINE_TYPE_ID
,l.INVOICE_TO_PARTY_SITE_ID
,l.INVOICE_TO_PARTY_ID
,l.ORGANIZATION_ID
,l.INVENTORY_ITEM_ID
,l.QUANTITY
,l.UOM_CODE
,l.MARKETING_SOURCE_CODE_ID
,l.PRICE_LIST_ID
,l.PRICE_LIST_LINE_ID
,l.CURRENCY_CODE
,l.LINE_LIST_PRICE
,l.LINE_ADJUSTED_AMOUNT
,l.LINE_ADJUSTED_PERCENT
,l.LINE_QUOTE_PRICE
,l.RELATED_ITEM_ID
,l.ITEM_RELATIONSHIP_TYPE
,l.ACCOUNTING_RULE_ID
,l.INVOICING_RULE_ID
,l.SPLIT_SHIPMENT_FLAG
,l.BACKORDER_FLAG
,l.ATTRIBUTE_CATEGORY
,l.ATTRIBUTE1
,l.ATTRIBUTE2
,l.ATTRIBUTE3
,l.ATTRIBUTE4
,l.ATTRIBUTE5
,l.ATTRIBUTE6
,l.ATTRIBUTE7
,l.ATTRIBUTE8
,l.ATTRIBUTE9
,l.ATTRIBUTE10
,l.ATTRIBUTE11
,l.ATTRIBUTE12
,l.ATTRIBUTE13
,l.ATTRIBUTE14
,l.ATTRIBUTE15
,l.MINISITE_ID
From aso_quote_lines l
Where l.QUOTE_LINE_ID = l_QTE_LINE_ID;
,l_qte_line_rec.LAST_UPDATE_DATE
,l_qte_line_rec.LAST_UPDATED_BY
,l_qte_line_rec.LAST_UPDATE_LOGIN
,l_qte_line_rec.REQUEST_ID
,l_qte_line_rec.PROGRAM_APPLICATION_ID
,l_qte_line_rec.PROGRAM_ID
,l_qte_line_rec.PROGRAM_UPDATE_DATE
,l_qte_line_rec.QUOTE_HEADER_ID
,l_qte_line_rec.ORG_ID
,l_qte_line_rec.LINE_CATEGORY_CODE
,l_qte_line_rec.ITEM_TYPE_CODE
,l_qte_line_rec.LINE_NUMBER
,l_qte_line_rec.START_DATE_ACTIVE
,l_qte_line_rec.END_DATE_ACTIVE
,l_qte_line_rec.ORDER_LINE_TYPE_ID
,l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID
,l_qte_line_rec.INVOICE_TO_PARTY_ID
,l_qte_line_rec.ORGANIZATION_ID
,l_qte_line_rec.INVENTORY_ITEM_ID
,l_qte_line_rec.QUANTITY
,l_qte_line_rec.UOM_CODE
,l_qte_line_rec.MARKETING_SOURCE_CODE_ID
,l_qte_line_rec.PRICE_LIST_ID
,l_qte_line_rec.PRICE_LIST_LINE_ID
,l_qte_line_rec.CURRENCY_CODE
,l_qte_line_rec.LINE_LIST_PRICE
,l_qte_line_rec.LINE_ADJUSTED_AMOUNT
,l_qte_line_rec.LINE_ADJUSTED_PERCENT
,l_qte_line_rec.LINE_QUOTE_PRICE
,l_qte_line_rec.RELATED_ITEM_ID
,l_qte_line_rec.ITEM_RELATIONSHIP_TYPE
,l_qte_line_rec.ACCOUNTING_RULE_ID
,l_qte_line_rec.INVOICING_RULE_ID
,l_qte_line_rec.SPLIT_SHIPMENT_FLAG
,l_qte_line_rec.BACKORDER_FLAG
,l_qte_line_rec.ATTRIBUTE_CATEGORY
,l_qte_line_rec.ATTRIBUTE1
,l_qte_line_rec.ATTRIBUTE2
,l_qte_line_rec.ATTRIBUTE3
,l_qte_line_rec.ATTRIBUTE4
,l_qte_line_rec.ATTRIBUTE5
,l_qte_line_rec.ATTRIBUTE6
,l_qte_line_rec.ATTRIBUTE7
,l_qte_line_rec.ATTRIBUTE8
,l_qte_line_rec.ATTRIBUTE9
,l_qte_line_rec.ATTRIBUTE10
,l_qte_line_rec.ATTRIBUTE11
,l_qte_line_rec.ATTRIBUTE12
,l_qte_line_rec.ATTRIBUTE13
,l_qte_line_rec.ATTRIBUTE14
,l_qte_line_rec.ATTRIBUTE15
,l_qte_line_rec.MINISITE_ID;
SELECT last_update_date
,ORG_ID
,QUOTE_NAME
,QUOTE_NUMBER
,QUOTE_VERSION
,QUOTE_STATUS_ID
,QUOTE_SOURCE_CODE
,QUOTE_EXPIRATION_DATE
,PRICE_FROZEN_DATE
,QUOTE_PASSWORD
,ORIGINAL_SYSTEM_REFERENCE
,PARTY_ID
,CUST_ACCOUNT_ID
,ORG_CONTACT_ID
,PHONE_ID
,INVOICE_TO_PARTY_SITE_ID
,INVOICE_TO_PARTY_ID
,ORIG_MKTG_SOURCE_CODE_ID
,MARKETING_SOURCE_CODE_ID
,ORDER_TYPE_ID
,QUOTE_CATEGORY_CODE
,ORDERED_DATE
,ACCOUNTING_RULE_ID
,INVOICING_RULE_ID
,EMPLOYEE_PERSON_ID
,PRICE_LIST_ID
,CURRENCY_CODE
,TOTAL_LIST_PRICE
,TOTAL_ADJUSTED_AMOUNT
,TOTAL_ADJUSTED_PERCENT
,TOTAL_TAX
,TOTAL_SHIPPING_CHARGE
,SURCHARGE
,TOTAL_QUOTE_PRICE
,PAYMENT_AMOUNT
,EXCHANGE_RATE
,EXCHANGE_TYPE_CODE
,EXCHANGE_RATE_DATE
,CONTRACT_ID
,SALES_CHANNEL_CODE
,ORDER_ID
FROM aso_quote_headers
WHERE quote_header_id = p_quote_header_id;
l_qte_header_rec.last_update_date
,l_qte_header_rec.ORG_ID
,l_qte_header_rec.QUOTE_NAME
,l_qte_header_rec.QUOTE_NUMBER
,l_qte_header_rec.QUOTE_VERSION
,l_qte_header_rec.QUOTE_STATUS_ID
,l_qte_header_rec.QUOTE_SOURCE_CODE
,l_qte_header_rec.QUOTE_EXPIRATION_DATE
,l_qte_header_rec.PRICE_FROZEN_DATE
,l_qte_header_rec.QUOTE_PASSWORD
,l_qte_header_rec.ORIGINAL_SYSTEM_REFERENCE
,l_qte_header_rec.PARTY_ID
,l_qte_header_rec.CUST_ACCOUNT_ID
,l_qte_header_rec.ORG_CONTACT_ID
,l_qte_header_rec.PHONE_ID
,l_qte_header_rec.INVOICE_TO_PARTY_SITE_ID
,l_qte_header_rec.INVOICE_TO_PARTY_ID
,l_qte_header_rec.ORIG_MKTG_SOURCE_CODE_ID
,l_qte_header_rec.MARKETING_SOURCE_CODE_ID
,l_qte_header_rec.ORDER_TYPE_ID
,l_qte_header_rec.QUOTE_CATEGORY_CODE
,l_qte_header_rec.ORDERED_DATE
,l_qte_header_rec.ACCOUNTING_RULE_ID
,l_qte_header_rec.INVOICING_RULE_ID
,l_qte_header_rec.EMPLOYEE_PERSON_ID
,l_qte_header_rec.PRICE_LIST_ID
,l_qte_header_rec.CURRENCY_CODE
,l_qte_header_rec.TOTAL_LIST_PRICE
,l_qte_header_rec.TOTAL_ADJUSTED_AMOUNT
,l_qte_header_rec.TOTAL_ADJUSTED_PERCENT
,l_qte_header_rec.TOTAL_TAX
,l_qte_header_rec.TOTAL_SHIPPING_CHARGE
,l_qte_header_rec.SURCHARGE
,l_qte_header_rec.TOTAL_QUOTE_PRICE
,l_qte_header_rec.PAYMENT_AMOUNT
,l_qte_header_rec.EXCHANGE_RATE
,l_qte_header_rec.EXCHANGE_TYPE_CODE
,l_qte_header_rec.EXCHANGE_RATE_DATE
,l_qte_header_rec.CONTRACT_ID
,l_qte_header_rec.SALES_CHANNEL_CODE
,l_qte_header_rec.ORDER_ID;
SELECT payment_id
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,quote_header_id
,quote_line_id
,payment_type_code
,payment_ref_number
,payment_option
,payment_term_id
,credit_card_code
,credit_card_holder_name
,credit_card_expiration_date
,credit_card_approval_code
,credit_card_approval_date
,payment_amount
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,trxn_extension_id
FROM ASO_PAYMENTS
WHERE quote_header_id = p_quote_header_id
AND quote_line_id IS NULL;
SELECT instr_assignment_id
FROM IBY_TRXN_EXTENSIONS_V
WHERE trxn_extension_id = p_trxn_extn_id;
,l_payment_rec.last_update_date
,l_payment_rec.last_updated_by
,l_payment_rec.last_update_login
,l_payment_rec.request_id
,l_payment_rec.program_application_id
,l_payment_rec.program_id
,l_payment_rec.program_update_date
,l_payment_rec.quote_header_id
,l_payment_rec.quote_line_id
,l_payment_rec.payment_type_code
,l_payment_rec.payment_ref_number
,l_payment_rec.payment_option
,l_payment_rec.payment_term_id
,l_payment_rec.credit_card_code
,l_payment_rec.credit_card_holder_name
,l_payment_rec.credit_card_expiration_date
,l_payment_rec.credit_card_approval_code
,l_payment_rec.credit_card_approval_date
,l_payment_rec.payment_amount
,l_payment_rec.attribute_category
,l_payment_rec.attribute1
,l_payment_rec.attribute2
,l_payment_rec.attribute3
,l_payment_rec.attribute4
,l_payment_rec.attribute5
,l_payment_rec.attribute6
,l_payment_rec.attribute7
,l_payment_rec.attribute8
,l_payment_rec.attribute9
,l_payment_rec.attribute10
,l_payment_rec.attribute11
,l_payment_rec.attribute12
,l_payment_rec.attribute13
,l_payment_rec.attribute14
,l_payment_rec.attribute15
,l_payment_rec.trxn_extension_id;
SELECT update_privilege_type_code
INTO l_privilege_type_code
FROM IBE_SH_QUOTE_ACCESS
WHERE quote_header_id = p_quote_header_id
AND quote_sharee_number = p_sharee_number;
SELECT party_type
FROM hz_parties
WHERE party_id = c_party_id;
PROCEDURE validateQuoteLastUpdateDate(
p_api_version_number IN NUMBER
,p_quote_header_id IN NUMBER
,p_last_update_date IN DATE
,X_Return_Status OUT NOCOPY VARCHAR2
,X_Msg_Count OUT NOCOPY NUMBER
,X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'validateQuoteLastUpdateDate';
l_last_update_date DATE;
SAVEPOINT validateLastUpdate_pvt;
l_last_update_date :=IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
if (l_last_update_date <> p_last_update_date) then
-- raise error
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
IBE_Util.Debug('Expected exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
ROLLBACK TO validateLastUpdate_pvt;
IBE_Util.Debug('Unexpected exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
ROLLBACK TO validateLastUpdate_pvt;
IBE_Util.Debug('Unknown exception in IBE_QUOTE_MISC_PVT.ValidateQuotelastUpdateDate');
ROLLBACK TO validateLastUpdate_pvt;
END validateQuoteLastUpdateDate;
SELECT party_id, cust_account_id
FROM aso_quote_headers
WHERE quote_header_id = p_quote_header_id;
x_last_update_date OUT NOCOPY DATE ,
x_return_status OUT NOCOPY VARCHAR2 ,
x_msg_count OUT NOCOPY NUMBER ,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'getshareeQuote';
l_last_update_date DATE := FND_API.G_MISS_DATE;
'SELECT quote_header_id,
last_update_date
FROM aso_quote_headers
WHERE quote_number = :1
AND quote_version = :2 ';
SELECT MAX(quote_version)
INTO l_quote_version
FROM aso_quote_headers
WHERE quote_number = p_quote_number;
INTO l_quote_header_id, l_last_update_date
USING p_quote_number, l_quote_version;
INTO l_quote_header_id, l_last_update_date
USING p_quote_number, l_quote_version, p_quote_password;
x_last_update_date := l_last_update_date;
select count(s.inventory_item_id)
into l_item_exists
from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
where s.section_item_id = b.section_item_id
and b.mini_site_id = p_minisite_id
and s.inventory_item_id = l_inventory_item_id
and (s.end_date_active > sysdate or s.end_date_active is null )
and s.start_date_active < sysdate;
select resource_id, status_code, publish_flag, quote_expiration_date,
max_version_flag , order_id, quote_name
from aso_quote_headers_all a, aso_quote_statuses_vl b
where quote_header_id = quote_hdr_id
and a.quote_status_id = b.quote_status_id;
select quote_header_id
from aso_quote_headers_all a
where quote_number = quote_num
and quote_version = quote_ver;
select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code, quote_header_id
from IBE_SH_QUOTE_ACCESS
where quote_sharee_number = c_retrieval_number;
select quote_sharee_number, quote_sharee_id, end_date_active, update_privilege_type_code
from IBE_SH_QUOTE_ACCESS
where quote_header_id = c_quote_header_id
and party_id = c_party_id
and cust_account_id = c_account_id;
L_LOAD_FORUPDATE CONSTANT number := 2;
L_UPDATE CONSTANT number := 2;
l_access_code := rec_retrieval_number.update_privilege_type_code;
l_access_code := rec_recipient_no_retnum.update_privilege_type_code;
Elsif ((p_access_level = L_UPDATE) or (p_access_level = L_FULL)) then
-- if a certain access level was passed in, then see if the db access level is sufficient
if (p_access_level = L_UPDATE and (l_access_code <> 'F' or l_access_code <> 'A')) or
(p_access_level = L_FULL and (l_access_code <> 'A')) then
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.debug('Including the Error code: IBE_SC_ERR_PRIVILEGE');
IBE_UTIL.debug('Including the Error code: IBE_SC_CART_DELETED');
X_reason_code(table_counter) := 'IBE_SC_CART_DELETED';
Elsif(p_load_type = L_LOAD_FORUPDATE) then
If (l_resource_id is not null and (l_resource_id <> FND_API.G_MISS_NUM)) THEN
If (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' and l_status_code <> 'DRAFT') THEN
-- Update on Draft profile enabled, only allow updates on DRAFT.
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.debug('Including the Error code: IBE_SC_INVALID_QUOTE_STS');
Else -- for a cart, check for 'STORE DRAFT' (if the loadType is load_forupdate, status has to be 'STORE DRAFT')
If (l_status_code <> 'STORE DRAFT') Then
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.debug('Including the Error code: IBE_SC_INVALID_CART_STS');
IBE_UTIL.debug('Including the Error code: IBE_SC_CART_DELETED');
X_reason_code(table_counter) := 'IBE_SC_CART_DELETED';
,x_last_update_date OUT NOCOPY DATE
)
is
CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
select quote_header_id, last_update_date
from aso_quote_headers_all
where quote_header_id = (select max(quote_header_id)
from aso_quote_headers_all
where upper(quote_source_code) = 'ISTORE ACCOUNT'
and party_id = p_partyid
and cust_account_id = p_cust_accountid
and quote_name = 'IBEACTIVECART'
and quote_expiration_date > sysdate
and resource_id IS NULL
and ORDER_ID IS NULL);
x_last_update_date := Rec_get_quote_id.last_update_date;
PROCEDURE Update_Config_Item_Lines(
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER ,
x_msg_data OUT NOCOPY VARCHAR2,
px_qte_line_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Config_Item_Lines';
SAVEPOINT Update_Config_Item_Lines;
IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(+)');
IBE_Util.Debug('IBE_Quote_Misc_pvt.Update_Config_Item_Lines(-)');
IBE_Util.Debug('Expected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
ROLLBACK to Update_config_item_lines;
IBE_Util.Debug('Unexpected error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
ROLLBACK to Update_config_item_lines;
IBE_Util.Debug('Unknown error IBE_Quote_Misc_pvt.Update_Config_Item_Lines');
ROLLBACK to Update_config_item_lines;
END Update_Config_Item_Lines;
select count(s.inventory_item_id)
into l_item_exists
from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
where s.section_item_id = b.section_item_id
and b.mini_site_id = p_minisite_id
and s.inventory_item_id = p_merchant_item_ids(i)
and (s.end_date_active > sysdate or s.end_date_active is null )
and s.start_date_active < sysdate;
SELECT related_quote_line_id
FROM aso_line_relationships
START WITH quote_line_id = p_qte_line_id
CONNECT BY quote_line_id = PRIOR related_quote_line_id;
SELECT
PRICE_ADJUSTMENT_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
QUOTE_HEADER_ID,
QUOTE_LINE_ID,
MODIFIER_HEADER_ID,
MODIFIER_LINE_ID,
MODIFIER_LINE_TYPE_CODE,
MODIFIER_MECHANISM_TYPE_CODE,
MODIFIED_FROM,
MODIFIED_TO,
OPERAND,
ARITHMETIC_OPERATOR,
AUTOMATIC_FLAG,
UPDATE_ALLOWABLE_FLAG,
UPDATED_FLAG,
APPLIED_FLAG,
ON_INVOICE_FLAG,
PRICING_PHASE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
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,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
RANGE_BREAK_QUANTITY,
ACCRUAL_CONVERSION_RATE,
PRICING_GROUP_SEQUENCE,
ACCRUAL_FLAG,
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,
MODIFIER_LEVEL_CODE,
PRICE_BREAK_TYPE_CODE,
SUBSTITUTION_ATTRIBUTE,
PRORATION_TYPE_CODE,
INCLUDE_ON_RETURNS_FLAG,
CREDIT_OR_CHARGE_FLAG,
ORIG_SYS_DISCOUNT_REF,
CHANGE_REASON_CODE,
CHANGE_REASON_TEXT,
COST_ID,
LIST_LINE_TYPE_CODE,
UPDATE_ALLOWED,
CHANGE_SEQUENCE,
LIST_HEADER_ID,
LIST_LINE_ID,
QUOTE_SHIPMENT_ID
FROM ASO_PRICE_ADJUSTMENTS
WHERE quote_header_id = p_qte_header_id AND
(quote_line_id = p_qte_line_id OR
(quote_line_id IS NULL AND p_qte_line_id IS NULL))
AND modifier_line_type_code <> 'PRG';
l_price_adj_rec.LAST_UPDATE_DATE := price_adj_rec.LAST_UPDATE_DATE;
l_price_adj_rec.LAST_UPDATED_BY := price_adj_rec.LAST_UPDATED_BY;
l_price_adj_rec.LAST_UPDATE_LOGIN := price_adj_rec.LAST_UPDATE_LOGIN;
l_price_adj_rec.PROGRAM_UPDATE_DATE := price_adj_rec.PROGRAM_UPDATE_DATE;
l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := price_adj_rec.UPDATE_ALLOWABLE_FLAG;
l_price_adj_rec.UPDATED_FLAG := price_adj_rec.UPDATED_FLAG;
l_price_adj_rec.UPDATE_ALLOWED := price_adj_rec.UPDATE_ALLOWED;
,p_last_update_date IN OUT NOCOPY DATE
,p_party_id IN NUMBER := FND_API.G_MISS_NUM
,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Split_Line';
l_last_update_date DATE;
lx_last_update_date DATE;
l_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
IF (l_last_update_date <> p_last_update_date) then
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.Debug('comparing dates');
p_last_update_date := l_last_update_date;
IBE_Quote_Misc_pvt.Validate_User_Update
( p_init_msg_list => p_init_msg_list
,p_quote_header_id => p_quote_header_id
,p_party_id => p_party_id
,p_cust_account_id => p_cust_account_id
,p_quote_retrieval_number => p_quote_retrieval_number
,p_validate_user => p_validate_user
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdatedate(p_quote_header_id);
select a.resource_id,
a.publish_flag,
b.status_code,
a.party_id,
a.cust_account_id,
a.quote_source_code
from aso_quote_headers a ,
aso_quote_statuses_b b
where a.quote_status_id = b.quote_status_id
and a.quote_header_id = p_quote_header_id;
select quote_header_id
from ibe_active_quotes
where quote_header_id = c_quote_header_id
and party_id = c_party_id
and cust_account_id = c_cust_account_id
and record_type = 'CART';
IF (FND_Profile.Value('IBE_UPDATE_DRAFT_QUOTES') = 'Y' ) THEN -- Update on Draft profile enabled, only allow updates on DRAFT.
IF (l_status_code <> 'DRAFT') THEN
IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_QUOTE_STS');
ELSE -- update profile is not enabled, but update call for quote is coming down.
IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
FND_Message.Set_Name('IBE', 'IBE_SC_INVALID_OPERATION'); -- Invalid Operation
IF (p_save_type <> END_WORKING AND p_save_type <> OP_DELETE_CART) THEN
IF ((p_save_type = UPDATE_EXPRESSORDER OR p_save_type = SAVE_EXPRESSORDER)
AND (l_source_code <> 'IStore Oneclick')) THEN
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.DEBUG('Validate_quote: Oneclick operation on a non-oneclick cart');
IF ((p_save_type <> UPDATE_EXPRESSORDER AND p_save_type <> SAVE_EXPRESSORDER)
AND (l_source_code = 'IStore Oneclick')) THEN
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.DEBUG('Validate_quote: Non-Oneclick operation on a oneclick cart');
PROCEDURE Validate_User_Update(
p_api_version_number IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
,p_quote_header_id IN NUMBER
,p_party_id IN NUMBER := FND_API.G_MISS_NUM
,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
,p_privilege_type_code IN VARCHAR2 := 'F'
,p_save_type IN NUMBER := FND_API.G_MISS_NUM
,p_last_update_date IN DATE := FND_API.G_MISS_DATE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Validate_User_Update';
l_last_update_date DATE;
l_last_updated_by NUMBER;
SELECT customer_id
from fnd_user
WHERE user_id = c_user_id;
SELECT quote_header_id,update_privilege_type_code,end_date_active, party_id, cust_account_id
from ibe_sh_quote_access
where quote_sharee_number = p_quote_retrieval_number
and quote_header_id = p_quote_header_id;
SELECT count(*)
from ibe_sh_quote_access
where party_id = c_party_id
and quote_header_id = p_quote_header_id;
SELECT quote_header_id
from aso_quote_headers_all
where quote_header_id = p_quote_header_id
AND (party_id = l_party_id OR (party_id = p_party_id AND cust_account_id = p_cust_account_id));
select resource_id
from jtf_rs_resource_extns
where user_id = l_user_id;
SELECT j.resource_id
FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j
WHERE j.user_id = l_user_id
AND j.resource_id = srp.resource_id
AND srp.status = 'A'
AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)
AND nvl(trunc(srp.end_date_active), trunc(sysdate)) >= trunc(sysdate)
AND NVL(srp.org_id,MO_GLOBAL.get_current_org_id()) = MO_GLOBAL.get_current_org_id();
Cursor c_last_update_date(c_quote_hdr_id number) is
SELECT status_code,
a.last_update_date,
a.last_updated_by,
a.party_id,
a.resource_id
FROM aso_quote_headers a,
aso_quote_statuses_vl b
WHERE quote_header_id = c_quote_hdr_id
and a.quote_status_id = b.quote_status_id;
rec_last_update_date c_last_update_date%rowtype;
select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;
IBE_UTIL.DEBUG('Begin validate_user_update' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
IBE_UTIL.DEBUG('rec_sharee_info.update_privilege_type_code : '||rec_sharee_info.update_privilege_type_code);
l_privilege_type_code := rec_sharee_info.update_privilege_type_code;
IBE_UTIL.DEBUG('Validate_user_update: Before Last update date validation,p_last_update_date= '||p_last_update_date);
IF (p_last_update_date <> FND_API.G_MISS_DATE) THEN
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.DEBUG('Validate_user_update: Last update date validation START');
FOR rec_last_update_date in c_last_update_date(p_quote_header_id) LOOP
l_last_update_date := rec_last_update_date.last_update_date;
l_quote_status := rec_last_update_date.status_code;
l_last_updated_by := rec_last_update_date.last_updated_by;
l_owner_party_id := rec_last_update_date.party_id;
l_resource_id := rec_last_update_date.resource_id;
EXIT when c_last_update_date%NOTFOUND;
IBE_UTIL.DEBUG('Validate_user_update: l_last_update_date='||to_char(l_last_update_date,'mm/dd/yyyy:hh24:MI:SS'));
IBE_UTIL.DEBUG('Validate_user_update: p_last_update_date='||to_char(p_last_update_date,'mm/dd/yyyy:hh24:MI:SS'));
IF(l_last_update_date <> p_last_update_date) THEN
IF (l_quote_status = 'ORDER SUBMITTED') THEN
IF (IBE_UTIL.G_DEBUGON = l_true) THEN
IBE_UTIL.DEBUG('Validate_user_update: raising Quote_already_ordered error');
IF ((l_last_updated_by <> l_user_id) OR (p_save_type = PLACE_ORDER)) THEN
-- determine which error message we need to show
OPEN c_getPartyInfo(l_last_updated_by);
IBE_UTIL.DEBUG('Validate_user_update: l_last_upd_party_id : ' || l_last_upd_party_id);
IBE_UTIL.DEBUG('Validate_user_update: l_owner_party_id : ' || l_owner_party_id);
IBE_UTIL.DEBUG('Validate_user_update: l_resource_id : ' || l_resource_id);
IBE_UTIL.DEBUG('Validate_user_update: raising Quote_needs_refresh error : ' || l_err_code);
IBE_UTIL.DEBUG('Validate_user_update: Last update date validation END');
END IF; -- last_update_date validation end.
IBE_UTIL.DEBUG('End validate_user_update' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
IBE_Util.Debug('End:Expected exception:IBE_Quote_Misc_pvt.validate_user_update');
IBE_Util.Debug('End:Unexpected exception:IBE_Quote_Misc_pvt.validate_user_update');
IBE_Util.Debug('End:Others exception:IBE_Quote_Misc_pvt.validate_user_update');
END validate_user_update;
select quote_sharee_id
from ibe_sh_quote_access
where quote_sharee_number = c_retrieval_num ;
select cust_account_id, party_type
from aso_quote_headers_all a, hz_parties p
where a.party_id = p.party_id
and quote_header_id = c_quote_header_id;
select party_type
from hz_parties
where party_id = c_party_id;
IBE_SH_QUOTE_ACCESS_PKG.update_Row(
p_QUOTE_SHAREE_ID => l_recip_id
,p_party_id => p_party_id
,p_cust_account_id => p_cust_account_id);
select fnd_global.resp_appl_id appId from dual;
select fnd_global.resp_id respId from dual;
select fnd_global.user_id userId from dual;
SELECT (MO_GLOBAL.get_current_org_id()) orgId from dual;
SELECT FND_GLOBAL.SESSION_ID session_id
,FND_GLOBAL.USER_NAME user_name
,FND_GLOBAL.LOGIN_ID login_id
,userenv('CLIENT_INFO') client_info
,userenv('LANG') lang
FROM dual;
SELECT SESSION_ID
,USER_ID
,RESPONSIBILITY_ID
,ORG_ID
,NLS_LANGUAGE
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,RESPONSIBILITY_APPLICATION_ID
,SECURITY_GROUP_ID
,PAGE_ID,LOGIN_ID
,TIME_OUT
FROM icx_sessions
WHERE session_id = p_session_id;
SELECT * from MO_GLOB_ORG_ACCESS_TMP;
SELECT sys_context('multi_org2','current_org_id') sys_context from dual;
IBE_UTIL.DEBUG('last_updated_by='||rec_ICXSessionDetails.last_updated_by);
IBE_UTIL.DEBUG('last_update_date='||rec_ICXSessionDetails.last_update_date);
IBE_UTIL.DEBUG('last_update_login='||rec_ICXSessionDetails.last_update_login);
select HP.party_id,HP.party_name
from hz_relationships HPR,hz_parties HP where hpr.party_id = p_party_id
and HPR.subject_type = 'PERSON'
and HPR.object_type = 'ORGANIZATION'
and hp.party_id=HPR.subject_id;
select party_id,party_name
from hz_parties HP where party_id = p_party_id;
,p_last_update_date IN DATE :=FND_API.G_MISS_DATE
,p_save_type IN NUMBER := FND_API.G_MISS_NUM
,x_last_update_date OUT NOCOPY DATE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Add_Attachment';
IBE_Util.Debug('Call to Validate_User_Update');
IBE_Quote_Misc_pvt.Validate_User_Update
( p_init_msg_list => p_Init_Msg_List
,p_quote_header_id => p_quote_header_id
,p_party_id => p_party_id
,p_cust_account_id => p_cust_account_id
,p_validate_user => p_validate_user
,p_quote_retrieval_number => p_retrieval_number
,p_save_type => p_save_type
,p_last_update_date => p_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
PROCEDURE Delete_Attachment(
p_api_version_number IN NUMBER
,p_init_msg_list IN VARCHAR2
,p_commit IN VARCHAR2
,p_quote_header_id IN NUMBER
,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
,p_last_update_date IN DATE
,p_party_id IN NUMBER
,p_cust_account_id IN NUMBER
,p_retrieval_number IN NUMBER
,x_last_update_date OUT NOCOPY DATE
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attachment';
IBE_Util.Debug('Begin IBE_Quote_Misc_pvt.Delete_Attachment()');
IBE_Util.Debug('Call to Validate_User_Update');
IBE_Quote_Misc_pvt.Validate_User_Update(
p_quote_header_id => p_quote_header_id
,p_party_id => p_party_id
,p_cust_account_id => p_cust_account_id
,p_validate_user => FND_API.G_TRUE
,p_quote_retrieval_number => p_retrieval_number
,p_last_update_date => p_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
IBE_Util.Debug('Call to ASO_ATTACHMENT_INT.Delete_Attachment');
ASO_ATTACHMENT_INT.Delete_Attachments
(
p_api_version_number => p_api_version_number
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,p_quote_header_id => p_quote_header_id
,p_quote_attachment_ids => p_quote_attachment_ids
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
IBE_Util.Debug('End ASO_ATTACHMENT_INT.Delete_Attachment');
x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
x_last_update_date := getQuoteLastUpdateDate(p_quote_header_id);
IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
IBE_Util.Debug('End IBE_Quote_Misc_pvt.Delete_Attachment()');
END Delete_Attachment;
select status_code
from aso_quote_headers_all a, aso_quote_statuses_vl b
where quote_header_id = quote_hdr_id
and a.quote_status_id = b.quote_status_id;