DBA Data[Home] [Help]

APPS.CN_DIMENSIONS_PKG dependencies on CN_OBJECTS

Line 177: -- clean up cn_objects and remove pointers to non-existent dimension ID

173: -- get environment org ID
174: select X_ORG_ID
175: into l_env_org_id from dual;
176:
177: -- clean up cn_objects and remove pointers to non-existent dimension ID
178: select source_table_id into l_table_id
179: from cn_dimensions where dimension_id = X_DIMENSION_ID
180: --R12 MOAC Changes--Start
181: and org_id = X_ORG_ID;

Line 184: update cn_objects set dimension_id = null,

180: --R12 MOAC Changes--Start
181: and org_id = X_ORG_ID;
182: --R12 MOAC Changes--End
183:
184: update cn_objects set dimension_id = null,
185: primary_key = null, user_column_name = null
186: where table_id = l_table_id
187: --R12 MOAC Changes--Start
188: and org_id = X_ORG_ID;