APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_PC_CONSTRAINTS

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_PC_Constraints_Admin_Pvt';

2: /* $Header: OEXPPCHB.pls 120.27.12020000.7 2013/04/25 11:53:20 sujithku ship $ */
3:
4: -- START 8547934
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_PC_Constraints_Admin_Pvt';
7:
8: FUNCTION Inventory_Item
9: ( p_inventory_item_id IN NUMBER,
10: p_org_id IN NUMBER DEFAULT NULL)

Line 418: FROM OE_PC_CONSTRAINTS OEP

414: WHERE OEV.ENTITY_ID = ent_id
415: AND OEV.APPLICATION_ID = 660
416: AND OEV.CONSTRAINTS_ENABLED_FLAG = 'Y'
417: AND EXISTS ( SELECT 'CONSTRAINT EXISTS FOR THIS COLUMN'
418: FROM OE_PC_CONSTRAINTS OEP
419: WHERE OEP.COLUMN_NAME = OEV.COLUMN_NAME
420: --14797876 start
421: --AND OEP.ON_OPERATION_ACTION IN (1,2)
422: AND OEP.ON_OPERATION_ACTION IN (1,2,0.5)

Line 431: FROM OE_PC_CONSTRAINTS

427:
428: /* Check Whether the entity is constrained for update */
429: CURSOR IS_ENTITY_CONSTRAINED (v_ent_id NUMBER) IS
430: SELECT 'Y' -- There is an entity level constraint'
431: FROM OE_PC_CONSTRAINTS
432: WHERE ENTITY_ID = v_ent_id
433: AND COLUMN_NAME IS NULL
434: AND ON_OPERATION_ACTION IN (1,2)
435: AND CONSTRAINED_OPERATION <> 'X';