DBA Data[Home] [Help]

PACKAGE: APPS.GHR_GENERAL

Source


1 PACKAGE ghr_general AUTHID CURRENT_USER AS
2 /* $Header: ghgenral.pkh 120.0 2005/05/29 03:12:56 appldev noship $ */
3 --
4 --
5 FUNCTION return_number(p_value varchar2) RETURN number;
6 FUNCTION return_rif_date(p_value varchar2) RETURN date;
7 --
8 FUNCTION get_remark_code(p_remark_id IN ghr_remarks.code%type)
9           RETURN varchar2;
10 pragma restrict_references (get_remark_code, WNDS,WNPS);
11 --
12 Procedure get_poi_to_send_ntfn
13 (
14 Itemtype in varchar2,
15 Itemkey  in varchar2,
16 actid    in number,
17 funcmode in varchar2,
18 result out NOCOPY varchar2
19 );
20 
21     Procedure ghr_tsp_migrate(
22         p_assignment_id     in per_assignments_f.assignment_id%type,
23         p_opt_name          in Varchar2,
24         p_opt_val           in Number,
25         p_effective_date    in Date,
26         p_business_group_id in per_assignments_f.business_group_id%type,
27         p_person_id         in per_assignments_f.person_id%type);
28 
29     Procedure ghr_tsp_catchup_migrate(
30         p_assignment_id     in per_assignments_f.assignment_id%type,
31         p_opt_name          in Varchar2,
32         p_opt_val           in Number,
33         p_effective_date    in Date,
34         p_business_group_id in per_assignments_f.business_group_id%type,
35         p_person_id         in per_assignments_f.person_id%type);
36 
37     Procedure ghr_fehb_migrate(
38         p_assignment_id      in per_assignments_f.assignment_id%type,
39         p_business_group_id  in per_assignments_f.business_group_id%type,
40         p_person_id          in per_assignments_f.person_id%type,
41         p_effective_date     in Date    ,
42         p_health_plan        in ben_pl_f.short_code%type,
43         p_option_code        in ben_opt_f.short_code%type,
44         p_element_entry_id   in pay_element_entries_f.element_entry_id%type,
45         p_object_version_number   in pay_element_entries_f.object_version_number%type,
46         p_temps_cost         in pay_element_entry_values_f.screen_entry_value%type);
47 End ghr_general;