DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_SETS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;

142: l_status Varchar2(100);
143: l_error_message Varchar2(4000); -- bug 2548069 (frontported): resolve ORA-6502
144:
145: l_arg_value VARCHAR2(240);
146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;

Line 147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;

143: l_error_message Varchar2(4000); -- bug 2548069 (frontported): resolve ORA-6502
144:
145: l_arg_value VARCHAR2(240);
146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
151: l_parameter_name VARCHAR2(32767);

Line 148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;

144:
145: l_arg_value VARCHAR2(240);
146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
151: l_parameter_name VARCHAR2(32767);
152:

Line 149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;

145: l_arg_value VARCHAR2(240);
146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
151: l_parameter_name VARCHAR2(32767);
152:
153: No_Org_For_Entity EXCEPTION;

Line 150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;

146: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
147: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
148: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
149: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
150: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
151: l_parameter_name VARCHAR2(32767);
152:
153: No_Org_For_Entity EXCEPTION;
154:

Line 346: fnd_descr_flex_column_usages

342: flex_value_set_id,
343: lower(decode(l_execution_method_code, 'P', srw_param,'K',srw_param, end_user_column_name)) parameter_name
344: --Bug 6766880 added l_execution_method_code K
345: FROM
346: fnd_descr_flex_column_usages
347: WHERE application_id = l_application_id
348: AND descriptive_flexfield_name = '$SRS$.'||l_concurrent_program_name
349: AND enabled_flag = 'Y'
350: ORDER BY