DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_DFLEX

Line 3358: v_flexfield fnd_dflex.dflex_r;

3354: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3355: p_validate_only IN BOOLEAN
3356: ) IS
3357: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3358: v_flexfield fnd_dflex.dflex_r;
3359: v_flexinfo fnd_dflex.dflex_dr;
3360: v_contexts fnd_dflex.contexts_dr;
3361: v_segments fnd_dflex.segments_dr;
3362: l_attributes_default_count NUMBER;

Line 3359: v_flexinfo fnd_dflex.dflex_dr;

3355: p_validate_only IN BOOLEAN
3356: ) IS
3357: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3358: v_flexfield fnd_dflex.dflex_r;
3359: v_flexinfo fnd_dflex.dflex_dr;
3360: v_contexts fnd_dflex.contexts_dr;
3361: v_segments fnd_dflex.segments_dr;
3362: l_attributes_default_count NUMBER;
3363: l_enabled_attributes NUMBER;

Line 3360: v_contexts fnd_dflex.contexts_dr;

3356: ) IS
3357: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3358: v_flexfield fnd_dflex.dflex_r;
3359: v_flexinfo fnd_dflex.dflex_dr;
3360: v_contexts fnd_dflex.contexts_dr;
3361: v_segments fnd_dflex.segments_dr;
3362: l_attributes_default_count NUMBER;
3363: l_enabled_attributes NUMBER;
3364: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;

Line 3361: v_segments fnd_dflex.segments_dr;

3357: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3358: v_flexfield fnd_dflex.dflex_r;
3359: v_flexinfo fnd_dflex.dflex_dr;
3360: v_contexts fnd_dflex.contexts_dr;
3361: v_segments fnd_dflex.segments_dr;
3362: l_attributes_default_count NUMBER;
3363: l_enabled_attributes NUMBER;
3364: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;
3365: v_context_value mtl_flex_context.descriptive_flex_context_code%type;

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

3467: END LOOP;
3468: END IF;
3469:
3470: IF (l_debug = 1) THEN
3471: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_flexfield...');
3472: END IF;
3473: -- Get flexfield
3474: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3475:

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

3470: IF (l_debug = 1) THEN
3471: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_flexfield...');
3472: END IF;
3473: -- Get flexfield
3474: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3475:
3476: IF (l_debug = 1) THEN
3477: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3478: END IF;

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

3473: -- Get flexfield
3474: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
3475:
3476: IF (l_debug = 1) THEN
3477: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3478: END IF;
3479: -- Get Contexts
3480: l_context_value := NULL;
3481: fnd_dflex.get_contexts(v_flexfield, v_contexts);

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

3477: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_context...');
3478: END IF;
3479: -- Get Contexts
3480: l_context_value := NULL;
3481: fnd_dflex.get_contexts(v_flexfield, v_contexts);
3482:
3483: FOR i IN 1..g_serial_attributes_tbl.COUNT LOOP
3484: IF (Upper(g_serial_attributes_tbl(i).COLUMN_NAME) = 'SERIAL_ATTRIBUTE_CATEGORY'
3485: AND g_serial_attributes_tbl(i).column_value IS NULL ) THEN

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

3532: IF (v_contexts.is_enabled(i) AND ((UPPER(v_contexts.context_code(i)) = UPPER(l_context_value)) OR
3533: v_contexts.is_global(i))) THEN
3534: -- Get segments
3535: IF (l_debug = 1) THEN
3536: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_segments...');
3537: END IF;
3538:
3539: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);
3540: <>

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

3535: IF (l_debug = 1) THEN
3536: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling fnd_dflex.get_segments...');
3537: END IF;
3538:
3539: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);
3540: <>
3541: FOR j IN 1..v_segments.nsegments LOOP
3542: IF v_segments.is_enabled(j) THEN
3543: v_colName := v_segments.application_column_name(j);