1 Package hxc_approval_period_sets_api as
2 /* $Header: hxcaprpsapi.pkh 120.0 2005/05/29 06:12:38 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_approval_period_sets >-----------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- This API creates the Approval Period Sets.
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 Period Set
23 -- is created. Default is FALSE.
24 -- p_approval_period_set_id Yes number Primary Key for entity
25 -- p_object_version_number No number Object Version Number
26 -- p_name Yes varchar2 Approval Period Set Name
27 --
28 -- Post Success:
29 --
30 -- The OUT PARAMETERS set,after the approval period set has been created
31 -- successfully,are:
32 --
33 -- Name Type Description
34 --
35 -- p_approval_period_set_id number Primary key of the new
36 -- approval period set
37 -- p_object_version_number number Object version number for the
38 -- new approval period set
39 --
40 -- Post Failure:
41 --
42 -- The approval set will not be created and an application error will be
43 -- raised.
44 --
45 -- Access Status:
46 -- Public.
47 --
48 -- {End Of Comments}
49 --
50 procedure create_approval_period_sets
51 (p_validate in boolean default false
52 ,p_approval_period_set_id in out nocopy number
53 ,p_object_version_number in out nocopy number
54 ,p_name in varchar2
55 -- ,p_effective_date in date default null
56 );
57 --
58 -- ----------------------------------------------------------------------------
59 -- |------------------------<update_approval_period_sets>---------------------|
60 -- ----------------------------------------------------------------------------
61 --
62 -- {Start Of Comments}
63 --
64 -- Description:
65 --
66 -- This API updates an existing Approval Period Sets
67 --
68 -- Prerequisites:
69 --
70 -- None
71 --
72 -- In Parameters:
73 -- Name Reqd Type Description
74 --
75 -- p_validate No boolean If TRUE then the database
76 -- remains unchanged. If FALSE
77 -- then the approval set
78 -- is updated. Default is FALSE.
79 -- p_approval_period_set_id Yes number Primary Key for entity
80 -- p_object_version_number No number Object Version Number
81 -- p_name Yes varchar2 Approval Period Set Name
82 --
83 -- Post Success:
84 --
85 -- when the approval set has been updated successfully the following
86 -- out parameters are set.
87 --
88 -- Name Type Description
89 --
90 -- p_object_version_number Number Object version number for the
91 -- updated approval set
92 --
93 -- Post Failure:
94 --
95 -- The approval set will not be updated and an application error raised
96 --
97 -- Access Status:
98 -- Public.
99 --
100 -- {End Of Comments}
101 --
102 procedure update_approval_period_sets
103 (p_validate in boolean default false
104 ,p_approval_period_set_id in number
105 ,p_object_version_number in out nocopy number
106 ,p_name in varchar2
107 -- ,p_effective_date in date default null
108 );
109 --
110 -- ----------------------------------------------------------------------------
111 -- |------------------------< delete_approval_period_sets >-------------------|
112 -- ----------------------------------------------------------------------------
113 --
114 -- {Start Of Comments}
115 --
116 -- Description:
117 --
118 -- This API deletes an existing Approval Period Sets
119 --
120 -- Prerequisites:
121 --
122 -- None
123 --
124 -- In Parameters:
125 -- Name Reqd Type Description
126 --
127 -- p_validate No boolean If TRUE then the database
128 -- remains unchanged. If FALSE
129 -- then the approval set
130 -- is deleted. Default is FALSE.
131 -- p_approval_period_set_id Yes number Primary Key for entity
132 -- p_object_version_number Yes number Object Version Number
133 --
134 -- Post Success:
135 --
136 -- when the approval set has been deleted successfully the process
137 -- completes with success.
138 --
139 -- Post Failure:
140 --
141 -- The approval set will not be deleted and an application error raised
142 --
143 -- Access Status:
144 -- Public.
145 --
146 -- {End Of Comments}
147 --
148 procedure delete_approval_period_sets
149 (p_validate in boolean default false
150 ,p_approval_period_set_id in number
151 ,p_object_version_number in number
152 );
153 --
154 --
155 END hxc_approval_period_sets_api;