DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on INV_CACHE

Line 2078: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN

2074: l_parent_lpn := l_lpn_info.parent_lpn;
2075: END IF;
2076: --LPN STATUS project
2077:
2078: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2079: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2080: l_onhand_status_enabled := 1;
2081: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2082: l_serial_controlled := 0;

Line 2079: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN

2075: END IF;
2076: --LPN STATUS project
2077:
2078: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2079: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2080: l_onhand_status_enabled := 1;
2081: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2082: l_serial_controlled := 0;
2083: IF (l_debug = 1) THEN

Line 2081: l_default_org_status_id := inv_cache.org_rec.default_status_id ;

2077:
2078: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2079: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2080: l_onhand_status_enabled := 1;
2081: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2082: l_serial_controlled := 0;
2083: IF (l_debug = 1) THEN
2084: trace('Org is onhand status enabled');
2085: END IF;

Line 2095: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN

2091: END IF;
2092:
2093: IF (l_onhand_status_enabled = 1 )THEN
2094: l_item_info.lot_number_status := NULL;
2095: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN
2096: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2097: l_serial_controlled := 1; -- Item is serial controlled
2098: IF (l_debug = 1) THEN
2099: trace('Item is seiarl controlled so not consedring on hand status');

Line 2096: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

2092:
2093: IF (l_onhand_status_enabled = 1 )THEN
2094: l_item_info.lot_number_status := NULL;
2095: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN
2096: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2097: l_serial_controlled := 1; -- Item is serial controlled
2098: IF (l_debug = 1) THEN
2099: trace('Item is seiarl controlled so not consedring on hand status');
2100: END IF;