APPS.CSC_PROF_TABLE_COLUMNS_PKG dependencies on CSC_PROF_TABLE_COLUMNS_B

Line 57: INSERT INTO CSC_PROF_TABLE_COLUMNS_B(

53: OPEN C2;
54: FETCH C2 INTO px_TABLE_COLUMN_ID;
55: CLOSE C2;
56: End If;
57: INSERT INTO CSC_PROF_TABLE_COLUMNS_B(
58: TABLE_COLUMN_ID,
59: BLOCK_ID,
60: TABLE_NAME,
61: COLUMN_NAME,

Line 140: Update CSC_PROF_TABLE_COLUMNS_B

136:
137: IS
138: BEGIN
139:
140: Update CSC_PROF_TABLE_COLUMNS_B
141: SET
142: BLOCK_ID = decode( p_BLOCK_ID, CSC_CORE_UTILS_PVT.G_MISS_NUM, BLOCK_ID, p_BLOCK_ID),
143: TABLE_NAME = decode( p_TABLE_NAME, CSC_CORE_UTILS_PVT.G_MISS_CHAR, TABLE_NAME, p_TABLE_NAME),
144: COLUMN_NAME = decode( p_COLUMN_NAME, CSC_CORE_UTILS_PVT.G_MISS_CHAR, COLUMN_NAME, p_COLUMN_NAME),

Line 183: from CSC_PROF_TABLE_COLUMNS_B

179: ALIAS_NAME,
180: COLUMN_NAME,
181: COLUMN_SEQUENCE,
182: OBJECT_VERSION_NUMBER
183: from CSC_PROF_TABLE_COLUMNS_B
184: where TABLE_COLUMN_ID = P_TABLE_COLUMN_ID
185: and object_version_number = p_object_version_number
186: for update of TABLE_COLUMN_ID nowait;
187: recinfo c%rowtype;

Line 220: delete from CSC_PROF_TABLE_COLUMNS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from CSC_PROF_TABLE_COLUMNS_B
221: where TABLE_COLUMN_ID = P_TABLE_COLUMN_ID
222: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;
223:
224: if (sql%notfound) then

Line 235: WHERE TABLE_COLUMN_ID IN (SELECT TABLE_COLUMN_ID FROM CSC_PROF_TABLE_COLUMNS_B

231: p_TABLE_NAME VARCHAR2,
232: p_COLUMN_NAME VARCHAR2) IS
233: Begin
234: DELETE FROM CSC_PROF_TABLE_COLUMNS_TL
235: WHERE TABLE_COLUMN_ID IN (SELECT TABLE_COLUMN_ID FROM CSC_PROF_TABLE_COLUMNS_B
236: WHERE BLOCK_ID = p_BLOCK_ID
237: AND TABLE_NAME = p_TABLE_NAME
238: AND COLUMN_NAME = p_COLUMN_NAME);
239: IF (SQL%FOUND) THEN

Line 240: DELETE FROM CSC_PROF_TABLE_COLUMNS_B

236: WHERE BLOCK_ID = p_BLOCK_ID
237: AND TABLE_NAME = p_TABLE_NAME
238: AND COLUMN_NAME = p_COLUMN_NAME);
239: IF (SQL%FOUND) THEN
240: DELETE FROM CSC_PROF_TABLE_COLUMNS_B
241: WHERE BLOCK_ID = p_BLOCK_ID
242: AND TABLE_NAME = p_TABLE_NAME
243: AND COLUMN_NAME = p_COLUMN_NAME ;
244: END IF;

Line 253: from CSC_PROF_TABLE_COLUMNS_B B

249: begin
250: delete from CSC_PROF_TABLE_COLUMNS_TL T
251: where not exists
252: (select NULL
253: from CSC_PROF_TABLE_COLUMNS_B B
254: where B.TABLE_COLUMN_ID = T.TABLE_COLUMN_ID
255: );
256:
257: update CSC_PROF_TABLE_COLUMNS_TL T set (