DBA Data[Home] [Help]

APPS.BIS_SUBMIT_REQUESTSET dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 20: from fnd_descr_flex_column_usages

16: select 'Y'
17: from dual
18: where exists
19: (select descriptive_flexfield_name
20: from fnd_descr_flex_column_usages
21: where application_id=p_app_id
22: and descriptive_flex_context_code = 'Global Data Elements'
23: and descriptive_flexfield_name='$SRS$.'||p_program_name
24: and enabled_flag='Y'

Line 47: sqlstmt:='update fnd_descr_flex_column_usages '||

43: sqlstmt varchar2(2000);
44: begin
45: /** comment out the code because this procedure logic will not
46: be used in current RSG
47: sqlstmt:='update fnd_descr_flex_column_usages '||
48: 'set default_value=null '||
49: 'where application_id='||p_app_id||
50: ' and descriptive_flexfield_name='||'''$SRS$.'||p_program_name||''''||
51: ' and default_value is not null '||