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.INVKBCGN dependencies on FND_FLEX_EXT

Line 1568: seg_low fnd_flex_ext.SegmentArray;

1564: v_proj_ref_enabled Number := Null;
1565: Rec Boolean := FALSE;
1566: comma varchar2(1) := '''';
1567:
1568: seg_low fnd_flex_ext.SegmentArray;
1569: seg_high fnd_flex_ext.SegmentArray;
1570:
1571: Cursor CUR1(v_struct_num Number) is
1572: select a.application_column_name, b.format_type

Line 1569: seg_high fnd_flex_ext.SegmentArray;

1565: Rec Boolean := FALSE;
1566: comma varchar2(1) := '''';
1567:
1568: seg_low fnd_flex_ext.SegmentArray;
1569: seg_high fnd_flex_ext.SegmentArray;
1570:
1571: Cursor CUR1(v_struct_num Number) is
1572: select a.application_column_name, b.format_type
1573: from FND_ID_FLEX_SEGMENTS_VL a, FND_FLEX_VALUE_SETS b

Line 1596: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);

1592: Select project_reference_enabled into v_proj_ref_enabled
1593: from MTL_PARAMETERS
1594: where organization_id = X_org_id;
1595:
1596: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1597:
1598: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1599: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1600:

Line 1598: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);

1594: where organization_id = X_org_id;
1595:
1596: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1597:
1598: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1599: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1600:
1601:
1602: -- bug 4662395 set the profile mfg_organization_id so

Line 1599: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);

1595:
1596: v_delim := fnd_flex_ext.get_delimiter('INV','MTLL', v_flex_num);
1597:
1598: v_num := fnd_flex_ext.breakup_segments( X_locator_lo, v_delim, seg_low);
1599: v_num := fnd_flex_ext.breakup_segments( X_locator_hi, v_delim, seg_high);
1600:
1601:
1602: -- bug 4662395 set the profile mfg_organization_id so
1603: -- the call to MTL_PROJECT_V will return data.

Line 1693: seg_low fnd_flex_ext.SegmentArray;

1689: v_flex_num Number := Null;
1690: Rec Boolean := FALSE;
1691: comma varchar2(1) := '''';
1692:
1693: seg_low fnd_flex_ext.SegmentArray;
1694: seg_high fnd_flex_ext.SegmentArray;
1695:
1696:
1697:

Line 1694: seg_high fnd_flex_ext.SegmentArray;

1690: Rec Boolean := FALSE;
1691: comma varchar2(1) := '''';
1692:
1693: seg_low fnd_flex_ext.SegmentArray;
1694: seg_high fnd_flex_ext.SegmentArray;
1695:
1696:
1697:
1698: Cursor CUR1(v_struct_num Number) is

Line 1718: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);

1714: Select id_flex_num into v_flex_num
1715: from fnd_id_flex_structures
1716: where id_flex_code = 'MSTK';
1717:
1718: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1719: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1720: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1721:
1722: -- Building the where clause

Line 1719: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);

1715: from fnd_id_flex_structures
1716: where id_flex_code = 'MSTK';
1717:
1718: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1719: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1720: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1721:
1722: -- Building the where clause
1723:

Line 1720: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);

1716: where id_flex_code = 'MSTK';
1717:
1718: v_delim := fnd_flex_ext.get_delimiter('INV','MSTK',v_flex_num);
1719: v_num := fnd_flex_ext.breakup_segments( X_item_lo, v_delim, seg_low);
1720: v_num := fnd_flex_ext.breakup_segments( X_item_hi, v_delim, seg_high);
1721:
1722: -- Building the where clause
1723:
1724: for CUR2 in CUR1(v_flex_num) Loop

Line 1922: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);

1918: -- the call to MTL_PROJECT_V will return data.
1919:
1920: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1921:
1922: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);
1923:
1924: str1 := '||'''||v_delim||'''||';
1925:
1926: for CUR2 in CUR1(v_flex_code) Loop