APPS.FND_DESCR_FLEX_COL_USAGE_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 36: cursor C is select ROWID from FND_DESCR_FLEX_COLUMN_USAGES

32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: l_application_column_name VARCHAR2(30);
35:
36: cursor C is select ROWID from FND_DESCR_FLEX_COLUMN_USAGES
37: where APPLICATION_ID = X_APPLICATION_ID
38: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
39: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
40: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 46: insert into FND_DESCR_FLEX_COLUMN_USAGES (

42:
43: begin
44: /* Bug 1732116 - Remove row level delete of report parameters from here. */
45:
46: insert into FND_DESCR_FLEX_COLUMN_USAGES (
47: APPLICATION_ID,
48: DESCRIPTIVE_FLEXFIELD_NAME,
49: DESCRIPTIVE_FLEX_CONTEXT_CODE,
50: APPLICATION_COLUMN_NAME,

Line 189: from FND_DESCR_FLEX_COLUMN_USAGES

185: DEFAULT_TYPE,
186: DEFAULT_VALUE,
187: RUNTIME_PROPERTY_FUNCTION,
188: SRW_PARAM
189: from FND_DESCR_FLEX_COLUMN_USAGES
190: where APPLICATION_ID = X_APPLICATION_ID
191: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
192: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
193: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME

Line 291: update FND_DESCR_FLEX_COLUMN_USAGES set

287: X_LAST_UPDATED_BY in NUMBER,
288: X_LAST_UPDATE_LOGIN in NUMBER
289: ) is
290: begin
291: update FND_DESCR_FLEX_COLUMN_USAGES set
292: END_USER_COLUMN_NAME = X_END_USER_COLUMN_NAME,
293: COLUMN_SEQ_NUM = X_COLUMN_SEQ_NUM,
294: ENABLED_FLAG = X_ENABLED_FLAG,
295: REQUIRED_FLAG = X_REQUIRED_FLAG,

Line 355: delete from FND_DESCR_FLEX_COLUMN_USAGES

351: if (sql%notfound) then
352: raise no_data_found;
353: end if;
354:
355: delete from FND_DESCR_FLEX_COLUMN_USAGES
356: where APPLICATION_ID = X_APPLICATION_ID
357: and DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
358: and DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD
359: and APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;

Line 378: from FND_DESCR_FLEX_COLUMN_USAGES B

374: /*
375: delete from FND_DESCR_FLEX_COL_USAGE_TL T
376: where not exists
377: (select NULL
378: from FND_DESCR_FLEX_COLUMN_USAGES B
379: where B.APPLICATION_ID = T.APPLICATION_ID
380: and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
381: and B.DESCRIPTIVE_FLEX_CONTEXT_CODE = T.DESCRIPTIVE_FLEX_CONTEXT_CODE
382: and B.APPLICATION_COLUMN_NAME = T.APPLICATION_COLUMN_NAME