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 4045: l_context_r fnd_dflex.context_r;

4041: TYPE seg_name IS TABLE OF VARCHAR2(1000)
4042: INDEX BY BINARY_INTEGER;
4043:
4044: l_context VARCHAR2(1000);
4045: l_context_r fnd_dflex.context_r;
4046: l_contexts_dr fnd_dflex.contexts_dr;
4047: l_dflex_r fnd_dflex.dflex_r;
4048: l_segments_dr fnd_dflex.segments_dr;
4049: l_enabled_seg_name seg_name;

Line 4046: l_contexts_dr fnd_dflex.contexts_dr;

4042: INDEX BY BINARY_INTEGER;
4043:
4044: l_context VARCHAR2(1000);
4045: l_context_r fnd_dflex.context_r;
4046: l_contexts_dr fnd_dflex.contexts_dr;
4047: l_dflex_r fnd_dflex.dflex_r;
4048: l_segments_dr fnd_dflex.segments_dr;
4049: l_enabled_seg_name seg_name;
4050: l_wms_all_segs_tbl seg_name;

Line 4047: l_dflex_r fnd_dflex.dflex_r;

4043:
4044: l_context VARCHAR2(1000);
4045: l_context_r fnd_dflex.context_r;
4046: l_contexts_dr fnd_dflex.contexts_dr;
4047: l_dflex_r fnd_dflex.dflex_r;
4048: l_segments_dr fnd_dflex.segments_dr;
4049: l_enabled_seg_name seg_name;
4050: l_wms_all_segs_tbl seg_name;
4051: l_nsegments BINARY_INTEGER;

Line 4048: l_segments_dr fnd_dflex.segments_dr;

4044: l_context VARCHAR2(1000);
4045: l_context_r fnd_dflex.context_r;
4046: l_contexts_dr fnd_dflex.contexts_dr;
4047: l_dflex_r fnd_dflex.dflex_r;
4048: l_segments_dr fnd_dflex.segments_dr;
4049: l_enabled_seg_name seg_name;
4050: l_wms_all_segs_tbl seg_name;
4051: l_nsegments BINARY_INTEGER;
4052: l_global_context BINARY_INTEGER;

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

4090: --AND p_attributes_tbl.COUNT > 0 THEN
4091: l_dflex_r.application_id := 401;
4092: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
4093: /* Get all contexts */
4094: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
4095:
4096: IF g_debug = 1 THEN
4097: print_debug('Found contexts for the Flexfield MTL_LOT_NUMBERS', 9);
4098: END IF;

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

4109:
4110: /* Prepare the context_r type for getting the segments associated with the global context */
4111: l_context_r.flexfield := l_dflex_r;
4112: l_context_r.context_code := l_context;
4113: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4114:
4115: IF g_debug = 1 THEN
4116: print_debug('After successfully getting all the enabled segmenst for the Global Context ', 9);
4117: END IF;

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

4193:
4194: /* Prepare the context_r type */
4195: l_context_r.flexfield := l_dflex_r;
4196: l_context_r.context_code := l_context;
4197: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4198: /* read through the segments */
4199: l_nsegments := l_segments_dr.nsegments;
4200: IF g_debug = 1 THEN
4201: print_debug('No of segments enabled for context ' || l_context || ' are ' || l_nsegments, 9);

Line 4776: l_context_r fnd_dflex.context_r;

4772: l_wms_installed VARCHAR2(5);
4773: l_chk NUMBER;
4774: l_context VARCHAR2(1000);
4775: l_global_context BINARY_INTEGER;
4776: l_context_r fnd_dflex.context_r;
4777: l_contexts_dr fnd_dflex.contexts_dr;
4778: l_dflex_r fnd_dflex.dflex_r;
4779: l_segments_dr fnd_dflex.segments_dr;
4780: inv_global_index NUMBER;

Line 4777: l_contexts_dr fnd_dflex.contexts_dr;

4773: l_chk NUMBER;
4774: l_context VARCHAR2(1000);
4775: l_global_context BINARY_INTEGER;
4776: l_context_r fnd_dflex.context_r;
4777: l_contexts_dr fnd_dflex.contexts_dr;
4778: l_dflex_r fnd_dflex.dflex_r;
4779: l_segments_dr fnd_dflex.segments_dr;
4780: inv_global_index NUMBER;
4781: inv_context_index NUMBER;

Line 4778: l_dflex_r fnd_dflex.dflex_r;

4774: l_context VARCHAR2(1000);
4775: l_global_context BINARY_INTEGER;
4776: l_context_r fnd_dflex.context_r;
4777: l_contexts_dr fnd_dflex.contexts_dr;
4778: l_dflex_r fnd_dflex.dflex_r;
4779: l_segments_dr fnd_dflex.segments_dr;
4780: inv_global_index NUMBER;
4781: inv_context_index NUMBER;
4782: wms_global_index NUMBER;

Line 4779: l_segments_dr fnd_dflex.segments_dr;

4775: l_global_context BINARY_INTEGER;
4776: l_context_r fnd_dflex.context_r;
4777: l_contexts_dr fnd_dflex.contexts_dr;
4778: l_dflex_r fnd_dflex.dflex_r;
4779: l_segments_dr fnd_dflex.segments_dr;
4780: inv_global_index NUMBER;
4781: inv_context_index NUMBER;
4782: wms_global_index NUMBER;
4783: wms_context_index NUMBER;

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

4962: /* Populate the flex field record */
4963: l_dflex_r.application_id := 401;
4964: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
4965: /* Get all contexts */
4966: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
4967: /* From the l_contexts_dr, get the position of the global context */
4968: l_global_context := l_contexts_dr.global_context;
4969: l_context := l_contexts_dr.context_code(l_global_context);
4970: /* Prepare the context_r type for getting the segments associated with the global context */

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

4970: /* Prepare the context_r type for getting the segments associated with the global context */
4971: l_context_r.flexfield := l_dflex_r;
4972: l_context_r.context_code := l_context;
4973: /*Get the segments for the context */
4974: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
4975:
4976: /*Loop through the Segments table to see if any segments are required */
4977: --inv_global_index :=l_segments_dr.first;
4978: l_global_nsegments := l_segments_dr.nsegments;

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

5005:
5006: l_context_r.flexfield := l_dflex_r;
5007: l_context_r.context_code := nvl(p_lot_rec.attribute_category, l_attr_category_cur.attribute_category);
5008: /*Get the segments for the context */
5009: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
5010: /*Loop through the Segments table to see if any segments are required */
5011: inv_context_index := NULL;
5012:
5013: --inv_context_index :=l_segments_dr.first;

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

5264: l_dflex_r.flexfield_name := 'Lot Attributes';
5265:
5266: /* Get all contexts */
5267:
5268: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
5269: l_context := NULL;
5270: l_global_context := NULL;
5271:
5272: /* From the l_contexts_dr, get the position of the global context */

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

5280: l_context_r.context_code := l_context;
5281:
5282: /*Get the segments for the context */
5283:
5284: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
5285:
5286: /*Loop through the Segments table to see if any segments are required */
5287:
5288: --wms_global_index :=l_segments_dr.first;

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

5394: /* Prepare the context_r type for getting the segments associated with the global context */
5395: l_context_r.flexfield := l_dflex_r;
5396: l_context_r.context_code := l_context;
5397: /*Get the segments for the context */
5398: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
5399: /*Loop through the Segments table to see if any segments are required */
5400: --wms_context_index :=l_segments_dr.first;
5401: print_debug('Before looping for wms context', 9);
5402:

Line 7480: l_context_r fnd_dflex.context_r;

7476: l_c_attr_index NUMBER;
7477: l_n_attr_index NUMBER;
7478: l_d_attr_index NUMBER;
7479: l_context VARCHAR2(1000);
7480: l_context_r fnd_dflex.context_r;
7481: l_contexts_dr fnd_dflex.contexts_dr;
7482: l_dflex_r fnd_dflex.dflex_r;
7483: l_segments_dr fnd_dflex.segments_dr;
7484: l_enabled_seg_name seg_name;

Line 7481: l_contexts_dr fnd_dflex.contexts_dr;

7477: l_n_attr_index NUMBER;
7478: l_d_attr_index NUMBER;
7479: l_context VARCHAR2(1000);
7480: l_context_r fnd_dflex.context_r;
7481: l_contexts_dr fnd_dflex.contexts_dr;
7482: l_dflex_r fnd_dflex.dflex_r;
7483: l_segments_dr fnd_dflex.segments_dr;
7484: l_enabled_seg_name seg_name;
7485: l_wms_all_segs_tbl seg_name;

Line 7482: l_dflex_r fnd_dflex.dflex_r;

7478: l_d_attr_index NUMBER;
7479: l_context VARCHAR2(1000);
7480: l_context_r fnd_dflex.context_r;
7481: l_contexts_dr fnd_dflex.contexts_dr;
7482: l_dflex_r fnd_dflex.dflex_r;
7483: l_segments_dr fnd_dflex.segments_dr;
7484: l_enabled_seg_name seg_name;
7485: l_wms_all_segs_tbl seg_name;
7486: l_nsegments BINARY_INTEGER;

Line 7483: l_segments_dr fnd_dflex.segments_dr;

7479: l_context VARCHAR2(1000);
7480: l_context_r fnd_dflex.context_r;
7481: l_contexts_dr fnd_dflex.contexts_dr;
7482: l_dflex_r fnd_dflex.dflex_r;
7483: l_segments_dr fnd_dflex.segments_dr;
7484: l_enabled_seg_name seg_name;
7485: l_wms_all_segs_tbl seg_name;
7486: l_nsegments BINARY_INTEGER;
7487: l_global_context BINARY_INTEGER;

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

7933:
7934:
7935:
7936: /* Get all contexts */
7937: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
7938:
7939: /* From the l_contexts_dr, get the position of the global context */
7940: IF g_debug = 1 THEN
7941: print_debug('Found contexts for the Flexfield Lot Attributes ', 9);

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

7951:
7952: /* Prepare the context_r type for getting the segments associated with the global context */
7953: l_context_r.flexfield := l_dflex_r;
7954: l_context_r.context_code := l_context;
7955: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
7956: /* read through the segments */
7957: l_global_nsegments := l_segments_dr.nsegments;
7958:
7959: IF g_debug = 1 THEN

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

8050: fnd_flex_descval.set_context_value(l_context);
8051: /* Prepare the context_r type */
8052: l_context_r.flexfield := l_dflex_r;
8053: l_context_r.context_code := l_context;
8054: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
8055: /* read through the segments */
8056: l_nsegments := 0;
8057: l_nsegments := l_segments_dr.nsegments;
8058: FOR i IN 1 .. l_nsegments LOOP