DBA Data[Home] [Help]

APPS.FND_CONCURRENT_ARGUMENTS_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 36: CURSOR C IS SELECT rowid FROM fnd_descr_flex_column_usages

32: X_FORM_ABOVE_PROMPT in VARCHAR2,
33: X_DESCRIPTION in VARCHAR2
34: ) IS
35: LANG VARCHAR2(30);
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 43: INSERT INTO fnd_descr_flex_column_usages(

39: AND descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD
40: AND application_column_name = X_APPLICATION_COLUMN_NAME;
41: BEGIN
42:
43: INSERT INTO fnd_descr_flex_column_usages(
44: application_id,
45: descriptive_flexfield_name,
46: descriptive_flex_context_code,
47: application_column_name,

Line 196: FROM fnd_descr_flex_column_usages

192: range_code,
193: default_type,
194: default_value,
195: srw_param
196: FROM fnd_descr_flex_column_usages
197: WHERE APPLICATION_ID = X_APPLICATION_ID AND
198: DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME AND
199: descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD AND
200: application_column_name = X_APPLICATION_COLUMN_NAME

Line 334: UPDATE fnd_descr_flex_column_usages

330: X_DESCRIPTION in VARCHAR2
331: ) IS
332: BEGIN
333:
334: UPDATE fnd_descr_flex_column_usages
335: SET
336: application_id = X_APPLICATION_ID,
337: descriptive_flexfield_name = X_DESCRIPTIVE_FLEXFIELD_NAME,
338: descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD,

Line 399: DELETE FROM fnd_descr_flex_column_usages

395: X_DESCRIPTIVE_FLEX_CONTEXT_COD in VARCHAR2,
396: X_APPLICATION_COLUMN_NAME in VARCHAR2
397: ) IS
398: BEGIN
399: DELETE FROM fnd_descr_flex_column_usages
400: WHERE APPLICATION_ID = X_APPLICATION_ID AND
401: DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME AND
402: DESCRIPTIVE_FLEX_CONTEXT_CODE = X_DESCRIPTIVE_FLEX_CONTEXT_COD AND
403: APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME;