79: return(l_print_type);
80: end get_PRINT_TYPE;
81: --------------------------------------------------------------------------------
82: function get_ORG_NAME return varchar2 is
83: l_org_id HR_OPERATING_UNITS.organization_id%TYPE := null;
84: l_org_name HR_OPERATING_UNITS.name%TYPE := null;
85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name
80: end get_PRINT_TYPE;
81: --------------------------------------------------------------------------------
82: function get_ORG_NAME return varchar2 is
83: l_org_id HR_OPERATING_UNITS.organization_id%TYPE := null;
84: l_org_name HR_OPERATING_UNITS.name%TYPE := null;
85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name
88: into l_org_name
85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name
88: into l_org_name
89: from hr_operating_units
90: where organization_id = l_org_id;
91: return(l_org_name);
92: exception
93: WHEN no_data_found THEN