1 Package pqh_rule_sets_swi As
2 /* $Header: pqrstswi.pkh 120.0 2005/05/29 02:39:28 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_rule_set >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_rule_sets_api.create_rule_set
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_rule_set
27 (p_validate in number default hr_api.g_false_num
28 ,p_business_group_id in number default null
29 ,p_rule_set_id out nocopy number
30 ,p_rule_set_name in varchar2
31 ,p_description in varchar2
32 ,p_organization_structure_id in number default null
33 ,p_organization_id in number default null
34 ,p_referenced_rule_set_id in number default null
35 ,p_rule_level_cd in varchar2 default null
36 ,p_object_version_number out nocopy number
37 ,p_short_name in varchar2
38 ,p_effective_date in date
39 ,p_language_code in varchar2 default hr_api.userenv_lang
40 ,p_rule_applicability in varchar2
41 ,p_rule_category in varchar2
42 ,p_starting_organization_id in number default null
43 ,p_seeded_rule_flag in varchar2 default 'N'
44 ,p_status in varchar2 default null
45 ,p_return_status out nocopy varchar2
46 );
47 -- ----------------------------------------------------------------------------
48 -- |----------------------------< delete_rule_set >---------------------------|
49 -- ----------------------------------------------------------------------------
50 -- {Start of comments}
51 --
52 -- Description:
53 -- This procedure is the self-service wrapper procedure to the following
54 -- API: pqh_rule_sets_api.delete_rule_set
55 --
56 -- Pre-requisites
57 -- All 'IN' parameters to this procedure have been appropriately derived.
58 --
59 -- Post Success:
60 -- p_return_status will return value indicating success.
61 --
62 -- Post Failure:
63 -- p_return_status will return value indication failure.
64 --
65 -- Access Status:
66 -- Internal Development use only.
67 --
68 -- {End of comments}
69 -- ----------------------------------------------------------------------------
70 PROCEDURE delete_rule_set
71 (p_validate in number default hr_api.g_false_num
72 ,p_rule_set_id in number
73 ,p_object_version_number in number
74 ,p_effective_date in date
75 ,p_return_status out nocopy varchar2
76 );
77 -- ----------------------------------------------------------------------------
78 -- |----------------------------< update_rule_set >---------------------------|
79 -- ----------------------------------------------------------------------------
80 -- {Start of comments}
81 --
82 -- Description:
83 -- This procedure is the self-service wrapper procedure to the following
84 -- API: pqh_rule_sets_api.update_rule_set
85 --
86 -- Pre-requisites
87 -- All 'IN' parameters to this procedure have been appropriately derived.
88 --
89 -- Post Success:
90 -- p_return_status will return value indicating success.
91 --
92 -- Post Failure:
93 -- p_return_status will return value indication failure.
94 --
95 -- Access Status:
96 -- Internal Development use only.
97 --
98 -- {End of comments}
99 -- ----------------------------------------------------------------------------
100 PROCEDURE update_rule_set
101 (p_validate in number default hr_api.g_false_num
102 ,p_business_group_id in number default hr_api.g_number
103 ,p_rule_set_id in number
104 ,p_rule_set_name in varchar2 default hr_api.g_varchar2
105 ,p_description in varchar2 default hr_api.g_varchar2
106 ,p_organization_structure_id in number default hr_api.g_number
107 ,p_organization_id in number default hr_api.g_number
108 ,p_referenced_rule_set_id in number default hr_api.g_number
109 ,p_rule_level_cd in varchar2 default hr_api.g_varchar2
110 ,p_object_version_number in out nocopy number
111 ,p_short_name in varchar2 default hr_api.g_varchar2
112 ,p_effective_date in date
113 ,p_language_code in varchar2 default hr_api.userenv_lang
114 ,p_rule_applicability in varchar2 default hr_api.g_varchar2
115 ,p_rule_category in varchar2 default hr_api.g_varchar2
116 ,p_starting_organization_id in number default hr_api.g_number
117 ,p_seeded_rule_flag in varchar2 default hr_api.g_varchar2
118 ,p_status in varchar2 default hr_api.g_varchar2
119 ,p_return_status out nocopy varchar2
120 );
121 end pqh_rule_sets_swi;