APPS.IMC_THREE_SIXTY_COLS_PKG dependencies on IMC_THREE_SIXTY_COLS_B

Line 38: insert into IMC_THREE_SIXTY_COLS_B (

34: end if;
35: CLOSE C2;
36: end if;
37:
38: insert into IMC_THREE_SIXTY_COLS_B (
39: COLUMN_ID,
40: QUERY_ID,
41: FILTER_QUERY_ID,
42: COLUMN_NAME,

Line 142: from IMC_THREE_SIXTY_COLS_B

138: SORT_FLAG,
139: SECURITY_FUNCTION,
140: SEQ_NO,
141: OBJECT_VERSION_NUMBER
142: from IMC_THREE_SIXTY_COLS_B
143: where COLUMN_ID = X_COLUMN_ID
144: for update of COLUMN_ID nowait;
145: recinfo c%rowtype;
146:

Line 221: update IMC_THREE_SIXTY_COLS_B set

217: X_LAST_UPDATED_BY in NUMBER,
218: X_LAST_UPDATE_LOGIN in NUMBER
219: ) is
220: begin
221: update IMC_THREE_SIXTY_COLS_B set
222: QUERY_ID = X_QUERY_ID,
223: FILTER_QUERY_ID = X_FILTER_QUERY_ID,
224: COLUMN_NAME = X_COLUMN_NAME,
225: COLUMN_DATA_TYPE = X_COLUMN_DATA_TYPE,

Line 269: delete from IMC_THREE_SIXTY_COLS_B

265: if (sql%notfound) then
266: raise no_data_found;
267: end if;
268:
269: delete from IMC_THREE_SIXTY_COLS_B
270: where COLUMN_ID = X_COLUMN_ID;
271:
272: if (sql%notfound) then
273: raise no_data_found;

Line 283: from IMC_THREE_SIXTY_COLS_B B

279: begin
280: delete from IMC_THREE_SIXTY_COLS_TL T
281: where not exists
282: (select NULL
283: from IMC_THREE_SIXTY_COLS_B B
284: where B.COLUMN_ID = T.COLUMN_ID
285: );
286:
287: update IMC_THREE_SIXTY_COLS_TL T set (