6352: (
6353: p_req_material_rec IN REQ_MATERIAL_REC_TYPE,
6354: flex_fields_defaults OUT NOCOPY dff_default_values_type
6355: ) IS
6356: flexfield fnd_dflex.dflex_r;
6357: flexinfo fnd_dflex.dflex_dr;
6358: contexts fnd_dflex.contexts_dr;
6359: i BINARY_INTEGER;
6360: j BINARY_INTEGER;
6353: p_req_material_rec IN REQ_MATERIAL_REC_TYPE,
6354: flex_fields_defaults OUT NOCOPY dff_default_values_type
6355: ) IS
6356: flexfield fnd_dflex.dflex_r;
6357: flexinfo fnd_dflex.dflex_dr;
6358: contexts fnd_dflex.contexts_dr;
6359: i BINARY_INTEGER;
6360: j BINARY_INTEGER;
6361: segments fnd_dflex.segments_dr;
6354: flex_fields_defaults OUT NOCOPY dff_default_values_type
6355: ) IS
6356: flexfield fnd_dflex.dflex_r;
6357: flexinfo fnd_dflex.dflex_dr;
6358: contexts fnd_dflex.contexts_dr;
6359: i BINARY_INTEGER;
6360: j BINARY_INTEGER;
6361: segments fnd_dflex.segments_dr;
6362: BEGIN
6357: flexinfo fnd_dflex.dflex_dr;
6358: contexts fnd_dflex.contexts_dr;
6359: i BINARY_INTEGER;
6360: j BINARY_INTEGER;
6361: segments fnd_dflex.segments_dr;
6362: BEGIN
6363: fnd_dflex.get_flexfield('AHL', 'Material Reqmt Flex Field', flexfield, flexinfo);
6364: IF(p_req_material_rec.ATTRIBUTE_CATEGORY IS NULL)THEN
6365: flex_fields_defaults.ATTRIBUTE_CATEGORY := flexinfo.default_context_value;
6359: i BINARY_INTEGER;
6360: j BINARY_INTEGER;
6361: segments fnd_dflex.segments_dr;
6362: BEGIN
6363: fnd_dflex.get_flexfield('AHL', 'Material Reqmt Flex Field', flexfield, flexinfo);
6364: IF(p_req_material_rec.ATTRIBUTE_CATEGORY IS NULL)THEN
6365: flex_fields_defaults.ATTRIBUTE_CATEGORY := flexinfo.default_context_value;
6366: ELSIF (p_req_material_rec.ATTRIBUTE_CATEGORY = FND_API.G_MISS_CHAR)THEN
6367: flex_fields_defaults.ATTRIBUTE_CATEGORY := NULL;
6371: IF G_DEBUG='Y' THEN
6372: AHL_DEBUG_PUB.debug('flex_fields_defaults.ATTRIBUTE_CATEGORY : ' || flex_fields_defaults.ATTRIBUTE_CATEGORY);
6373: END IF;
6374: IF(flex_fields_defaults.ATTRIBUTE_CATEGORY IS NOT NULL)THEN
6375: fnd_dflex.get_contexts(flexfield, contexts);
6376: FOR j IN 1 .. contexts.ncontexts LOOP
6377: IF(contexts.is_enabled(j) AND
6378: (flex_fields_defaults.ATTRIBUTE_CATEGORY = contexts.context_code(j)
6379: OR contexts.is_global(j))
6377: IF(contexts.is_enabled(j) AND
6378: (flex_fields_defaults.ATTRIBUTE_CATEGORY = contexts.context_code(j)
6379: OR contexts.is_global(j))
6380: ) THEN
6381: fnd_dflex.get_segments
6382: ( fnd_dflex.make_context(flexfield,
6383: contexts.context_code(j)),
6384: segments,
6385: TRUE
6378: (flex_fields_defaults.ATTRIBUTE_CATEGORY = contexts.context_code(j)
6379: OR contexts.is_global(j))
6380: ) THEN
6381: fnd_dflex.get_segments
6382: ( fnd_dflex.make_context(flexfield,
6383: contexts.context_code(j)),
6384: segments,
6385: TRUE
6386: );