22: declare
23: init_error exception;
24: Org_Name hr_organization_units.name%TYPE;
25: Job_Name per_jobs.name%TYPE;
26: Sort_By_Meaning pa_lookups.meaning%TYPE;
27: begin
28: ORGANIZATION_ID_T:=ORGANIZATION_ID;
29: JOB_ID_T := JOB_ID;
30: /*srw.user_exit('FND SRWINIT');*/null;
42: end if;
43: C_Job := Job_Name;
44: if SORT_BY is not NULL then
45: select meaning into Sort_By_Meaning from
46: pa_lookups
47: where lookup_code = SORT_BY and
48: lookup_type = 'ASSIGNMENT SORT BY';
49: end if;
50: C_Sort_By_Meaning := Sort_By_Meaning;