2208: * end loop;
2209: * end if;
2210: *
2211: * -- Get flexfield
2212: * fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
2213: *
2214: * -- Get Contexts
2215: * fnd_dflex.get_contexts(v_flexfield, v_contexts);
2216: * -- Get Context Value.
2211: * -- Get flexfield
2212: * fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
2213: *
2214: * -- Get Contexts
2215: * fnd_dflex.get_contexts(v_flexfield, v_contexts);
2216: * -- Get Context Value.
2217: * if g_lot_attributes_tbl(9).column_value is null then
2218: * inv_lot_sel_attr.get_context_code(l_context_value,
2219: * p_organization_id,p_inventory_item_id,l_attributes_name);
2232: * IF(v_contexts.is_enabled(i) AND ((UPPER(v_contexts.context_code(i)) =
2233: * UPPER(l_context_value)) OR
2234: * v_contexts.is_global(i))) THEN
2235: * -- Get segments
2236: * fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
2237: * v_contexts.context_code(i)), v_segments, TRUE);
2238: * <
2239: * FOR j IN 1..v_segments.nsegments LOOP
2240: * IF v_segments.is_enabled(j) THEN
2285: , p_transaction_type_id IN NUMBER
2286: )
2287: IS
2288: l_attributes_name VARCHAR2 (50) := 'Lot Attributes';
2289: v_flexfield fnd_dflex.dflex_r;
2290: v_flexinfo fnd_dflex.dflex_dr;
2291: v_contexts fnd_dflex.contexts_dr;
2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2286: )
2287: IS
2288: l_attributes_name VARCHAR2 (50) := 'Lot Attributes';
2289: v_flexfield fnd_dflex.dflex_r;
2290: v_flexinfo fnd_dflex.dflex_dr;
2291: v_contexts fnd_dflex.contexts_dr;
2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2294: l_enabled_attributes NUMBER;
2287: IS
2288: l_attributes_name VARCHAR2 (50) := 'Lot Attributes';
2289: v_flexfield fnd_dflex.dflex_r;
2290: v_flexinfo fnd_dflex.dflex_dr;
2291: v_contexts fnd_dflex.contexts_dr;
2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2294: l_enabled_attributes NUMBER;
2295: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2288: l_attributes_name VARCHAR2 (50) := 'Lot Attributes';
2289: v_flexfield fnd_dflex.dflex_r;
2290: v_flexinfo fnd_dflex.dflex_dr;
2291: v_contexts fnd_dflex.contexts_dr;
2292: v_segments fnd_dflex.segments_dr;
2293: l_attributes_default_count NUMBER;
2294: l_enabled_attributes NUMBER;
2295: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2296: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
2604: END IF;
2605:
2606: IF (l_debug = 1)
2607: THEN
2608: print_debug ('calling fnd_dflex.get_flexfield', 'Validate_Attributes');
2609: END IF;
2610:
2611: -- Get flexfield
2612: fnd_dflex.get_flexfield ('INV', l_attributes_name, v_flexfield
2608: print_debug ('calling fnd_dflex.get_flexfield', 'Validate_Attributes');
2609: END IF;
2610:
2611: -- Get flexfield
2612: fnd_dflex.get_flexfield ('INV', l_attributes_name, v_flexfield
2613: , v_flexinfo);
2614:
2615: IF (l_debug = 1)
2616: THEN
2613: , v_flexinfo);
2614:
2615: IF (l_debug = 1)
2616: THEN
2617: print_debug ('calling fnd_dflex.get_context', 'Validate_Attributes');
2618: END IF;
2619:
2620: -- Get Contexts
2621: l_context_value := NULL;
2618: END IF;
2619:
2620: -- Get Contexts
2621: l_context_value := NULL;
2622: fnd_dflex.get_contexts (v_flexfield, v_contexts);
2623:
2624: --will get the number of contexts, their name etc
2625:
2626: --till now we have populated the attributes in the g_lot_attributes table...now we
2731: --get the segments that have been enabled for this context
2732: -- Get segments
2733: IF (l_debug = 1)
2734: THEN
2735: print_debug ('calling fnd_dflex.get_segments'
2736: , 'Validate_Attributes'
2737: );
2738: END IF;
2739: fnd_dflex.get_segments
2735: print_debug ('calling fnd_dflex.get_segments'
2736: , 'Validate_Attributes'
2737: );
2738: END IF;
2739: fnd_dflex.get_segments
2740: (fnd_dflex.make_context (v_flexfield
2741: , v_contexts.context_code (i)
2742: )
2743: , v_segments
2736: , 'Validate_Attributes'
2737: );
2738: END IF;
2739: fnd_dflex.get_segments
2740: (fnd_dflex.make_context (v_flexfield
2741: , v_contexts.context_code (i)
2742: )
2743: , v_segments
2744: , TRUE
3016: , p_result_ser_attr_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3017: )
3018: IS
3019: l_attributes_name VARCHAR2 (50) := 'Serial Attributes';
3020: v_flexfield fnd_dflex.dflex_r;
3021: v_flexinfo fnd_dflex.dflex_dr;
3022: v_contexts fnd_dflex.contexts_dr;
3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3017: )
3018: IS
3019: l_attributes_name VARCHAR2 (50) := 'Serial Attributes';
3020: v_flexfield fnd_dflex.dflex_r;
3021: v_flexinfo fnd_dflex.dflex_dr;
3022: v_contexts fnd_dflex.contexts_dr;
3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3025: l_enabled_attributes NUMBER;
3018: IS
3019: l_attributes_name VARCHAR2 (50) := 'Serial Attributes';
3020: v_flexfield fnd_dflex.dflex_r;
3021: v_flexinfo fnd_dflex.dflex_dr;
3022: v_contexts fnd_dflex.contexts_dr;
3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3025: l_enabled_attributes NUMBER;
3026: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3019: l_attributes_name VARCHAR2 (50) := 'Serial Attributes';
3020: v_flexfield fnd_dflex.dflex_r;
3021: v_flexinfo fnd_dflex.dflex_dr;
3022: v_contexts fnd_dflex.contexts_dr;
3023: v_segments fnd_dflex.segments_dr;
3024: l_attributes_default_count NUMBER;
3025: l_enabled_attributes NUMBER;
3026: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3027: v_context_value mtl_flex_context.descriptive_flex_context_code%TYPE;
3201: END IF;
3202:
3203: IF (l_debug = 1)
3204: THEN
3205: print_debug ('calling fnd_dflex.get_flexfield'
3206: , 'validate_serial_attributes'
3207: );
3208: END IF;
3209:
3207: );
3208: END IF;
3209:
3210: -- Get flexfield
3211: fnd_dflex.get_flexfield ('INV', l_attributes_name, v_flexfield
3212: , v_flexinfo);
3213:
3214: IF (l_debug = 1)
3215: THEN
3212: , v_flexinfo);
3213:
3214: IF (l_debug = 1)
3215: THEN
3216: print_debug ('calling fnd_dflex.get_context'
3217: , 'validate_serial_attributes'
3218: );
3219: END IF;
3220:
3219: END IF;
3220:
3221: -- Get Contexts
3222: l_context_value := NULL;
3223: fnd_dflex.get_contexts (v_flexfield, v_contexts);
3224:
3225: --will get the number of contexts, their name etc
3226:
3227: --till now we have populated the attributes in the g_lot_attributes table...now we
3340: --get the segments that have been enabled for this context
3341: -- Get segments
3342: IF (l_debug = 1)
3343: THEN
3344: print_debug ('calling fnd_dflex.get_segments'
3345: , 'validate_serial_attributes'
3346: );
3347: END IF;
3348:
3361: value_set value_set_a,
3362: default_type default_type_a,
3363: default_value default_value_a)
3364: */
3365: fnd_dflex.get_segments
3366: (fnd_dflex.make_context (v_flexfield
3367: , v_contexts.context_code (i)
3368: )
3369: , v_segments
3362: default_type default_type_a,
3363: default_value default_value_a)
3364: */
3365: fnd_dflex.get_segments
3366: (fnd_dflex.make_context (v_flexfield
3367: , v_contexts.context_code (i)
3368: )
3369: , v_segments
3370: , TRUE