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