1 package ben_cwb_change_access as
2 /* $Header: bencwbca.pkh 120.1 2006/12/01 06:15:27 ddeb noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< update_access >------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API is used internally for Compensation Change Access functionality
11 -- for update of Access for the targetted popultaion.
12 --
13 -- Prerequisites:
14 -- The persons record identified by p_group_per_in_ler_id must already exists.
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_validate No boolean If true, the database
19 -- remains unchanged. If false
20 -- then the person will be
21 -- updated.
22 -- p_popl_cd Yes varchar Decideds the population to be
23 -- to be affected.
24 -- Possible Values:
25 -- D - Direct Managers
26 -- A - All Managers
27 -- H - Selection from HGrid
28 -- S - Selection from Search
29 -- p_group_per_in_ler_id No varchar Manager's Group Per In Ler Id
30 -- Should be Null if p_popl_cd
31 -- equals D or A.
32 -- p_group_pl_id Yes number Group Plan Id
33 -- p_group_oipl_id Yes number For Group Plan Level Access
34 -- will be always '-1'
35 -- p_access_cd_from Yes number Filtering choosen population
36 -- Possible Values:
37 -- 'ANY' - Default
38 -- 'RO' - Read Only
39 -- 'UP' - Updateable
40 -- 'NA' - Not Available
41 -- p_access_cd_to Yes varchar Target Access Code.
42 -- p_cascade No varchar This will only be populated
43 -- if p_popl_cd = 'S'
44 -- p_comments No varchar User comments for Notification
45 -- p_acting_person_id Yes varchar Acting Manager's Person Id
46 -- To be used for Notification
47 -- p_grp_pl_name Yes varchar Group Plan Name
48 -- To be used for Notification
49 -- p_grp_pl_strt_dt Yes varchar Group Plan For Start Date
50 -- To be used for Notification
51 -- p_grp_pl_end_dt Yes varchar Group Plan For End Date
52 -- To be used for Notification
53 -- Post Success:
54 -- The API will set the following out parameters:
55 --
56 -- Name Type Description
57 -- p_return_status number Managers Ler Id
58 --
59 -- p_throw_exp varchar Returns 'Y' if some accesses were not changed
60 --
61 -- Post Failure:
62 -- None
63 --
64 -- Access Status:
65 -- Public
66 --
67 -- {End Of Comments}
68
69 PROCEDURE update_access (
70 p_validate in boolean default false
71 ,p_popl_cd in varchar2
72 ,p_group_per_in_ler_id in BEN_CWB_ACCESS_STRING_ARRAY default null
73 ,p_group_pl_id in number
74 ,p_group_oipl_id in number
75 ,p_access_cd_from in varchar2 default 'ANY'
76 ,p_access_cd_to in varchar2
77 ,p_cascade in varchar2 default 'N'
78 ,p_comments in varchar2 default null
79 ,p_acting_person_id in number
80 ,p_grp_pl_name in varchar2
81 ,p_grp_pl_for_strt_dt in varchar2
82 ,p_grp_pl_for_end_dt in varchar2
83 ,p_return_status out nocopy number
84 ,p_requestor_name in varchar2
85 ,p_throw_exp out nocopy varchar2
86 );
87
88 END ben_cwb_change_access;