[Home] [Help]
18: l_from_name varchar2(500);
19: l_forward_from_display_name varchar2(100);
20: l_load_form varchar2(100);
21: l_load_pdrh varchar2(100);
22: l_category ghr_position_descriptions.category%TYPE;
23: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
24: l_grade_level ghr_pd_classifications.grade_level%TYPE;
25: l_official_title ghr_pd_classifications.official_title%TYPE;
26:
147: funcmode in varchar2,
148: result in OUT NOCOPY varchar2) is
149: --
150: --
151: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
152: l_result VARCHAR2(4000);
153: --
154: begin
155: -- NOCOPY Changes
196: l_user_name ghr_pd_routing_history.user_name%TYPE;
197: l_from_name VARCHAR2(500);
198: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
199: l_groupbox_name ghr_groupboxes.name%TYPE;
200: l_category ghr_position_descriptions.category%TYPE;
201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;
204: --
207: l_current_status ghr_pd_routing_history.action_taken%TYPE;
208: l_date_initiated varchar2(15);
209: l_date_received varchar2(15);
210: l_routing_group varchar2(500);
211: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
212: l_result Varchar2(4000);
213: --
214: begin
215: --
442: p_date_inititated OUT NOCOPY varchar2,
443: p_date_received OUT NOCOPY varchar2
444: ) is
445: -- Local variables
446: l_category ghr_position_descriptions.category%TYPE;
447: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
449: l_grade_level ghr_pd_classifications.grade_level%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
458: l_date_initiated ghr_pd_routing_history.date_notification_sent%TYPE;
459: l_date_received ghr_pd_routing_history.date_notification_sent%TYPE;
460: l_date_notification_sent ghr_pd_routing_history.date_notification_sent%TYPE;
461: --
462: l_routing_group_id ghr_position_descriptions.routing_group_id%TYPE;
463: l_routing_group_name ghr_routing_groups.name%TYPE;
464: l_count integer;
465: --
466: --
465: --
466: --
467: cursor csr_pd_details is
468: SELECT category, routing_group_id
469: FROM ghr_position_descriptions
470: WHERE position_description_id = p_position_description_id;
471: --
472: cursor csr_pdc is
473: SELECT count(*)
637: --
638: PROCEDURE get_routing_group_details (
639: p_user_name IN fnd_user.user_name%TYPE
640: ,p_position_description_id IN
641: ghr_position_descriptions.position_description_id%TYPE
642: ,p_routing_group_id IN OUT NOCOPY NUMBER
643: ,p_initiator_flag IN OUT NOCOPY VARCHAR2
644: ,p_requester_flag IN OUT NOCOPY VARCHAR2
645: ,p_authorizer_flag IN OUT NOCOPY VARCHAR2
660: WHERE use.user_name = p_user_name
661: AND pei.person_id = use.employee_id
662: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
663: AND pei.pei_information3 = (SELECT routing_group_id from
664: GHR_POSITION_DESCRIPTIONS
665: WHERE position_description_id = p_position_description_id);
666:
667: -- NOCOPY CHANGES
668: l_routing_group_id NUMBER(20);
750: result in OUT NOCOPY varchar2) is
751: --
752: --
753: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
754: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
755: l_load_form varchar2(100);
756: l_result VARCHAR2(4000);
757: --
758: cursor csr_pdh is