2919: p_attribute18 IN OUT NOCOPY VARCHAR2,
2920: p_attribute19 IN OUT NOCOPY VARCHAR2,
2921: p_attribute20 IN OUT NOCOPY VARCHAR2)
2922: IS
2923: p_flexfield fnd_dflex.dflex_r;
2924: p_flexinfo fnd_dflex.dflex_dr;
2925: p_contexts fnd_dflex.contexts_dr;
2926: p_segments fnd_dflex.segments_dr;
2927: j BINARY_INTEGER;
2920: p_attribute19 IN OUT NOCOPY VARCHAR2,
2921: p_attribute20 IN OUT NOCOPY VARCHAR2)
2922: IS
2923: p_flexfield fnd_dflex.dflex_r;
2924: p_flexinfo fnd_dflex.dflex_dr;
2925: p_contexts fnd_dflex.contexts_dr;
2926: p_segments fnd_dflex.segments_dr;
2927: j BINARY_INTEGER;
2928: i BINARY_INTEGER;
2921: p_attribute20 IN OUT NOCOPY VARCHAR2)
2922: IS
2923: p_flexfield fnd_dflex.dflex_r;
2924: p_flexinfo fnd_dflex.dflex_dr;
2925: p_contexts fnd_dflex.contexts_dr;
2926: p_segments fnd_dflex.segments_dr;
2927: j BINARY_INTEGER;
2928: i BINARY_INTEGER;
2929: k BINARY_INTEGER;
2922: IS
2923: p_flexfield fnd_dflex.dflex_r;
2924: p_flexinfo fnd_dflex.dflex_dr;
2925: p_contexts fnd_dflex.contexts_dr;
2926: p_segments fnd_dflex.segments_dr;
2927: j BINARY_INTEGER;
2928: i BINARY_INTEGER;
2929: k BINARY_INTEGER;
2930:
2935:
2936: PROCEDURE Get_Flexfield
2937: IS
2938: BEGIN
2939: fnd_dflex.get_flexfield( appl_short_name, flex_field_name, p_flexfield, p_flexinfo );
2940: END Get_Flexfield;
2941:
2942: PROCEDURE Get_Contexts
2943: IS
2941:
2942: PROCEDURE Get_Contexts
2943: IS
2944: BEGIN
2945: fnd_dflex.get_contexts( p_flexfield, p_contexts );
2946: END Get_Contexts;
2947:
2948:
2949: BEGIN
2993: IF p_contexts.is_global(k)
2994: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
2995:
2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');
2997: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
2998: ,p_segments
2999: ,TRUE);
3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');
3001:
2996: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside IF p_contexts.is_global(k) OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN');
2997: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
2998: ,p_segments
2999: ,TRUE);
3000: FND_FILE.PUT_LINE(FND_FILE.LOG,' After fnd_dflex.Get_Segments');
3001:
3002: FOR j IN 1 .. p_segments.nsegments LOOP
3003: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside FOR j IN 1 .. p_segments.nsegments LOOP'||j);
3004:
3122: p_attribute29 IN OUT NOCOPY VARCHAR2,
3123: p_attribute30 IN OUT NOCOPY VARCHAR2)
3124:
3125: IS
3126: p_flexfield fnd_dflex.dflex_r;
3127: p_flexinfo fnd_dflex.dflex_dr;
3128: p_contexts fnd_dflex.contexts_dr;
3129: p_segments fnd_dflex.segments_dr;
3130: j BINARY_INTEGER;
3123: p_attribute30 IN OUT NOCOPY VARCHAR2)
3124:
3125: IS
3126: p_flexfield fnd_dflex.dflex_r;
3127: p_flexinfo fnd_dflex.dflex_dr;
3128: p_contexts fnd_dflex.contexts_dr;
3129: p_segments fnd_dflex.segments_dr;
3130: j BINARY_INTEGER;
3131: i BINARY_INTEGER;
3124:
3125: IS
3126: p_flexfield fnd_dflex.dflex_r;
3127: p_flexinfo fnd_dflex.dflex_dr;
3128: p_contexts fnd_dflex.contexts_dr;
3129: p_segments fnd_dflex.segments_dr;
3130: j BINARY_INTEGER;
3131: i BINARY_INTEGER;
3132: k BINARY_INTEGER;
3125: IS
3126: p_flexfield fnd_dflex.dflex_r;
3127: p_flexinfo fnd_dflex.dflex_dr;
3128: p_contexts fnd_dflex.contexts_dr;
3129: p_segments fnd_dflex.segments_dr;
3130: j BINARY_INTEGER;
3131: i BINARY_INTEGER;
3132: k BINARY_INTEGER;
3133:
3138:
3139: PROCEDURE Get_Flexfield
3140: IS
3141: BEGIN
3142: fnd_dflex.get_flexfield( appl_short_name, flex_field_name, p_flexfield, p_flexinfo );
3143: END Get_Flexfield;
3144:
3145: PROCEDURE Get_Contexts
3146: IS
3144:
3145: PROCEDURE Get_Contexts
3146: IS
3147: BEGIN
3148: fnd_dflex.get_contexts( p_flexfield, p_contexts );
3149: END Get_Contexts;
3150:
3151:
3152: BEGIN
3194:
3195: IF p_contexts.is_global(k)
3196: OR p_contexts.context_code(k) = p_flexinfo.default_context_value THEN
3197:
3198: fnd_dflex.Get_Segments( fnd_dflex.make_context(p_flexfield,p_contexts.context_code(k))
3199: ,p_segments
3200: ,TRUE);
3201:
3202: FOR j IN 1 .. p_segments.nsegments LOOP