APPS.CN_SYS_TABLES_PVT dependencies on CN_OBJ_COLUMNS_V

Line 517: DELETE FROM cn_obj_columns_v

513: --no table handler exists
514: --add delete table handler later
515:
516: --first delete all columns
517: DELETE FROM cn_obj_columns_v
518: WHERE table_id = p_table_rec.object_id;
519:
520: --then delete the table itself
521: DELETE FROM cn_obj_tables_v

Line 623: FROM cn_obj_columns_v cocv, cn_obj_tables_v cotv

619: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
620:
621: CURSOR l_table_csr IS
622: SELECT cotv.table_id, cotv.name
623: FROM cn_obj_columns_v cocv, cn_obj_tables_v cotv
624: WHERE cocv.column_id= p_column_rec.object_id
625: AND cocv.table_id = cotv.table_id
626: AND cocv.org_id=p_column_rec.org_id AND
627: cocv.org_id=cotv.org_id;

Line 631: FROM cn_obj_columns_v

627: cocv.org_id=cotv.org_id;
628:
629: CURSOR l_dim_value_csr IS
630: SELECT count(user_column_name)
631: FROM cn_obj_columns_v
632: WHERE table_id = l_table_id
633: AND user_column_name = 'Y'
634: AND org_id=p_column_rec.org_id
635: AND column_id <> p_column_rec.object_id;

Line 746: UPDATE cn_obj_columns_v

742: end if;
743:
744:
745: -- we are ok now proceed with update.
746: UPDATE cn_obj_columns_v
747: SET calc_formula_flag = p_column_rec.usage,
748: user_name = p_column_rec.user_name,
749: foreign_key = p_column_rec.foreign_key,
750: dimension_id = p_column_rec.dimension_id,

Line 1095: FROM cn_obj_columns_v

1091: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1092:
1093: CURSOR l_delete_csr ( p_column_id number ) IS
1094: SELECT table_id
1095: FROM cn_obj_columns_v
1096: WHERE column_id = p_column_id
1097: AND object_type = 'COL';
1098:
1099: BEGIN

Line 1128: DELETE FROM cn_obj_columns_v

1124: fnd_msg_pub.ADD;
1125: RAISE fnd_api.g_exc_error;
1126: end if;
1127:
1128: DELETE FROM cn_obj_columns_v
1129: WHERE column_id = p_column_id
1130: AND object_type = 'COL';
1131:
1132: -- End of API body.