APPS.WMS_PACKING_WORKBENCH_PVT dependencies on INV_LOT_SEL_ATTR

Line 9: g_lot_ser_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

5: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_PACKING_WORKBENCH_PVT';
6: g_pkg_version CONSTANT VARCHAR2(100) := '$Header: WMSPACVB.pls 120.13.12010000.3 2008/12/23 07:22:32 schiluve ship $';
7:
8: -- Lot Serial Attributes
9: g_lot_ser_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
10: G_DATE_MASK VARCHAR2(100) := 'YYYY/MM/DD';
11:
12: g_kit_count_current_comp NUMBER :=0 ;
13:

Line 1822: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

1818: ) IS
1819: l_table_name VARCHAR2(30);
1820: l_flex_name VARCHAR2(30);
1821:
1822: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1823: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1824: l_context_code varchar2(30);
1825: l_count number;
1826: l_return_status VARCHAR2(1);

Line 1823: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

1819: l_table_name VARCHAR2(30);
1820: l_flex_name VARCHAR2(30);
1821:
1822: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1823: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1824: l_context_code varchar2(30);
1825: l_count number;
1826: l_return_status VARCHAR2(1);
1827: l_msg_count NUMBER;

Line 1848: INV_LOT_SEL_ATTR.get_context_code(

1844: END IF;
1845:
1846: g_lot_ser_attr.delete;
1847:
1848: INV_LOT_SEL_ATTR.get_context_code(
1849: context_value => l_context_code
1850: , org_id => p_organization_id
1851: , item_id => p_inventory_item_id
1852: , flex_name => l_flex_name);

Line 1856: INV_LOT_SEL_ATTR.get_default(

1852: , flex_name => l_flex_name);
1853: IF l_debug = 1 THEN
1854: trace(' Got context_code = '||l_context_code);
1855: END IF;
1856: INV_LOT_SEL_ATTR.get_default(
1857: x_attributes_default => l_attr_list
1858: , x_attributes_default_count => l_count
1859: , x_return_status => l_return_status
1860: , x_msg_count => l_msg_count

Line 1872: trace('Error in INV_LOT_SEL_ATTR.get_default,msg_data='||l_msg_data);

1868: , p_attributes => l_null_attr);
1869:
1870: IF l_return_status <> 'S' THEN
1871: IF l_debug = 1 THEN
1872: trace('Error in INV_LOT_SEL_ATTR.get_default,msg_data='||l_msg_data);
1873: END IF;
1874: RETURN ;
1875: END IF;
1876: FOR i IN 1..l_attr_list.count Loop