DBA Data[Home] [Help]

APPS.INVPAGI2 dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 220: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;

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

Line 936: FROM hr_all_organization_units_vl

932: exception
933: WHEN NO_DATA_FOUND then
934: BEGIN
935: SELECT name INTO l_org_name
936: FROM hr_all_organization_units_vl
937: WHERE organization_id = cr.organization_id;
938: EXCEPTION
939: WHEN OTHERS THEN
940: l_org_name := cr.organization_id;