1 PACKAGE OTA_TPS_SWI AUTHID CURRENT_USER AS
2 /* $Header: ottpsswi.pkh 115.4 2004/03/03 05:17:33 rdola noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_training_plan >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_tps_api.create_training_plan
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_training_plan
27 (p_validate IN NUMBER DEFAULT hr_api.g_false_num
28 ,p_effective_date IN date
29 ,p_business_group_id IN number
30 ,p_time_period_id IN NUMBER DEFAULT NULL
31 ,p_plan_status_type_id IN VARCHAR2
32 ,p_organization_id IN NUMBER DEFAULT NULL
33 ,p_person_id IN NUMBER DEFAULT NULL
34 ,p_budget_currency IN VARCHAR2 DEFAULT NULL
35 ,p_name IN VARCHAR2
36 ,p_description IN VARCHAR2 DEFAULT NULL
37 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
38 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
39 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
40 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
41 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
42 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
43 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
44 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
45 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
46 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
47 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
48 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
49 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
50 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
51 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
52 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
53 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
54 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
55 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
56 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
57 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
58 ,p_attribute21 IN VARCHAR2 DEFAULT NULL
59 ,p_attribute22 IN VARCHAR2 DEFAULT NULL
60 ,p_attribute23 IN VARCHAR2 DEFAULT NULL
61 ,p_attribute24 IN VARCHAR2 DEFAULT NULL
62 ,p_attribute25 IN VARCHAR2 DEFAULT NULL
63 ,p_attribute26 IN VARCHAR2 DEFAULT NULL
64 ,p_attribute27 IN VARCHAR2 DEFAULT NULL
65 ,p_attribute28 IN VARCHAR2 DEFAULT NULL
66 ,p_attribute29 IN VARCHAR2 DEFAULT NULL
67 ,p_attribute30 IN VARCHAR2 DEFAULT NULL
68 ,p_plan_source IN VARCHAR2 DEFAULT NULL
69 ,p_start_date IN date DEFAULT NULL
70 ,p_end_date IN date DEFAULT NULL
71 ,p_training_plan_id IN number
72 ,p_creator_person_id IN NUMBER DEFAULT NULL
73 ,p_additional_member_flag IN VARCHAR2 DEFAULT NULL
74 ,p_learning_path_id IN NUMBER DEFAULT NULL
75 -- Modified for Bug#3479186
76 ,p_contact_id IN NUMBER DEFAULT NULL
77 ,p_object_version_NUMBER OUT NOCOPY number
78 ,p_return_status OUT NOCOPY VARCHAR2
79 );
80 -- ----------------------------------------------------------------------------
81 -- |-------------------------< delete_training_plan >-------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start of comments}
84 --
85 -- Description:
86 -- This procedure is the self-service wrapper procedure to the following
87 -- API: ota_tps_api.delete_training_plan
88 --
89 -- Pre-requisites
90 -- All 'IN' parameters to this procedure have been appropriately derived.
91 --
92 -- Post Success:
93 -- p_return_status will return value indicating success.
94 --
95 -- Post Failure:
96 -- p_return_status will return value indication failure.
97 --
98 -- Access Status:
99 -- Internal Development use only.
100 --
101 -- {End of comments}
102 -- ----------------------------------------------------------------------------
103 PROCEDURE delete_training_plan
104 (p_validate IN NUMBER DEFAULT hr_api.g_false_num
105 ,p_training_plan_id IN number
106 ,p_object_version_NUMBER IN number
107 ,p_return_status OUT NOCOPY VARCHAR2
108 );
109 -- ----------------------------------------------------------------------------
110 -- |-------------------------< update_training_plan >-------------------------|
111 -- ----------------------------------------------------------------------------
112 -- {Start of comments}
113 --
114 -- Description:
115 -- This procedure is the self-service wrapper procedure to the following
116 -- API: ota_tps_api.update_training_plan
117 --
118 -- Pre-requisites
119 -- All 'IN' parameters to this procedure have been appropriately derived.
120 --
121 -- Post Success:
122 -- p_return_status will return value indicating success.
123 --
124 -- Post Failure:
125 -- p_return_status will return value indication failure.
126 --
127 -- Access Status:
128 -- Internal Development use only.
129 --
130 -- {End of comments}
131 -- ----------------------------------------------------------------------------
132 PROCEDURE update_training_plan
133 (p_validate IN NUMBER DEFAULT hr_api.g_false_num
134 ,p_effective_date IN date
135 ,p_training_plan_id IN number
136 ,p_object_version_NUMBER IN OUT NOCOPY number
137 ,p_time_period_id IN number DEFAULT hr_api.g_number
138 ,p_plan_status_type_id IN VARCHAR2
139 ,p_budget_currency IN VARCHAR2 DEFAULT hr_api.g_varchar2
140 ,p_name IN VARCHAR2
141 ,p_description IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
142 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
143 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
144 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
145 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
146 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
147 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
148 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
149 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
150 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
151 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
152 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
153 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
154 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
155 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
156 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
157 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
158 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
159 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
160 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
161 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
162 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
163 ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
164 ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
165 ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
166 ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
167 ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
168 ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
169 ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
170 ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
171 ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
172 ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
173 ,p_plan_source IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
174 ,p_start_date IN date DEFAULT hr_api.g_date
175 ,p_end_date IN date DEFAULT hr_api.g_date
176 ,p_creator_person_id IN NUMBER DEFAULT hr_api.g_number
177 ,p_additional_member_flag IN VARCHAR2 DEFAULT hr_api.g_VARCHAR2
178 ,p_learning_path_id IN NUMBER DEFAULT hr_api.g_number
179 ,p_contact_id IN NUMBER DEFAULT hr_api.g_number
180 ,p_return_status OUT NOCOPY VARCHAR2
181 );
182 END ota_tps_swi;