1 Package hxc_mapping_comp_usage_api as
2 /* $Header: hxcmcuapi.pkh 120.0.12010000.1 2008/07/28 11:16:15 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_mapping_comp_usage>----------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start Of Comments}
9 --
10 -- Description:
11 --
12 -- This API creates a Mapping Component Usage for a given mapping
13 -- and mapping component.
14 --
15 -- Prerequisites:
16 --
17 -- None
18 --
19 -- In Parameters:
20 -- Name Reqd Type Description
21 --
22 -- p_validate No boolean If TRUE then the database
23 -- remains unchanged. If FALSE
24 -- then a new mapping_comp_usage
25 -- is created. Default is FALSE.
26 -- p_mapping_comp_usage_id No number Primary Key for entity
27 -- p_object_version_number No number Object Version Number
28 -- p_mapping_id Yes number Field Mapping Id
29 -- p_mapping_component_id Yes number Field Mapping Component Id
30 --
31 -- Post Success:
32 --
33 -- when the mapping_comp_usage has been created successfully the following
34 -- out parameters are set.
35 --
36 -- Name Type Description
37 --
38 -- p_mapping_comp_usage_id Number Primary Key for the new rule
39 -- p_object_version_number Number Object version number for the
40 -- new rule
41 --
42 -- Post Failure:
43 --
44 -- The mapping component usage will not be inserted and an application error raised
45 --
46 -- Access Status:
47 -- Public.
48 --
49 -- {End Of Comments}
50 --
51 procedure create_mapping_comp_usage
52 (p_validate in boolean default false
53 ,p_mapping_comp_usage_id in out nocopy number
54 ,p_object_version_number in out nocopy number
55 ,p_mapping_id in number
56 ,p_mapping_component_id in number
57 );
58 --
59 /*
60 -- ----------------------------------------------------------------------------
61 -- |------------------------<update_mapping_comp_usage>-----------------------|
62 -- ----------------------------------------------------------------------------
63 --
64 -- {Start Of Comments}
65 --
66 -- Description:
67 --
68 -- This API updates an existing Mapping Component Usage with a given name, approval
69 -- rule usage covering a particular date range.
70 --
71 -- Prerequisites:
72 --
73 -- None
74 --
75 -- In Parameters:
76 -- Name Reqd Type Description
77 --
78 -- p_validate No boolean If TRUE then the database
79 -- remains unchanged. If FALSE
80 -- then the mapping_comp_usage
81 -- is updated. Default is FALSE.
82 -- p_mapping_comp_usage_id Yes number Primary Key for entity
83 -- p_object_version_number Yes number Object Version Number
84 -- p_mapping_id No number Field Mapping ID
85 -- p_mapping_component_id No number Field Mapping ID
86 --
87 -- Post Success:
88 --
89 -- when the mapping_comp_usage has been updated successfully the following
90 -- out parameters are set.
91 --
92 -- Name Type Description
93 --
94 -- p_object_version_number Number Object version number for the
95 -- updated rule
96 --
97 -- Post Failure:
98 --
99 -- The mapping component usage will not be updated and an application error raised
100 --
101 -- Access Status:
102 -- Public.
103 --
104 -- {End Of Comments}
105 --
106 procedure update_mapping_comp_usage
107 (p_validate in boolean default false
108 ,p_mapping_comp_usage_id in number
109 ,p_object_version_number in out nocopy number
110 ,p_mapping_id in number default null
111 ,p_mapping_component_id in number default null
112 );
113 */
114 --
115 -- ----------------------------------------------------------------------------
116 -- |------------------------< delete_mapping_comp_usage >---------------------|
117 -- ----------------------------------------------------------------------------
118 --
119 -- {Start Of Comments}
120 --
121 -- Description:
122 --
123 -- This API deletes an existing Mapping Component Usage
124 --
125 -- Prerequisites:
126 --
127 -- None
128 --
129 -- In Parameters:
130 -- Name Reqd Type Description
131 --
132 -- p_validate No boolean If TRUE then the database
133 -- remains unchanged. If FALSE
134 -- then the mapping_comp_usage
135 -- is deleted. Default is FALSE.
136 -- p_mapping_comp_usage_id Yes number Primary Key for entity
137 -- p_object_version_number Yes number Object Version Number
138 --
139 -- Post Success:
140 --
141 -- when the mapping_comp_usage has been deleted successfully the process
142 -- completes with success.
143 --
144 -- Post Failure:
145 --
146 -- The mapping component usage will not be deleted and an application error raised
147 --
148 -- Access Status:
149 -- Public.
150 --
151 -- {End Of Comments}
152 --
153 procedure delete_mapping_comp_usage
154 (p_validate in boolean default false
155 ,p_mapping_comp_usage_id in number
156 ,p_object_version_number in number
157 );
158 --
159 --
160 END hxc_mapping_comp_usage_api;