The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF p_line_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_line_rec.transaction_phase_code
,p_old_line_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_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
AND NOT OE_GLOBALS.EQUAL(p_line_rec.unit_selling_price
,p_old_line_rec.unit_selling_price) THEN
IF p_line_rec.unit_selling_price IS NULL THEN
x_return_status := FND_API.G_RET_STS_ERROR;
SELECT type
INTO l_rule_type
FROM ra_rules
WHERE rule_id = p_line_rec.accounting_rule_id;
SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
INTO l_cust_trx_type_id
FROM ra_cust_trx_types cust_type,ra_customer_trx cust_trx
WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
AND cust_trx.customer_trx_id = p_line_rec.commitment_id;
SELECT tax_calculation_flag
INTO l_calculate_tax_flag
FROM RA_CUST_TRX_TYPES
WHERE CUST_TRX_TYPE_ID = l_line_type_rec.cust_trx_type_id;
SELECT TAX_CALCULATION_EVENT_CODE
INTO l_tax_calculation_event_code
FROM oe_transaction_types_all
WHERE transaction_type_id
= OE_Order_Cache.g_header_rec.order_type_id;
select decode(revision_qty_control_code, 2, 'Y', 'N')
into l_revision_controlled
from mtl_system_items
where inventory_item_id = p_line_rec.inventory_item_id
and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
SELECT Enforce_Ship_Set_And_Smc
INTO l_shipset_enforce
FROM Wsh_Shipping_Parameters
WHERE Organization_Id = p_line_rec.ship_from_org_Id;
SELECT count(*)
INTO l_ship_set
FROM Wsh_Delivery_Details
WHERE Ship_Set_Id = p_line_rec.ship_set_id
AND Source_Code = 'OE'
AND Source_Header_Id = p_line_rec.header_id
AND Released_Status In ('S','Y','C')
AND ROWNUM = 1; -- 3229707 Removed 'B' from Released_Status check
SELECT count(*)
INTO l_ship_set
FROM wsh_delivery_details wdd
WHERE wdd.ship_set_id = p_line_rec.ship_set_id
AND wdd.source_code = 'OE'
AND wdd.source_header_id = p_line_rec.header_id
AND ((wdd.released_status = 'C')
OR EXISTS (select wda.delivery_detail_id
FROM wsh_delivery_assignments wda, wsh_new_deliveries wnd
WHERE wda.delivery_detail_id = wdd.delivery_detail_id
AND wda.delivery_id = wnd.delivery_id
AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
AND rownum = 1;
SELECT SET_NAME
INTO l_set_name
FROM OE_SETS
WHERE set_id = p_line_rec.ship_set_id;
SELECT count(*)
INTO l_smc_model
FROM Wsh_Delivery_Details
WHERE Ship_Model_Complete_Flag = 'Y'
AND Top_Model_Line_Id = p_line_rec.top_model_line_id
AND Source_Header_Id = p_line_rec.header_id
AND Source_Code = 'OE'
AND Released_Status In ('S','Y','C')
AND ROWNUM = 1;
SELECT ORDERED_ITEM,inventory_item_id
INTO l_model_name,l_model_item_id
FROM OE_ORDER_LINES
WHERE line_id = p_line_rec.top_model_line_id;
SELECT order_date_type_code
INTO l_order_date_type_code
FROM oe_order_headers
WHERE header_id = p_header_id;
SELECT ordered_item, item_type_code,inventory_item_id,ordered_quantity
INTO l_ordered_item, l_item_type_code,l_inv_item_id,l_ordered_quantity
FROM oe_order_lines
WHERE line_id = p_line_rec.top_model_line_id;
SELECT INDIVISIBLE_FLAG
INTO l_indivisible_flag
FROM mtl_system_items
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id =
OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
SELECT 'EXISTS'
FROM oe_workflow_assignments a
WHERE a.line_type_id = p_line_rec.line_type_id
AND nvl(a.item_type_code,nvl(l_new_wf_item_type,'-99')) = nvl(l_new_wf_item_type,'-99')
AND a.process_name = lprocessname
AND a.order_type_id = lorder_type_id
AND sysdate BETWEEN A.START_DATE_ACTIVE
AND nvl( A.END_DATE_ACTIVE, sysdate + 1 )
ORDER BY a.item_type_code ;
SELECT order_type_id
FROM oe_order_headers
WHERE header_id = p_line_rec.header_id ;
SELECT 'EXISTS'
FROM oe_workflow_assignments a
WHERE a.line_type_id = p_line_rec.line_type_id
AND a.item_type_code = l_new_wf_item_type
AND a.order_type_id = lorder_type_id
AND sysdate between A.START_DATE_ACTIVE
AND nvl( A.END_DATE_ACTIVE, sysdate + 1 );
select ORDER_CATEGORY_CODE
into lline_category_code from oe_transaction_types_all
where transaction_type_id = p_line_rec.line_type_id;
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
l_new_wf_item_type := OE_Order_WF_Util.get_wf_item_type(p_line_rec);
Select root_activity
Into lprocessname
From wf_items_v
Where item_type = 'OEOL'
And item_key = to_char(p_line_rec.line_id) -- 2212128
And rownum = 1;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND msi.customer_order_enabled_flag =
DECODE(l_validate, 'Y', 'Y',
msi.customer_order_enabled_flag)
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND msi.customer_order_enabled_flag =
DECODE(l_validate, 'Y', 'Y',
msi.customer_order_enabled_flag)
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
FROM financials_system_parameters fsp);
SELECT a.shippable_item_flag, b.shippable_item_flag
INTO l_shipable_flag_old,l_shipable_flag_new
FROM mtl_system_items_b a,mtl_system_items_b b
WHERE a.inventory_item_id = p_line_rec.inventory_item_id
AND b.inventory_item_id = a.inventory_item_id
AND a.organization_id = p_old_line_rec.ship_from_org_id
AND b.organization_id = p_line_rec.ship_from_org_id;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND msi.internal_order_enabled_flag = 'Y'
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND rownum=1;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND rownum=1;
/*SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND msi.customer_order_enabled_flag =
Decode(g_cust_ord_enabled_flag, 'Y'
,'Y','N',msi.customer_order_enabled_flag)
AND rownum=1;*/
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND msi.customer_order_enabled_flag = g_cust_ord_enabled_flag
AND rownum=1;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND rownum =1;
SELECT null
INTO l_dummy
FROM mtl_system_items_b msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_inventory_item_id
AND org.organization_id= msi.organization_id
AND msi.customer_order_enabled_flag = 'Y'
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id= p_ship_from_org_id
AND rownum=1;
SELECT 'VALID'
INTO l_dummy
FROM mtl_task_v
WHERE project_id = p_project_id
AND task_id = p_task_id;
SELECT NVL(PROJECT_CONTROL_LEVEL,0)
INTO l_project_control_level
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = p_ship_from_org_id;
SELECT DECODE(items.org_independent_flag, 'Y', 1,
DECODE(items.organization_id, item_val_org, 1, 2))
FROM mtl_cross_reference_types types
, mtl_cross_references items
, mtl_system_items_vl sitems
WHERE types.cross_reference_type = items.cross_reference_type
AND items.inventory_item_id = sitems.inventory_item_id
AND sitems.organization_id = item_val_org
AND sitems.inventory_item_id = p_inventory_item_id
AND items.cross_reference_type = p_item_identifier_type
AND items.cross_reference = p_ordered_item
AND (types.disable_date is NULL or types.disable_date > sysdate) --And condition added for bug 3844345 shewgupt
AND sitems.customer_order_enabled_flag = 'Y' --And condition added for bug 3844345 shewgupt
ORDER BY 1;
SELECT DECODE(items.org_independent_flag, 'Y', 1,
DECODE(items.organization_id, item_val_org, 1, 2))
FROM mtl_cross_reference_types types
, mtl_cross_references items
, mtl_system_items_vl sitems
WHERE types.cross_reference_type = items.cross_reference_type
AND items.inventory_item_id = sitems.inventory_item_id
AND sitems.organization_id = item_val_org
AND sitems.inventory_item_id = p_inventory_item_id
AND items.cross_reference_type = p_item_identifier_type
AND items.cross_reference = p_ordered_item
ORDER BY 1;
SELECT 'valid'
INTO l_dummy
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
AND internal_order_enabled_flag = 'Y';
SELECT 'valid'
INTO l_dummy
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
/*SELECT 'valid'
INTO l_dummy
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
AND customer_order_enabled_flag = 'Y'; */
/*SELECT 'valid'
INTO l_dummy
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
AND customer_order_enabled_flag = 'Y'; */
SELECT 'valid'
INTO l_dummy
FROM mtl_customer_items citems
,mtl_customer_item_xrefs cxref
,mtl_system_items_vl sitems
,mtl_parameters mp -- 4402603
WHERE citems.customer_item_id = cxref.customer_item_id
AND cxref.inventory_item_id = sitems.inventory_item_id
AND sitems.inventory_item_id = p_inventory_item_id
AND sitems.organization_id =
OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
AND sitems.customer_order_enabled_flag = 'Y' -- bug 3835602
AND citems.customer_item_id = p_ordered_item_id
AND citems.customer_id = p_sold_to_org_id
AND citems.inactive_flag = 'N'
AND cxref.inactive_flag = 'N'
AND mp.organization_id = sitems.organization_id -- 4402603
AND cxref.master_organization_id = mp.master_organization_id ; -- 4402603
SELECT 'valid'
INTO l_dummy
FROM mtl_customer_items citems
,mtl_customer_item_xrefs cxref
,mtl_system_items_vl sitems
,mtl_parameters mp -- 4402603
WHERE citems.customer_item_id = cxref.customer_item_id
AND cxref.inventory_item_id = sitems.inventory_item_id
AND sitems.inventory_item_id = p_inventory_item_id
AND sitems.organization_id =
OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
AND citems.customer_item_id = p_ordered_item_id
AND citems.customer_id = p_sold_to_org_id
AND mp.organization_id = sitems.organization_id -- 4402603
AND cxref.master_organization_id = mp.master_organization_id ; -- 4402603
ELSIF p_line_category_code ='ORDER' THEN /* SELECT replaced for with the following for 2219230 */
IF l_debug_level > 0 then
oe_debug_pub.add('Validating generic item when category code is ORDER , item_val_org:'||to_char(item_val_org),5);
SELECT inventory_item_id
INTO l_ref_inventory_item_id
FROM oe_order_lines
WHERE line_id = p_reference_line_id;
SELECT nvl(fulfilled_quantity, 0)
, nvl(shippable_flag, 'N')
, invoice_interface_status_code
, nvl(shipped_quantity, 0)
INTO l_ref_fulfilled_quantity
, l_ref_shippable_flag
, l_ref_inv_iface_status
, l_ref_shipped_quantity
FROM oe_order_lines
WHERE line_id = p_reference_line_id;
SELECT nvl(returnable_flag,'Y')
INTO l_returnable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
and organization_id = nvl(p_ship_from_org_id,
oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID')); */
SELECT tax_code
INTO l_tax_code
FROM oe_order_lines
WHERE line_id = p_reference_line_id
and line_category_code = 'ORDER';
SELECT nvl(booked_flag,'N'),
nvl(ORDER_QUANTITY_UOM,' '),
source_document_type_id,
subscription_enable_flag -- sol_ord_er #16014165
INTO l_booked_flag,
l_uom_code,
l_source_document_type_id,
l_subscription_enable_flag -- sol_ord_er #16014165
FROM oe_order_lines
WHERE line_id = p_reference_line_id
and line_category_code = 'ORDER';
SELECT wf_assign.process_name
INTO l_root
FROM oe_workflow_assignments wf_assign,
oe_order_headers header
WHERE nvl(p_wfasgn_item_type ,'-99') = nvl(wf_assign.item_type_code,nvl(p_wfasgn_item_type,'-99'))
AND header.header_id = p_header_id
AND header.order_type_id = wf_assign.order_type_id
AND wf_assign.line_type_id = p_line_type_id
AND wf_assign.line_type_id IS NOT NULL
AND sysdate >= wf_assign.start_date_active
AND sysdate <= nvl(wf_assign.end_date_active, sysdate)
ORDER BY wf_assign.item_type_code;
select INSTANCE_ID
into l_rootid
from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
where A.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
and A.NAME = 'ROOT'
and l_actdate >= A.BEGIN_DATE
and l_actdate < NVL(A.END_DATE, l_actdate+1)
and PA.PROCESS_NAME = 'ROOT'
and PA.PROCESS_ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
and PA.PROCESS_VERSION = A.VERSION
and PA.INSTANCE_LABEL = l_root;
SELECT NVL(SUM(ordered_quantity),0)
INTO l_ord_qty
FROM oe_order_lines
WHERE line_category_code= 'RETURN'
and reference_line_id = p_line_id;
ELSIF p_action_code = OE_GLOBALS.G_OPR_DELETE THEN
-- Line deletion during config item delinking (p_ord_qty>0)
fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_DELINK');
Select 'VALID'
Into l_dummy
From oe_ship_to_orgs_v
Where customer_id = p_sold_to_org_id
AND site_use_id = p_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_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_sold_to_org_id FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID FROM
HZ_CUST_ACCT_RELATE_ALL h WHERE
RELATED_CUST_ACCOUNT_ID = p_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;
SELECT 'VALID'
INTO l_dummy
FROM OE_SHIP_TO_ORGS_V SHP
WHERE SHP.ORGANIZATION_ID =p_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_sold_to_org_id
AND site_use_id = p_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_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_sold_to_org_id FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID FROM
HZ_CUST_ACCT_RELATE_ALL h WHERE
RELATED_CUST_ACCOUNT_ID = p_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;
SELECT 'VALID'
INTO l_dummy
FROM OE_DELIVER_TO_ORGS_V DEL
WHERE DEL.ORGANIZATION_ID =p_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 ratrx.end_date_commitment, ratrx.trx_number
into l_comm_end_date, l_commitment_number
from ra_customer_trx ratrx
where ratrx.customer_trx_id = p_line_rec.commitment_id
and exists
( Select 1
From ra_cust_trx_types ractt
Where ractt.type in ('DEP','GUAR')
and ratrx.cust_trx_type_id = ractt.cust_trx_type_id
and ractt.org_id = p_line_rec.org_id)
and ratrx.bill_to_customer_id
in (select to_number(p_line_rec.sold_to_org_id )
from sys.dual
union
select cust_account_id customer_id
from hz_cust_acct_relate
where related_cust_account_id = p_line_rec.sold_to_org_id
and status = 'A')
and ratrx.invoice_currency_code = p_hdr_currency_code
and trunc(sysdate) between trunc(nvl( ratrx.start_date_commitment, sysdate))
and trunc(nvl( ratrx.end_date_commitment, sysdate ))
and ratrx.complete_flag = 'Y' ;
select /* MOAC_SQL_CHANGE */ 'Y'
into l_exists
from ra_customer_trx ratrx
where ratrx.bill_to_customer_id in
(select p_line_rec.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_line_rec.sold_to_org_id
and status = 'A'
and bill_to_flag = 'Y'
and h.org_id =ratrx.org_id
union
select cas.cust_account_id customer_id
from hz_cust_site_uses_all su,
hz_cust_acct_sites_all cas
where cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_id = p_line_rec.invoice_to_org_id
and cas.org_id=ratrx.org_id
union
select c.cust_account_id customer_id
from hz_cust_acct_relate_all c,
hz_cust_site_uses_all su,
hz_cust_acct_sites_all cas
where cas.cust_acct_site_id = su.cust_acct_site_id
and su.site_use_id = p_line_rec.invoice_to_org_id
and c.related_cust_account_id = cas.cust_account_id
and c.status = 'A'
and c.org_id =ratrx.org_id
and cas.org_id=ratrx.org_id
and c.bill_to_flag = 'Y')
and ratrx.customer_trx_id = p_line_rec.commitment_id;
select /* MOAC_SQL_CHANGE */ ratrx.end_date_commitment, ratrx.trx_number,
ratrx.agreement_id, ratrl.inventory_item_id
INTO l_comm_end_date, l_commitment_number,
l_agreement_id, l_inventory_item_id
from ra_customer_trx_all ratrx,
ra_cust_trx_types_all ractt,
ra_customer_trx_lines ratrl
where ractt.type in ('DEP','GUAR')
AND ratrx.cust_trx_type_id = ractt.cust_trx_type_id
AND ractt.org_id = p_line_rec.org_id
AND ratrl.org_id =ratrx.org_id
AND ratrl.customer_trx_id = ratrx.customer_trx_id
and ratrx.invoice_currency_code = p_hdr_currency_code
and trunc(sysdate) between trunc(nvl( ratrx.start_date_commitment, sysdate))
and trunc(nvl( ratrx.end_date_commitment, sysdate ))
and ratrx.complete_flag = 'Y'
AND ratrx.customer_trx_id = p_line_rec.commitment_id;
SELECT purchasing_enabled_flag
INTO l_purchasing_enabled_flag
FROM mtl_system_items msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
SELECT purchasing_enabled_flag
INTO l_purchasing_enabled_flag
FROM mtl_system_items msi,
org_organization_definitions org
WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
AND org.organization_id= msi.organization_id
AND sysdate <= nvl( org.disable_date, sysdate)
AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
FROM financials_system_parameters fsp);
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
NOT OE_GLOBALS.Equal(p_line_rec.source_type_code,
p_old_line_rec.source_type_code) AND
p_line_rec.ato_line_id <> p_line_rec.line_id AND
OE_Config_Util.CASCADE_CHANGES_FLAG = 'N' AND
OE_CODE_CONTROL.Get_Code_Release_Level >= '110508'
THEN
IF l_debug_level > 0 then
oe_debug_pub.add('item under ato model', 4);
Select arrival_set_id,
ship_set_id
Into l_arrival_set_id,
l_ship_set_id
FROM OE_ORDER_LINES_ALL
Where line_id = p_line_rec.top_model_line_id;
SELECT meaning
INTO l_temp
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'ITEM_TYPE'
AND LOOKUP_CODE = p_line_rec.item_type_code;
SELECT /* MOAC_SQL_CHANGE */ BL.SOLD_TO_ORG_ID,
BHE.on_hold_flag,
BLE.START_DATE_ACTIVE,
BLE.END_DATE_ACTIVE,
BL.INVENTORY_ITEM_ID,
BL.ORDERED_ITEM_ID, --bug6929192
BL.ORDERED_ITEM, --bug6929192
BL.ITEM_IDENTIFIER_TYPE,
BL.PRICE_LIST_ID,
BL.SHIP_TO_ORG_ID,
BL.INVOICE_TO_ORG_ID,
BL.FREIGHT_TERMS_CODE,
BL.SHIPPING_METHOD_CODE,
BL.PAYMENT_TERM_ID,
BL.ACCOUNTING_RULE_ID,
BL.INVOICING_RULE_ID,
BLE.ENFORCE_PRICE_LIST_FLAG,
BLE.ENFORCE_SHIP_TO_FLAG,
BLE.ENFORCE_INVOICE_TO_FLAG,
BLE.ENFORCE_FREIGHT_TERM_FLAG,
BLE.ENFORCE_SHIPPING_METHOD_FLAG,
BLE.ENFORCE_PAYMENT_TERM_FLAG,
BLE.ENFORCE_ACCOUNTING_RULE_FLAG,
BLE.ENFORCE_INVOICING_RULE_FLAG,
NVL(BH.FLOW_STATUS_CODE,'ACTIVE')
INTO l_sold_to_org_id,
l_on_hold_flag,
l_start_date_active,
l_end_date_active,
l_item_id,
l_ordered_item_id,
l_ordered_item,
l_item_context,
l_price_list_id,
L_SHIP_TO_ORG_ID,
L_INVOICE_TO_ORG_ID,
L_FREIGHT_TERMS_CODE,
L_SHIPPING_METHOD_CODE,
L_PAYMENT_TERM_ID,
L_ACCOUNTING_RULE_ID,
L_INVOICING_RULE_ID,
l_enforce_price_list_flag,
l_enforce_ship_to_flag,
l_enforce_invoice_to_flag,
l_enforce_freight_term_flag,
l_enforce_shipping_method_flag,
l_enforce_payment_term_flag,
l_enforce_accounting_rule_flag,
l_enforce_invoicing_rule_flag,
l_flow_status_code
FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_HEADERS BH,
OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
WHERE BLE.ORDER_NUMBER = p_line_rec.blanket_number
AND BLE.LINE_NUMBER = p_line_rec.blanket_line_number
AND BHE.ORDER_NUMBER = BLE.ORDER_NUMBER
AND BL.LINE_ID = BLE.LINE_ID
AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'
AND BH.ORG_ID =BL.ORG_ID
AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'
AND NVL(BH.DRAFT_SUBMITTED_FLAG,'Y') = 'Y';
SELECT 'VALID'
INTO l_temp
FROM MTL_ITEM_CATEGORIES
WHERE ORGANIZATION_ID = l_item_val_org -- 5630818
AND INVENTORY_ITEM_ID = p_line_rec.inventory_item_id
AND CATEGORY_ID = l_item_id
-- Bug 2857391 => Item can be assigned to this category
-- in multiple category sets, select only 1 row to avoid
-- multiple rows error.
AND ROWNUM = 1;
SELECT DESCRIPTION
INTO l_temp
FROM MTL_CATEGORIES_VL
WHERE CATEGORY_ID = l_item_id;
SELECT 'Y'
INTO l_exists
FROM HZ_CUST_ACCT_RELATE
WHERE RELATED_CUST_ACCOUNT_ID = p_line_rec.sold_to_org_id
AND CUST_ACCOUNT_ID = l_sold_to_org_id
AND STATUS = 'A'
AND ROWNUM = 1;
SELECT item_type_code, ato_line_id
INTO x_item_type_code, x_ato_line_id
FROM oe_order_lines
WHERE line_id = p_line_rec.reference_line_id;
SELECT --RELEASED_STATUS, -- 14108180
SRC_REQUESTED_QUANTITY,
SRC_REQUESTED_QUANTITY2
FROM WSH_DELIVERY_DETAILS
WHERE SOURCE_CODE = 'OE'
AND SOURCE_LINE_ID = p_line_rec.line_id
AND released_status in ('Y', 'S', 'N', 'X'); --14108180;
SELECT ABS(mmt.transaction_quantity) transaction_quantity,
mmt.transaction_uom,
mmt.revision
FROM oe_order_lines_all ool, mtl_material_transactions mmt
WHERE ool.line_id = p_line_rec.reference_line_id
AND mmt.transaction_source_type_id = 2
AND mmt.transaction_type_id = 33
AND mmt.trx_source_line_id = ool.line_id
AND mmt.inventory_item_id = ool.inventory_item_id
AND mmt.organization_id = ool.ship_from_org_id;
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 I.SERVICEABLE_PRODUCT_FLAG,L.flow_status_code INTO
l_serviceable_product_flag,l_flow_status_code
FROM MTL_SYSTEM_ITEMS I,OE_ORDER_LINES L
WHERE I.INVENTORY_ITEM_ID = L.inventory_item_id
AND I.ORGANIZATION_ID = g_master_org_id
AND L.LINE_ID = P_LINE_REC.service_reference_line_id;
SELECT 'VALID'
INTO l_dummy
FROM MTL_SUBINVENTORIES_TRK_VAL_V
WHERE organization_id = p_line_rec.ship_from_org_id
AND secondary_inventory_name = p_line_rec.subinventory;
AND p_line_rec.operation =OE_GLOBALS.G_OPR_UPDATE
AND nvl(p_line_rec.split_action_code,'X')<>'SPLIT'
THEN
fnd_message.set_name('ONT','OE_CANT_UPDATE_SHIPMENT_NO');
/*SELECT RESTRICT_SUBINVENTORIES_CODE
INTO l_restrict_subinv
FROM MTL_SYSTEM_ITEMS
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id = p_line_rec.ship_from_org_id;*/
select 'Y'
into l_dummy
from MTL_ITEM_SUB_INVENTORIES_ALL_V
where organization_id = p_line_rec.ship_from_org_id
and inventory_item_id = p_line_rec.inventory_item_id
and secondary_inventory = p_line_rec.subinventory;
select 'Y'
into l_dummy
from mtl_subinventories_trk_val_v sub
where sub.organization_id = p_line_rec.ship_from_org_id
and sub.secondary_inventory_name = p_line_rec.subinventory
and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
OR
(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
and nvl(p_line_rec.order_source_id, -1) <> 10
)
OR
(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
and nvl(p_line_rec.order_source_id, -1) = 10
and 'N' = (select inventory_asset_flag
from mtl_system_items
where inventory_item_id = p_line_rec.inventory_item_id
and organization_id = p_line_rec.ship_from_org_id)
)
OR
(fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
and nvl(p_line_rec.order_source_id, -1) = 10
and 'Y' = (select inventory_asset_flag
from mtl_system_items
where inventory_item_id = p_line_rec.inventory_item_id
and organization_id = p_line_rec.ship_from_org_id)
and sub.asset_inventory = 1
)
);
SELECT 1
INTO l_dummy
FROM mtl_item_revisions
WHERE inventory_item_id=p_line_rec.inventory_item_id
AND organization_id=p_line_rec.ship_from_org_id
AND effectivity_date<=sysdate
AND revision= p_line_rec.item_revision;
select sum(ordered_quantity)
into l_quantity_entered
from oe_order_lines
where reference_line_id = p_line_rec.reference_line_id
and line_category_code = 'RETURN'
and item_revision = p_line_rec.item_revision
and sold_to_org_id = p_line_rec.sold_to_org_id
and booked_flag = 'Y'
and cancelled_flag <> 'Y'
and line_id <> p_line_rec.line_id;
SELECT 'N'
INTO l_valid_line_number
FROM oe_order_lines L
WHERE L.line_number = p_line_rec.line_number
AND L.header_id = p_line_rec.header_id
AND L.line_id <> p_line_rec.line_id
AND ( L.item_type_code = 'STANDARD'
OR ( L.top_model_line_id = L.line_id
--bug 16682423
--AND L.item_type_code = 'MODEL'));
UPDATE OE_ORDER_LINES_ALL
SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
SCHEDULE_ARRIVAL_DATE = p_old_line_rec.schedule_arrival_date,
SHIP_FROM_ORG_ID = p_old_line_rec.ship_from_org_id
WHERE top_model_line_id = p_line_rec.top_model_line_id;
IF NOT OE_GLOBALS.EQUAL(p_line_rec.auto_selected_quantity
,p_old_line_rec.auto_selected_quantity)
OR p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
Validate_Decimal_Quantity
(p_item_id => p_line_rec.inventory_item_id
,p_item_type_code => l_item_type_code
,p_input_quantity => p_line_rec.auto_selected_quantity
,p_uom_code => p_line_rec.order_quantity_uom
-- 3718547
,p_ato_line_id => nvl(l_ato_line_id, p_line_rec.ato_line_id)
,p_line_id => nvl(l_line_id, p_line_rec.line_id)
,p_line_num => l_line_num
,x_output_quantity => l_rounded_qty
-- 4197444
,x_return_status => l_status);
oe_debug_pub.add('Auto Selected Qty '||p_line_rec.auto_selected_quantity,2);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG) AND
OE_Config_Util.CASCADE_CHANGES_FLAG = 'N' AND
p_line_rec.line_id <> p_line_rec.ato_line_id THEN
IF (NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,
p_old_line_rec.project_id)) THEN
l_return_status := FND_API.G_RET_STS_ERROR;
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_line_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_line_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 INV to SITE_USE for bug 3739650
HZ_CUST_ACCT_SITES ADDR
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_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_line_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 oe_invoice_to_orgs_v
Where customer_id = p_line_rec.sold_to_org_id
And site_use_id = p_line_rec.invoice_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_line_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.STATUS ='A' AND --bug 2752321
ACCT_SITE.CUST_ACCOUNT_ID in (
SELECT p_line_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_line_rec.sold_to_org_id
and h.org_id=acct_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 '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_ALL ADDR
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_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_line_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 'VALID'
INTO l_dummy
FROM AR_VAT_TAX V,
AR_SYSTEM_PARAMETERS P
WHERE V.TAX_CODE = p_line_rec.tax_code
AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND NVL(V.ENABLED_FLAG,'Y')='Y'
AND NVL(V.TAX_CLASS,'O')='O'
AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
AND TRUNC(p_line_rec.tax_date) BETWEEN TRUNC(V.START_DATE) AND
TRUNC(NVL(V.END_DATE, p_line_rec.tax_date))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM AR_VAT_TAX V
WHERE V.TAX_CODE = p_line_rec.tax_code
AND V.SET_OF_BOOKS_ID = l_sob_id
AND NVL(V.ENABLED_FLAG,'Y')='Y'
AND NVL(V.TAX_CLASS,'O')='O'
AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
AND TRUNC(p_line_rec.tax_date) BETWEEN TRUNC(V.START_DATE) AND
TRUNC(NVL(V.END_DATE, p_line_rec.tax_date))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM ZX_OUTPUT_CLASSIFICATIONS_V
WHERE LOOKUP_CODE = p_line_rec.tax_code
-- AND LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS'
AND ENABLED_FLAG ='Y'
AND ORG_ID in (p_line_rec.org_id, -99)
AND TRUNC(p_line_rec.tax_date) BETWEEN
TRUNC(START_DATE_ACTIVE) AND
TRUNC(NVL(END_DATE_ACTIVE, p_line_rec.tax_date))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_line_rec.tax_exempt_number
AND EXEMPT_REASON_CODE = p_line_rec.tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_line_rec.ship_to_org_id,
p_line_rec.invoice_to_org_id))
= nvl(p_line_rec.ship_to_org_id,
p_line_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 TAX_CODE = p_line_rec.tax_code
AND org_id = l_org_id
AND party_id = l_bill_to_party_id
-- AND nvl(LEGAL_ENTITY_ID,-99) IN (nvl(l_legal_entity_id, legal_entity_id), -99)
AND EXEMPTION_STATUS_CODE = 'PRIMARY'
AND TRUNC(NVL(p_line_rec.request_date,sysdate))
BETWEEN TRUNC(EFFECTIVE_FROM)
AND TRUNC(NVL(EFFECTIVE_TO,NVL(p_line_rec.request_date,sysdate)))
AND ROWNUM = 1;
SELECT 'VALID'
INTO l_dummy
FROM ZX_EXEMPTIONS_V
WHERE EXEMPT_CERTIFICATE_NUMBER = p_line_rec.tax_exempt_number
AND EXEMPT_REASON_CODE = p_line_rec.tax_exempt_reason_code
AND nvl(site_use_id,nvl(p_line_rec.ship_to_org_id,
p_line_rec.invoice_to_org_id))
= nvl(p_line_rec.ship_to_org_id,
p_line_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 TAX_CODE = p_line_rec.tax_code
AND org_id = l_org_id
AND party_id = l_bill_to_party_id
-- AND nvl(LEGAL_ENTITY_ID,-99) IN (nvl(l_legal_entity_id, legal_entity_id), -99)
AND EXEMPTION_STATUS_CODE IN ( 'PRIMARY', 'MANUAL', 'UNAPPROVED' )
AND TRUNC(NVL(p_line_rec.request_date,sysdate))
BETWEEN TRUNC(EFFECTIVE_FROM)
AND TRUNC(NVL(EFFECTIVE_TO,NVL(p_line_rec.request_date,sysdate)))
AND ROWNUM = 1;
/*SELECT primary_uom_code
INTO l_uom
FROM mtl_system_items_b
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id = nvl(p_line_rec.ship_from_org_id,
OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
SELECT primary_uom_code
INTO l_uom
FROM mtl_system_items
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id = g_master_org_id ;
/*SELECT count(*)
INTO l_uom_count
FROM mtl_item_uoms_view
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND uom_code = p_line_rec.order_quantity_uom
AND organization_id = nvl(p_line_rec.ship_from_org_id,
OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
select list_type_code
into l_list_type_code
from qp_list_headers_vl
where list_header_id = p_line_rec.price_list_id;
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_line_rec.agreement_id
AND trunc(nvl(p_line_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
INTO l_price_list_name
FROM qp_List_headers_vl
WHERE list_header_id = p_line_rec.price_list_id
AND trunc(nvl(p_line_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
INTO l_price_list_name
FROM QP_List_headers_vl
WHERE list_header_id = l_price_list_id
AND trunc(nvl(p_line_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_line_rec.sold_to_org_id
and status = 'A'
AND cust_account_id = l_sold_to_org
);
Select transactional_curr_code
into l_hdr_currency_code
From oe_order_headers_all
Where header_id = p_line_rec.header_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
/*SELECT name, list_type_code
INTO l_price_list_name, l_list_type_code
FROM qp_list_headers_vl
WHERE list_header_id = p_line_rec.price_list_id
AND trunc(nvl(p_line_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 'Y'
INTO l_dummy
FROM oe_agreements oa
WHERE price_list_id = p_line_rec.price_list_id
AND (sold_to_org_id = -1
OR sold_to_org_id = p_line_rec.sold_to_org_id);
SELECT 'Y'
INTO l_dummy
FROM oe_agreements oa
WHERE price_list_id = p_line_rec.price_list_id
AND sold_to_org_id IN
(select -1
from dual
union
select p_line_rec.sold_to_org_id
from dual
union
select r.cust_account_id
from hz_cust_acct_relate r
where r.related_cust_account_id = p_line_rec.sold_to_org_id);
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
(p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
(p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
p_line_rec.line_id <> p_line_rec.top_model_line_id ) OR --bug 2382657
(p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED) OR
(p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
p_line_rec.service_reference_line_id IS NOT NULL AND
p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
THEN
IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,
p_old_line_rec.line_number)) THEN
l_return_status := FND_API.G_RET_STS_ERROR;
p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_line_rec.ordered_quantity = 0
THEN
IF l_debug_level > 0 then
oe_debug_pub.add('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);
p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_line_rec.ordered_quantity = 0
THEN
IF l_debug_level > 0 then
oe_debug_pub.add('class/option qty changed to 0', 1);
p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
OE_Sales_Can_Util.G_Require_Reason = FALSE
THEN
-- this is a decrement and not a cancellation.
SELECT count(*)
INTO l_option_count
FROM oe_order_lines
WHERE top_model_line_id = p_line_rec.line_id
AND line_id <> p_line_rec.line_id;
SELECT name
INTO l_agreement_name
FROM oe_agreements_vl
WHERE agreement_id = p_line_rec.agreement_id
AND trunc(nvl(p_line_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 requisition_header_id, po_header_id
--INTO l_uom_count, l_msg_count
INTO l_req_header_id,l_po_header_id
FROM oe_drop_ship_sources
WHERE line_id = p_line_rec.line_id;
SELECT segment1
INTO l_sold_to_org
FROM po_requisition_headers_all
WHERE requisition_header_id = l_req_header_id;
SELECT segment1
INTO l_sold_to_org
FROM po_headers_all
WHERE po_header_id = l_po_header_id;
(p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
p_line_rec.item_type_code <> 'CONFIG' )) AND
(p_line_rec.top_model_line_id is NOT NULL and
p_line_rec.top_model_line_id <> p_line_rec.line_id)
AND NVL(p_line_rec.model_remnant_flag,'N')='N'
THEN
Decimal_Ratio_Check
( p_line_rec => p_line_rec
,x_return_status => l_status);
OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
SELECT 'VALID'
INTO l_dummy
FROM
HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
WHERE
ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_line_rec.end_customer_contact_id
AND ACCT_ROLE.CUST_ACCOUNT_ID = p_line_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_line_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_line_rec.end_customer_id;
IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
OE_GLOBALS.Equal (p_line_rec.inventory_item_id,
p_old_line_rec.inventory_item_id) THEN
IF l_debug_level > 0 THEN
OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,2);
OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
SELECT type
INTO l_rule_type
FROM ra_rules
WHERE rule_id = p_line_rec.accounting_rule_id;
SELECT type
INTO l_rule_type
FROM ra_rules
WHERE rule_id = p_line_rec.accounting_rule_id;
SELECT uom_code
INTO l_uom
FROM mtl_item_uoms_view
WHERE inventory_item_id = p_line_rec.inventory_item_id
and uom_code=p_line_rec.service_period
AND organization_id = l_mast_org_id
and rownum=1;
SELECT uom_code
INTO l_uom
FROM mtl_item_uoms_view
WHERE inventory_item_id = p_line_rec.inventory_item_id
and uom_code=p_line_rec.service_period
AND organization_id = p_line_rec.ship_from_org_id
and rownum=1;
SELECT primary_uom_code
INTO l_uom
FROM mtl_system_items_b
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id = l_mast_org_id
and rownum=1;
SELECT primary_uom_code
INTO l_uom
FROM mtl_system_items_b
WHERE inventory_item_id = p_line_rec.inventory_item_id
AND organization_id = p_line_rec.ship_from_org_id
and rownum=1;
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
THEN
l_type_code := Get_Date_Type(p_x_line_rec.header_id);
p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
THEN
l_type_code := Get_Date_Type(p_x_line_rec.header_id);
FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
SELECT context_required_flag, default_context_field_name
FROM FND_DESCRIPTIVE_FLEXS_VL
WHERE (application_id = 660)
AND (descriptive_flexfield_name = l_flex_name); --End of bug#7380336
(p_x_line_rec.operation = oe_globals.g_opr_update AND
(p_x_line_rec.attribute1 IS NOT NULL AND
( p_x_line_rec.attribute1 <>
p_old_line_rec.attribute1 OR
p_old_line_rec.attribute1 IS NULL ))
OR (p_x_line_rec.attribute10 IS NOT NULL AND
( p_x_line_rec.attribute10 <>
p_old_line_rec.attribute10 OR
p_old_line_rec.attribute10 IS NULL ))
OR (p_x_line_rec.attribute11 IS NOT NULL AND
( p_x_line_rec.attribute11 <>
p_old_line_rec.attribute11 OR
p_old_line_rec.attribute11 IS NULL ))
OR (p_x_line_rec.attribute12 IS NOT NULL AND
( p_x_line_rec.attribute12 <>
p_old_line_rec.attribute12 OR
p_old_line_rec.attribute12 IS NULL ))
OR (p_x_line_rec.attribute13 IS NOT NULL AND
( p_x_line_rec.attribute13 <>
p_old_line_rec.attribute13 OR
p_old_line_rec.attribute13 IS NULL ))
OR (p_x_line_rec.attribute14 IS NOT NULL AND
( p_x_line_rec.attribute14 <>
p_old_line_rec.attribute14 OR
p_old_line_rec.attribute14 IS NULL ))
OR (p_x_line_rec.attribute15 IS NOT NULL AND
( p_x_line_rec.attribute15 <>
p_old_line_rec.attribute15 OR
p_old_line_rec.attribute15 IS NULL ))
OR (p_x_line_rec.attribute16 IS NOT NULL AND -- For bug 2184255
( p_x_line_rec.attribute16 <>
p_old_line_rec.attribute16 OR
p_old_line_rec.attribute16 IS NULL ))
OR (p_x_line_rec.attribute17 IS NOT NULL AND
( p_x_line_rec.attribute17 <>
p_old_line_rec.attribute17 OR
p_old_line_rec.attribute17 IS NULL ))
OR (p_x_line_rec.attribute18 IS NOT NULL AND
( p_x_line_rec.attribute18 <>
p_old_line_rec.attribute18 OR
p_old_line_rec.attribute18 IS NULL ))
OR (p_x_line_rec.attribute19 IS NOT NULL AND
( p_x_line_rec.attribute19 <>
p_old_line_rec.attribute19 OR
p_old_line_rec.attribute19 IS NULL ))
OR (p_x_line_rec.attribute2 IS NOT NULL AND
( p_x_line_rec.attribute2 <>
p_old_line_rec.attribute2 OR
p_old_line_rec.attribute2 IS NULL ))
OR (p_x_line_rec.attribute20 IS NOT NULL AND
( p_x_line_rec.attribute20 <>
p_old_line_rec.attribute20 OR
p_old_line_rec.attribute20 IS NULL ))
OR (p_x_line_rec.attribute3 IS NOT NULL AND
( p_x_line_rec.attribute3 <>
p_old_line_rec.attribute3 OR
p_old_line_rec.attribute3 IS NULL ))
OR (p_x_line_rec.attribute4 IS NOT NULL AND
( p_x_line_rec.attribute4 <>
p_old_line_rec.attribute4 OR
p_old_line_rec.attribute4 IS NULL ))
OR (p_x_line_rec.attribute5 IS NOT NULL AND
( p_x_line_rec.attribute5 <>
p_old_line_rec.attribute5 OR
p_old_line_rec.attribute5 IS NULL ))
OR (p_x_line_rec.attribute6 IS NOT NULL AND
( p_x_line_rec.attribute6 <>
p_old_line_rec.attribute6 OR
p_old_line_rec.attribute6 IS NULL ))
OR (p_x_line_rec.attribute7 IS NOT NULL AND
( p_x_line_rec.attribute7 <>
p_old_line_rec.attribute7 OR
p_old_line_rec.attribute7 IS NULL ))
OR (p_x_line_rec.attribute8 IS NOT NULL AND
( p_x_line_rec.attribute8 <>
p_old_line_rec.attribute8 OR
p_old_line_rec.attribute8 IS NULL ))
OR (p_x_line_rec.attribute9 IS NOT NULL AND
( p_x_line_rec.attribute9 <>
p_old_line_rec.attribute9 OR
p_old_line_rec.attribute9 IS NULL ))
OR (p_x_line_rec.context IS NOT NULL AND
( p_x_line_rec.context <>
p_old_line_rec.context OR
p_old_line_rec.context IS NULL )))
THEN
IF l_debug_level > 0 then
oe_debug_pub.add('Before calling line_desc_flex',2);
( p_x_line_rec.operation = oe_globals.g_opr_update AND
(p_x_line_rec.global_attribute1 IS NOT NULL AND
( p_x_line_rec.global_attribute1 <>
p_old_line_rec.global_attribute1 OR
p_old_line_rec.global_attribute1 IS NULL ))
OR (p_x_line_rec.global_attribute10 IS NOT NULL AND
( p_x_line_rec.global_attribute10 <>
p_old_line_rec.global_attribute10 OR
p_old_line_rec.global_attribute10 IS NULL ))
OR (p_x_line_rec.global_attribute11 IS NOT NULL AND
( p_x_line_rec.global_attribute11 <>
p_old_line_rec.global_attribute11 OR
p_old_line_rec.global_attribute11 IS NULL ))
OR (p_x_line_rec.global_attribute12 IS NOT NULL AND
( p_x_line_rec.global_attribute12 <>
p_old_line_rec.global_attribute12 OR
p_old_line_rec.global_attribute12 IS NULL ))
OR (p_x_line_rec.global_attribute13 IS NOT NULL AND
( p_x_line_rec.global_attribute13 <>
p_old_line_rec.global_attribute13 OR
p_old_line_rec.global_attribute13 IS NULL ))
OR (p_x_line_rec.global_attribute14 IS NOT NULL AND
( p_x_line_rec.global_attribute14 <>
p_old_line_rec.global_attribute14 OR
p_old_line_rec.global_attribute14 IS NULL ))
OR (p_x_line_rec.global_attribute15 IS NOT NULL AND
( p_x_line_rec.global_attribute15 <>
p_old_line_rec.global_attribute15 OR
p_old_line_rec.global_attribute15 IS NULL ))
OR (p_x_line_rec.global_attribute16 IS NOT NULL AND
( p_x_line_rec.global_attribute16 <>
p_old_line_rec.global_attribute16 OR
p_old_line_rec.global_attribute16 IS NULL ))
OR (p_x_line_rec.global_attribute17 IS NOT NULL AND
( p_x_line_rec.global_attribute17 <>
p_old_line_rec.global_attribute17 OR
p_old_line_rec.global_attribute17 IS NULL ))
OR (p_x_line_rec.global_attribute18 IS NOT NULL AND
( p_x_line_rec.global_attribute18 <>
p_old_line_rec.global_attribute18 OR
p_old_line_rec.global_attribute18 IS NULL ))
OR (p_x_line_rec.global_attribute19 IS NOT NULL AND
( p_x_line_rec.global_attribute19 <>
p_old_line_rec.global_attribute19 OR
p_old_line_rec.global_attribute19 IS NULL ))
OR (p_x_line_rec.global_attribute2 IS NOT NULL AND
( p_x_line_rec.global_attribute2 <>
p_old_line_rec.global_attribute2 OR
p_old_line_rec.global_attribute2 IS NULL ))
OR (p_x_line_rec.global_attribute20 IS NOT NULL AND
( p_x_line_rec.global_attribute20 <>
p_old_line_rec.global_attribute20 OR
p_old_line_rec.global_attribute20 IS NULL ))
OR (p_x_line_rec.global_attribute3 IS NOT NULL AND
( p_x_line_rec.global_attribute3 <>
p_old_line_rec.global_attribute3 OR
p_old_line_rec.global_attribute3 IS NULL ))
OR (p_x_line_rec.global_attribute4 IS NOT NULL AND
( p_x_line_rec.global_attribute4 <>
p_old_line_rec.global_attribute4 OR
p_old_line_rec.global_attribute4 IS NULL ))
OR (p_x_line_rec.global_attribute5 IS NOT NULL AND
( p_x_line_rec.global_attribute5 <>
p_old_line_rec.global_attribute5 OR
p_old_line_rec.global_attribute5 IS NULL ))
OR (p_x_line_rec.global_attribute6 IS NOT NULL AND
( p_x_line_rec.global_attribute6 <>
p_old_line_rec.global_attribute6 OR
p_old_line_rec.global_attribute6 IS NULL ))
OR (p_x_line_rec.global_attribute7 IS NOT NULL AND
( p_x_line_rec.global_attribute7 <>
p_old_line_rec.global_attribute7 OR
p_old_line_rec.global_attribute7 IS NULL ))
OR (p_x_line_rec.global_attribute8 IS NOT NULL AND
( p_x_line_rec.global_attribute8 <>
p_old_line_rec.global_attribute8 OR
p_old_line_rec.global_attribute8 IS NULL ))
OR (p_x_line_rec.global_attribute9 IS NOT NULL AND
( p_x_line_rec.global_attribute9 <>
p_old_line_rec.global_attribute9 OR
p_old_line_rec.global_attribute9 IS NULL ))
OR (p_x_line_rec.global_attribute_category IS NOT NULL AND
( p_x_line_rec.global_attribute_category <>
p_old_line_rec.global_attribute_category OR
p_old_line_rec.global_attribute_category IS NULL )))
THEN
IF l_debug_level > 0 then
OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
( p_x_line_rec.operation = oe_globals.g_opr_update AND
(p_x_line_rec.industry_attribute1 IS NOT NULL AND
( p_x_line_rec.industry_attribute1 <>
p_old_line_rec.industry_attribute1 OR
p_old_line_rec.industry_attribute1 IS NULL ))
OR (p_x_line_rec.industry_attribute10 IS NOT NULL AND
( p_x_line_rec.industry_attribute10 <>
p_old_line_rec.industry_attribute10 OR
p_old_line_rec.industry_attribute10 IS NULL ))
OR (p_x_line_rec.industry_attribute11 IS NOT NULL AND
( p_x_line_rec.industry_attribute11 <>
p_old_line_rec.industry_attribute11 OR
p_old_line_rec.industry_attribute11 IS NULL ))
OR (p_x_line_rec.industry_attribute12 IS NOT NULL AND
( p_x_line_rec.industry_attribute12 <>
p_old_line_rec.industry_attribute12 OR
p_old_line_rec.industry_attribute12 IS NULL ))
OR (p_x_line_rec.industry_attribute13 IS NOT NULL AND
( p_x_line_rec.industry_attribute13 <>
p_old_line_rec.industry_attribute13 OR
p_old_line_rec.industry_attribute13 IS NULL ))
OR (p_x_line_rec.industry_attribute14 IS NOT NULL AND
( p_x_line_rec.industry_attribute14 <>
p_old_line_rec.industry_attribute14 OR
p_old_line_rec.industry_attribute14 IS NULL ))
OR (p_x_line_rec.industry_attribute15 IS NOT NULL AND
( p_x_line_rec.industry_attribute15 <>
p_old_line_rec.industry_attribute15 OR
p_old_line_rec.industry_attribute15 IS NULL ))
OR (p_x_line_rec.industry_attribute16 IS NOT NULL AND
( p_x_line_rec.industry_attribute16 <>
p_old_line_rec.industry_attribute16 OR
p_old_line_rec.industry_attribute16 IS NULL ))
OR (p_x_line_rec.industry_attribute17 IS NOT NULL AND
( p_x_line_rec.industry_attribute17 <>
p_old_line_rec.industry_attribute17 OR
p_old_line_rec.industry_attribute17 IS NULL ))
OR (p_x_line_rec.industry_attribute18 IS NOT NULL AND
( p_x_line_rec.industry_attribute18 <>
p_old_line_rec.industry_attribute18 OR
p_old_line_rec.industry_attribute18 IS NULL ))
OR (p_x_line_rec.industry_attribute19 IS NOT NULL AND
( p_x_line_rec.industry_attribute19 <>
p_old_line_rec.industry_attribute19 OR
p_old_line_rec.industry_attribute19 IS NULL ))
OR (p_x_line_rec.industry_attribute2 IS NOT NULL AND
( p_x_line_rec.industry_attribute2 <>
p_old_line_rec.industry_attribute2 OR
p_old_line_rec.industry_attribute2 IS NULL ))
OR (p_x_line_rec.industry_attribute20 IS NOT NULL AND
( p_x_line_rec.industry_attribute20 <>
p_old_line_rec.industry_attribute20 OR
p_old_line_rec.industry_attribute20 IS NULL ))
OR (p_x_line_rec.industry_attribute21 IS NOT NULL AND
( p_x_line_rec.industry_attribute21 <>
p_old_line_rec.industry_attribute21 OR
p_old_line_rec.industry_attribute21 IS NULL ))
OR (p_x_line_rec.industry_attribute22 IS NOT NULL AND
( p_x_line_rec.industry_attribute22 <>
p_old_line_rec.industry_attribute22 OR
p_old_line_rec.industry_attribute22 IS NULL ))
OR (p_x_line_rec.industry_attribute23 IS NOT NULL AND
( p_x_line_rec.industry_attribute23 <>
p_old_line_rec.industry_attribute23 OR
p_old_line_rec.industry_attribute23 IS NULL ))
OR (p_x_line_rec.industry_attribute24 IS NOT NULL AND
( p_x_line_rec.industry_attribute24 <>
p_old_line_rec.industry_attribute24 OR
p_old_line_rec.industry_attribute24 IS NULL ))
OR (p_x_line_rec.industry_attribute25 IS NOT NULL AND
( p_x_line_rec.industry_attribute25 <>
p_old_line_rec.industry_attribute25 OR
p_old_line_rec.industry_attribute25 IS NULL ))
OR (p_x_line_rec.industry_attribute26 IS NOT NULL AND
( p_x_line_rec.industry_attribute26 <>
p_old_line_rec.industry_attribute26 OR
p_old_line_rec.industry_attribute26 IS NULL ))
OR (p_x_line_rec.industry_attribute27 IS NOT NULL AND
( p_x_line_rec.industry_attribute27 <>
p_old_line_rec.industry_attribute27 OR
p_old_line_rec.industry_attribute27 IS NULL ))
OR (p_x_line_rec.industry_attribute28 IS NOT NULL AND
( p_x_line_rec.industry_attribute28 <>
p_old_line_rec.industry_attribute28 OR
p_old_line_rec.industry_attribute28 IS NULL ))
OR (p_x_line_rec.industry_attribute29 IS NOT NULL AND
( p_x_line_rec.industry_attribute29 <>
p_old_line_rec.industry_attribute29 OR
p_old_line_rec.industry_attribute29 IS NULL ))
OR (p_x_line_rec.industry_attribute3 IS NOT NULL AND
( p_x_line_rec.industry_attribute3 <>
p_old_line_rec.industry_attribute3 OR
p_old_line_rec.industry_attribute3 IS NULL ))
OR (p_x_line_rec.industry_attribute30 IS NOT NULL AND
( p_x_line_rec.industry_attribute30 <>
p_old_line_rec.industry_attribute30 OR
p_old_line_rec.industry_attribute30 IS NULL ))
OR (p_x_line_rec.industry_attribute4 IS NOT NULL AND
( p_x_line_rec.industry_attribute4 <>
p_old_line_rec.industry_attribute4 OR
p_old_line_rec.industry_attribute4 IS NULL ))
OR (p_x_line_rec.industry_attribute5 IS NOT NULL AND
( p_x_line_rec.industry_attribute5 <>
p_old_line_rec.industry_attribute5 OR
p_old_line_rec.industry_attribute5 IS NULL ))
OR (p_x_line_rec.industry_attribute6 IS NOT NULL AND
( p_x_line_rec.industry_attribute6 <>
p_old_line_rec.industry_attribute6 OR
p_old_line_rec.industry_attribute6 IS NULL ))
OR (p_x_line_rec.industry_attribute7 IS NOT NULL AND
( p_x_line_rec.industry_attribute7 <>
p_old_line_rec.industry_attribute7 OR
p_old_line_rec.industry_attribute7 IS NULL ))
OR (p_x_line_rec.industry_attribute8 IS NOT NULL AND
( p_x_line_rec.industry_attribute8 <>
p_old_line_rec.industry_attribute8 OR
p_old_line_rec.industry_attribute8 IS NULL ))
OR (p_x_line_rec.industry_attribute9 IS NOT NULL AND
( p_x_line_rec.industry_attribute9 <>
p_old_line_rec.industry_attribute9 OR
p_old_line_rec.industry_attribute9 IS NULL ))
OR (p_x_line_rec.industry_context IS NOT NULL AND
( p_x_line_rec.industry_context <>
p_old_line_rec.industry_context OR
p_old_line_rec.industry_context IS NULL )))
THEN
IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN
IF NOT OE_VALIDATE.I_Line_Desc_Flex
(p_context => p_x_line_rec.Industry_context
,p_attribute1 => p_x_line_rec.Industry_attribute1
,p_attribute2 => p_x_line_rec.Industry_attribute2
,p_attribute3 => p_x_line_rec.Industry_attribute3
,p_attribute4 => p_x_line_rec.Industry_attribute4
,p_attribute5 => p_x_line_rec.Industry_attribute5
,p_attribute6 => p_x_line_rec.Industry_attribute6
,p_attribute7 => p_x_line_rec.Industry_attribute7
,p_attribute8 => p_x_line_rec.Industry_attribute8
,p_attribute9 => p_x_line_rec.Industry_attribute9
,p_attribute10 => p_x_line_rec.Industry_attribute10
,p_attribute11 => p_x_line_rec.Industry_attribute11
,p_attribute12 => p_x_line_rec.Industry_attribute12
,p_attribute13 => p_x_line_rec.Industry_attribute13
,p_attribute14 => p_x_line_rec.Industry_attribute14
,p_attribute15 => p_x_line_rec.Industry_attribute15
,p_attribute16 => p_x_line_rec.Industry_attribute16
,p_attribute17 => p_x_line_rec.Industry_attribute17
,p_attribute18 => p_x_line_rec.Industry_attribute18
,p_attribute19 => p_x_line_rec.Industry_attribute19
,p_attribute20 => p_x_line_rec.Industry_attribute20
,p_attribute21 => p_x_line_rec.Industry_attribute21
,p_attribute22 => p_x_line_rec.Industry_attribute22
,p_attribute23 => p_x_line_rec.Industry_attribute23
,p_attribute24 => p_x_line_rec.Industry_attribute24
,p_attribute25 => p_x_line_rec.Industry_attribute25
,p_attribute26 => p_x_line_rec.Industry_attribute26
,p_attribute27 => p_x_line_rec.Industry_attribute27
,p_attribute28 => p_x_line_rec.Industry_attribute28
,p_attribute29 => p_x_line_rec.Industry_attribute29
,p_attribute30 => p_x_line_rec.Industry_attribute30) THEN
IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
p_x_line_rec.Industry_context := null;
( p_x_line_rec.operation = oe_globals.g_opr_update AND
(p_x_line_rec.tp_attribute1 IS NOT NULL AND
( p_x_line_rec.tp_attribute1 <>
p_old_line_rec.tp_attribute1 OR
p_old_line_rec.tp_attribute1 IS NULL ))
OR (p_x_line_rec.tp_attribute2 IS NOT NULL AND
( p_x_line_rec.tp_attribute2 <>
p_old_line_rec.tp_attribute2 OR
p_old_line_rec.tp_attribute2 IS NULL ))
OR (p_x_line_rec.tp_attribute3 IS NOT NULL AND
( p_x_line_rec.tp_attribute3 <>
p_old_line_rec.tp_attribute3 OR
p_old_line_rec.tp_attribute3 IS NULL ))
OR (p_x_line_rec.tp_attribute4 IS NOT NULL AND
( p_x_line_rec.tp_attribute4 <>
p_old_line_rec.tp_attribute4 OR
p_old_line_rec.tp_attribute4 IS NULL ))
OR (p_x_line_rec.tp_attribute5 IS NOT NULL AND
( p_x_line_rec.tp_attribute5 <>
p_old_line_rec.tp_attribute5 OR
p_old_line_rec.tp_attribute5 IS NULL ))
OR (p_x_line_rec.tp_attribute6 IS NOT NULL AND
( p_x_line_rec.tp_attribute6 <>
p_old_line_rec.tp_attribute6 OR
p_old_line_rec.tp_attribute6 IS NULL ))
OR (p_x_line_rec.tp_attribute7 IS NOT NULL AND
( p_x_line_rec.tp_attribute7 <>
p_old_line_rec.tp_attribute7 OR
p_old_line_rec.tp_attribute7 IS NULL ))
OR (p_x_line_rec.tp_attribute8 IS NOT NULL AND
( p_x_line_rec.tp_attribute8 <>
p_old_line_rec.tp_attribute8 OR
p_old_line_rec.tp_attribute8 IS NULL ))
OR (p_x_line_rec.tp_attribute9 IS NOT NULL AND
( p_x_line_rec.tp_attribute9 <>
p_old_line_rec.tp_attribute9 OR
p_old_line_rec.tp_attribute9 IS NULL ))
OR (p_x_line_rec.tp_attribute10 IS NOT NULL AND
( p_x_line_rec.tp_attribute10 <>
p_old_line_rec.tp_attribute10 OR
p_old_line_rec.tp_attribute10 IS NULL ))
OR (p_x_line_rec.tp_attribute11 IS NOT NULL AND
( p_x_line_rec.tp_attribute11 <>
p_old_line_rec.tp_attribute11 OR
p_old_line_rec.tp_attribute11 IS NULL ))
OR (p_x_line_rec.tp_attribute12 IS NOT NULL AND
( p_x_line_rec.tp_attribute12 <>
p_old_line_rec.tp_attribute12 OR
p_old_line_rec.tp_attribute12 IS NULL ))
OR (p_x_line_rec.tp_attribute13 IS NOT NULL AND
( p_x_line_rec.tp_attribute13 <>
p_old_line_rec.tp_attribute13 OR
p_old_line_rec.tp_attribute13 IS NULL ))
OR (p_x_line_rec.tp_attribute14 IS NOT NULL AND
( p_x_line_rec.tp_attribute14 <>
p_old_line_rec.tp_attribute14 OR
p_old_line_rec.tp_attribute14 IS NULL ))
OR (p_x_line_rec.tp_attribute15 IS NOT NULL AND
( p_x_line_rec.tp_attribute15 <>
p_old_line_rec.tp_attribute15 OR
p_old_line_rec.tp_attribute15 IS NULL )))
THEN
IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN
IF NOT OE_VALIDATE.TP_Line_Desc_Flex
(p_context => p_x_line_rec.tp_context
,p_attribute1 => p_x_line_rec.tp_attribute1
,p_attribute2 => p_x_line_rec.tp_attribute2
,p_attribute3 => p_x_line_rec.tp_attribute3
,p_attribute4 => p_x_line_rec.tp_attribute4
,p_attribute5 => p_x_line_rec.tp_attribute5
,p_attribute6 => p_x_line_rec.tp_attribute6
,p_attribute7 => p_x_line_rec.tp_attribute7
,p_attribute8 => p_x_line_rec.tp_attribute8
,p_attribute9 => p_x_line_rec.tp_attribute9
,p_attribute10 => p_x_line_rec.tp_attribute10
,p_attribute11 => p_x_line_rec.tp_attribute11
,p_attribute12 => p_x_line_rec.tp_attribute12
,p_attribute13 => p_x_line_rec.tp_attribute13
,p_attribute14 => p_x_line_rec.tp_attribute14
,p_attribute15 => p_x_line_rec.tp_attribute15) THEN
IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
p_x_line_rec.tp_context := null;
( p_x_line_rec.operation = oe_globals.g_opr_update AND
p_x_line_rec.line_category_code = 'RETURN' AND -- added for bug 2750455
((p_x_line_rec.return_attribute1 IS NOT NULL AND -- additional pair of braces added for 2750455
( p_x_line_rec.return_attribute1 <>
p_old_line_rec.return_attribute1 OR
p_old_line_rec.return_attribute1 IS NULL ))
OR (p_x_line_rec.return_attribute2 IS NOT NULL AND
( p_x_line_rec.return_attribute2 <>
p_old_line_rec.return_attribute2 OR
p_old_line_rec.return_attribute2 IS NULL ))
OR (p_x_line_rec.return_context IS NOT NULL AND
( p_x_line_rec.return_context <>
p_old_line_rec.return_context OR
p_old_line_rec.return_context IS NULL ))))
THEN
IF l_debug_level > 0 then
oe_debug_pub.add('Before calling Return line_desc_flex',2);
PROCEDURE Entity_Delete
( x_return_status OUT NOCOPY VARCHAR2
, p_line_rec IN OE_Order_PUB.Line_Rec_Type
)
IS
l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Oe_debug_pub.ADD('Entering Oe_validate_line.entity_delete for line ID : ' || p_line_rec.line_id);
OE_GLOBALS.G_OPR_DELETE)
THEN
-- Message is populated in the function
l_return_status := FND_API.G_RET_STS_ERROR;
oe_debug_pub.add('Leaving Oe_validate_line.entity_delete with status : '||l_return_status, 1);
, 'Entity_Delete'
);
END Entity_Delete;