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.WMS_EPC_PVT dependencies on MGD_IDCOMPONENT

Line 1685: x_components OUT nocopy mgd_idcomponent_varray,

1681: p_partition_value IN NUMBER,
1682: x_gtin OUT nocopy NUMBER,
1683: x_sscc OUT nocopy NUMBER,
1684: x_gtin_serial OUT nocopy NUMBER,
1685: x_components OUT nocopy mgd_idcomponent_varray,
1686: x_return_status OUT nocopy VARCHAR2)
1687: IS
1688:
1689: l_components MGD_IDCOMPONENT_VARRAY;

Line 1689: l_components MGD_IDCOMPONENT_VARRAY;

1685: x_components OUT nocopy mgd_idcomponent_varray,
1686: x_return_status OUT nocopy VARCHAR2)
1687: IS
1688:
1689: l_components MGD_IDCOMPONENT_VARRAY;
1690:
1691: l_sscc_len NUMBER;
1692: l_gtin_len NUMBER;
1693: l_lpn_num_format NUMBER;

Line 1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000

1771: trace('p_filter_value,p_partition_value, p_company_prefix,l_item_reference,l_gtin_serial');
1772: trace(p_filter_value||','||p_partition_value||','||To_number(p_company_prefix)||','||l_item_reference||','||l_gtin_serial);
1773: END IF;
1774:
1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

Line 1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1772: trace(p_filter_value||','||p_partition_value||','||To_number(p_company_prefix)||','||l_item_reference||','||l_gtin_serial);
1773: END IF;
1774:
1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),

1773: END IF;
1774:
1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1781:

Line 1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),

1774:
1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1781:
1782:

Line 1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

1775: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1781:
1782:
1783: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN

Line 1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

1776: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1777: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1778: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1779: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1780: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1781:
1782:
1783: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
1784:

Line 1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10

1783: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
1784:
1785: --{{ get all expected components FOR EPC_SGTIN_64}}
1786: --use company-prefix -INDEX
1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1784:
1785: --{{ get all expected components FOR EPC_SGTIN_64}}
1786: --use company-prefix -INDEX
1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1792:

Line 1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),

1785: --{{ get all expected components FOR EPC_SGTIN_64}}
1786: --use company-prefix -INDEX
1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1792:
1793: END IF;

Line 1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

1786: --use company-prefix -INDEX
1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1792:
1793: END IF;
1794: --WHEN GTIN = NULL IS HANDLED IN THE EXCEPTION OF get_lpn_gtin_serial()

Line 1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

1787: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1788: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1789: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1790: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1791: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1792:
1793: END IF;
1794: --WHEN GTIN = NULL IS HANDLED IN THE EXCEPTION OF get_lpn_gtin_serial()
1795: END IF;

Line 1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001

1824: END IF;
1825: --{{ get all expected components FOR EPC_SSCC_96 for containers}}
1826: IF p_epc_rule_type = 'EPC_SSCC_96' THEN
1827: --use company-prefix
1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001
1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),

Line 1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1825: --{{ get all expected components FOR EPC_SSCC_96 for containers}}
1826: IF p_epc_rule_type = 'EPC_SSCC_96' THEN
1827: --use company-prefix
1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001
1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),
1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));

Line 1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),

1826: IF p_epc_rule_type = 'EPC_SSCC_96' THEN
1827: --use company-prefix
1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001
1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),
1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));
1834: ELSIF p_epc_rule_type = 'EPC_SSCC_64' THEN

Line 1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),

1827: --use company-prefix
1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001
1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),
1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));
1834: ELSIF p_epc_rule_type = 'EPC_SSCC_64' THEN
1835:

Line 1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),

1828: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',49,NULL), --for 00110001
1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),
1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));
1834: ELSIF p_epc_rule_type = 'EPC_SSCC_64' THEN
1835:
1836:

Line 1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));

1829: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1830: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1831: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1832: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL),
1833: MGD_IDCOMPONENT('UNALLOCATED',0,NULL));
1834: ELSIF p_epc_rule_type = 'EPC_SSCC_64' THEN
1835:
1836:
1837: --{{ get all expected components FOR EPC_SSCC_64 for containers}}

Line 1839: mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',8,NULL), --00001000

1835:
1836:
1837: --{{ get all expected components FOR EPC_SSCC_64 for containers}}
1838: l_components :=
1839: mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',8,NULL), --00001000
1840: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1841: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1842: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL));
1843:

Line 1840: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1836:
1837: --{{ get all expected components FOR EPC_SSCC_64 for containers}}
1838: l_components :=
1839: mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',8,NULL), --00001000
1840: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1841: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1842: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL));
1843:
1844:

Line 1841: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),

1837: --{{ get all expected components FOR EPC_SSCC_64 for containers}}
1838: l_components :=
1839: mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',8,NULL), --00001000
1840: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1841: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1842: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL));
1843:
1844:
1845: END IF;

Line 1842: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL));

1838: l_components :=
1839: mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',8,NULL), --00001000
1840: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1841: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1842: MGD_IDCOMPONENT('SERIALREFERENCE',l_serial_reference,NULL));
1843:
1844:
1845: END IF;
1846:

Line 1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000

1903: IF p_epc_rule_type = 'EPC_SGTIN_96' THEN
1904:
1905: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
1906: --use company-prefix
1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

Line 1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1904:
1905: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
1906: --use company-prefix
1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),

1905: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
1906: --use company-prefix
1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1913:

Line 1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),

1906: --use company-prefix
1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1913:
1914: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN

Line 1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

1907: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1913:
1914: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
1915:

Line 1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

1908: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1909: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
1910: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
1911: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1912: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1913:
1914: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
1915:
1916: IF l_debug = 1 THEN

Line 1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10

1921: END IF;
1922:
1923: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
1924: --use company-prefix -INDEX
1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

1922:
1923: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
1924: --use company-prefix -INDEX
1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1930:

Line 1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),

1923: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
1924: --use company-prefix -INDEX
1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1930:
1931:

Line 1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

1924: --use company-prefix -INDEX
1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1930:
1931:
1932: END IF;

Line 1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

1925: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
1926: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
1927: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
1928: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
1929: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
1930:
1931:
1932: END IF;
1933: --WHEN GTIN = NULL IS HANDLED IN THE EXCEPTION OF get_item_gtin_serial()

Line 2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000

2007: IF p_epc_rule_type = 'EPC_SGTIN_96' THEN
2008:
2009: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
2010: --use company-prefix
2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

Line 2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

2008:
2009: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
2010: --use company-prefix
2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),

2009: --{{ get all expected components FOR EPC_SGTIN_96 for Item}}
2010: --use company-prefix
2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2017: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN

Line 2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),

2010: --use company-prefix
2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2017: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
2018:

Line 2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

2011: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',48,NULL), --for 00110000
2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2017: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
2018:
2019: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}

Line 2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

2012: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2013: MGD_IDCOMPONENT('PARTITION',p_partition_value,NULL),
2014: MGD_IDCOMPONENT('COMPANYPREFIX',To_number(p_company_prefix),NULL),
2015: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2016: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2017: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
2018:
2019: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
2020: --use company-prefix -INDEX

Line 2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10

2017: ELSIF p_epc_rule_type = 'EPC_SGTIN_64' THEN
2018:
2019: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
2020: --use company-prefix -INDEX
2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

Line 2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),

2018:
2019: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
2020: --use company-prefix -INDEX
2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2026:

Line 2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),

2019: --{{ get all expected components FOR EPC_SGTIN_64 for Item}}
2020: --use company-prefix -INDEX
2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2026:
2027: END IF;

Line 2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),

2020: --use company-prefix -INDEX
2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2026:
2027: END IF;
2028: --WHEN GTIN = NULL IS HANDLED IN THE EXCEPTION OF

Line 2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));

2021: l_components := mgd_idcomponent_varray( MGD_IDCOMPONENT('HEADER',2,NULL),--10
2022: MGD_IDCOMPONENT('FILTERVALUE',p_filter_value,NULL),
2023: MGD_IDCOMPONENT('COMPANYPREFIXINDEX',To_number(p_comp_prefix_index),NULL),
2024: MGD_IDCOMPONENT('ITEMREFERENCE',l_item_reference,NULL),
2025: MGD_IDCOMPONENT('SERIALNUMBER',l_gtin_serial,NULL));
2026:
2027: END IF;
2028: --WHEN GTIN = NULL IS HANDLED IN THE EXCEPTION OF
2029: --get_serialnum_gtin_serial() -> get_gtin_and_gserial()

Line 2052: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',207,NULL),--11001111

2048:
2049: IF p_epc_rule_type = 'EPC_DOD_96' THEN
2050: --{{ get all expected components FOR EPC_DOD_96 for container}}
2051:
2052: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',207,NULL),--11001111
2053: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2054: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2055: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2056:

Line 2053: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),

2049: IF p_epc_rule_type = 'EPC_DOD_96' THEN
2050: --{{ get all expected components FOR EPC_DOD_96 for container}}
2051:
2052: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',207,NULL),--11001111
2053: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2054: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2055: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2056:
2057:

Line 2054: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),

2050: --{{ get all expected components FOR EPC_DOD_96 for container}}
2051:
2052: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',207,NULL),--11001111
2053: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2054: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2055: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2056:
2057:
2058: ELSIF p_epc_rule_type = 'EPC_DOD_64' THEN

Line 2055: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));

2051:
2052: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',207,NULL),--11001111
2053: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2054: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2055: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2056:
2057:
2058: ELSIF p_epc_rule_type = 'EPC_DOD_64' THEN
2059: --{{ get all expected components FOR EPC_DOD_96 for container }}

Line 2065: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',206,NULL),--11001110

2061: IF l_debug = 1 THEN
2062: trace('Inside EPC_DOD_64 to collect components');
2063: END IF;
2064:
2065: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',206,NULL),--11001110
2066: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2067: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2068: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2069:

Line 2066: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),

2062: trace('Inside EPC_DOD_64 to collect components');
2063: END IF;
2064:
2065: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',206,NULL),--11001110
2066: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2067: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2068: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2069:
2070: END IF;

Line 2067: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),

2063: END IF;
2064:
2065: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',206,NULL),--11001110
2066: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2067: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2068: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2069:
2070: END IF;
2071:

Line 2068: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));

2064:
2065: l_components := mgd_idcomponent_varray(MGD_IDCOMPONENT('HEADER',206,NULL),--11001110
2066: MGD_IDCOMPONENT('FILTER',p_filter_value,NULL),
2067: MGD_IDCOMPONENT('GOVERNMENTMANAGEDIDENTIFIER',NULL,p_cage_code),
2068: MGD_IDCOMPONENT('SERIALNUMBER',p_serial_number,NULL));
2069:
2070: END IF;
2071:
2072:

Line 2302: l_components mgd_idcomponent_varray := mgd_idcomponent_varray(mgd_idcomponent('HEADER',NULL,null));

2298: l_serial_number VARCHAR2(30);
2299: l_item_id NUMBER;
2300: l_rev VARCHAR2(3);
2301: l_bit_length NUMBER;
2302: l_components mgd_idcomponent_varray := mgd_idcomponent_varray(mgd_idcomponent('HEADER',NULL,null));
2303: pcode mgd_idcode;
2304:
2305: BEGIN
2306: