APPS.AP_WEB_AUDIT_UTILS dependencies on FND_DFLEX

Line 805: flexfield fnd_dflex.dflex_r;

801:
802: v_result VARCHAR2(4000);
803: v_value VARCHAR2(4000);
804: template_rec template_cur%ROWTYPE;
805: flexfield fnd_dflex.dflex_r;
806: flexinfo fnd_dflex.dflex_dr;
807: contexts fnd_dflex.contexts_dr;
808: i BINARY_INTEGER;
809: segments fnd_dflex.segments_dr;

Line 806: flexinfo fnd_dflex.dflex_dr;

802: v_result VARCHAR2(4000);
803: v_value VARCHAR2(4000);
804: template_rec template_cur%ROWTYPE;
805: flexfield fnd_dflex.dflex_r;
806: flexinfo fnd_dflex.dflex_dr;
807: contexts fnd_dflex.contexts_dr;
808: i BINARY_INTEGER;
809: segments fnd_dflex.segments_dr;
810: first_component boolean := TRUE;

Line 807: contexts fnd_dflex.contexts_dr;

803: v_value VARCHAR2(4000);
804: template_rec template_cur%ROWTYPE;
805: flexfield fnd_dflex.dflex_r;
806: flexinfo fnd_dflex.dflex_dr;
807: contexts fnd_dflex.contexts_dr;
808: i BINARY_INTEGER;
809: segments fnd_dflex.segments_dr;
810: first_component boolean := TRUE;
811:

Line 809: segments fnd_dflex.segments_dr;

805: flexfield fnd_dflex.dflex_r;
806: flexinfo fnd_dflex.dflex_dr;
807: contexts fnd_dflex.contexts_dr;
808: i BINARY_INTEGER;
809: segments fnd_dflex.segments_dr;
810: first_component boolean := TRUE;
811:
812: BEGIN
813: IF p_report_header_id is null OR p_distribution_line_number is null THEN

Line 817: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);

813: IF p_report_header_id is null OR p_distribution_line_number is null THEN
814: return null;
815: END IF;
816:
817: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
818: fnd_dflex.get_contexts(flexfield, contexts);
819:
820: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
821:

Line 818: fnd_dflex.get_contexts(flexfield, contexts);

814: return null;
815: END IF;
816:
817: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
818: fnd_dflex.get_contexts(flexfield, contexts);
819:
820: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
821:
822: FOR i IN 1 .. segments.nsegments LOOP

Line 820: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);

816:
817: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
818: fnd_dflex.get_contexts(flexfield, contexts);
819:
820: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
821:
822: FOR i IN 1 .. segments.nsegments LOOP
823:
824: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));

Line 852: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, SUBSTRB(template_rec.web_prompt,0,30)),segments,TRUE);

848:
849: /* Doing substrb since OIE uses expense type name as the context value. However the context value code
850: * definition only accepts 30 characters, but the expense type name can be 80. This was discussed with
851: * OIE team and their suggested resolution was to substr the value. */
852: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, SUBSTRB(template_rec.web_prompt,0,30)),segments,TRUE);
853:
854:
855: FOR i IN 1 .. segments.nsegments LOOP
856: