DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_DFLEX

Line 3715: v_flexfield fnd_dflex.dflex_r;

3711: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3712: p_validate_only IN BOOLEAN
3713: ) IS
3714: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3715: v_flexfield fnd_dflex.dflex_r;
3716: v_flexinfo fnd_dflex.dflex_dr;
3717: v_contexts fnd_dflex.contexts_dr;
3718: v_segments fnd_dflex.segments_dr;
3719: l_attributes_default_count NUMBER;

Line 3716: v_flexinfo fnd_dflex.dflex_dr;

3712: p_validate_only IN BOOLEAN
3713: ) IS
3714: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3715: v_flexfield fnd_dflex.dflex_r;
3716: v_flexinfo fnd_dflex.dflex_dr;
3717: v_contexts fnd_dflex.contexts_dr;
3718: v_segments fnd_dflex.segments_dr;
3719: l_attributes_default_count NUMBER;
3720: l_enabled_attributes NUMBER;

Line 3717: v_contexts fnd_dflex.contexts_dr;

3713: ) IS
3714: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3715: v_flexfield fnd_dflex.dflex_r;
3716: v_flexinfo fnd_dflex.dflex_dr;
3717: v_contexts fnd_dflex.contexts_dr;
3718: v_segments fnd_dflex.segments_dr;
3719: l_attributes_default_count NUMBER;
3720: l_enabled_attributes NUMBER;
3721: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;

Line 3718: v_segments fnd_dflex.segments_dr;

3714: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3715: v_flexfield fnd_dflex.dflex_r;
3716: v_flexinfo fnd_dflex.dflex_dr;
3717: v_contexts fnd_dflex.contexts_dr;
3718: v_segments fnd_dflex.segments_dr;
3719: l_attributes_default_count NUMBER;
3720: l_enabled_attributes NUMBER;
3721: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;
3722: v_context_value mtl_flex_context.descriptive_flex_context_code%type;

Line 3836: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_flexfield...');

3832: END LOOP;
3833: END IF;
3834:
3835: IF (l_debug = 1) THEN
3836: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_flexfield...');
3837: END IF;
3838: -- Get flexfield
3839: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3840:

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

3835: IF (l_debug = 1) THEN
3836: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_flexfield...');
3837: END IF;
3838: -- Get flexfield
3839: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3840:
3841: IF (l_debug = 1) THEN
3842: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3843: END IF;

Line 3842: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');

3838: -- Get flexfield
3839: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3840:
3841: IF (l_debug = 1) THEN
3842: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3843: END IF;
3844: -- Get Contexts
3845: l_context_value := NULL;
3846: fnd_dflex.get_contexts(v_flexfield, v_contexts);

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

3842: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3843: END IF;
3844: -- Get Contexts
3845: l_context_value := NULL;
3846: fnd_dflex.get_contexts(v_flexfield, v_contexts);
3847:
3848: FOR i IN 1..g_serial_attributes_tbl.COUNT LOOP
3849: IF (Upper(g_serial_attributes_tbl(i).COLUMN_NAME) = 'SERIAL_ATTRIBUTE_CATEGORY'
3850: AND g_serial_attributes_tbl(i).column_value IS NULL ) THEN

Line 3901: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_segments...');

3897: IF (v_contexts.is_enabled(i) AND ((UPPER(v_contexts.context_code(i)) = UPPER(l_context_value)) OR
3898: v_contexts.is_global(i))) THEN
3899: -- Get segments
3900: IF (l_debug = 1) THEN
3901: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_segments...');
3902: END IF;
3903:
3904: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);
3905: <>

Line 3904: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);

3900: IF (l_debug = 1) THEN
3901: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_segments...');
3902: END IF;
3903:
3904: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);
3905: <>
3906: FOR j IN 1..v_segments.nsegments LOOP
3907: IF v_segments.is_enabled(j) THEN
3908: v_colName := v_segments.application_column_name(j);