1 Package hxc_seeddata_by_level_api as
2 /* $Header: hxchsdapi.pkh 120.0 2005/05/29 05:40:52 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< create_seed_data_by_level >----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API creates the Seed Data Levels.
11 --
12 -- Prerequisites:
13 -- None
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate No If p_validate is true then
18 -- the database remains unchanged.
19 -- If false, then a seed data level
20 -- is created. Default is False.
21 -- p_object_type Yes The object_type identifies the type
22 -- of seed data for which the level is
23 -- specified. The object_type must be
24 -- one of the lookup codes
25 -- corresponding to the lookup type
26 -- 'HXC_SEED_DATA_REFERENCE'
27 -- p_object_id Yes Object Type indirectly refers to the
28 -- table for whose seed data the level is
29 -- specified. Object_id refers to the
30 -- primary key for the seed data in that
31 -- table
32 -- p_hxc_required Yes This parameter specifies the OTL Code
33 -- level for the seed data. This value
34 -- must be one of the lookup codes
35 -- corresponding to the lookup type
36 -- 'HXC_REQUIRED'
37 -- p_owner_application_id Yes This parameter specifies the application
38 -- that owns the seed data
39 -- Post Success:
40 -- The seed data levels will be created and no error will be thrown.
41 --
42 --
43 -- Post Failure:
44 -- The seed data levels are not created and an application error will be raised
45 --
46 -- Access Status:
47 -- Public.
48 --
49 -- {End Of Comments}
50 --
51 procedure create_seed_data_by_level
52 (p_validate in boolean default false
53 ,p_object_id in number
54 ,p_object_type in varchar2
55 ,p_hxc_required in varchar2
56 ,p_owner_application_id in number
57 );
58 --
59
60
61 -- ----------------------------------------------------------------------------
62 -- |-----------------------< update_seed_data_by_level >----------------------|
63 -- ----------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description:
67 --
68 -- This API updates the Level or Owning application of seed data.
69 --
70 -- Prerequisites:
71 -- None
72 --
73 -- In Parameters:
74 -- Name Reqd Type Description
75 -- p_validate No If p_validate is true then
76 -- the database remains unchanged.
77 -- If false, then a seed data level
78 -- is created. Default is False.
79 -- p_object_type Yes The object_type identifies the type
80 -- of seed data for which the level is
81 -- specified. The object_type must be
82 -- one of the lookup codes
83 -- corresponding to the lookup type
84 -- 'HXC_SEED_DATA_REFERENCE'
85 -- p_object_id Yes Object Type indirectly refers to the
86 -- table for whose seed data the level is
87 -- specified. Object_id refers to the
88 -- primary key for the seed data in that
89 -- table
90 -- p_hxc_required Yes This parameter specifies the OTL Code
91 -- level for the seed data. This value
92 -- must be one of the lookup codes
93 -- corresponding to the lookup type
94 -- 'HXC_REQUIRED'
95 -- p_owner_application_id Yes This parameter specifies the application
96 -- that owns the seed data
97 --
98 --
99 -- Post Success:
100 -- The seed data levels will be updated and no error will be thrown.
101 --
102 --
103 -- Post Failure:
104 -- The seed data levels will not be updated and an application error will be thrown.
105 --
106 -- Access Status:
107 -- Public.
108 --
109 -- {End Of Comments}
110 --
111 procedure update_seed_data_by_level
112 (p_validate in boolean default false
113 ,p_object_id in number
114 ,p_object_type in varchar2
115 ,p_hxc_required in varchar2
116 ,p_owner_application_id in number
117 );
118 --
119
120
121
122 -- ----------------------------------------------------------------------------
123 -- |-----------------------< delete_seed_data_by_level >----------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 --
129 -- This API deletes the record corresponding to the given object_id and
130 -- object_type in the hxc_seeddata_by_level.
131 --
132 -- Prerequisites:
133 --
134 --
135 -- In Parameters:
136 -- Name Reqd Type Description
137 -- p_validate No If p_validate is true then
138 -- the database remains unchanged.
139 -- If false, then a seed data level
140 -- is created. Default is False.
141 -- p_object_type Yes The object_type identifies the type
142 -- of seed data for which the level is
143 -- specified. The object_type must be
144 -- one of the lookup codes
145 -- corresponding to the lookup type
146 -- 'HXC_SEED_DATA_REFERENCE'
147 -- p_object_id Yes Object Type indirectly refers to the
148 -- table for whose seed data the level is
149 -- specified. Object_id refers to the
150 -- primary key for the seed data in that
151 -- table
152 --
153 -- Post Success:
154 -- The seed data level record will be deleted and no error will be thrown.
155 --
156 --
157 -- Post Failure:
158 -- The seed data level record will not be deleted and an application error will be thrown.
159 --
160 -- Access Status:
161 -- Public.
162 --
163 -- {End Of Comments}
164 --
165 procedure delete_seed_data_by_level
166 (p_validate in boolean default false
167 ,p_object_id in number
168 ,p_object_type in varchar2
169 );
170 --
171 end hxc_seeddata_by_level_api;