APPS.AP_WEB_AUDIT_UTILS dependencies on FND_DFLEX

Line 766: flexfield fnd_dflex.dflex_r;

762:
763: v_result VARCHAR2(4000);
764: v_value VARCHAR2(4000);
765: template_rec template_cur%ROWTYPE;
766: flexfield fnd_dflex.dflex_r;
767: flexinfo fnd_dflex.dflex_dr;
768: contexts fnd_dflex.contexts_dr;
769: i BINARY_INTEGER;
770: segments fnd_dflex.segments_dr;

Line 767: flexinfo fnd_dflex.dflex_dr;

763: v_result VARCHAR2(4000);
764: v_value VARCHAR2(4000);
765: template_rec template_cur%ROWTYPE;
766: flexfield fnd_dflex.dflex_r;
767: flexinfo fnd_dflex.dflex_dr;
768: contexts fnd_dflex.contexts_dr;
769: i BINARY_INTEGER;
770: segments fnd_dflex.segments_dr;
771: first_component boolean := TRUE;

Line 768: contexts fnd_dflex.contexts_dr;

764: v_value VARCHAR2(4000);
765: template_rec template_cur%ROWTYPE;
766: flexfield fnd_dflex.dflex_r;
767: flexinfo fnd_dflex.dflex_dr;
768: contexts fnd_dflex.contexts_dr;
769: i BINARY_INTEGER;
770: segments fnd_dflex.segments_dr;
771: first_component boolean := TRUE;
772:

Line 770: segments fnd_dflex.segments_dr;

766: flexfield fnd_dflex.dflex_r;
767: flexinfo fnd_dflex.dflex_dr;
768: contexts fnd_dflex.contexts_dr;
769: i BINARY_INTEGER;
770: segments fnd_dflex.segments_dr;
771: first_component boolean := TRUE;
772:
773: BEGIN
774: IF p_report_header_id is null OR p_distribution_line_number is null THEN

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

774: IF p_report_header_id is null OR p_distribution_line_number is null THEN
775: return null;
776: END IF;
777:
778: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
779: fnd_dflex.get_contexts(flexfield, contexts);
780:
781: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
782:

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

775: return null;
776: END IF;
777:
778: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
779: fnd_dflex.get_contexts(flexfield, contexts);
780:
781: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
782:
783: FOR i IN 1 .. segments.nsegments LOOP

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

777:
778: fnd_dflex.get_flexfield('SQLAP', 'AP_EXPENSE_REPORT_LINES', flexfield, flexinfo);
779: fnd_dflex.get_contexts(flexfield, contexts);
780:
781: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
782:
783: FOR i IN 1 .. segments.nsegments LOOP
784:
785: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));

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

809:
810: /* Doing substrb since OIE uses expense type name as the context value. However the context value code
811: * definition only accepts 30 characters, but the expense type name can be 80. This was discussed with
812: * OIE team and their suggested resolution was to substr the value. */
813: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, SUBSTRB(template_rec.web_prompt,0,30)),segments,TRUE);
814:
815:
816: FOR i IN 1 .. segments.nsegments LOOP
817: