eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on FND_DFLEX

Line 3886: l_context_r fnd_dflex.context_r;

3882: TYPE seg_name IS TABLE OF VARCHAR2(1000)
3883: INDEX BY BINARY_INTEGER;
3884:
3885: l_context VARCHAR2(1000);
3886: l_context_r fnd_dflex.context_r;
3887: l_contexts_dr fnd_dflex.contexts_dr;
3888: l_dflex_r fnd_dflex.dflex_r;
3889: l_segments_dr fnd_dflex.segments_dr;
3890: l_enabled_seg_name seg_name;

Line 3887: l_contexts_dr fnd_dflex.contexts_dr;

3883: INDEX BY BINARY_INTEGER;
3884:
3885: l_context VARCHAR2(1000);
3886: l_context_r fnd_dflex.context_r;
3887: l_contexts_dr fnd_dflex.contexts_dr;
3888: l_dflex_r fnd_dflex.dflex_r;
3889: l_segments_dr fnd_dflex.segments_dr;
3890: l_enabled_seg_name seg_name;
3891: l_wms_all_segs_tbl seg_name;

Line 3888: l_dflex_r fnd_dflex.dflex_r;

3884:
3885: l_context VARCHAR2(1000);
3886: l_context_r fnd_dflex.context_r;
3887: l_contexts_dr fnd_dflex.contexts_dr;
3888: l_dflex_r fnd_dflex.dflex_r;
3889: l_segments_dr fnd_dflex.segments_dr;
3890: l_enabled_seg_name seg_name;
3891: l_wms_all_segs_tbl seg_name;
3892: l_nsegments BINARY_INTEGER;

Line 3889: l_segments_dr fnd_dflex.segments_dr;

3885: l_context VARCHAR2(1000);
3886: l_context_r fnd_dflex.context_r;
3887: l_contexts_dr fnd_dflex.contexts_dr;
3888: l_dflex_r fnd_dflex.dflex_r;
3889: l_segments_dr fnd_dflex.segments_dr;
3890: l_enabled_seg_name seg_name;
3891: l_wms_all_segs_tbl seg_name;
3892: l_nsegments BINARY_INTEGER;
3893: l_global_context BINARY_INTEGER;

Line 3935: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);

3931: --AND p_attributes_tbl.COUNT > 0 THEN
3932: l_dflex_r.application_id := 401;
3933: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
3934: /* Get all contexts */
3935: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
3936:
3937: IF g_debug = 1 THEN
3938: print_debug('Found contexts for the Flexfield MTL_LOT_NUMBERS', 9);
3939: END IF;

Line 3954: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

3950:
3951: /* Prepare the context_r type for getting the segments associated with the global context */
3952: l_context_r.flexfield := l_dflex_r;
3953: l_context_r.context_code := l_context;
3954: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
3955:
3956: IF g_debug = 1 THEN
3957: print_debug('After successfully getting all the enabled segmenst for the Global Context ', 9);
3958: END IF;

Line 4038: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

4034:
4035: /* Prepare the context_r type */
4036: l_context_r.flexfield := l_dflex_r;
4037: l_context_r.context_code := l_context;
4038: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4039: /* read through the segments */
4040: l_nsegments := l_segments_dr.nsegments;
4041: IF g_debug = 1 THEN
4042: print_debug('No of segments enabled for context ' || l_context || ' are ' || l_nsegments, 9);

Line 4617: l_context_r fnd_dflex.context_r;

4613: l_wms_installed VARCHAR2(5);
4614: l_chk NUMBER;
4615: l_context VARCHAR2(1000);
4616: l_global_context BINARY_INTEGER;
4617: l_context_r fnd_dflex.context_r;
4618: l_contexts_dr fnd_dflex.contexts_dr;
4619: l_dflex_r fnd_dflex.dflex_r;
4620: l_segments_dr fnd_dflex.segments_dr;
4621: inv_global_index NUMBER;

Line 4618: l_contexts_dr fnd_dflex.contexts_dr;

4614: l_chk NUMBER;
4615: l_context VARCHAR2(1000);
4616: l_global_context BINARY_INTEGER;
4617: l_context_r fnd_dflex.context_r;
4618: l_contexts_dr fnd_dflex.contexts_dr;
4619: l_dflex_r fnd_dflex.dflex_r;
4620: l_segments_dr fnd_dflex.segments_dr;
4621: inv_global_index NUMBER;
4622: inv_context_index NUMBER;

Line 4619: l_dflex_r fnd_dflex.dflex_r;

4615: l_context VARCHAR2(1000);
4616: l_global_context BINARY_INTEGER;
4617: l_context_r fnd_dflex.context_r;
4618: l_contexts_dr fnd_dflex.contexts_dr;
4619: l_dflex_r fnd_dflex.dflex_r;
4620: l_segments_dr fnd_dflex.segments_dr;
4621: inv_global_index NUMBER;
4622: inv_context_index NUMBER;
4623: wms_global_index NUMBER;

Line 4620: l_segments_dr fnd_dflex.segments_dr;

4616: l_global_context BINARY_INTEGER;
4617: l_context_r fnd_dflex.context_r;
4618: l_contexts_dr fnd_dflex.contexts_dr;
4619: l_dflex_r fnd_dflex.dflex_r;
4620: l_segments_dr fnd_dflex.segments_dr;
4621: inv_global_index NUMBER;
4622: inv_context_index NUMBER;
4623: wms_global_index NUMBER;
4624: wms_context_index NUMBER;

Line 4804: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);

4800: /* Populate the flex field record */
4801: l_dflex_r.application_id := 401;
4802: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
4803: /* Get all contexts */
4804: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
4805: /* From the l_contexts_dr, get the position of the global context */
4806: l_global_context := l_contexts_dr.global_context;
4807: l_context := l_contexts_dr.context_code(l_global_context);
4808: /* Prepare the context_r type for getting the segments associated with the global context */

Line 4812: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

4808: /* Prepare the context_r type for getting the segments associated with the global context */
4809: l_context_r.flexfield := l_dflex_r;
4810: l_context_r.context_code := l_context;
4811: /*Get the segments for the context */
4812: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4813:
4814: /*Loop through the Segments table to see if any segments are required */
4815: --inv_global_index :=l_segments_dr.first;
4816: l_global_nsegments := l_segments_dr.nsegments;

Line 4847: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

4843:
4844: l_context_r.flexfield := l_dflex_r;
4845: l_context_r.context_code := nvl(p_lot_rec.attribute_category, l_attr_category_cur.attribute_category);
4846: /*Get the segments for the context */
4847: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4848: /*Loop through the Segments table to see if any segments are required */
4849: inv_context_index := NULL;
4850:
4851: --inv_context_index :=l_segments_dr.first;

Line 5106: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);

5102: l_dflex_r.flexfield_name := 'Lot Attributes';
5103:
5104: /* Get all contexts */
5105:
5106: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
5107: l_context := NULL;
5108: l_global_context := NULL;
5109:
5110: /* From the l_contexts_dr, get the position of the global context */

Line 5122: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

5118: l_context_r.context_code := l_context;
5119:
5120: /*Get the segments for the context */
5121:
5122: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
5123:
5124: /*Loop through the Segments table to see if any segments are required */
5125:
5126: --wms_global_index :=l_segments_dr.first;

Line 5236: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

5232: /* Prepare the context_r type for getting the segments associated with the global context */
5233: l_context_r.flexfield := l_dflex_r;
5234: l_context_r.context_code := l_context;
5235: /*Get the segments for the context */
5236: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
5237: /*Loop through the Segments table to see if any segments are required */
5238: --wms_context_index :=l_segments_dr.first;
5239: print_debug('Before looping for wms context', 9);
5240:

Line 7127: l_context_r fnd_dflex.context_r;

7123: l_c_attr_index NUMBER;
7124: l_n_attr_index NUMBER;
7125: l_d_attr_index NUMBER;
7126: l_context VARCHAR2(1000);
7127: l_context_r fnd_dflex.context_r;
7128: l_contexts_dr fnd_dflex.contexts_dr;
7129: l_dflex_r fnd_dflex.dflex_r;
7130: l_segments_dr fnd_dflex.segments_dr;
7131: l_enabled_seg_name seg_name;

Line 7128: l_contexts_dr fnd_dflex.contexts_dr;

7124: l_n_attr_index NUMBER;
7125: l_d_attr_index NUMBER;
7126: l_context VARCHAR2(1000);
7127: l_context_r fnd_dflex.context_r;
7128: l_contexts_dr fnd_dflex.contexts_dr;
7129: l_dflex_r fnd_dflex.dflex_r;
7130: l_segments_dr fnd_dflex.segments_dr;
7131: l_enabled_seg_name seg_name;
7132: l_wms_all_segs_tbl seg_name;

Line 7129: l_dflex_r fnd_dflex.dflex_r;

7125: l_d_attr_index NUMBER;
7126: l_context VARCHAR2(1000);
7127: l_context_r fnd_dflex.context_r;
7128: l_contexts_dr fnd_dflex.contexts_dr;
7129: l_dflex_r fnd_dflex.dflex_r;
7130: l_segments_dr fnd_dflex.segments_dr;
7131: l_enabled_seg_name seg_name;
7132: l_wms_all_segs_tbl seg_name;
7133: l_nsegments BINARY_INTEGER;

Line 7130: l_segments_dr fnd_dflex.segments_dr;

7126: l_context VARCHAR2(1000);
7127: l_context_r fnd_dflex.context_r;
7128: l_contexts_dr fnd_dflex.contexts_dr;
7129: l_dflex_r fnd_dflex.dflex_r;
7130: l_segments_dr fnd_dflex.segments_dr;
7131: l_enabled_seg_name seg_name;
7132: l_wms_all_segs_tbl seg_name;
7133: l_nsegments BINARY_INTEGER;
7134: l_global_context BINARY_INTEGER;

Line 7584: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);

7580:
7581:
7582:
7583: /* Get all contexts */
7584: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
7585:
7586: /* From the l_contexts_dr, get the position of the global context */
7587: IF g_debug = 1 THEN
7588: print_debug('Found contexts for the Flexfield Lot Attributes ', 9);

Line 7602: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

7598:
7599: /* Prepare the context_r type for getting the segments associated with the global context */
7600: l_context_r.flexfield := l_dflex_r;
7601: l_context_r.context_code := l_context;
7602: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
7603: /* read through the segments */
7604: l_global_nsegments := l_segments_dr.nsegments;
7605:
7606: IF g_debug = 1 THEN

Line 7701: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);

7697: fnd_flex_descval.set_context_value(l_context);
7698: /* Prepare the context_r type */
7699: l_context_r.flexfield := l_dflex_r;
7700: l_context_r.context_code := l_context;
7701: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
7702: /* read through the segments */
7703: l_nsegments := 0;
7704: l_nsegments := l_segments_dr.nsegments;
7705: FOR i IN 1 .. l_nsegments LOOP