[Home] [Help]
770: i number := 1;
771:
772: /*This cursor fetches all actions that are available to the current
773: person subject to various limitations around their PTU records
774: (as specified in per_form_functions). For example, a person who is
775: just an EMP will have 'Create Applicant' whereas a person who is
776: already an EMP and APL will not.
777:
778: If an action-based customized restriction exists the
780:
781: CURSOR csr_get_actions IS
782: select distinct pff.result action
783: ,hr_general.decode_lookup('HR_PTU_ACTION_TYPES',pff.result) meaning
784: from per_form_functions pff
785: where pff.form = 'PERWSEPI'
786: and pff.function = 'ACTION_RESTRICTIONS'
787: and ((p_person_id is null and pff.input is null)
788: or (p_person_id is not null