[Home] [Help]
27:
28: declare
29:
30: init_error exception;
31: Org_Name hr_organization_units.name%TYPE;
32: Sort_By_Name pa_lookups.meaning%TYPE;
33:
34: begin
35:
38:
39:
40: if START_ORG_ID is not NULL then
41: select substr(name,1,60) into Org_Name from
42: hr_organization_units
43: where organization_id = START_ORG_ID;
44: end if;
45: C_Org_Name := Org_Name;
46: if SORT_BY is not NULL then