1 Package PQH_RANK_PROCESS_API as
2 /* $Header: pqrnkapi.pkh 120.1 2005/06/03 11:58:28 nsanghal noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_rank_process >-----------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 --
12 --
13 -- Prerequisites:
14 --
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_validate No boolean Commit or rollback
19 -- p_effective_date Yes date effective date
20 --
21 --
22 --
23 -- Post Success:
24 --
25 -- Out Parameters:
26 -- Name Type Description
27 -- p_rank_process_id number primary key
28 -- p_object_version_number number object version number
29 --
30 -- Post Failure:
31 --
32 --
33 -- Access Status:
34 -- Public.
35 --
36 -- {End Of Comments}
37 --
38 procedure create_rank_process
39 (p_validate in boolean default false
40 ,p_effective_date in date
41 ,p_rank_process_id out nocopy number
42 ,p_pgm_id in number default null
43 ,p_pl_id in number default null
44 ,p_oipl_id in number default null
45 ,p_process_cd in varchar2
46 ,p_process_date in date
47 ,p_benefit_action_id in number default null
48 ,p_person_id in number
49 ,p_assignment_id in number
50 ,p_total_score in number default null
51 ,p_request_id in number default null
52 ,p_business_group_id in number default null
53 ,p_object_version_number out nocopy number
54 ,p_per_in_ler_id in number default null
55 );
56 --
57 -- ----------------------------------------------------------------------------
58 -- |----------------------------< update_rank_process >-----------------------|
59 -- ----------------------------------------------------------------------------
60 procedure update_rank_process
61 (p_validate in boolean default false
62 ,p_effective_date in date
63 ,p_rank_process_id in number
64 ,p_pgm_id in number default hr_api.g_number
65 ,p_pl_id in number default hr_api.g_number
66 ,p_oipl_id in number default hr_api.g_number
67 ,p_process_cd in varchar2
68 ,p_process_date in date
69 ,p_benefit_action_id in number default hr_api.g_number
70 ,p_person_id in number
71 ,p_assignment_id in number
72 ,p_total_score in number default hr_api.g_number
73 ,p_request_id in number default hr_api.g_number
74 ,p_business_group_id in number default hr_api.g_number
75 ,p_object_version_number in out nocopy number
76 ,p_per_in_ler_id in number default hr_api.g_number
77 );
78 --
79 -- ----------------------------------------------------------------------------
80 -- |----------------------------< delete_rank_process >-----------------------|
81 -- ----------------------------------------------------------------------------
82 procedure delete_rank_process
83 (p_validate in boolean default false
84 ,p_effective_date in date
85 ,p_rank_process_id in number
86 ,p_object_version_number in number
87 );
88 --
89 end pqh_rank_process_api;
[Home] [Help]