APPS.WIP_EAM_WORKREQUEST_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 541: attribute_name IN fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE ,

537: -- To find the DFF attribute's user defined prompt name.
538: FUNCTION dff_prompt_name (
539: appl_short_name IN fnd_application.application_short_name%TYPE,
540: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
541: attribute_name IN fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE ,
542: attribute_category IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE := 'Global Data Elements')
543: RETURN fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE IS
544:
545: flexfield fnd_dflex.dflex_r;

Line 543: RETURN fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE IS

539: appl_short_name IN fnd_application.application_short_name%TYPE,
540: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
541: attribute_name IN fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE ,
542: attribute_category IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE := 'Global Data Elements')
543: RETURN fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE IS
544:
545: flexfield fnd_dflex.dflex_r;
546: flexinfo fnd_dflex.dflex_dr;
547: context fnd_dflex.context_r;

Line 549: l_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;

545: flexfield fnd_dflex.dflex_r;
546: flexinfo fnd_dflex.dflex_dr;
547: context fnd_dflex.context_r;
548: segments fnd_dflex.segments_dr;
549: l_prompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
550: l_i number;
551:
552: BEGIN
553:

Line 705: l_dffprompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;

701: l_old_maintenance_object_id NUMBER;
702: l_counter NUMBER;
703: l_extended_log_flag VARCHAR2(1);
704: l_work_request_auto_approve VARCHAR2(1);
705: l_dffprompt fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE;
706: l_stmt_num NUMBER;
707: l_results_out VARCHAR2(200);
708: l_error_message VARCHAR2(200);
709: WF_ERROR EXCEPTION;