[Home] [Help]
2855: p_attribute18 IN OUT NOCOPY VARCHAR2,
2856: p_attribute19 IN OUT NOCOPY VARCHAR2,
2857: p_attribute20 IN OUT NOCOPY VARCHAR2)
2858: IS
2859: p_flexfield fnd_dflex.dflex_r;
2860: p_flexinfo fnd_dflex.dflex_dr;
2861: p_contexts fnd_dflex.contexts_dr;
2862: p_segments fnd_dflex.segments_dr;
2863: j BINARY_INTEGER;
2856: p_attribute19 IN OUT NOCOPY VARCHAR2,
2857: p_attribute20 IN OUT NOCOPY VARCHAR2)
2858: IS
2859: p_flexfield fnd_dflex.dflex_r;
2860: p_flexinfo fnd_dflex.dflex_dr;
2861: p_contexts fnd_dflex.contexts_dr;
2862: p_segments fnd_dflex.segments_dr;
2863: j BINARY_INTEGER;
2864: i BINARY_INTEGER;
2857: p_attribute20 IN OUT NOCOPY VARCHAR2)
2858: IS
2859: p_flexfield fnd_dflex.dflex_r;
2860: p_flexinfo fnd_dflex.dflex_dr;
2861: p_contexts fnd_dflex.contexts_dr;
2862: p_segments fnd_dflex.segments_dr;
2863: j BINARY_INTEGER;
2864: i BINARY_INTEGER;
2865: k BINARY_INTEGER;
2858: IS
2859: p_flexfield fnd_dflex.dflex_r;
2860: p_flexinfo fnd_dflex.dflex_dr;
2861: p_contexts fnd_dflex.contexts_dr;
2862: p_segments fnd_dflex.segments_dr;
2863: j BINARY_INTEGER;
2864: i BINARY_INTEGER;
2865: k BINARY_INTEGER;
2866:
2871:
2872: PROCEDURE Get_Flexfield
2873: IS
2874: BEGIN
2875: fnd_dflex.get_flexfield( appl_short_name, flex_field_name, p_flexfield, p_flexinfo );
2876: END Get_Flexfield;
2877:
2878: PROCEDURE Get_Contexts
2879: IS
2877:
2878: PROCEDURE Get_Contexts
2879: IS
2880: BEGIN
2881: fnd_dflex.get_contexts( p_flexfield, p_contexts );
2882: END Get_Contexts;
2883:
2884:
2885: BEGIN
2916:
2917: IF p_contexts.is_global(k)
2918: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
2919:
2920: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
2921: ,p_segments
2922: ,TRUE);
2923:
2924: FOR j IN 1 .. p_segments.nsegments LOOP
3039: p_attribute29 IN OUT NOCOPY VARCHAR2,
3040: p_attribute30 IN OUT NOCOPY VARCHAR2)
3041:
3042: IS
3043: p_flexfield fnd_dflex.dflex_r;
3044: p_flexinfo fnd_dflex.dflex_dr;
3045: p_contexts fnd_dflex.contexts_dr;
3046: p_segments fnd_dflex.segments_dr;
3047: j BINARY_INTEGER;
3040: p_attribute30 IN OUT NOCOPY VARCHAR2)
3041:
3042: IS
3043: p_flexfield fnd_dflex.dflex_r;
3044: p_flexinfo fnd_dflex.dflex_dr;
3045: p_contexts fnd_dflex.contexts_dr;
3046: p_segments fnd_dflex.segments_dr;
3047: j BINARY_INTEGER;
3048: i BINARY_INTEGER;
3041:
3042: IS
3043: p_flexfield fnd_dflex.dflex_r;
3044: p_flexinfo fnd_dflex.dflex_dr;
3045: p_contexts fnd_dflex.contexts_dr;
3046: p_segments fnd_dflex.segments_dr;
3047: j BINARY_INTEGER;
3048: i BINARY_INTEGER;
3049: k BINARY_INTEGER;
3042: IS
3043: p_flexfield fnd_dflex.dflex_r;
3044: p_flexinfo fnd_dflex.dflex_dr;
3045: p_contexts fnd_dflex.contexts_dr;
3046: p_segments fnd_dflex.segments_dr;
3047: j BINARY_INTEGER;
3048: i BINARY_INTEGER;
3049: k BINARY_INTEGER;
3050:
3055:
3056: PROCEDURE Get_Flexfield
3057: IS
3058: BEGIN
3059: fnd_dflex.get_flexfield( appl_short_name, flex_field_name, p_flexfield, p_flexinfo );
3060: END Get_Flexfield;
3061:
3062: PROCEDURE Get_Contexts
3063: IS
3061:
3062: PROCEDURE Get_Contexts
3063: IS
3064: BEGIN
3065: fnd_dflex.get_contexts( p_flexfield, p_contexts );
3066: END Get_Contexts;
3067:
3068:
3069: BEGIN
3111:
3112: IF p_contexts.is_global(k)
3113: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
3114:
3115: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
3116: ,p_segments
3117: ,TRUE);
3118:
3119: FOR j IN 1 .. p_segments.nsegments LOOP