DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on FND_DFLEX

Line 2212: * fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);

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.

Line 2215: * fnd_dflex.get_contexts(v_flexfield, v_contexts);

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);

Line 2236: * fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,

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

Line 2289: v_flexfield fnd_dflex.dflex_r;

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;

Line 2290: v_flexinfo fnd_dflex.dflex_dr;

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;

Line 2291: v_contexts fnd_dflex.contexts_dr;

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;

Line 2292: v_segments fnd_dflex.segments_dr;

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;

Line 2608: print_debug ('calling fnd_dflex.get_flexfield', 'Validate_Attributes');

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

Line 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

Line 2617: print_debug ('calling fnd_dflex.get_context', 'Validate_Attributes');

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;

Line 2622: fnd_dflex.get_contexts (v_flexfield, v_contexts);

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

Line 2735: print_debug ('calling fnd_dflex.get_segments'

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

Line 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

Line 2740: (fnd_dflex.make_context (v_flexfield

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

Line 3020: v_flexfield fnd_dflex.dflex_r;

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;

Line 3021: v_flexinfo fnd_dflex.dflex_dr;

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;

Line 3022: v_contexts fnd_dflex.contexts_dr;

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;

Line 3023: v_segments fnd_dflex.segments_dr;

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;

Line 3205: print_debug ('calling fnd_dflex.get_flexfield'

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:

Line 3211: fnd_dflex.get_flexfield ('INV', l_attributes_name, v_flexfield

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

Line 3216: print_debug ('calling fnd_dflex.get_context'

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:

Line 3223: fnd_dflex.get_contexts (v_flexfield, v_contexts);

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

Line 3344: print_debug ('calling fnd_dflex.get_segments'

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:

Line 3365: fnd_dflex.get_segments

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

Line 3366: (fnd_dflex.make_context (v_flexfield

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