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