[Home] [Help]
430: --
431: --
432: l_user_name ghr_pa_routing_history.user_name%TYPE;
433: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
434: l_groupbox_name ghr_groupboxes.name%TYPE;
435: l_subject varchar2(500);
436: l_line1 varchar2(500);
437: l_line2 varchar2(500);
438: l_line3 varchar2(500);
607: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
608: l_user_name ghr_pa_routing_history.user_name%TYPE;
609: l_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
610: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
611: l_groupbox_name ghr_groupboxes.name%TYPE;
612: --
613: --
614: cursor csr_pa_routing_history is
615: SELECT max(pa_routing_history_id)
622: WHERE pa_routing_history_id = l_pa_routing_history_id;
623: --
624: cursor csr_gbx_details is
625: SELECT name
626: FROM GHR_GROUPBOXES
627: WHERE GROUPBOX_ID = l_groupbox_id;
628: --
629: --
630: begin
1316: l_effective_date ghr_pa_requests.effective_date%type;
1317: l_first_noa_id ghr_pa_requests.first_noa_id%type;
1318: l_second_noa_id ghr_pa_requests.second_noa_id%type;
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;
1321: --
1322: CURSOR chk_groupbox is
1323: select name,groupbox_id,display_name from ghr_groupboxes
1324: where routing_group_id = l_routing_group_id
1319: l_noa_family_code ghr_pa_requests.noa_family_code%type;
1320: l_gbx_id ghr_groupboxes.groupbox_id%type;
1321: --
1322: CURSOR chk_groupbox is
1323: select name,groupbox_id,display_name from ghr_groupboxes
1324: where routing_group_id = l_routing_group_id
1325: and name = l_forward_to_name;
1326:
1327: CURSOR chk_groupbox_users is
1332: PERSONNELIST_FLAG,
1333: APPROVER_FLAG,
1334: REVIEWER_FLAG
1335: from ghr_groupbox_users
1336: where groupbox_id = ( select groupbox_id from ghr_groupboxes
1337: where routing_group_id = l_routing_group_id )
1338: and user_name = l_forward_to_name;
1339:
1340: