1 Package PQH_DE_CASE_GROUPS_API as
2 /* $Header: pqcgnapi.pkh 120.0 2005/05/29 01:42:49 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <PQH_DE_CASE_GROUPS_API> >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API Creates the the master definition of Case Group details
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32
33
34 procedure Insert_CASE_GROUPS
35 (p_validate in boolean default false
36 ,p_effective_date in date
37 ,p_Case_Group_NUMBER In Varchar2
38 ,P_DESCRIPTION In Varchar2
39 ,p_Advanced_Pay_Grade IN Number
40 ,p_Entries_in_Minute In Varchar2
41 ,p_Period_Of_Prob_Advmnt IN Number
42 ,p_Period_Of_Time_Advmnt IN Number
43 ,p_Advancement_To IN Number
44 ,p_Advancement_Additional_pyt IN Number
45 ,p_time_advanced_pay_grade in number
46 ,p_time_advancement_to in number
47 ,p_business_group_id in number
48 ,p_time_advn_units in varchar2
49 ,p_prob_advn_units in varchar2
50 ,p_sub_csgrp_description In Varchar2
51 ,P_CASE_GROUP_ID out nocopy Number
52 ,p_object_version_number out nocopy number) ;
53
54
55
56 Procedure Update_CASE_GROUPS
57 (p_validate in boolean default false
58 ,p_effective_date in date
59 ,p_case_group_id in number
60 ,p_object_version_number in out nocopy number
61 ,p_case_group_number in varchar2 default hr_api.g_varchar2
62 ,p_description in varchar2 default hr_api.g_varchar2
63 ,p_advanced_pay_grade in number default hr_api.g_number
64 ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
65 ,p_period_of_prob_advmnt in number default hr_api.g_number
66 ,p_period_of_time_advmnt in number default hr_api.g_number
67 ,p_advancement_to in number default hr_api.g_number
68 ,p_advancement_additional_pyt in number default hr_api.g_number
69 ,p_time_advanced_pay_grade in number default hr_api.g_number
70 ,p_time_advancement_to in number default hr_api.g_number
71 ,p_business_group_id in number default hr_api.g_number
72 ,p_time_advn_units in varchar2 default hr_api.g_varchar2
73 ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
74 ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
75 );
76
77
78 procedure delete_CASE_GROUPS
79 (p_validate in boolean default false
80 ,p_CASE_GROUP_ID In Number
81 ,p_object_version_number In number);
82 --
83 end PQH_DE_CASE_GROUPS_API;