PACKAGE: APPS.GHR_MASS_CON_PROGRAM

Source

1 PACKAGE GHR_MASS_CON_PROGRAM AUTHID CURRENT_USER AS
2 /* $Header: ghmascon.pkh 120.3 2011/04/09 15:11:46 utokachi noship $ */
3 
4 type first_lac1_record is record
5 ( first_action_la_code1    ghr_pa_requests.first_action_la_code1%type,
6   first_action_la_desc1    ghr_pa_requests.first_action_la_desc1%type,
7   first_lac1_information1  ghr_pa_requests.first_lac1_information1%type,
8   first_lac1_information2  ghr_pa_requests.first_lac1_information2%type,
9   first_lac1_information3  ghr_pa_requests.first_lac1_information3%type,
10   first_lac1_information4  ghr_pa_requests.first_lac1_information4%type,
11   first_lac1_information5  ghr_pa_requests.first_lac1_information5%type);
12 
13 type first_lac2_record is record
14 ( first_action_la_code2    ghr_pa_requests.first_action_la_code2%type,
15   first_action_la_desc2    ghr_pa_requests.first_action_la_desc2%type,
16   first_lac2_information1  ghr_pa_requests.first_lac2_information1%type,
17   first_lac2_information2  ghr_pa_requests.first_lac2_information2%type,
18   first_lac2_information3  ghr_pa_requests.first_lac2_information3%type,
19   first_lac2_information4  ghr_pa_requests.first_lac2_information4%type,
20   first_lac2_information5  ghr_pa_requests.first_lac2_information5%type);
21 
22 PROCEDURE get_furlough_rtd_lac
23 (
24  p_noa_action        in      VARCHAR2,
25  p_pay_plan          in	     VARCHAR2,
26  p_effective_date    in      date,
27  p_first_lac1_record out nocopy     first_lac1_record,
28  p_first_lac2_record out nocopy     first_lac2_record
29 ) ;
30 
31 Procedure create_remarks
32 	(p_noa_action		in  VARCHAR2,
33 	 p_effective_date       in  date,
34     p_person_id    IN number,
35 	 p_pa_request_id        in  ghr_pa_requests.pa_request_id%type,
36 	 p_work_schedule	IN  ghr_pa_requests.work_schedule%type,
37 	 p_fegli		IN  VARCHAR2,
38 	 p_fehb_plan		IN  VARCHAR2,
39 	 p_prd			IN  VARCHAR2
40 	);
41 PROCEDURE main_concurrent_program
42 (   p_errbuf     OUT NOCOPY VARCHAR2,
43     p_retcode    OUT NOCOPY NUMBER,
44 		p_effective_date    in      varchar2,
45 		p_noa_action        in      ghr_nature_of_actions.code%type,
46     p_nte_date          in      varchar2,
47     p_business_group_id in 			Number,
48 		p_agency            in      varchar2
49 ) ;
50 
51 Procedure build_rpa
52 ( p_noa_action        in      VARCHAR2,
53  p_rpa_type          in      ghr_pa_requests.rpa_type%TYPE,
54  p_effective_date    in      date,
55  p_nte_date          in      varchar2,
56  p_person_id         in      per_people_f.person_id%TYPE,
57  p_assignment_id     in      per_assignments_f.assignment_id%TYPE,
58  p_position_id       in      hr_positions_f.position_id%TYPE,
59  p_location_id       in      hr_locations.location_id%TYPE,
60  p_business_group_id  in      number,
61  p_errbuf            out nocopy      varchar2, --\   error log
62  p_status            out nocopy      varchar2, --||
63  p_retcode           out nocopy      number
64 );
65 PROCEDURE get_pa_request_id_ovn
66 (
67  p_pa_request_id         in      ghr_pa_requests.pa_request_id%TYPE,
68  p_effective_date        in      date,
69  p_person_id             in      per_people_f.person_id%TYPE,
70  p_pa_notification_id    out nocopy      ghr_pa_requests.pa_notification_id%TYPE,
71  p_rpa_type              out nocopy      ghr_pa_requests.rpa_type%TYPE,
72  p_object_version_number out nocopy      ghr_pa_requests.object_version_number%TYPE
73 );
74 procedure marpa_process
75 (
76  p_noa_action       in      VARCHAR2,
77  p_rpa_type          in      ghr_pa_requests.rpa_type%TYPE,
78  p_effective_date    in      date,
79  p_person_id         in      per_people_f.person_id%TYPE,
80  p_pa_request_rec    in out nocopy  ghr_pa_requests%rowtype ,
81  p_log_text          out nocopy     varchar2
82 );
83 
84 
85 Procedure create_shadow_row ( p_rpa_data in  ghr_pa_requests%rowtype);
86 
87 Procedure update_shadow_row ( p_rpa_data in  ghr_pa_requests%rowtype,
88                               p_result   out nocopy  Boolean );
89 
90 END GHR_MASS_CON_PROGRAM;