[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
-- Transaction phase cannot be updated on a saved transaction.
IF OE_Quote_Util.G_COMPLETE_NEG = 'N' AND
NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code
,p_old_header_rec.transaction_phase_code)
THEN
FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');
END IF; -- End of check for UPDATE operation
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
IF p_operation = OE_GLOBALS.G_OPR_UPDATE
THEN
IF NOT OE_GLOBALS.EQUAL(p_order_type_id
,p_old_Order_type_id)
THEN
SELECT root_activity
into lprocessname
from wf_items_v
where item_key = to_char(p_header_id)
AND item_type = 'OEOH'
AND rownum = 1;
SELECT 'EXISTS'
INTO lexists
FROM oe_workflow_assignments a
WHERE a.order_type_id = p_order_type_id
AND a.process_name = lprocessname
AND a.line_type_id IS NULL
AND a.end_date_active is null
AND rownum = 1;
SELECT commitment_id
FROM oe_order_lines
WHERE header_id = p_header_id
AND commitment_id is not null;
SELECT invoice_currency_code
INTO l_commitment_curr_code
FROM ra_customer_trx
WHERE customer_trx_id = l_commitment_id;
SELECT commitment_id
FROM oe_order_lines
WHERE header_id = p_header_id
AND commitment_id is not null;
select 'Y'
from ra_customer_trx ratrx
where ratrx.customer_trx_id = p_commitment_id
and ratrx.bill_to_customer_id = p_sold_to_org_id
union all
select 'Y'
from ra_customer_trx ratrx
where ratrx.customer_trx_id = p_commitment_id
and exists (SELECT 1
FROM hz_cust_acct_relate_all hcar
WHERE hcar.cust_account_id = ratrx.bill_to_customer_id
and hcar.related_cust_account_id = p_sold_to_org_id
AND hcar.status = 'A'
and hcar.org_id = ratrx.org_id
AND hcar.bill_to_flag = 'Y');
/*SELECT MOAC_SQL_CHANGE 'Y'
INTO l_exists
FROM ra_customer_trx ratrx
WHERE ratrx.bill_to_customer_id
IN (SELECT p_sold_to_org_id
FROM sys.dual
UNION
SELECT cust_account_id customer_id
FROM hz_cust_acct_relate_all h
WHERE related_cust_account_id = p_sold_to_org_id
AND status = 'A'
and h.org_id = ratrx.org_id
AND bill_to_flag = 'Y')
AND ratrx.customer_trx_id = l_commitment_id;*/
WHERE EXISTS (SELECT 'Y'
FROM OE_ORDER_HEADERS
WHERE HEADER_ID <> p_header_id
AND SOLD_TO_ORG_ID = p_sold_to_org_id
AND CUST_PO_NUMBER = p_cust_po_number )
OR EXISTS (SELECT 'Y'
FROM OE_ORDER_LINES
WHERE HEADER_ID <> p_header_id
AND SOLD_TO_ORG_ID = p_sold_to_org_id
AND CUST_PO_NUMBER = p_cust_po_number ); */
SELECT 'Y'
INTO l_duplicate_exists
FROM DUAL
WHERE EXISTS (SELECT 'Y'
FROM OE_ORDER_HEADERS
WHERE HEADER_ID <> p_header_id
AND SOLD_TO_ORG_ID = p_sold_to_org_id
AND CUST_PO_NUMBER = p_cust_po_number );
SELECT 'Y'
INTO l_duplicate_exists
FROM DUAL
WHERE EXISTS (SELECT 'Y'
FROM OE_ORDER_LINES
WHERE HEADER_ID <> p_header_id
AND SOLD_TO_ORG_ID = p_sold_to_org_id
AND CUST_PO_NUMBER = p_cust_po_number );
SELECT BH.AGREEMENT_ID,
BH.SOLD_TO_ORG_ID,
BHE.on_hold_flag,
BHE.START_DATE_ACTIVE,
BHE.END_DATE_ACTIVE,
NVL(BH.FLOW_STATUS_CODE,'ACTIVE')
INTO l_agreement_id,
l_sold_to_org_id,
l_on_hold_flag,
l_start_date_active,
l_end_date_active,
l_flow_status_code
FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
WHERE BH.ORDER_NUMBER = p_header_rec.blanket_number
AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'
AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'
AND NVL(BH.DRAFT_SUBMITTED_FLAG,'Y') = 'Y';
SELECT 'Y'
INTO l_exists
FROM HZ_CUST_ACCT_RELATE
WHERE RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
AND CUST_ACCOUNT_ID = l_sold_to_org_id
AND STATUS = 'A'
AND ROWNUM = 1;
SELECT cust_acct.cust_account_id,
cust_Acct.party_id,
acct_site.party_site_id,
site_use.org_id
FROM
HZ_CUST_SITE_USES_ALL site_use,
HZ_CUST_ACCT_SITES_ALL acct_site,
HZ_CUST_ACCOUNTS_ALL cust_Acct
WHERE site_use.site_use_id = p_site_org_id
AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
and acct_site.cust_account_id = cust_acct.cust_account_id;
SELECT l.line_id,
l.ib_current_location,
l.ib_installed_at_location
FROM oe_order_lines_all l
WHERE l.header_id=p_old_header_rec.header_id;
Select 1
into l_temp
From Oe_Order_Lines_All
Where header_id = p_header_rec.header_id
and calculate_price_flag in ('P','N')
and rownum = 1;
SELECT 'VALID'
INTO l_dummy
FROM OE_ORDER_TYPES_V
WHERE ORDER_TYPE_ID = p_header_rec.order_type_id
AND TRUNC(p_header_rec.ordered_date)
BETWEEN NVL(START_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date))
AND NVL( END_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date));
select list_type_code
into l_list_type_code
from qp_list_headers_vl
where list_header_id = p_header_rec.price_list_id;
select name,revision, sold_to_org_id
into l_agreement_name,l_agreement_revision, l_sold_to_org
from oe_agreements_vl
where agreement_id = p_header_rec.agreement_id;
select name,revision, sold_to_org_id
into l_agreement_name,l_agreement_revision, l_sold_to_org
from oe_agreements_vl
where agreement_id = p_header_rec.agreement_id
AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));
select name ,sold_to_org_id , price_list_id
into l_agreement_name,l_sold_to_org,l_price_list_id
from oe_agreements_v
where agreement_id = p_header_rec.agreement_id
AND trunc(nvl(p_header_rec.pricing_date,sysdate)) between
trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));
SELECT 'VALID'
INTO l_dummy
FROM dual
WHERE exists(
select 'x' from
hz_cust_acct_relate where
related_cust_account_id = p_header_rec.sold_to_org_id
and status = 'A'
AND cust_account_id = l_sold_to_org
);
SELECT 'VALID'
INTO l_dummy
FROM oe_ship_to_orgs_v
WHERE customer_id = p_header_rec.sold_to_org_id
AND site_use_id = p_header_rec.ship_to_org_id
AND status = 'A'
AND address_status ='A'; --bug 2752321
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
Into l_dummy
FROM HZ_CUST_SITE_USES_ALL SITE,
HZ_CUST_ACCT_SITES ACCT_SITE
WHERE SITE.SITE_USE_ID = p_header_rec.ship_to_org_id
AND SITE.SITE_USE_CODE = l_site_use_code
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SITE.STATUS = 'A'
AND ACCT_SITE.STATUS ='A' AND --bug 2752321
ACCT_SITE.CUST_ACCOUNT_ID in (
SELECT p_header_rec.sold_to_org_id FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID FROM
HZ_CUST_ACCT_RELATE_ALL h WHERE
RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
and h.org_id =acct_site.org_id
and ship_to_flag = 'Y' and status = 'A')
--bug 4205113
AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
AND ROWNUM = 1;
('Cr: Yes- After the select',2);
SELECT 'VALID'
INTO l_dummy
FROM OE_SHIP_TO_ORGS_V SHP
WHERE SHP.ORGANIZATION_ID =p_header_rec.ship_to_org_id
AND SHP.STATUS = 'A'
AND SHP.ADDRESS_STATUS ='A' --bug 2752321
AND SYSDATE BETWEEN NVL(SHP.START_DATE_ACTIVE, SYSDATE)
AND NVL(SHP.END_DATE_ACTIVE, SYSDATE);
SELECT 'VALID'
INTO l_dummy
FROM oe_deliver_to_orgs_v
WHERE customer_id = p_header_rec.sold_to_org_id
AND site_use_id = p_header_rec.deliver_to_org_id
AND status = 'A'
AND address_status ='A'; --bug 2752321
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
Into l_dummy
FROM HZ_CUST_SITE_USES_ALL SITE,
HZ_CUST_ACCT_SITES ACCT_SITE
WHERE SITE.SITE_USE_ID = p_header_rec.deliver_to_org_id
AND SITE.SITE_USE_CODE = l_site_use_code
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SITE.STATUS = 'A'
AND ACCT_SITE.STATUS = 'A' AND --bug 2752321
ACCT_SITE.CUST_ACCOUNT_ID in (
SELECT p_header_rec.sold_to_org_id FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID FROM
HZ_CUST_ACCT_RELATE_ALL h WHERE
RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
and h.org_id =acct_site.org_id
and ship_to_flag = 'Y' and status='A')
--bug 4205113
AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
AND ROWNUM = 1;
oe_debug_pub.add('Cr: Yes- After the select',2);
SELECT 'VALID'
INTO l_dummy
FROM OE_DELIVER_TO_ORGS_V DEL
WHERE DEL.ORGANIZATION_ID =p_header_rec.deliver_to_org_id
AND DEL.STATUS = 'A'
AND DEL.ADDRESS_STATUS ='A' --bug 2752321
AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
Select 'VALID'
Into l_dummy
From oe_invoice_to_orgs_v
Where customer_id = p_header_rec.sold_to_org_id
AND site_use_id = p_header_rec.invoice_to_org_id
and status = 'A'
and address_status ='A'; --bug 2752321
SELECT 'VALID'
Into l_dummy
FROM HZ_CUST_SITE_USES_ALL SITE,
HZ_CUST_ACCT_SITES ACCT_SITE
WHERE SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id
AND SITE.SITE_USE_CODE = l_site_use_code
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SITE.STATUS = 'A'
AND ACCT_SITE.ORG_ID=SITE.ORG_ID
AND ACCT_SITE.STATUS = 'A' AND
ACCT_SITE.CUST_ACCOUNT_ID in (
SELECT p_header_rec.sold_to_org_id FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID FROM
HZ_CUST_ACCT_RELATE_ALL h WHERE
RELATED_CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
and h.org_id =site.org_id
and bill_to_flag = 'Y' and status='A' )
--bug 4205113
AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
AND ROWNUM = 1;
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
INTO l_dummy
FROM
HZ_CUST_SITE_USES_ALL SITE,
HZ_CUST_ACCT_SITES ACCT_SITE
WHERE
SITE.SITE_USE_ID = p_header_rec.sold_to_site_use_id
AND SITE.SITE_USE_CODE = 'SOLD_TO'
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
AND SITE.STATUS = 'A'
AND ACCT_SITE.STATUS='A';
SELECT 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.end_customer_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.end_customer_id
AND ROWNUM = 1
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND STATUS= 'A';
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
INTO
l_dummy
FROM
hz_cust_site_uses_all site_use,
hz_cust_acct_sites acct_site
WHERE
site_use.site_use_id=p_header_rec.end_customer_site_use_id
and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
and acct_site.cust_account_id=p_header_rec.end_customer_id;
SELECT 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.sold_to_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = p_header_rec.sold_to_org_id
AND ROWNUM = 1
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND STATUS= 'A';
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
HZ_CUST_SITE_USES_ALL SITE_USE, --changed INV to SITE_USE for bug 3739650
HZ_CUST_ACCT_SITES ADDR
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.invoice_to_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ADDR.CUST_ACCT_SITE_ID = SITE_USE.CUST_ACCT_SITE_ID
AND SITE_USE.SITE_USE_ID = p_header_rec.invoice_to_org_id
AND SITE_USE.STATUS = 'A'
AND ADDR.STATUS ='A' --bug 2752321
AND ACCT_ROLE.STATUS = 'A'
AND ROWNUM = 1;
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
HZ_CUST_SITE_USES_ALL SITE_USE, --changed SHIP to SITE_USE for bug 3739650
HZ_CUST_ACCT_SITES ADDR
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.ship_to_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ADDR.CUST_ACCT_SITE_ID = SITE_USE.CUST_ACCT_SITE_ID
AND SITE_USE.SITE_USE_ID = p_header_rec.ship_to_org_id
AND SITE_USE.STATUS = 'A'
AND ADDR.STATUS ='A' --bug 2752321
AND ACCT_ROLE.STATUS = 'A'
AND ROWNUM = 1;
SELECT /* MOAC_SQL_CHANGE */ 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
HZ_CUST_SITE_USES_ALL SITE_USE, --changed DELIVER to SITE_USE for bug 3739650
HZ_CUST_ACCT_SITES ADDR
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_header_rec.deliver_to_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = ADDR.CUST_ACCOUNT_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ADDR.CUST_ACCT_SITE_ID = SITE_USE.CUST_ACCT_SITE_ID
AND SITE_USE.SITE_USE_ID = p_header_rec.deliver_to_org_id
AND SITE_USE.STATUS = 'A'
AND ADDR.STATUS ='A' --bug 2752321
AND ACCT_ROLE.STATUS = 'A'
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_header_rec.tax_exempt_number
AND EXEMPT_REASON_CODE=p_header_rec.tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_header_rec.ship_to_org_id,p_header_rec.invoice_to_org_id)) =
nvl(p_header_rec.ship_to_org_id,p_header_rec.invoice_to_org_id)
AND nvl(cust_account_id, l_bill_to_cust_acct_id) = l_bill_to_cust_acct_id
AND nvl(PARTY_SITE_ID,nvl(l_ship_to_party_site_id, l_bill_to_party_site_id))=
nvl(l_ship_to_party_site_id, l_bill_to_party_site_id)
and org_id = p_header_rec.org_id
and party_id = l_bill_to_party_id
AND EXEMPTION_STATUS_CODE = 'PRIMARY'
AND TRUNC(NVL(p_header_rec.request_date,sysdate)) BETWEEN
TRUNC(EFFECTIVE_FROM) AND
TRUNC(NVL(EFFECTIVE_TO,NVL(p_header_rec.request_date,sysdate)))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_header_rec.tax_exempt_number
AND EXEMPT_REASON_CODE=p_header_rec.tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_header_rec.ship_to_org_id,p_header_rec.invoice_to_org_id)) =
nvl(p_header_rec.ship_to_org_id,p_header_rec.invoice_to_org_id)
AND nvl(cust_account_id, l_bill_to_cust_acct_id) = l_bill_to_cust_acct_id
AND nvl(PARTY_SITE_ID,nvl(l_ship_to_party_site_id, l_bill_to_party_site_id))=
nvl(l_ship_to_party_site_id, l_bill_to_party_site_id)
and org_id = p_header_rec.org_id
and party_id = l_bill_to_party_id
AND EXEMPTION_STATUS_CODE IN ('PRIMARY','MANUAL','UNAPPROVED')
AND TRUNC(NVL(p_header_rec.request_date,sysdate)) BETWEEN
TRUNC(EFFECTIVE_FROM) AND
TRUNC(NVL(EFFECTIVE_TO,NVL(p_header_rec.request_date,sysdate)))
AND ROWNUM = 1;
SELECT party.party_name
INTO l_customer_name
FROM hz_parties party,
hz_cust_accounts cust_acct
WHERE cust_acct.cust_account_id = p_header_rec.sold_to_org_id
AND cust_acct.party_id = party.party_id;
select count(payment_type_code) into l_payment_count
from oe_payments
where header_id = p_header_rec.header_id
and line_id is null;
oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
SELECT 'Y'
INTO l_auth_exist
FROM iby_trxn_ext_auths_v iby_auth ,
oe_payments op
WHERE iby_auth.trxn_extension_id = op.trxn_extension_id
AND NVL(iby_auth.authorization_amount,0) > 0
AND iby_auth.authorization_status =0
AND op.payment_level_code ='ORDER'
AND op.payment_type_code ='CREDIT_CARD'
AND op.PAYMENT_COLLECTION_EVENT ='INVOICE'
AND op.header_id =p_x_header_rec.header_id;
( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
(p_x_header_rec.attribute1 IS NOT NULL AND
( p_x_header_rec.attribute1 <>
p_old_header_rec.attribute1 OR
p_old_header_rec.attribute1 IS NULL ))
OR (p_x_header_rec.attribute10 IS NOT NULL AND
( p_x_header_rec.attribute10 <>
p_old_header_rec.attribute10 OR
p_old_header_rec.attribute10 IS NULL ))
OR (p_x_header_rec.attribute11 IS NOT NULL AND
( p_x_header_rec.attribute11 <>
p_old_header_rec.attribute11 OR
p_old_header_rec.attribute11 IS NULL ))
OR (p_x_header_rec.attribute12 IS NOT NULL AND
( p_x_header_rec.attribute12 <>
p_old_header_rec.attribute12 OR
p_old_header_rec.attribute12 IS NULL ))
OR (p_x_header_rec.attribute13 IS NOT NULL AND
( p_x_header_rec.attribute13 <>
p_old_header_rec.attribute13 OR
p_old_header_rec.attribute13 IS NULL ))
OR (p_x_header_rec.attribute14 IS NOT NULL AND
( p_x_header_rec.attribute14 <>
p_old_header_rec.attribute14 OR
p_old_header_rec.attribute14 IS NULL ))
OR (p_x_header_rec.attribute15 IS NOT NULL AND
( p_x_header_rec.attribute15 <>
p_old_header_rec.attribute15 OR
p_old_header_rec.attribute15 IS NULL ))
OR (p_x_header_rec.attribute16 IS NOT NULL AND --For bug 2184255
( p_x_header_rec.attribute16 <>
p_old_header_rec.attribute16 OR
p_old_header_rec.attribute16 IS NULL ))
OR (p_x_header_rec.attribute17 IS NOT NULL AND
( p_x_header_rec.attribute17 <>
p_old_header_rec.attribute17 OR
p_old_header_rec.attribute17 IS NULL ))
OR (p_x_header_rec.attribute18 IS NOT NULL AND
( p_x_header_rec.attribute18 <>
p_old_header_rec.attribute18 OR
p_old_header_rec.attribute18 IS NULL ))
OR (p_x_header_rec.attribute19 IS NOT NULL AND
( p_x_header_rec.attribute19 <>
p_old_header_rec.attribute19 OR
p_old_header_rec.attribute19 IS NULL ))
OR (p_x_header_rec.attribute2 IS NOT NULL AND
( p_x_header_rec.attribute2 <>
p_old_header_rec.attribute2 OR
p_old_header_rec.attribute2 IS NULL ))
OR (p_x_header_rec.attribute20 IS NOT NULL AND -- for bug 2184255
( p_x_header_rec.attribute20 <>
p_old_header_rec.attribute20 OR
p_old_header_rec.attribute20 IS NULL ))
OR (p_x_header_rec.attribute3 IS NOT NULL AND
( p_x_header_rec.attribute3 <>
p_old_header_rec.attribute3 OR
p_old_header_rec.attribute3 IS NULL ))
OR (p_x_header_rec.attribute4 IS NOT NULL AND
( p_x_header_rec.attribute4 <>
p_old_header_rec.attribute4 OR
p_old_header_rec.attribute4 IS NULL ))
OR (p_x_header_rec.attribute5 IS NOT NULL AND
( p_x_header_rec.attribute5 <>
p_old_header_rec.attribute5 OR
p_old_header_rec.attribute5 IS NULL ))
OR (p_x_header_rec.attribute6 IS NOT NULL AND
( p_x_header_rec.attribute6 <>
p_old_header_rec.attribute6 OR
p_old_header_rec.attribute6 IS NULL ))
OR (p_x_header_rec.attribute7 IS NOT NULL AND
( p_x_header_rec.attribute7 <>
p_old_header_rec.attribute7 OR
p_old_header_rec.attribute7 IS NULL ))
OR (p_x_header_rec.attribute8 IS NOT NULL AND
( p_x_header_rec.attribute8 <>
p_old_header_rec.attribute8 OR
p_old_header_rec.attribute8 IS NULL ))
OR (p_x_header_rec.attribute9 IS NOT NULL AND
( p_x_header_rec.attribute9 <>
p_old_header_rec.attribute9 OR
p_old_header_rec.attribute9 IS NULL ))
OR (p_x_header_rec.context IS NOT NULL AND
( p_x_header_rec.context <>
p_old_header_rec.context OR
p_old_header_rec.context IS NULL )))
THEN
oe_debug_pub.add('Before calling header_desc_flex',2);
( p_x_header_rec.operation = oe_globals.g_opr_update AND
(p_x_header_rec.global_attribute1 IS NOT NULL AND
( p_x_header_rec.global_attribute1 <>
p_old_header_rec.global_attribute1 OR
p_old_header_rec.global_attribute1 IS NULL ))
OR (p_x_header_rec.global_attribute10 IS NOT NULL AND
( p_x_header_rec.global_attribute10 <>
p_old_header_rec.global_attribute10 OR
p_old_header_rec.global_attribute10 IS NULL ))
OR (p_x_header_rec.global_attribute11 IS NOT NULL AND
( p_x_header_rec.global_attribute11 <>
p_old_header_rec.global_attribute11 OR
p_old_header_rec.global_attribute11 IS NULL ))
OR (p_x_header_rec.global_attribute12 IS NOT NULL AND
( p_x_header_rec.global_attribute12 <>
p_old_header_rec.global_attribute12 OR
p_old_header_rec.global_attribute12 IS NULL ))
OR (p_x_header_rec.global_attribute13 IS NOT NULL AND
( p_x_header_rec.global_attribute13 <>
p_old_header_rec.global_attribute13 OR
p_old_header_rec.global_attribute13 IS NULL ))
OR (p_x_header_rec.global_attribute14 IS NOT NULL AND
( p_x_header_rec.global_attribute14 <>
p_old_header_rec.global_attribute14 OR
p_old_header_rec.global_attribute14 IS NULL ))
OR (p_x_header_rec.global_attribute15 IS NOT NULL AND
( p_x_header_rec.global_attribute15 <>
p_old_header_rec.global_attribute15 OR
p_old_header_rec.global_attribute15 IS NULL ))
OR (p_x_header_rec.global_attribute16 IS NOT NULL AND
( p_x_header_rec.global_attribute16 <>
p_old_header_rec.global_attribute16 OR
p_old_header_rec.global_attribute16 IS NULL ))
OR (p_x_header_rec.global_attribute17 IS NOT NULL AND
( p_x_header_rec.global_attribute17 <>
p_old_header_rec.global_attribute17 OR
p_old_header_rec.global_attribute17 IS NULL ))
OR (p_x_header_rec.global_attribute18 IS NOT NULL AND
( p_x_header_rec.global_attribute18 <>
p_old_header_rec.global_attribute18 OR
p_old_header_rec.global_attribute18 IS NULL ))
OR (p_x_header_rec.global_attribute19 IS NOT NULL AND
( p_x_header_rec.global_attribute19 <>
p_old_header_rec.global_attribute19 OR
p_old_header_rec.global_attribute19 IS NULL ))
OR (p_x_header_rec.global_attribute2 IS NOT NULL AND
( p_x_header_rec.global_attribute2 <>
p_old_header_rec.global_attribute2 OR
p_old_header_rec.global_attribute2 IS NULL ))
OR (p_x_header_rec.global_attribute20 IS NOT NULL AND
( p_x_header_rec.global_attribute20 <>
p_old_header_rec.global_attribute20 OR
p_old_header_rec.global_attribute20 IS NULL ))
OR (p_x_header_rec.global_attribute3 IS NOT NULL AND
( p_x_header_rec.global_attribute3 <>
p_old_header_rec.global_attribute3 OR
p_old_header_rec.global_attribute3 IS NULL ))
OR (p_x_header_rec.global_attribute4 IS NOT NULL AND
( p_x_header_rec.global_attribute4 <>
p_old_header_rec.global_attribute4 OR
p_old_header_rec.global_attribute4 IS NULL ))
OR (p_x_header_rec.global_attribute5 IS NOT NULL AND
( p_x_header_rec.global_attribute5 <>
p_old_header_rec.global_attribute5 OR
p_old_header_rec.global_attribute5 IS NULL ))
OR (p_x_header_rec.global_attribute6 IS NOT NULL AND
( p_x_header_rec.global_attribute6 <>
p_old_header_rec.global_attribute6 OR
p_old_header_rec.global_attribute6 IS NULL ))
OR (p_x_header_rec.global_attribute7 IS NOT NULL AND
( p_x_header_rec.global_attribute7 <>
p_old_header_rec.global_attribute7 OR
p_old_header_rec.global_attribute7 IS NULL ))
OR (p_x_header_rec.global_attribute8 IS NOT NULL AND
( p_x_header_rec.global_attribute8 <>
p_old_header_rec.global_attribute8 OR
p_old_header_rec.global_attribute8 IS NULL ))
OR (p_x_header_rec.global_attribute9 IS NOT NULL AND
( p_x_header_rec.global_attribute9 <>
p_old_header_rec.global_attribute9 OR
p_old_header_rec.global_attribute9 IS NULL ))
OR (p_x_header_rec.global_attribute_category IS NOT NULL AND
( p_x_header_rec.global_attribute_category <>
p_old_header_rec.global_attribute_category OR
p_old_header_rec.global_attribute_category IS NULL )))
THEN
OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
( p_x_header_rec.operation = oe_globals.g_opr_update AND
(p_x_header_rec.tp_attribute1 IS NOT NULL AND
( p_x_header_rec.tp_attribute1 <>
p_old_header_rec.tp_attribute1 OR
p_old_header_rec.tp_attribute1 IS NULL ))
OR (p_x_header_rec.tp_attribute2 IS NOT NULL AND
( p_x_header_rec.tp_attribute2 <>
p_old_header_rec.tp_attribute2 OR
p_old_header_rec.tp_attribute2 IS NULL ))
OR (p_x_header_rec.tp_attribute3 IS NOT NULL AND
( p_x_header_rec.tp_attribute3 <>
p_old_header_rec.tp_attribute3 OR
p_old_header_rec.tp_attribute3 IS NULL ))
OR (p_x_header_rec.tp_attribute4 IS NOT NULL AND
( p_x_header_rec.tp_attribute4 <>
p_old_header_rec.tp_attribute4 OR
p_old_header_rec.tp_attribute4 IS NULL ))
OR (p_x_header_rec.tp_attribute5 IS NOT NULL AND
( p_x_header_rec.tp_attribute5 <>
p_old_header_rec.tp_attribute5 OR
p_old_header_rec.tp_attribute5 IS NULL ))
OR (p_x_header_rec.tp_attribute6 IS NOT NULL AND
( p_x_header_rec.tp_attribute6 <>
p_old_header_rec.tp_attribute6 OR
p_old_header_rec.tp_attribute6 IS NULL ))
OR (p_x_header_rec.tp_attribute7 IS NOT NULL AND
( p_x_header_rec.tp_attribute7 <>
p_old_header_rec.tp_attribute7 OR
p_old_header_rec.tp_attribute7 IS NULL ))
OR (p_x_header_rec.tp_attribute8 IS NOT NULL AND
( p_x_header_rec.tp_attribute8 <>
p_old_header_rec.tp_attribute8 OR
p_old_header_rec.tp_attribute8 IS NULL ))
OR (p_x_header_rec.tp_attribute9 IS NOT NULL AND
( p_x_header_rec.tp_attribute9 <>
p_old_header_rec.tp_attribute9 OR
p_old_header_rec.tp_attribute9 IS NULL ))
OR (p_x_header_rec.tp_attribute10 IS NOT NULL AND
( p_x_header_rec.tp_attribute10 <>
p_old_header_rec.tp_attribute10 OR
p_old_header_rec.tp_attribute10 IS NULL ))
OR (p_x_header_rec.tp_attribute11 IS NOT NULL AND
( p_x_header_rec.tp_attribute11 <>
p_old_header_rec.tp_attribute11 OR
p_old_header_rec.tp_attribute11 IS NULL ))
OR (p_x_header_rec.tp_attribute12 IS NOT NULL AND
( p_x_header_rec.tp_attribute12 <>
p_old_header_rec.tp_attribute12 OR
p_old_header_rec.tp_attribute12 IS NULL ))
OR (p_x_header_rec.tp_attribute13 IS NOT NULL AND
( p_x_header_rec.tp_attribute13 <>
p_old_header_rec.tp_attribute13 OR
p_old_header_rec.tp_attribute13 IS NULL ))
OR (p_x_header_rec.tp_attribute14 IS NOT NULL AND
( p_x_header_rec.tp_attribute14 <>
p_old_header_rec.tp_attribute14 OR
p_old_header_rec.tp_attribute14 IS NULL ))
OR (p_x_header_rec.tp_attribute15 IS NOT NULL AND
( p_x_header_rec.tp_attribute15 <>
p_old_header_rec.tp_attribute15 OR
p_old_header_rec.tp_attribute15 IS NULL )))
THEN
IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN
IF NOT OE_VALIDATE.TP_Header_Desc_Flex
(p_context => p_x_header_rec.tp_context
,p_attribute1 => p_x_header_rec.tp_attribute1
,p_attribute2 => p_x_header_rec.tp_attribute2
,p_attribute3 => p_x_header_rec.tp_attribute3
,p_attribute4 => p_x_header_rec.tp_attribute4
,p_attribute5 => p_x_header_rec.tp_attribute5
,p_attribute6 => p_x_header_rec.tp_attribute6
,p_attribute7 => p_x_header_rec.tp_attribute7
,p_attribute8 => p_x_header_rec.tp_attribute8
,p_attribute9 => p_x_header_rec.tp_attribute9
,p_attribute10 => p_x_header_rec.tp_attribute10
,p_attribute11 => p_x_header_rec.tp_attribute11
,p_attribute12 => p_x_header_rec.tp_attribute12
,p_attribute13 => p_x_header_rec.tp_attribute13
,p_attribute14 => p_x_header_rec.tp_attribute14
,p_attribute15 => p_x_header_rec.tp_attribute15) THEN
IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
p_x_header_rec.tp_context := null;
PROCEDURE: Entity_Delete
Description:
-------------------------------------------------------*/
PROCEDURE Entity_Delete
( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, p_header_rec IN OE_Order_PUB.Header_Rec_Type
)
IS
l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
,'Entity_Delete'
);
END Entity_Delete;