[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 status_code, end_date_active
FROM ozf_funds_all_b
WHERE fund_id = l_fund_id;
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_b --Bug 13360969 changed table name to fetch global flag, previously fetching of global flag was not consistent.
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_tl -- Bug 13360969 changed table name
WHERE name = l_code);
SELECT list_header_id
FROM qp_list_headers_tl -- Bug 13360969 changed table name to fetch list_header_id, fetching of list_header_id was not consisitent with 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);
SELECT admin_flag
FROM ams_act_access
WHERE act_access_to_object_id = p_source_object_id
AND user_or_role_id = p_user_or_role_id;
SELECT status_code, end_date_active
FROM ozf_funds_all_b
WHERE fund_id = l_fund_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_budget_source_type
,l_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
,'Y' --NULL nepanda For Bug 10385923. Setting Admin Flag for OWNER to Y, as it should be 'Y' by default
,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
,l_admin_flag --nepanda For Bug 10385923. Updating the admin flag for the default group with the admin flag of the offer from which this offer is getting copied
,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;