DBA Data[Home] [Help]

APPS.INVPAGI2 dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 217: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;

213: l_item_number mtl_system_items_interface.item_number%TYPE;
214: l_item_id mtl_system_items_interface.inventory_item_id%TYPE;
215: l_Itemid_error BOOLEAN := FALSE;
216:
217: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;
218: l_msg_text fnd_new_messages.message_text%TYPE;
219:
220: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
221: l_ret_status VARCHAR2(1);

Line 887: FROM hr_all_organization_units_vl

883: exception
884: WHEN NO_DATA_FOUND then
885: BEGIN
886: SELECT name INTO l_org_name
887: FROM hr_all_organization_units_vl
888: WHERE organization_id = cr.organization_id;
889: EXCEPTION
890: WHEN OTHERS THEN
891: l_org_name := cr.organization_id;