DBA Data[Home] [Help]

APPS.BOM_ALT_DESIGS_POLICY dependencies on DBMS_RLS

Line 67: DBMS_RLS.ADD_POLICY(OBJECT_SCHEMA => l_Prod_Schema, -- We will add the policy to the BOM schema

63: FOR pprec IN prod_policy LOOP
64: RETURN;
65: END LOOP;
66:
67: DBMS_RLS.ADD_POLICY(OBJECT_SCHEMA => l_Prod_Schema, -- We will add the policy to the BOM schema
68: OBJECT_NAME => 'BOM_ALTERNATE_DESIGNATORS',
69: POLICY_NAME => 'STRUCT_TYPE_ALTS',
70: --FUNCTION_SCHEMA => 'APPS',
71: POLICY_FUNCTION => 'Bom_alt_desigs_policy.get_alt_predicate',

Line 89: DBMS_RLS.DROP_POLICY(--OBJECT_SCHEMA => l_Prod_Schema, -- We will drop the policy from the universal schema

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: BEGIN
89: DBMS_RLS.DROP_POLICY(--OBJECT_SCHEMA => l_Prod_Schema, -- We will drop the policy from the universal schema
90: OBJECT_NAME => 'BOM_ALTERNATE_DESIGNATORS',
91: POLICY_NAME => 'STRUCT_TYPE_ALTS');
92: EXCEPTION
93: WHEN OTHERS THEN

Line 96: DBMS_RLS.DROP_POLICY(OBJECT_SCHEMA => l_Prod_Schema, -- We will drop the policy from the BOM schema

92: EXCEPTION
93: WHEN OTHERS THEN
94: NULL;
95: END;
96: DBMS_RLS.DROP_POLICY(OBJECT_SCHEMA => l_Prod_Schema, -- We will drop the policy from the BOM schema
97: OBJECT_NAME => 'BOM_ALTERNATE_DESIGNATORS',
98: POLICY_NAME => 'STRUCT_TYPE_ALTS');
99: EXCEPTION
100: WHEN OTHERS THEN