DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on FND_DFLEX

Line 350: v_flexfield fnd_dflex.dflex_r;

346: l_organization_id NUMBER;
347: l_inventory_item_id NUMBER;
348: x_context_value mtl_flex_context.descriptive_flex_context_code%type;
349: l_attributes_name VARCHAR2(50) := 'Lot Attributes';
350: v_flexfield fnd_dflex.dflex_r;
351: v_flexinfo fnd_dflex.dflex_dr;
352: v_contexts fnd_dflex.contexts_dr;
353: v_segments fnd_dflex.segments_dr;
354: l_return_status VARCHAR2(1);

Line 351: v_flexinfo fnd_dflex.dflex_dr;

347: l_inventory_item_id NUMBER;
348: x_context_value mtl_flex_context.descriptive_flex_context_code%type;
349: l_attributes_name VARCHAR2(50) := 'Lot Attributes';
350: v_flexfield fnd_dflex.dflex_r;
351: v_flexinfo fnd_dflex.dflex_dr;
352: v_contexts fnd_dflex.contexts_dr;
353: v_segments fnd_dflex.segments_dr;
354: l_return_status VARCHAR2(1);
355: l_status BOOLEAN;

Line 352: v_contexts fnd_dflex.contexts_dr;

348: x_context_value mtl_flex_context.descriptive_flex_context_code%type;
349: l_attributes_name VARCHAR2(50) := 'Lot Attributes';
350: v_flexfield fnd_dflex.dflex_r;
351: v_flexinfo fnd_dflex.dflex_dr;
352: v_contexts fnd_dflex.contexts_dr;
353: v_segments fnd_dflex.segments_dr;
354: l_return_status VARCHAR2(1);
355: l_status BOOLEAN;
356: l_progress varchar2(100);

Line 353: v_segments fnd_dflex.segments_dr;

349: l_attributes_name VARCHAR2(50) := 'Lot Attributes';
350: v_flexfield fnd_dflex.dflex_r;
351: v_flexinfo fnd_dflex.dflex_dr;
352: v_contexts fnd_dflex.contexts_dr;
353: v_segments fnd_dflex.segments_dr;
354: l_return_status VARCHAR2(1);
355: l_status BOOLEAN;
356: l_progress varchar2(100);
357: v_colname varchar2(50);

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

693:
694: -- Get the Context Code for this Item First
695:
696: -- Get flexfield
697: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
698:
699: -- Get Contexts
700: fnd_dflex.get_contexts(v_flexfield, v_contexts);
701:

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

696: -- Get flexfield
697: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
698:
699: -- Get Contexts
700: fnd_dflex.get_contexts(v_flexfield, v_contexts);
701:
702:
703: l_progress := '60';
704: IF (l_debug = 1) THEN

Line 763: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,

759: ((UPPER(v_contexts.context_code(i)) = UPPER(x_context_value)) OR
760: v_contexts.is_global(i))
761: ) THEN
762: -- Get segments
763: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
764: v_contexts.context_code(i)),
765: v_segments, TRUE);
766:
767: <>

Line 1342: v_flexfield fnd_dflex.dflex_r;

1338:
1339: x_context_value mtl_flex_context.descriptive_flex_context_code%type;
1340: l_status BOOLEAN;
1341:
1342: v_flexfield fnd_dflex.dflex_r;
1343: v_flexinfo fnd_dflex.dflex_dr;
1344: v_contexts fnd_dflex.contexts_dr;
1345: v_segments fnd_dflex.segments_dr;
1346:

Line 1343: v_flexinfo fnd_dflex.dflex_dr;

1339: x_context_value mtl_flex_context.descriptive_flex_context_code%type;
1340: l_status BOOLEAN;
1341:
1342: v_flexfield fnd_dflex.dflex_r;
1343: v_flexinfo fnd_dflex.dflex_dr;
1344: v_contexts fnd_dflex.contexts_dr;
1345: v_segments fnd_dflex.segments_dr;
1346:
1347: v_colname varchar2(50);

Line 1344: v_contexts fnd_dflex.contexts_dr;

1340: l_status BOOLEAN;
1341:
1342: v_flexfield fnd_dflex.dflex_r;
1343: v_flexinfo fnd_dflex.dflex_dr;
1344: v_contexts fnd_dflex.contexts_dr;
1345: v_segments fnd_dflex.segments_dr;
1346:
1347: v_colname varchar2(50);
1348:

Line 1345: v_segments fnd_dflex.segments_dr;

1341:
1342: v_flexfield fnd_dflex.dflex_r;
1343: v_flexinfo fnd_dflex.dflex_dr;
1344: v_contexts fnd_dflex.contexts_dr;
1345: v_segments fnd_dflex.segments_dr;
1346:
1347: v_colname varchar2(50);
1348:
1349: l_ATTRIBUTE_CATEGORY VARCHAR2(30) ;

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

1663:
1664: -- Get the Context Code for this Item First
1665:
1666: -- Get flexfield
1667: fnd_dflex.get_flexfield('INV', l_attributes_name, v_flexfield, v_flexinfo);
1668:
1669: l_progress := '80';
1670: IF (l_debug = 1) THEN
1671: print_debug('At Step = '|| l_progress,4);

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

1671: print_debug('At Step = '|| l_progress,4);
1672: END IF;
1673:
1674: -- Get Contexts
1675: fnd_dflex.get_contexts(v_flexfield, v_contexts);
1676:
1677:
1678: IF (l_debug = 1) THEN
1679: print_debug('Number of contexts Found '||v_contexts.ncontexts , 4);

Line 1740: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,

1736: ((UPPER(v_contexts.context_code(i)) = UPPER(x_context_value)) OR
1737: v_contexts.is_global(i))
1738: ) THEN
1739: -- Get segments
1740: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
1741: v_contexts.context_code(i)),
1742: v_segments, TRUE);
1743:
1744: <>