[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select a.name,
substr(a.description,1,240) description,
lkp1.meaning offer_type,
a.start_date_active,
a.end_date_active,
lkp.meaning settlement_name,
b.effective_date,
b.offer_adjustment_name
from qp_list_headers a,
ozf_offer_adjustments_vl b,
ozf_lookups lkp,
ozf_lookups lkp1,
ozf_offers offr
where a.list_header_id = b.list_header_id
and a.list_header_id = offr.qp_list_header_id
and b.offer_adjustment_id = p_offer_adjustment_id
and lkp.lookup_code = b.settlement_code
and lkp.lookup_type = 'OZF_OFFER_LUMPSUM_PAYMENT'
and lkp1.lookup_code = offr.offer_type
and lkp1.lookup_type = 'OZF_OFFER_TYPE';
select a.name,
substr(a.description,1,240) description,
lkp1.meaning offer_type,
a.start_date_active,
a.end_date_active,
lkp.meaning settlement_name,
b.effective_date,
b.offer_adjustment_name
from qp_list_headers a,
ozf_offer_adjustments_vl b,
ozf_lookups lkp,
ozf_lookups lkp1,
ozf_offers offr
where a.list_header_id = b.list_header_id
and a.list_header_id = offr.qp_list_header_id
and b.offer_adjustment_id = p_offer_adjustment_id
and lkp.lookup_code = b.settlement_code
and lkp.lookup_type = 'OZF_OFFER_LUMPSUM_PAYMENT'
and lkp1.lookup_code = offr.offer_type
and lkp1.lookup_type = 'OZF_OFFER_TYPE';
select a.name,
substr(a.description,1,240) description,
lkp1.meaning offer_type,
a.start_date_active,
a.end_date_active,
lkp.meaning settlement_name,
b.effective_date,
b.offer_adjustment_name
from qp_list_headers a,
ozf_offer_adjustments_vl b,
ozf_lookups lkp,
ozf_lookups lkp1,
ozf_offers offr
where a.list_header_id = b.list_header_id
and a.list_header_id = offr.qp_list_header_id
and b.offer_adjustment_id = p_offer_adjustment_id
and lkp.lookup_code = b.settlement_code
and lkp.lookup_type = 'OZF_OFFER_LUMPSUM_PAYMENT'
and lkp1.lookup_code = offr.offer_type
and lkp1.lookup_type = 'OZF_OFFER_TYPE';
select a.name,
substr(a.description,1,240) description,
lkp1.meaning offer_type,
a.start_date_active,
a.end_date_active,
lkp.meaning settlement_name,
b.effective_date,
b.offer_adjustment_name
from qp_list_headers a,
ozf_offer_adjustments_vl b,
ozf_lookups lkp,
ozf_lookups lkp1,
ozf_offers offr
where a.list_header_id = b.list_header_id
and a.list_header_id = offr.qp_list_header_id
and b.offer_adjustment_id = p_offer_adjustment_id
and lkp.lookup_code = b.settlement_code
and lkp.lookup_type = 'OZF_OFFER_LUMPSUM_PAYMENT'
and lkp1.lookup_code = offr.offer_type
and lkp1.lookup_type = 'OZF_OFFER_TYPE';
select a.name,
substr(a.description,1,240) description,
lkp1.meaning offer_type,
a.start_date_active,
a.end_date_active,
lkp.meaning settlement_name,
b.effective_date,
b.offer_adjustment_name
from qp_list_headers a,
ozf_offer_adjustments_vl b,
ozf_lookups lkp,
ozf_lookups lkp1,
ozf_offers offr
where a.list_header_id = b.list_header_id
and a.list_header_id = offr.qp_list_header_id
and b.offer_adjustment_id = p_offer_adjustment_id
and lkp.lookup_code = b.settlement_code
and lkp.lookup_type = 'OZF_OFFER_LUMPSUM_PAYMENT'
and lkp1.lookup_code = offr.offer_type
and lkp1.lookup_type = 'OZF_OFFER_TYPE';
select
description,
effective_date,
list_header_id,
offer_adjustment_name
from ozf_offer_adjustments_vl
where offer_adjustment_id = p_offer_adjustment_id;
SELECT qlh.description,
'' business_unit_id,
'' country_code,
OFF.custom_setup_id,
nvl(OFF.budget_amount_tc,0),
qlh.orig_org_id org_id, --added for bugfix 8253195
OFF.offer_type,--'' activity_type_code, -- Changed to fix bug#2288550
'' priority,
qlh.start_date_active,
qlh.end_date_active ,
OFF.transaction_currency_code ,
OFF.owner_id
FROM ozf_offers OFF,
qp_list_headers_vl qlh
WHERE OFF.qp_list_header_id=qlh.list_header_id
AND qlh.list_header_id=p_list_header_id;
SELECT fund.short_name,
fund.business_unit_id,
fund.custom_setup_id,
NVL(offr.budget_amount_tc,0),
fund.org_id,
TO_CHAR(fund.category_id),
fund.start_date_active,
fund.end_date_active,
fund.currency_code_tc,
fund.owner
FROM ozf_funds_all_vl fund, ozf_offers offr
WHERE fund.fund_number = offr.offer_code
AND offr.qp_list_header_id = p_list_header_id;
SELECT NVL(budget_offer_yn, 'N')
FROM ozf_offers
WHERE qp_list_header_id = p_list_header_id;
PROCEDURE Update_OffrAdj_Status (
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2
) IS
l_status_code VARCHAR2 (30);
l_api_name CONSTANT VARCHAR2 (30) := 'Update_OffrAdj_Status';
SELECT effective_date
FROM ozf_offer_adjustments_b
WHERE offer_adjustment_id = p_offer_adjustment_id ;
aname => 'UPDATE_GEN_STATUS'
);
OZF_Offer_Backdate_PVT.Update_Offer_Discounts
(
p_init_msg_list => FND_API.G_FALSE
,p_api_version => l_api_version
,p_commit => FND_API.G_FALSE
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_offer_adjustment_id => l_offer_adjustment_id
) ;
UPDATE ozf_offer_adjustments_b
SET status_code = l_next_status_code ,
-- approved_date = sysdate ,
object_version_number = l_object_version_number+1
WHERE offer_adjustment_id = l_offer_adjustment_id;
'Update_OffrAdj_Status',
itemtype, itemkey,to_char(actid),l_error_msg);
'Update_OffrAdj_Status',
itemtype, itemkey,to_char(actid),l_error_msg);
END Update_OffrAdj_Status;