[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT group_number, retroactive_flag, beneficiary_party_id, combine_schedule_flag, volume_tracking_level_code, accrue_to_code, precedence
FROM ozf_offr_market_options
WHERE qp_list_header_id = cp_listHeaderId
AND group_number = cp_groupNumber;
SELECT offer_market_option_id , object_version_number, group_number
FROM ozf_offr_market_options
WHERE offer_id = cp_offerId;
OZF_offer_Market_Options_PVT.Update_market_options(
p_api_version_number => 1.0
, p_init_msg_list => FND_API.G_FALSE
, p_commit => FND_API.G_FALSE
, p_validation_level => FND_API.G_VALID_LEVEL_FULL
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
, p_mo_rec => l_mo_rec
);
SELECT product_context
, product_attribute
, product_attr_value
, apply_discount_flag
, include_volume_flag
, excluder_flag
FROM ozf_offer_discount_products
WHERE offer_discount_line_id = cp_sourceTierHeaderId;
SELECT qualifier_context
, qualifier_attribute
, qualifier_attr_value
, comparison_operator_code
, qualifier_attr_value_to
, qualifier_grouping_no
, list_header_id
, start_date_active
, end_date_active
, active_flag
, context
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
FROM qp_qualifiers
WHERE list_header_id = cp_listHeaderId;
SELECT volume_from
, volume_to
, discount
, formula_id
, tier_type
, volume_operator
, volume_break_type
, tier_level
FROM ozf_offer_discount_lines
WHERE parent_discount_line_id = cp_parentDiscountId;
SELECT a.volume_type
, a.volume_break_type
, a.discount_type
, a.uom_code
, c.discount_table_name
, c.description
, a.tier_level
, a.offer_discount_line_id
FROM ozf_offer_discount_lines a, ozf_offr_disc_struct_name_b b , ozf_offr_disc_struct_name_tl c
WHERE a.offer_discount_line_id = b.offer_discount_Line_id
AND b.offr_disc_struct_name_id = c.offr_disc_struct_name_id
AND c.language = USERENV('LANG')
AND a.offer_id = cp_offerId;
SELECT offer_id FROM ozf_offers
WHERE qp_list_header_id = cp_listHeaderId;
SELECT a.modifier_level_code
, a.offer_type
, a.activity_media_id
, a.reusable
, b.list_type_code
, a.transaction_currency_code
, a.perf_date_from
, a.perf_date_to
, a.custom_setup_id
, a.functional_currency_code
, b.currency_code
, b.ask_for_flag
, b.start_date_active_first
, b.end_date_active_first
, b.active_date_first_type
, b.start_date_active_second
, b.end_date_active_second
, b.active_date_second_type
, a.budget_source_type
, a.budget_source_id
, a.budget_amount_tc
, a.offer_amount
, a.volume_offer_type
, a.budget_offer_yn
, a.confidential_flag
, a.source_from_parent
, b.global_flag
, b.orig_org_id
, b.context
, b.attribute1
, b.attribute2
, b.attribute3
, b.attribute4
, b.attribute5
, b.attribute6
, b.attribute7
, b.attribute8
, b.attribute9
, b.attribute10
, b.attribute11
, b.attribute12
, b.attribute13
, b.attribute14
, b.attribute15
FROM ozf_offers a, qp_list_headers_all b
WHERE a.qp_list_header_id = b.list_header_id
AND a.qp_list_header_id = p_listHeaderId;
SELECT offer_id FROM ozf_offers
WHERE qp_list_header_id = cp_listHeaderId ;
SELECT *
FROM qp_modifier_summary_v
WHERE list_header_id = l_org_list_header_id;
SELECT list_line_id
FROM qp_modifier_summary_v
WHERE list_header_id = l_new_list_header_id
AND list_line_type_code = l_mod_sum_rec.list_line_type_code
AND automatic_flag = l_mod_sum_rec.automatic_flag
AND modifier_level_code = l_mod_sum_rec.modifier_level_code
AND NVL(price_break_type_code,'z') = NVL(l_mod_sum_rec.price_break_type_code,'z')
AND NVL(operand,-99999) = NVL(l_mod_sum_rec.operand,-99999)
AND NVL(arithmetic_operator,'z') = NVL(l_mod_sum_rec.arithmetic_operator,'z')
AND NVL(override_flag,'z') = NVL(l_mod_sum_rec.override_flag,'z')
AND NVL(print_on_invoice_flag,'z') = NVL(l_mod_sum_rec.print_on_invoice_flag,'z')
AND NVL(pricing_group_sequence,-99999) = NVL(l_mod_sum_rec.pricing_group_sequence,-99999)
AND NVL(incompatibility_grp_code,'z') = NVL(l_mod_sum_rec.incompatibility_grp_code,'z')
AND NVL(product_precedence,-99999) = NVL(l_mod_sum_rec.product_precedence,-99999)
AND NVL(pricing_phase_id,-99999) = NVL(l_mod_sum_rec.pricing_phase_id,-99999)
AND NVL(product_attribute_context,'z') = NVL(l_mod_sum_rec.product_attribute_context,'z')
AND NVL(product_attr,'z') = NVL(l_mod_sum_rec.product_attr,'z')
AND NVL(product_attr_val,'z') = NVL(l_mod_sum_rec.product_attr_val,'z')
AND NVL(product_uom_code,'z') = NVL(l_mod_sum_rec.product_uom_code,'z')
AND NVL(comparison_operator_code,'z') = NVL(l_mod_sum_rec.comparison_operator_code,'z')
AND NVL(pricing_attribute_context,'z') = NVL(l_mod_sum_rec.pricing_attribute_context,'z')
AND NVL(pricing_attr,'z') = NVL(l_mod_sum_rec.pricing_attr,'z')
AND NVL(pricing_attr_value_from,'z') = NVL(l_mod_sum_rec.pricing_attr_value_from,'z')
AND NVL(pricing_attr_value_to,'z') = NVL(l_mod_sum_rec.pricing_attr_value_to,'z')
AND NVL(excluder_flag,'z') = NVL(l_mod_sum_rec.excluder_flag,'z')
AND NVL(attribute_grouping_no,-99999) = NVL(l_mod_sum_rec.attribute_grouping_no,-99999)
AND NVL(to_rltd_modifier_id,'z') = NVL(l_mod_sum_rec.to_rltd_modifier_id,'z')
AND NVL(rltd_modifier_id,'z') = NVL(l_mod_sum_rec.rltd_modifier_id,'z')
AND NVL(accrual_flag,'z') = NVL(l_mod_sum_rec.accrual_flag,'z')
AND NVL(accrual_conversion_rate,-99999) = NVL(l_mod_sum_rec.accrual_conversion_rate,-99999)
AND NVL(estim_accrual_rate,-99999) = NVL(l_mod_sum_rec.estim_accrual_rate,-99999)
AND NVL(price_by_formula_id,-99999) = NVL(l_mod_sum_rec.price_by_formula_id,-99999)
AND NVL(generate_using_formula_id,-99999) = NVL(l_mod_sum_rec.generate_using_formula_id,-99999);
SELECT ozf_offer_discount_lines_s.NEXTVAL
FROM DUAL;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM ozf_offer_discount_lines
WHERE offer_discount_line_id = l_id);
SELECT *
FROM ozf_offer_discount_lines
WHERE offer_discount_line_id = p_org_line_id;
INSERT INTO ozf_offer_discount_lines(offer_discount_line_id
,parent_discount_line_id
,volume_from
,volume_to
,volume_operator
,volume_type
,volume_break_type
,discount
,discount_type
,tier_type
,tier_level
,incompatibility_group
,precedence
,bucket
,scan_value
,scan_data_quantity
,scan_unit_forecast
,channel_id
,adjustment_flag
,start_date_active
,end_date_active
,uom_code
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,object_version_number
,offer_id)
VALUES(x_new_line_id
,p_parent_line_id
,l_line_detail.volume_from
,l_line_detail.volume_to
,l_line_detail.volume_operator
,l_line_detail.volume_type
,l_line_detail.volume_break_type
,l_line_detail.discount
,l_line_detail.discount_type
,l_line_detail.tier_type
,l_line_detail.tier_level
,l_line_detail.incompatibility_group
,l_line_detail.precedence
,l_line_detail.bucket
,l_line_detail.scan_value
,l_line_detail.scan_data_quantity
,l_line_detail.scan_unit_forecast
,l_line_detail.channel_id
,l_line_detail.adjustment_flag
,l_line_detail.start_date_active
,l_line_detail.end_date_active
,l_line_detail.uom_code
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.conc_login_id
,1
,p_offer_id);
SELECT ozf_offer_discount_products_s.NEXTVAL
FROM DUAL;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM ozf_offer_discount_products
WHERE off_discount_product_id = l_id);
SELECT *
FROM ozf_offer_discount_products
WHERE off_discount_product_id = p_org_prod_id;
INSERT INTO ozf_offer_discount_products(off_discount_product_id
,product_level
,product_id
,excluder_flag
,uom_code
,start_date_active
,end_date_active
,offer_discount_line_id
,offer_id
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,object_version_number
,parent_off_disc_prod_id)
VALUES(x_new_prod_id
,l_product_detail.product_level
,l_product_detail.product_id
,l_product_detail.excluder_flag
,l_product_detail.uom_code
,l_product_detail.start_date_active
,l_product_detail.end_date_active
,p_new_line_id
,p_offer_id
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.conc_login_id
,1
,p_parent_prod_id);
SELECT offer_discount_line_id
FROM ozf_offer_discount_lines
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id)
AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl
SELECT offer_discount_line_id
FROM ozf_offer_discount_lines
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id)
AND parent_discount_line_id = p_parent_line_id;
SELECT off_discount_product_id
FROM ozf_offer_discount_products
WHERE offer_discount_line_id = p_line_id;
SELECT offer_discount_line_id
FROM ozf_offer_discount_lines
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id);
SELECT off_discount_product_id
FROM ozf_offer_discount_products
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id)
AND parent_off_disc_prod_id IS NULL;
SELECT off_discount_product_id
FROM ozf_offer_discount_products
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id)
AND parent_off_disc_prod_id = p_parent_prod_id;
SELECT ozf_offer_qualifiers_s.NEXTVAL
FROM DUAL;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM ozf_offer_qualifiers
WHERE qualifier_id = l_id);
SELECT *
FROM ozf_offer_qualifiers
WHERE offer_id = (SELECT offer_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id);
INSERT INTO ozf_offer_qualifiers(qualifier_id
,creation_date
,created_by
,last_update_date
,last_updated_by
,last_update_login
,qualifier_grouping_no
,qualifier_context
,qualifier_attribute
,qualifier_attr_value
,start_date_active
,end_date_active
,offer_id
,offer_discount_line_id
,context
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,active_flag
,object_version_number)
VALUES(l_new_qual_id
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.conc_login_id
,l_market_elig.qualifier_grouping_no
,l_market_elig.qualifier_context
,l_market_elig.qualifier_attribute
,l_market_elig.qualifier_attr_value
,l_market_elig.start_date_active
,l_market_elig.end_date_active
,p_new_offer_id
,NULL
,l_market_elig.context
,l_market_elig.attribute1
,l_market_elig.attribute2
,l_market_elig.attribute3
,l_market_elig.attribute4
,l_market_elig.attribute5
,l_market_elig.attribute6
,l_market_elig.attribute7
,l_market_elig.attribute8
,l_market_elig.attribute9
,l_market_elig.attribute10
,l_market_elig.attribute11
,l_market_elig.attribute12
,l_market_elig.attribute13
,l_market_elig.attribute14
,l_market_elig.attribute15
,l_market_elig.active_flag
,1);
SELECT *
FROM qp_list_headers
WHERE list_header_id = p_source_object_id;
SELECT *
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM ozf_offers
WHERE offer_code = l_code);
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM qp_list_headers
WHERE name = l_code);
SELECT list_header_id
FROM qp_list_headers
WHERE name = l_name;
SELECT ozf_offers_s.NEXTVAL
FROM DUAL;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM ozf_offers
WHERE offer_id = l_id);
SELECT qp_limits_s.NEXTVAL
FROM DUAL;
SELECT 1
FROM DUAL
WHERE EXISTS (SELECT 1
FROM qp_limits
WHERE limit_id = l_id);
SELECT *
FROM ozf_related_deal_lines
WHERE qp_list_header_id = p_source_object_id;
SELECT *
FROM ozf_volume_offer_tiers
WHERE qp_list_header_id = p_source_object_id;
SELECT *
FROM ams_act_products
WHERE arc_act_product_used_by = 'OFFR'
AND act_product_used_by_id = p_source_object_id;
SELECT *
FROM ams_act_products
WHERE arc_act_product_used_by = 'PROD'
AND act_product_used_by_id = l_act_prod_id;
SELECT list_line_id
FROM qp_list_lines
WHERE list_header_id = p_source_object_id;
SELECT *
FROM qp_limits
WHERE list_header_id = p_source_object_id
ORDER BY list_line_id;
SELECT *
FROM ams_act_contact_points
WHERE arc_contact_used_by = 'OFFR'
AND act_contact_used_by_id = p_source_object_id;
SELECT qualifier_context
,qualifier_attribute
,qualifier_attr_value
,qualifier_attr_value_to
,comparison_operator_code
,qualifier_grouping_no
,list_line_id
,list_header_id
,start_date_active
,end_date_active
FROM qp_qualifiers
WHERE list_header_id = p_source_object_id;
SELECT modifier_level_code
,pricing_phase_id
,incompatibility_grp_code
,product_precedence
,pricing_group_sequence
,print_on_invoice_flag
FROM qp_list_lines
WHERE list_header_id = p_source_object_id;
SELECT discount_type_code, discount
FROM ozf_volume_offer_tiers
WHERE qp_list_header_id = p_source_object_id
AND tier_value_from =
(SELECT MIN(tier_value_from)
FROM ozf_volume_offer_tiers
WHERE qp_list_header_id = p_source_object_id);
UPDATE qp_list_headers_b
SET comments = l_modifier_list_rec.comments
WHERE list_header_id = l_offer_rec.qp_list_header_id;
INSERT INTO ozf_offers
(offer_id
,qp_list_header_id
,offer_type
,offer_code
,reusable
,custom_setup_id
,user_status_id
,owner_id
,object_version_number
,customer_reference
,buying_group_contact_id
,perf_date_from
,perf_date_to
,status_code
,order_value_discount_type
,modifier_level_code
,offer_amount
,lumpsum_amount
,lumpsum_payment_type
,security_group_id
,distribution_type
,budget_amount_fc
,budget_amount_tc
,transaction_currency_code
,functional_currency_code
,account_closed_flag
,activity_media_id
,qualifier_id
,qualifier_type
,budget_offer_yn
,creation_date
,created_by
,last_updated_by
,last_update_date
,last_update_login
,qualifier_deleted
,break_type
,volume_offer_type
,confidential_flag
,budget_source_type
,budget_source_id
,retroactive
,source_from_parent
,last_recal_date
,buyer_name
,tier_level
,na_rule_header_id
,autopay_flag
,autopay_days
,autopay_method
,autopay_party_attr
,autopay_party_id
,beneficiary_account_id
,sales_method_flag
,org_id
,fund_request_curr_code)
VALUES
(l_offer_rec.offer_id
,l_offer_rec.qp_list_header_id
,l_offer_rec.offer_type
,l_offer_rec.offer_code
,l_offer_rec.reusable
,l_offer_rec.custom_setup_id
,ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT')
,l_offer_rec.owner_id
,1
,l_offer_rec.customer_reference
,l_offer_rec.buying_group_contact_id
,l_offer_rec.perf_date_from
,l_offer_rec.perf_date_to
,'DRAFT'
,l_offer_rec.order_value_discount_type
,l_offer_rec.modifier_level_code
,l_offer_rec.offer_amount
,l_offer_rec.lumpsum_amount
,l_offer_rec.lumpsum_payment_type
,l_offer_rec.security_group_id
,l_offer_rec.distribution_type
,l_offer_rec.budget_amount_fc
,l_offer_rec.budget_amount_tc
,l_offer_rec.transaction_currency_code
,l_offer_rec.functional_currency_code
,'N'
,l_offer_rec.activity_media_id
,l_offer_rec.qualifier_id
,l_offer_rec.qualifier_type
,DECODE(l_offer_rec.custom_setup_id, 101, 'Y', 108, 'Y', 'N')--l_offer_rec.budget_offer_yn
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.conc_login_id
,NULL
,l_offer_rec.break_type
,l_offer_rec.volume_offer_type
,l_offer_rec.confidential_flag
,l_offer_rec.budget_source_type
,l_offer_rec.budget_source_id
,l_offer_rec.retroactive
,l_offer_rec.source_from_parent
,l_modifier_list_rec.start_date_active -- default last_recal_date to offer start date
,l_offer_rec.buyer_name
,l_offer_rec.tier_level
,l_offer_rec.na_rule_header_id
,l_offer_rec.autopay_flag
,l_offer_rec.autopay_days
,l_offer_rec.autopay_method
,l_offer_rec.autopay_party_attr
,l_offer_rec.autopay_party_id
,l_offer_rec.beneficiary_account_id
,l_offer_rec.sales_method_flag
,l_offer_rec.org_id
,NVL(l_offer_rec.transaction_currency_code, fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY')));
INSERT INTO ams_act_access
(activity_access_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,act_access_to_object_id
,arc_act_access_to_object
,user_or_role_id
,arc_user_or_role_type
,last_update_login
,object_version_number
,active_from_date
,admin_flag
,approver_flag
,active_to_date
,security_group_id
,delete_flag
,owner_flag)
VALUES
(ams_act_access_s.NEXTVAL
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,l_offer_rec.qp_list_header_id
,'OFFR'
,l_offer_rec.owner_id
,'USER'
,FND_GLOBAL.conc_login_id
,1
,SYSDATE
,NULL
,NULL
,NULL
,NULL
,'N'
,'Y');
INSERT INTO ams_act_access_denorm
(access_denorm_id
,object_type
,object_id
,resource_id
,edit_metrics_yn
,source_code
,access_type
,creation_date
,last_update_date
,last_update_login
,last_updated_by
,created_by)
VALUES
(ams_act_access_denorm_s.NEXTVAL
,'OFFR'
,l_offer_rec.qp_list_header_id
,l_offer_rec.owner_id
,'Y'
,l_offer_rec.offer_code
,NULL
,SYSDATE
,SYSDATE
,FND_GLOBAL.conc_login_id
,FND_GLOBAL.user_id
,FND_GLOBAL.user_id);
INSERT INTO ams_act_access
(activity_access_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,act_access_to_object_id
,arc_act_access_to_object
,user_or_role_id
,arc_user_or_role_type
,last_update_login
,object_version_number
,active_from_date
,admin_flag
,approver_flag
,active_to_date
,security_group_id
,delete_flag
,owner_flag)
VALUES
(ams_act_access_s.NEXTVAL
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,l_offer_rec.qp_list_header_id
,'OFFR'
,l_default_team
,'GROUP'
,FND_GLOBAL.conc_login_id
,1
,SYSDATE
,NULL
,NULL
,NULL
,NULL
,'N'
,'N');
INSERT INTO qp_limits
(limit_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_header_id
,list_line_id
,limit_number
,basis
,organization_flag
,limit_level_code
,limit_exceed_action_code
,limit_hold_flag
,multival_attr1_type
,multival_attr1_context
,multival_attribute1
,multival_attr1_datatype
,multival_attr2_type
,multival_attr2_context
,multival_attribute2
,multival_attr2_datatype
,amount
,context
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,each_attr_exists
,non_each_attr_count
,total_attr_count)
VALUES
(l_new_limit_id
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.conc_login_id
,l_line_limits.program_application_id
,l_line_limits.program_id
,SYSDATE
,NULL
,l_offer_rec.qp_list_header_id
,-1
,l_line_limits.limit_number
,l_line_limits.basis
,l_line_limits.organization_flag
,l_line_limits.limit_level_code
,l_line_limits.limit_exceed_action_code
,l_line_limits.limit_hold_flag
,l_line_limits.multival_attr1_type
,l_line_limits.multival_attr1_context
,l_line_limits.multival_attribute1
,l_line_limits.multival_attr1_datatype
,l_line_limits.multival_attr2_type
,l_line_limits.multival_attr2_context
,l_line_limits.multival_attribute2
,l_line_limits.multival_attr2_datatype
,l_line_limits.amount
,l_line_limits.context
,l_line_limits.attribute1
,l_line_limits.attribute2
,l_line_limits.attribute3
,l_line_limits.attribute4
,l_line_limits.attribute5
,l_line_limits.attribute6
,l_line_limits.attribute7
,l_line_limits.attribute8
,l_line_limits.attribute9
,l_line_limits.attribute10
,l_line_limits.attribute11
,l_line_limits.attribute12
,l_line_limits.attribute13
,l_line_limits.attribute14
,l_line_limits.attribute15
,l_line_limits.each_attr_exists
,l_line_limits.non_each_attr_count
,l_line_limits.total_attr_count);
INSERT INTO qp_limits
(limit_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_header_id
,list_line_id
,limit_number
,basis
,organization_flag
,limit_level_code
,limit_exceed_action_code
,limit_hold_flag
,multival_attr1_type
,multival_attr1_context
,multival_attribute1
,multival_attr1_datatype
,multival_attr2_type
,multival_attr2_context
,multival_attribute2
,multival_attr2_datatype
,amount
,context
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,each_attr_exists
,non_each_attr_count
,total_attr_count)
VALUES
(l_new_limit_id
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.conc_login_id
,l_line_limits.program_application_id
,l_line_limits.program_id
,SYSDATE
,NULL
,l_offer_rec.qp_list_header_id
,l_new_limit_line_id
,l_line_limits.limit_number
,l_line_limits.basis
,l_line_limits.organization_flag
,l_line_limits.limit_level_code
,l_line_limits.limit_exceed_action_code
,l_line_limits.limit_hold_flag
,l_line_limits.multival_attr1_type
,l_line_limits.multival_attr1_context
,l_line_limits.multival_attribute1
,l_line_limits.multival_attr1_datatype
,l_line_limits.multival_attr2_type
,l_line_limits.multival_attr2_context
,l_line_limits.multival_attribute2
,l_line_limits.multival_attr2_datatype
,l_line_limits.amount
,l_line_limits.context
,l_line_limits.attribute1
,l_line_limits.attribute2
,l_line_limits.attribute3
,l_line_limits.attribute4
,l_line_limits.attribute5
,l_line_limits.attribute6
,l_line_limits.attribute7
,l_line_limits.attribute8
,l_line_limits.attribute9
,l_line_limits.attribute10
,l_line_limits.attribute11
,l_line_limits.attribute12
,l_line_limits.attribute13
,l_line_limits.attribute14
,l_line_limits.attribute15
,l_line_limits.each_attr_exists
,l_line_limits.non_each_attr_count
,l_line_limits.total_attr_count);
l_contact_point_rec.last_update_date := SYSDATE;
l_contact_point_rec.last_updated_by := FND_GLOBAL.user_id;
l_contact_point_rec.last_update_login := FND_GLOBAL.conc_login_id;
DELETE FROM qp_qualifiers
WHERE list_header_id = l_offer_rec.qp_list_header_id
AND list_line_id = -1;
SELECT budget_offer_yn, offer_type, custom_setup_id
FROM ozf_offers
WHERE qp_list_header_id = p_source_object_id;