APPS.CN_SYS_TABLES_PVT dependencies on CN_OBJ_COLUMNS_V

Line 518: DELETE FROM cn_obj_columns_v

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

Line 624: FROM cn_obj_columns_v cocv, cn_obj_tables_v cotv

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

Line 632: FROM cn_obj_columns_v

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

Line 747: UPDATE cn_obj_columns_v

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

Line 1098: FROM cn_obj_columns_v

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

Line 1131: DELETE FROM cn_obj_columns_v

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