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_SEL_ATTR dependencies on FND_DFLEX

Line 397: v_flexfield fnd_dflex.dflex_r;

393: , p_lot_serial_number IN VARCHAR2
394: , p_attributes IN lot_sel_attributes_tbl_type) IS
395:
396: c_api_name CONSTANT VARCHAR2(30) := 'get_default';
397: v_flexfield fnd_dflex.dflex_r;
398: v_flexinfo fnd_dflex.dflex_dr;
399: v_contexts fnd_dflex.contexts_dr;
400: v_segments fnd_dflex.segments_dr;
401:

Line 398: v_flexinfo fnd_dflex.dflex_dr;

394: , p_attributes IN lot_sel_attributes_tbl_type) IS
395:
396: c_api_name CONSTANT VARCHAR2(30) := 'get_default';
397: v_flexfield fnd_dflex.dflex_r;
398: v_flexinfo fnd_dflex.dflex_dr;
399: v_contexts fnd_dflex.contexts_dr;
400: v_segments fnd_dflex.segments_dr;
401:
402: v_attributes_category VARCHAR2(50) :=NULL;

Line 399: v_contexts fnd_dflex.contexts_dr;

395:
396: c_api_name CONSTANT VARCHAR2(30) := 'get_default';
397: v_flexfield fnd_dflex.dflex_r;
398: v_flexinfo fnd_dflex.dflex_dr;
399: v_contexts fnd_dflex.contexts_dr;
400: v_segments fnd_dflex.segments_dr;
401:
402: v_attributes_category VARCHAR2(50) :=NULL;
403: v_global_code VARCHAR2(50);

Line 400: v_segments fnd_dflex.segments_dr;

396: c_api_name CONSTANT VARCHAR2(30) := 'get_default';
397: v_flexfield fnd_dflex.dflex_r;
398: v_flexinfo fnd_dflex.dflex_dr;
399: v_contexts fnd_dflex.contexts_dr;
400: v_segments fnd_dflex.segments_dr;
401:
402: v_attributes_category VARCHAR2(50) :=NULL;
403: v_global_code VARCHAR2(50);
404: i BINARY_INTEGER;

Line 429: fnd_dflex.get_flexfield('INV', p_attributes_name, v_flexfield, v_flexinfo);

425: -- Get flexfield
426: IF (l_debug = 1) THEN
427: inv_log_util.trace('Get Flexfield ' || p_attributes_name, 'LOTSERATTR');
428: END IF;
429: fnd_dflex.get_flexfield('INV', p_attributes_name, v_flexfield, v_flexinfo);
430:
431: -- Get Contexts
432: fnd_dflex.get_contexts(v_flexfield, v_contexts);
433: IF (l_debug = 1) THEN

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

428: END IF;
429: fnd_dflex.get_flexfield('INV', p_attributes_name, v_flexfield, v_flexinfo);
430:
431: -- Get Contexts
432: fnd_dflex.get_contexts(v_flexfield, v_contexts);
433: IF (l_debug = 1) THEN
434: inv_log_util.trace('Get context ' , 'LOTSERATTR');
435: END IF;
436: /*bug 2474713 retrieve the context_column_name and the context_prompt */

Line 464: fnd_dflex.get_segments(fnd_dflex.make_context(

460: -- Get segmentse
461: IF (l_debug = 1) THEN
462: inv_log_util.trace('get segment', 'LOTSERATTR');
463: END IF;
464: fnd_dflex.get_segments(fnd_dflex.make_context(
465: v_flexfield, v_contexts.context_code(i)), v_segments, TRUE);
466:
467: <>
468: FOR j IN 1..v_segments.nsegments LOOP

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

528: x_attributes_default(v_rec_index).PROMPT := l_context_prompt;
529: END IF; /*bug2474713*/
530:
531: -- Get segments
532: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
533: v_contexts.context_code(i)),
534: v_segments, TRUE);
535: <>
536: FOR j IN 1..v_segments.nsegments LOOP

Line 687: v_flexfield fnd_dflex.dflex_r;

683: /* Returns the delimiter for the given dff
684: If flexfield is not found, then returns -1' */
685: FUNCTION get_delimiter(p_flex_name IN VARCHAR2,
686: p_application_short_name IN VARCHAR2) RETURN VARCHAR2 IS
687: v_flexfield fnd_dflex.dflex_r;
688: v_flexinfo fnd_dflex.dflex_dr;
689:
690: BEGIN
691:

Line 688: v_flexinfo fnd_dflex.dflex_dr;

684: If flexfield is not found, then returns -1' */
685: FUNCTION get_delimiter(p_flex_name IN VARCHAR2,
686: p_application_short_name IN VARCHAR2) RETURN VARCHAR2 IS
687: v_flexfield fnd_dflex.dflex_r;
688: v_flexinfo fnd_dflex.dflex_dr;
689:
690: BEGIN
691:
692: -- Get flexfield

Line 693: fnd_dflex.get_flexfield(p_application_short_name, p_flex_name, v_flexfield, v_flexinfo);

689:
690: BEGIN
691:
692: -- Get flexfield
693: fnd_dflex.get_flexfield(p_application_short_name, p_flex_name, v_flexfield, v_flexinfo);
694: return(v_flexinfo.segment_delimeter);
695: EXCEPTION
696: WHEN OTHERS THEN
697: RETURN('-1');

Line 711: v_flexfield fnd_dflex.dflex_r;

707: p_organization_id IN NUMBER,
708: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
709:
710: v_dflex_context_flag VARCHAR2(10);
711: v_flexfield fnd_dflex.dflex_r;
712: v_flexinfo fnd_dflex.dflex_dr;
713: v_contexts fnd_dflex.contexts_dr;
714: v_segments fnd_dflex.segments_dr;
715: v_attributes_category VARCHAR2(50) :=NULL;

Line 712: v_flexinfo fnd_dflex.dflex_dr;

708: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
709:
710: v_dflex_context_flag VARCHAR2(10);
711: v_flexfield fnd_dflex.dflex_r;
712: v_flexinfo fnd_dflex.dflex_dr;
713: v_contexts fnd_dflex.contexts_dr;
714: v_segments fnd_dflex.segments_dr;
715: v_attributes_category VARCHAR2(50) :=NULL;
716: i BINARY_INTEGER;

Line 713: v_contexts fnd_dflex.contexts_dr;

709:
710: v_dflex_context_flag VARCHAR2(10);
711: v_flexfield fnd_dflex.dflex_r;
712: v_flexinfo fnd_dflex.dflex_dr;
713: v_contexts fnd_dflex.contexts_dr;
714: v_segments fnd_dflex.segments_dr;
715: v_attributes_category VARCHAR2(50) :=NULL;
716: i BINARY_INTEGER;
717: j BINARY_INTEGER;

Line 714: v_segments fnd_dflex.segments_dr;

710: v_dflex_context_flag VARCHAR2(10);
711: v_flexfield fnd_dflex.dflex_r;
712: v_flexinfo fnd_dflex.dflex_dr;
713: v_contexts fnd_dflex.contexts_dr;
714: v_segments fnd_dflex.segments_dr;
715: v_attributes_category VARCHAR2(50) :=NULL;
716: i BINARY_INTEGER;
717: j BINARY_INTEGER;
718:

Line 798: v_flexfield fnd_dflex.dflex_r;

794: p_organization_id IN NUMBER,
795: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
796:
797: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled';
798: v_flexfield fnd_dflex.dflex_r;
799: v_flexinfo fnd_dflex.dflex_dr;
800: v_contexts fnd_dflex.contexts_dr;
801: v_segments fnd_dflex.segments_dr;
802:

Line 799: v_flexinfo fnd_dflex.dflex_dr;

795: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
796:
797: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled';
798: v_flexfield fnd_dflex.dflex_r;
799: v_flexinfo fnd_dflex.dflex_dr;
800: v_contexts fnd_dflex.contexts_dr;
801: v_segments fnd_dflex.segments_dr;
802:
803: v_attributes_category VARCHAR2(50) :=NULL;

Line 800: v_contexts fnd_dflex.contexts_dr;

796:
797: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled';
798: v_flexfield fnd_dflex.dflex_r;
799: v_flexinfo fnd_dflex.dflex_dr;
800: v_contexts fnd_dflex.contexts_dr;
801: v_segments fnd_dflex.segments_dr;
802:
803: v_attributes_category VARCHAR2(50) :=NULL;
804: i BINARY_INTEGER;

Line 801: v_segments fnd_dflex.segments_dr;

797: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled';
798: v_flexfield fnd_dflex.dflex_r;
799: v_flexinfo fnd_dflex.dflex_dr;
800: v_contexts fnd_dflex.contexts_dr;
801: v_segments fnd_dflex.segments_dr;
802:
803: v_attributes_category VARCHAR2(50) :=NULL;
804: i BINARY_INTEGER;
805: j BINARY_INTEGER;

Line 814: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);

810:
811: v_is_enabled :=0;
812:
813: -- Get flexfield
814: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
815:
816: -- Get Contexts
817: fnd_dflex.get_contexts(v_flexfield, v_contexts);
818:

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

813: -- Get flexfield
814: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
815:
816: -- Get Contexts
817: fnd_dflex.get_contexts(v_flexfield, v_contexts);
818:
819: -- Get attributes category
820: get_context_code(
821: context_value => v_attributes_category

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

832: v_contexts.is_global(i))
833: ) THEN
834:
835: -- Get segments
836: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
837: v_contexts.context_code(i)),
838: v_segments, TRUE);
839:
840: <>

Line 889: v_flexfield fnd_dflex.dflex_r;

885: p_organization_id IN NUMBER,
886: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
887:
888: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled_segment';
889: v_flexfield fnd_dflex.dflex_r;
890: v_flexinfo fnd_dflex.dflex_dr;
891: v_contexts fnd_dflex.contexts_dr;
892: v_segments fnd_dflex.segments_dr;
893:

Line 890: v_flexinfo fnd_dflex.dflex_dr;

886: p_inventory_item_id IN NUMBER) RETURN NUMBER IS
887:
888: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled_segment';
889: v_flexfield fnd_dflex.dflex_r;
890: v_flexinfo fnd_dflex.dflex_dr;
891: v_contexts fnd_dflex.contexts_dr;
892: v_segments fnd_dflex.segments_dr;
893:
894: v_attributes_category VARCHAR2(50) :=NULL;

Line 891: v_contexts fnd_dflex.contexts_dr;

887:
888: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled_segment';
889: v_flexfield fnd_dflex.dflex_r;
890: v_flexinfo fnd_dflex.dflex_dr;
891: v_contexts fnd_dflex.contexts_dr;
892: v_segments fnd_dflex.segments_dr;
893:
894: v_attributes_category VARCHAR2(50) :=NULL;
895: i BINARY_INTEGER;

Line 892: v_segments fnd_dflex.segments_dr;

888: c_api_name CONSTANT VARCHAR2(30) := 'is_enabled_segment';
889: v_flexfield fnd_dflex.dflex_r;
890: v_flexinfo fnd_dflex.dflex_dr;
891: v_contexts fnd_dflex.contexts_dr;
892: v_segments fnd_dflex.segments_dr;
893:
894: v_attributes_category VARCHAR2(50) :=NULL;
895: i BINARY_INTEGER;
896: j BINARY_INTEGER;

Line 905: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);

901:
902: v_is_enabled :=0;
903:
904: -- Get flexfield
905: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
906:
907: -- Get Contexts
908: fnd_dflex.get_contexts(v_flexfield, v_contexts);
909:

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

904: -- Get flexfield
905: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
906:
907: -- Get Contexts
908: fnd_dflex.get_contexts(v_flexfield, v_contexts);
909:
910: -- Get attributes category
911: INV_LOT_SEL_ATTR.get_context_code(
912: context_value => v_attributes_category

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

922: v_contexts.is_global(i))
923: ) THEN
924:
925: -- Get segments
926: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
927: v_contexts.context_code(i)),
928: v_segments, TRUE);
929:
930: <>

Line 1005: l_flexfield fnd_dflex.dflex_r;

1001: /* BUG 5334967 */
1002: l_precision NUMBER := 0;
1003: l_index NUMBER := 0;
1004:
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo fnd_dflex.dflex_dr;
1007: l_contexts_info fnd_dflex.contexts_dr;
1008: l_contexts fnd_dflex.context_r;
1009: l_segments fnd_dflex.segments_dr;

Line 1006: l_flexinfo fnd_dflex.dflex_dr;

1002: l_precision NUMBER := 0;
1003: l_index NUMBER := 0;
1004:
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo fnd_dflex.dflex_dr;
1007: l_contexts_info fnd_dflex.contexts_dr;
1008: l_contexts fnd_dflex.context_r;
1009: l_segments fnd_dflex.segments_dr;
1010: l_attributes_category VARCHAR2(50) :=NULL;

Line 1007: l_contexts_info fnd_dflex.contexts_dr;

1003: l_index NUMBER := 0;
1004:
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo fnd_dflex.dflex_dr;
1007: l_contexts_info fnd_dflex.contexts_dr;
1008: l_contexts fnd_dflex.context_r;
1009: l_segments fnd_dflex.segments_dr;
1010: l_attributes_category VARCHAR2(50) :=NULL;
1011: l_global_code VARCHAR2(50);

Line 1008: l_contexts fnd_dflex.context_r;

1004:
1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo fnd_dflex.dflex_dr;
1007: l_contexts_info fnd_dflex.contexts_dr;
1008: l_contexts fnd_dflex.context_r;
1009: l_segments fnd_dflex.segments_dr;
1010: l_attributes_category VARCHAR2(50) :=NULL;
1011: l_global_code VARCHAR2(50);
1012: l_rec_index BINARY_INTEGER := 0;

Line 1009: l_segments fnd_dflex.segments_dr;

1005: l_flexfield fnd_dflex.dflex_r;
1006: l_flexinfo fnd_dflex.dflex_dr;
1007: l_contexts_info fnd_dflex.contexts_dr;
1008: l_contexts fnd_dflex.context_r;
1009: l_segments fnd_dflex.segments_dr;
1010: l_attributes_category VARCHAR2(50) :=NULL;
1011: l_global_code VARCHAR2(50);
1012: l_rec_index BINARY_INTEGER := 0;
1013:

Line 1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);

1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;
1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1076: -- Get Contexts
1077: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);
1078: --Retrieve the context column name also --bug#2474713
1079: l_context_column_name := l_flexinfo.context_column_name;

Line 1077: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);

1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;
1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1076: -- Get Contexts
1077: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);
1078: --Retrieve the context column name also --bug#2474713
1079: l_context_column_name := l_flexinfo.context_column_name;
1080: --Adding for bug 6636904
1081: l_context_prompt := l_flexinfo.form_context_prompt;

Line 1159: l_contexts := fnd_dflex.make_context(l_flexfield, l_contexts_info.context_code(i));

1155: x_lot_serial_attributes(l_rec_index).PROMPT := l_context_prompt;
1156: END IF; /*bug #2474713 */
1157:
1158: --Get segments
1159: l_contexts := fnd_dflex.make_context(l_flexfield, l_contexts_info.context_code(i));
1160: fnd_dflex.get_segments(l_contexts, l_segments, TRUE);
1161: ---dbms_output.put_line('number of segment is ' || l_segments.nsegments);
1162: IF (l_debug=1) THEN
1163: debug('No of Segments ' ||l_segments.nsegments ,l_module_name,l_debug_level);

Line 1160: fnd_dflex.get_segments(l_contexts, l_segments, TRUE);

1156: END IF; /*bug #2474713 */
1157:
1158: --Get segments
1159: l_contexts := fnd_dflex.make_context(l_flexfield, l_contexts_info.context_code(i));
1160: fnd_dflex.get_segments(l_contexts, l_segments, TRUE);
1161: ---dbms_output.put_line('number of segment is ' || l_segments.nsegments);
1162: IF (l_debug=1) THEN
1163: debug('No of Segments ' ||l_segments.nsegments ,l_module_name,l_debug_level);
1164: END IF;

Line 1580: l_context_r fnd_dflex.context_r;

1576: AND lot_number = p_lot_number;
1577:
1578: l_inv_attr inv_attr%ROWTYPE;
1579: l_context VARCHAR2(1000);
1580: l_context_r fnd_dflex.context_r;
1581: l_contexts_dr fnd_dflex.contexts_dr;
1582: l_dflex_r fnd_dflex.dflex_r;
1583: l_segments_dr fnd_dflex.segments_dr;
1584: l_global_context BINARY_INTEGER;

Line 1581: l_contexts_dr fnd_dflex.contexts_dr;

1577:
1578: l_inv_attr inv_attr%ROWTYPE;
1579: l_context VARCHAR2(1000);
1580: l_context_r fnd_dflex.context_r;
1581: l_contexts_dr fnd_dflex.contexts_dr;
1582: l_dflex_r fnd_dflex.dflex_r;
1583: l_segments_dr fnd_dflex.segments_dr;
1584: l_global_context BINARY_INTEGER;
1585: l_nsegments BINARY_INTEGER;

Line 1582: l_dflex_r fnd_dflex.dflex_r;

1578: l_inv_attr inv_attr%ROWTYPE;
1579: l_context VARCHAR2(1000);
1580: l_context_r fnd_dflex.context_r;
1581: l_contexts_dr fnd_dflex.contexts_dr;
1582: l_dflex_r fnd_dflex.dflex_r;
1583: l_segments_dr fnd_dflex.segments_dr;
1584: l_global_context BINARY_INTEGER;
1585: l_nsegments BINARY_INTEGER;
1586:

Line 1583: l_segments_dr fnd_dflex.segments_dr;

1579: l_context VARCHAR2(1000);
1580: l_context_r fnd_dflex.context_r;
1581: l_contexts_dr fnd_dflex.contexts_dr;
1582: l_dflex_r fnd_dflex.dflex_r;
1583: l_segments_dr fnd_dflex.segments_dr;
1584: l_global_context BINARY_INTEGER;
1585: l_nsegments BINARY_INTEGER;
1586:
1587: BEGIN

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

1609:
1610: x_return_status := 'S';
1611: l_dflex_r.application_id := 401;
1612: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
1613: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1614: l_global_context := l_contexts_dr.global_context;
1615: l_context := l_contexts_dr.context_code(l_global_context);
1616:
1617: /* Prepare the context_r type for getting the segments associated with the global context */

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

1617: /* Prepare the context_r type for getting the segments associated with the global context */
1618: l_context_r.flexfield := l_dflex_r;
1619: l_context_r.context_code := l_context;
1620:
1621: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
1622:
1623: /* read through the segments */
1624:
1625: l_nsegments := l_segments_dr.nsegments;

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

1646:
1647: l_context_r.flexfield := l_dflex_r;
1648: l_context_r.context_code := l_context;
1649:
1650: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
1651: l_nsegments := l_segments_dr.nsegments;
1652: FOR i IN 1..l_nsegments LOOP
1653:
1654: x_inv_lot_attributes(substr(l_segments_dr.application_column_name(i),instr(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)).column_name :=l_segments_dr.application_column_name(i);

Line 1755: l_context_r fnd_dflex.context_r;

1751:
1752: l_inv_attr inv_attr%ROWTYPE;
1753: l_inv_ship_attr inv_ship_attr%ROWTYPE;
1754: l_context VARCHAR2(1000);
1755: l_context_r fnd_dflex.context_r;
1756: l_contexts_dr fnd_dflex.contexts_dr;
1757: l_dflex_r fnd_dflex.dflex_r;
1758: l_segments_dr fnd_dflex.segments_dr;
1759: l_global_context BINARY_INTEGER;

Line 1756: l_contexts_dr fnd_dflex.contexts_dr;

1752: l_inv_attr inv_attr%ROWTYPE;
1753: l_inv_ship_attr inv_ship_attr%ROWTYPE;
1754: l_context VARCHAR2(1000);
1755: l_context_r fnd_dflex.context_r;
1756: l_contexts_dr fnd_dflex.contexts_dr;
1757: l_dflex_r fnd_dflex.dflex_r;
1758: l_segments_dr fnd_dflex.segments_dr;
1759: l_global_context BINARY_INTEGER;
1760: l_nsegments BINARY_INTEGER;

Line 1757: l_dflex_r fnd_dflex.dflex_r;

1753: l_inv_ship_attr inv_ship_attr%ROWTYPE;
1754: l_context VARCHAR2(1000);
1755: l_context_r fnd_dflex.context_r;
1756: l_contexts_dr fnd_dflex.contexts_dr;
1757: l_dflex_r fnd_dflex.dflex_r;
1758: l_segments_dr fnd_dflex.segments_dr;
1759: l_global_context BINARY_INTEGER;
1760: l_nsegments BINARY_INTEGER;
1761:

Line 1758: l_segments_dr fnd_dflex.segments_dr;

1754: l_context VARCHAR2(1000);
1755: l_context_r fnd_dflex.context_r;
1756: l_contexts_dr fnd_dflex.contexts_dr;
1757: l_dflex_r fnd_dflex.dflex_r;
1758: l_segments_dr fnd_dflex.segments_dr;
1759: l_global_context BINARY_INTEGER;
1760: l_nsegments BINARY_INTEGER;
1761:
1762: BEGIN

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

1942:
1943: x_return_status := 'S';
1944: l_dflex_r.application_id := 401;
1945: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';
1946: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1947: l_global_context := l_contexts_dr.global_context;
1948: l_context := l_contexts_dr.context_code(l_global_context);
1949:
1950: /* Prepare the context_r type for getting the segments associated with the global context */

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

1950: /* Prepare the context_r type for getting the segments associated with the global context */
1951: l_context_r.flexfield := l_dflex_r;
1952: l_context_r.context_code := l_context;
1953:
1954: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
1955: debug('after calling fnd_dflex.get_segments', 'GET_INV_SERIAL_ATTR', 9);
1956:
1957: /* read through the segments */
1958:

Line 1955: debug('after calling fnd_dflex.get_segments', 'GET_INV_SERIAL_ATTR', 9);

1951: l_context_r.flexfield := l_dflex_r;
1952: l_context_r.context_code := l_context;
1953:
1954: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
1955: debug('after calling fnd_dflex.get_segments', 'GET_INV_SERIAL_ATTR', 9);
1956:
1957: /* read through the segments */
1958:
1959: l_nsegments := l_segments_dr.nsegments;

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

1998:
1999: l_context_r.flexfield := l_dflex_r;
2000: l_context_r.context_code := l_context;
2001:
2002: fnd_dflex.get_segments(CONTEXT => l_context_r, segments => l_segments_dr, enabled_only => TRUE);
2003: l_nsegments := l_segments_dr.nsegments;
2004: FOR i IN 1..l_nsegments LOOP
2005: debug('application column name is ' || l_segments_dr.application_column_name(i), 'GET_INV_SERIAL_ATTR', 9);
2006: x_inv_serial_attributes(substr(l_segments_dr.application_column_name(i),

Line 2066: v_flexfield fnd_dflex.dflex_r;

2062: p_inventory_item_id IN NUMBER,
2063: p_lot_number IN VARCHAR2) RETURN BOOLEAN IS
2064:
2065: c_api_name CONSTANT VARCHAR2(30) := 'is_lot_attributes_required';
2066: v_flexfield fnd_dflex.dflex_r;
2067: v_flexinfo fnd_dflex.dflex_dr;
2068: v_contexts fnd_dflex.contexts_dr;
2069: v_segments fnd_dflex.segments_dr;
2070: v_attributes_category VARCHAR2(50) := NULL;

Line 2067: v_flexinfo fnd_dflex.dflex_dr;

2063: p_lot_number IN VARCHAR2) RETURN BOOLEAN IS
2064:
2065: c_api_name CONSTANT VARCHAR2(30) := 'is_lot_attributes_required';
2066: v_flexfield fnd_dflex.dflex_r;
2067: v_flexinfo fnd_dflex.dflex_dr;
2068: v_contexts fnd_dflex.contexts_dr;
2069: v_segments fnd_dflex.segments_dr;
2070: v_attributes_category VARCHAR2(50) := NULL;
2071:

Line 2068: v_contexts fnd_dflex.contexts_dr;

2064:
2065: c_api_name CONSTANT VARCHAR2(30) := 'is_lot_attributes_required';
2066: v_flexfield fnd_dflex.dflex_r;
2067: v_flexinfo fnd_dflex.dflex_dr;
2068: v_contexts fnd_dflex.contexts_dr;
2069: v_segments fnd_dflex.segments_dr;
2070: v_attributes_category VARCHAR2(50) := NULL;
2071:
2072: i BINARY_INTEGER;

Line 2069: v_segments fnd_dflex.segments_dr;

2065: c_api_name CONSTANT VARCHAR2(30) := 'is_lot_attributes_required';
2066: v_flexfield fnd_dflex.dflex_r;
2067: v_flexinfo fnd_dflex.dflex_dr;
2068: v_contexts fnd_dflex.contexts_dr;
2069: v_segments fnd_dflex.segments_dr;
2070: v_attributes_category VARCHAR2(50) := NULL;
2071:
2072: i BINARY_INTEGER;
2073: j BINARY_INTEGER;

Line 2140: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);

2136: l_lot_att_required := TRUE;
2137: ELSE
2138:
2139: -- Get flexfield
2140: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
2141:
2142: -- Get Contexts
2143: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2144:

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

2139: -- Get flexfield
2140: fnd_dflex.get_flexfield('INV', p_flex_name, v_flexfield, v_flexinfo);
2141:
2142: -- Get Contexts
2143: fnd_dflex.get_contexts(v_flexfield, v_contexts);
2144:
2145: -- Get attributes category
2146: get_context_code(
2147: context_value => v_attributes_category

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

2157: v_contexts.is_global(i))
2158: ) THEN
2159:
2160: -- Get segments
2161: fnd_dflex.get_segments(fnd_dflex.make_context(v_flexfield,
2162: v_contexts.context_code(i)), v_segments, TRUE);
2163:
2164: <>
2165: FOR j IN 1..v_segments.nsegments LOOP