DBA Data[Home] [Help]

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.18.12020000.4 2012/08/09 06:23:00 zzyan 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 1893: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

1889: ) IS
1890: l_table_name VARCHAR2(30);
1891: l_flex_name VARCHAR2(30);
1892:
1893: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1894: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1895: l_context_code varchar2(30);
1896: l_count number;
1897: l_return_status VARCHAR2(1);

Line 1894: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;

1890: l_table_name VARCHAR2(30);
1891: l_flex_name VARCHAR2(30);
1892:
1893: l_attr_list INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1894: l_null_attr INV_LOT_SEL_ATTR.lot_sel_attributes_tbl_type;
1895: l_context_code varchar2(30);
1896: l_count number;
1897: l_return_status VARCHAR2(1);
1898: l_msg_count NUMBER;

Line 1919: INV_LOT_SEL_ATTR.get_context_code(

1915: END IF;
1916:
1917: g_lot_ser_attr.delete;
1918:
1919: INV_LOT_SEL_ATTR.get_context_code(
1920: context_value => l_context_code
1921: , org_id => p_organization_id
1922: , item_id => p_inventory_item_id
1923: , flex_name => l_flex_name);

Line 1927: INV_LOT_SEL_ATTR.get_default(

1923: , flex_name => l_flex_name);
1924: IF l_debug = 1 THEN
1925: trace(' Got context_code = '||l_context_code);
1926: END IF;
1927: INV_LOT_SEL_ATTR.get_default(
1928: x_attributes_default => l_attr_list
1929: , x_attributes_default_count => l_count
1930: , x_return_status => l_return_status
1931: , x_msg_count => l_msg_count

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

1939: , p_attributes => l_null_attr);
1940:
1941: IF l_return_status <> 'S' THEN
1942: IF l_debug = 1 THEN
1943: trace('Error in INV_LOT_SEL_ATTR.get_default,msg_data='||l_msg_data);
1944: END IF;
1945: RETURN ;
1946: END IF;
1947: FOR i IN 1..l_attr_list.count Loop