APPS.WMS_ASN_LOT_ATT dependencies on INV_LOT_SEL_ATTR

Line 372: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

368: l_shelf_life_days NUMBER;
369: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
370: l_lot_number varchar2(80);
371:
372: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
373: l_attributes_default_count NUMBER;
374: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
375:
376:

Line 374: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

370: l_lot_number varchar2(80);
371:
372: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
373: l_attributes_default_count NUMBER;
374: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
375:
376:
377: l_lot_status_enabled VARCHAR2(1);
378: l_default_lot_status_id NUMBER := NULL;

Line 620: inv_lot_sel_attr.get_default(

616: end if;
617: end loop;
618:
619: if( inv_install.adv_inv_installed(null) = true )then
620: inv_lot_sel_attr.get_default(
621: x_attributes_default => l_attributes_default,
622: x_attributes_default_count => l_attributes_default_count,
623: x_return_status => l_return_status,
624: x_msg_count => l_msg_count,

Line 716: inv_lot_sel_attr.get_context_code(x_context_value,

712: -- row, if not then get the context code
713: ---
714:
715: if g_lot_attributes_tbl(9).column_value is null then
716: inv_lot_sel_attr.get_context_code(x_context_value,
717: l_organization_id,l_inventory_item_id,l_attributes_name);
718: g_lot_attributes_tbl(9).column_value := x_context_value;
719:
720: IF (l_debug = 1) THEN

Line 1318: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

1314: l_api_name CONSTANT VARCHAR2(30):= 'insertSerial';
1315: l_userid NUMBER;
1316: l_loginid NUMBER;
1317: l_serial_control_code NUMBER;
1318: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1319: l_attributes_default_count NUMBER;
1320: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1321:
1322: l_column_idx BINARY_INTEGER := 55;

Line 1320: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

1316: l_loginid NUMBER;
1317: l_serial_control_code NUMBER;
1318: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1319: l_attributes_default_count NUMBER;
1320: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1321:
1322: l_column_idx BINARY_INTEGER := 55;
1323:
1324: l_return_status VARCHAR2(1);

Line 1567: -- call inv_lot_sel_attr.get_default to get the default value

1563: end if;
1564: end loop;
1565: end if;
1566: ----------------------------------------------------------
1567: -- call inv_lot_sel_attr.get_default to get the default value
1568: -- of the lot attributes
1569: ---------------------------------------------------------
1570:
1571: l_progress := '50';

Line 1576: inv_lot_sel_attr.get_default(

1572: IF (l_debug = 1) THEN
1573: print_debug('At Step = '|| l_progress,4);
1574: END IF;
1575:
1576: inv_lot_sel_attr.get_default(
1577: x_attributes_default => l_attributes_default,
1578: x_attributes_default_count => l_attributes_default_count,
1579: x_return_status => l_return_status,
1580: x_msg_count => l_msg_count,

Line 1695: inv_lot_sel_attr.get_context_code(x_context_value,

1691: l_progress := '90.1';
1692: IF (l_debug = 1) THEN
1693: print_debug('At Step = '|| l_progress,4);
1694: END IF;
1695: inv_lot_sel_attr.get_context_code(x_context_value,
1696: p_organization_id,p_inventory_item_id,l_attributes_name);
1697:
1698: g_serial_attributes_tbl(1).column_value := x_context_value;
1699: