1 Package hxc_data_app_rule_usages_api as
2 /* $Header: hxcdruapi.pkh 120.0 2005/05/29 05:29:17 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_data_app_rule_usages >-----------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- This API creates the Data Approval Rule Usages.
12 --
13 -- Prerequisites:
14 --
15 -- None.
16 --
17 -- In Parameters:
18 -- Name Reqd Type Description
19 --
20 -- p_validate No boolean If TRUE then the database
21 -- remains unchanged. If FALSE
22 -- then a new Approval Comp is
23 -- created. Default is FALSE.
24 -- p_data_app_rule_usage_id Yes number Primary Key for entity
25 -- p_approval_style_id Yes number Approval Style ID
26 -- p_time_entry_rule_id Yes number Time Enty Rule ID
27 -- p_time_recipient_id No number ID of the Application to
28 -- which the data approval rule
29 -- is applicable to
30 -- p_object_version_number No number Object Version Number
31 -- p_effective_date No date Effective date
32 --
33 -- Post Success:
34 --
35 -- The OUT PARAMETERS set,after the data approval rule usage has been created
36 -- successfully,are:
37 --
38 -- Name Type Description
39 --
40 -- p_data_app_rule_usage_id number Primary key of the new
41 -- data approval rule usage
42 -- p_object_version_number number Object version number for the
43 -- new data approval rule usage
44 --
45 -- Post Failure:
46 --
47 -- The data approval rule usage will not be created and an application error
48 -- will be raised.
49 --
50 -- Access Status:
51 -- Public.
52 --
53 -- {End Of Comments}
54 --
55 procedure create_data_app_rule_usages
56 (p_validate in boolean default false
57 ,p_data_app_rule_usage_id in out nocopy number
58 ,p_object_version_number in out nocopy number
59 ,p_approval_style_id in number
60 ,p_time_entry_rule_id in number
61 ,p_time_recipient_id in number
62 ,p_effective_date in date default null
63 );
64 --
65 -- ----------------------------------------------------------------------------
66 -- |------------------------<update_data_app_rule_usages> --------------------|
67 -- ----------------------------------------------------------------------------
68 --
69 -- {Start Of Comments}
70 --
71 -- Description:
72 --
73 -- This API updates an existing Data Approval Rule Usage row
74 --
75 -- Prerequisites:
76 --
77 -- None
78 --
79 -- In Parameters:
80 -- Name Reqd Type Description
81 --
82 -- p_validate No boolean If TRUE then the database
83 -- remains unchanged. If FALSE
84 -- then a new Rule usage is
85 -- created. Default is FALSE.
86 -- p_data_app_rule_usage_id Yes number Primary Key for entity
87 -- p_approval_style_id Yes number Approval Style ID
88 -- p_time_entry_rule_id Yes number Time Entry Rule ID
89 -- p_time_recipient_id No number ID of the Application to
90 -- which the data approval rule
91 -- is applicable to
92 -- p_object_version_number No number Object Version Number
93 -- p_effective_date No date Effective date
94 --
95 -- Post Success:
96 --
97 -- when the rule usage has been updated successfully the following
98 -- out parameters are set.
99 --
100 -- Name Type Description
101 --
102 -- p_object_version_number Number Object version number for the
103 -- updated rule usage
104 --
105 -- Post Failure:
106 --
107 -- The rule usage will not be updated and an application error raised
108 --
109 -- Access Status:
110 -- Public.
111 --
112 -- {End Of Comments}
113 --
114 procedure update_data_app_rule_usages
115 (p_validate in boolean default false
116 ,p_data_app_rule_usage_id in number
117 ,p_object_version_number in out nocopy number
118 ,p_approval_style_id in number
119 ,p_time_entry_rule_id in number
120 ,p_time_recipient_id in number
121 ,p_effective_date in date default null
122 );
123 --
124 -- ----------------------------------------------------------------------------
125 -- |------------------------< delete_data_app_rule_usages >-------------------|
126 -- ----------------------------------------------------------------------------
127 --
128 -- {Start Of Comments}
129 --
130 -- Description:
131 --
132 -- This API deletes an existing Rule Usage
133 --
134 -- Prerequisites:
135 --
136 -- None
137 --
138 -- In Parameters:
139 -- Name Reqd Type Description
140 --
141 -- p_validate No boolean If TRUE then the database
142 -- remains unchanged. If FALSE
143 -- then the rule usage
144 -- is deleted. Default is FALSE.
145 -- p_data_app_rule_usage_id Yes number Primary Key for entity
146 -- p_object_version_number Yes number Object Version Number
147 --
148 -- Post Success:
149 --
150 -- when the rule usage has been deleted successfully the process
151 -- completes with success.
152 --
153 -- Post Failure:
154 --
155 -- The rule usage will not be deleted and an application error raised
156 --
157 -- Access Status:
158 -- Public.
159 --
160 -- {End Of Comments}
161 --
162 procedure delete_data_app_rule_usages
163 (p_validate in boolean default false
164 ,p_data_app_rule_usage_id in number
165 ,p_object_version_number in number
166 );
167 --
168 --
169 END hxc_data_app_rule_usages_api;