1 Package ota_resource_definition_swi As
2 /* $Header: ottsrswi.pkh 120.0 2005/05/29 07:56 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_resource_definition >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_resource_definition_api.create_resource_definition
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_resource_definition
27 (p_supplied_resource_id in number
28 ,p_vendor_id in number
29 ,p_business_group_id in number
30 ,p_resource_definition_id in number
31 ,p_consumable_flag in varchar2 default null
32 ,p_object_version_number out nocopy number
33 ,p_resource_type in varchar2 default null
34 ,p_start_date in date default null
35 ,p_comments in varchar2 default null
36 ,p_cost in number
37 ,p_cost_unit in varchar2 default null
38 ,p_currency_code in varchar2 default null
39 ,p_end_date in date default null
40 ,p_internal_address_line in varchar2 default null
41 ,p_lead_time in number
42 ,p_name in varchar2 default null
43 ,p_supplier_reference in varchar2 default null
44 ,p_tsr_information_category in varchar2 default null
45 ,p_tsr_information1 in varchar2 default null
46 ,p_tsr_information2 in varchar2 default null
47 ,p_tsr_information3 in varchar2 default null
48 ,p_tsr_information4 in varchar2 default null
49 ,p_tsr_information5 in varchar2 default null
50 ,p_tsr_information6 in varchar2 default null
51 ,p_tsr_information7 in varchar2 default null
52 ,p_tsr_information8 in varchar2 default null
53 ,p_tsr_information9 in varchar2 default null
54 ,p_tsr_information10 in varchar2 default null
55 ,p_tsr_information11 in varchar2 default null
56 ,p_tsr_information12 in varchar2 default null
57 ,p_tsr_information13 in varchar2 default null
58 ,p_tsr_information14 in varchar2 default null
59 ,p_tsr_information15 in varchar2 default null
60 ,p_tsr_information16 in varchar2 default null
61 ,p_tsr_information17 in varchar2 default null
62 ,p_tsr_information18 in varchar2 default null
63 ,p_tsr_information19 in varchar2 default null
64 ,p_tsr_information20 in varchar2 default null
65 ,p_training_center_id in number
66 ,p_location_id in number
67 ,p_trainer_id in number
68 ,p_special_instruction in varchar2 default null
69 ,p_validate in number
70 ,p_effective_date in date
71 ,p_data_source in varchar2 default null
72 ,p_return_status out nocopy varchar2
73 );
74 -- ----------------------------------------------------------------------------
75 -- |----------------------< update_resource_definition >----------------------|
76 -- ----------------------------------------------------------------------------
77 -- {Start of comments}
78 --
79 -- Description:
80 -- This procedure is the self-service wrapper procedure to the following
81 -- API: ota_resource_definition_api.update_resource_definition
82 --
83 -- Pre-requisites
84 -- All 'IN' parameters to this procedure have been appropriately derived.
85 --
86 -- Post Success:
87 -- p_return_status will return value indicating success.
88 --
89 -- Post Failure:
90 -- p_return_status will return value indication failure.
91 --
92 -- Access Status:
93 -- Internal Development use only.
94 --
95 -- {End of comments}
96 -- ----------------------------------------------------------------------------
97 PROCEDURE update_resource_definition
98 (p_supplied_resource_id in number
99 ,p_vendor_id in number
100 ,p_business_group_id in number
101 ,p_resource_definition_id in number
102 ,p_consumable_flag in varchar2
103 ,p_object_version_number in out nocopy number
104 ,p_resource_type in varchar2
105 ,p_start_date in date default hr_api.g_date
106 ,p_comments in varchar2
107 ,p_cost in number
108 ,p_cost_unit in varchar2
109 ,p_currency_code in varchar2
110 ,p_end_date in date default hr_api.g_date
111 ,p_internal_address_line in varchar2
112 ,p_lead_time in number
113 ,p_name in varchar2
114 ,p_supplier_reference in varchar2
115 ,p_tsr_information_category in varchar2
116 ,p_tsr_information1 in varchar2
117 ,p_tsr_information2 in varchar2
118 ,p_tsr_information3 in varchar2
119 ,p_tsr_information4 in varchar2
120 ,p_tsr_information5 in varchar2
121 ,p_tsr_information6 in varchar2
122 ,p_tsr_information7 in varchar2
123 ,p_tsr_information8 in varchar2
124 ,p_tsr_information9 in varchar2
125 ,p_tsr_information10 in varchar2
126 ,p_tsr_information11 in varchar2
127 ,p_tsr_information12 in varchar2
128 ,p_tsr_information13 in varchar2
129 ,p_tsr_information14 in varchar2
130 ,p_tsr_information15 in varchar2
131 ,p_tsr_information16 in varchar2
132 ,p_tsr_information17 in varchar2
133 ,p_tsr_information18 in varchar2
134 ,p_tsr_information19 in varchar2
135 ,p_tsr_information20 in varchar2
136 ,p_training_center_id in number
137 ,p_location_id in number
138 ,p_trainer_id in number
139 ,p_special_instruction in varchar2
140 ,p_validate in number
141 ,p_effective_date in date
142 ,p_data_source in varchar2
143 ,p_return_status out nocopy varchar2
144 );
145 -- ----------------------------------------------------------------------------
146 -- |----------------------< delete_resource_definition >----------------------|
147 -- ----------------------------------------------------------------------------
148 -- {Start of comments}
149 --
150 -- Description:
151 -- This procedure is the self-service wrapper procedure to the following
152 -- API: ota_resource_definition_api.delete_resource_definition
153 --
154 -- Pre-requisites
155 -- All 'IN' parameters to this procedure have been appropriately derived.
156 --
157 -- Post Success:
158 -- p_return_status will return value indicating success.
159 --
160 -- Post Failure:
161 -- p_return_status will return value indication failure.
162 --
163 -- Access Status:
164 -- Internal Development use only.
165 --
166 -- {End of comments}
167 -- ----------------------------------------------------------------------------
168 PROCEDURE delete_resource_definition
169 (p_validate in number default hr_api.g_false_num
170 ,p_supplied_resource_id in number
171 ,p_object_version_number in number
172 ,p_return_status out nocopy varchar2
173 );
174 end ota_resource_definition_swi;