DBA Data[Home] [Help]

APPS.WSH_DOCUMENT_SETS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;

129: l_status Varchar2(100);
130: l_error_message Varchar2(4000); -- bug 2548069 (frontported): resolve ORA-6502
131:
132: l_arg_value VARCHAR2(240);
133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;

Line 134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;

130: l_error_message Varchar2(4000); -- bug 2548069 (frontported): resolve ORA-6502
131:
132: l_arg_value VARCHAR2(240);
133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
138: l_parameter_name VARCHAR2(32767);

Line 135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;

131:
132: l_arg_value VARCHAR2(240);
133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
138: l_parameter_name VARCHAR2(32767);
139:

Line 136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;

132: l_arg_value VARCHAR2(240);
133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
138: l_parameter_name VARCHAR2(32767);
139:
140: No_Org_For_Entity EXCEPTION;

Line 137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;

133: l_arg_name fnd_descr_flex_column_usages.end_user_column_name%type;
134: l_arg_required_flag fnd_descr_flex_column_usages.required_flag%type;
135: l_arg_default_value fnd_descr_flex_column_usages.default_value%type;
136: l_arg_default_type fnd_descr_flex_column_usages.default_type%type;
137: l_arg_value_set_id fnd_descr_flex_column_usages.flex_value_set_id%type;
138: l_parameter_name VARCHAR2(32767);
139:
140: No_Org_For_Entity EXCEPTION;
141:

Line 333: fnd_descr_flex_column_usages

329: flex_value_set_id,
330: lower(decode(l_execution_method_code, 'P', srw_param,'K',srw_param, end_user_column_name)) parameter_name
331: --Bug 6766880 added l_execution_method_code K
332: FROM
333: fnd_descr_flex_column_usages
334: WHERE application_id = l_application_id
335: AND descriptive_flexfield_name = '$SRS$.'||l_concurrent_program_name
336: AND enabled_flag = 'Y'
337: ORDER BY