1 Package per_solutions_selected_api as
2 /* $Header: pesosapi.pkh 120.0 2005/05/31 21:24:05 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------< CREATE_SOLUTIONS_SELECTED >-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This business process adds a new selected solution record.
11 --
12 -- Prerequisites:
13 -- None
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate yes Boolean If true, the database remains
18 -- unchanged. If false the
19 -- assignment is updated in
20 -- the database.
21 -- p_solution_id yes number ID of the solution selected
22 -- p_solution_set_name yes varchar2 Solution set into which the
23 -- solution has been selected
24 -- p_user_id yes number User Id of solution selected
25 --
26 --
27 -- Post Success:
28 -- When the selected solution is valid, the API sets the following out
29 -- parameters.
30 --
31 -- Name Type Description
32 -- p_object_version_number number If p_validate is false, this
33 -- will be set to the version number
34 -- of the Selected Solution created.
35 -- If p_validate is true this
36 -- parameter will be set to null.
37 --
38 --
39 -- Post Failure:
40 -- The API does not create a Selected Solution and raises an error.
41 --
42 --
43 -- Access Status:
44 -- Public.
45 --
46 -- {End Of Comments}
47 --
48 procedure create_solutions_selected
49 (p_validate in boolean default false
50 ,p_solution_id in number
51 ,p_solution_set_name in varchar2
52 ,p_user_id in number
53 ,p_object_version_number out nocopy number
54 );
55
56 -- ----------------------------------------------------------------------------
57 -- |--------------------< UPDATE_SOLUTIONS_SELECTED >-------------------------|
58 -- ----------------------------------------------------------------------------
59 -- {Start Of Comments}
60 --
61 -- Description:
62 -- This business process updates a solution type.
63 --
64 -- Prerequisites:
65 -- The Selected Solution record must exist.
66 --
67 -- In Parameters:
68 -- Name Reqd Type Description
69 -- p_validate yes Boolean If true, the database remains
70 -- unchanged. If false the
71 -- assignment is updated in
72 -- the database.
73 -- p_solution_id yes number ID of the solution selected
74 -- p_solution_set_name yes varchar2 Solution set into which the
75 -- solution has been selected
76 -- p_user_id yes number User Id of solution selected
77 -- p_object_version_number yes number Object Version Number
78 --
79 --
80 --
81 -- Post Success:
82 -- The Selected Solution record is updated and the API sets the following out
83 -- parameters.
84 --
85 -- Name Type Description
86 -- p_object_version_number number If p_validate is false the
87 -- new version number is returned.
88 -- If p_validate is true then the
89 -- version number passed in is
90 -- returned.
91 --
92 -- Post Failure:
93 -- The API does not update a Selected Solution and raises an error.
94 --
95 --
96 -- Access Status:
97 -- Public.
98 --
99 -- {End Of Comments}
100 --
101 procedure update_solutions_selected
102 (p_validate in boolean default false
103 ,p_solution_id in number
104 ,p_solution_set_name in varchar2
105 ,p_user_id in number
106 ,p_object_version_number in out nocopy number
107 );
108
109 -- ----------------------------------------------------------------------------
110 -- |--------------------< DELETE_SOLUTIONS_SELECTED >-------------------------|
111 -- ----------------------------------------------------------------------------
112 -- {Start Of Comments}
113 --
114 -- Description:
115 -- This business process deletes a selected solution.
116 --
117 -- Prerequisites:
118 -- The Selected Solution record must exist.
119 --
120 -- In Parameters:
121 -- Name Reqd Type Description
122 -- p_validate yes Boolean If true, the database remains
123 -- unchanged. If false the
124 -- assignment is updated in
125 -- the database.
126 -- p_solution_id yes number ID of the solution selected
127 -- p_solution_set_name yes varchar2 Solution set into which the
128 -- solution has been selected
129 -- p_user_id yes number User Id of solution selected
130 -- p_object_version_number yes number Object Version Number
131 --
132 -- Post Success:
133 -- The Selected Solution is deleted.
134 --
135 -- Post Failure:
136 -- The API does not delete a Selected Solution and raises an error.
137 --
138 -- Access Status:
139 -- Public.
140 --
141 -- {End Of Comments}
142 --
143 procedure delete_solutions_selected
144 (p_validate in boolean default false
145 ,p_solution_id in number
146 ,p_solution_set_name in varchar2
147 ,p_user_id in number
148 ,p_object_version_number in number
149 );
150 --
151 end per_solutions_selected_api;