DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on INV_ITEM_EVENTS_PVT

Line 521: Calling INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs with p_dml_type => 'DELETE', when l_status_code = 'Inactive', l_purch_enbl='N' AND l_int_ordr_enbl='N'

517: AND effective_date <= SYSDATE
518: AND pending_flag = 'Y';
519:
520: /*Start Bug#7454766
521: Calling INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs with p_dml_type => 'DELETE', when l_status_code = 'Inactive', l_purch_enbl='N' AND l_int_ordr_enbl='N'
522: */
523: OPEN c_get_values_from_msib(p_item_id, p_org_id);
524: FETCH c_get_values_from_msib
525: INTO l_status_code, l_purch_enbl, l_int_ordr_enbl;

Line 531: INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs(

527:
528:
529: -- fix bug 14473049 - incips update item statuses with pending statuses item not searchable in iproc
530: if(l_status_code <> 'Inactive') THEN
531: INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs(
532: p_entity_type => 'ITEM'
533: ,p_dml_type => 'UPDATE'
534: ,p_inventory_item_id => p_Item_Id
535: ,p_organization_id => p_org_id

Line 543: INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs(

539: /*if(l_status_code = 'Inactive') THEN*/ /*bug 13493707, and base bug is 9705250*/
540:
541: if (l_purch_enbl='N' AND l_int_ordr_enbl='N') THEN
542:
543: INV_ITEM_EVENTS_PVT.Invoke_ICX_APIs(
544: p_entity_type => 'ITEM'
545: ,p_dml_type => 'DELETE'
546: ,p_inventory_item_id => p_Item_Id
547: ,p_organization_id => p_org_id);