82: IF evt_det%FOUND THEN
83:
84: CLOSE evt_det;
85:
86: hr_utility.set_location(' Step:'|| l_proc, 20);
87:
88: /* open evt_type;
89: fetch evt_type into l_evt_Type;
90: close evt_type; */
165: ELSE
166: CLOSE evt_Det;
167: END IF;
168:
169: hr_utility.set_location(' Step:'|| l_proc, 30);
170:
171: --MULTI MESSAGE SUPPORT
172:
173:
212: l_enroll_status VARCHAR2(30);
213: l_member_status_type VARCHAR2(30);
214:
215: BEGIN
216: hr_utility.set_location(' Step:'|| l_proc, 10);
217: /*
218: FOR rec IN csr_tpm
219: LOOP
220:
217: /*
218: FOR rec IN csr_tpm
219: LOOP
220:
221: hr_utility.set_location(' Step:'|| l_proc, 20);
222: l_enroll_status := ota_trng_plan_util_ss.get_enroll_status (p_person_id => rec.person_id,
223: -- Modified for Bug#3479186
224: p_contact_id => rec.contact_id,
225: p_training_plan_member_id => rec.training_plan_member_id);
237:
238:
239: END LOOP;
240: */
241: hr_utility.set_location(' Step:'|| l_proc, 30);
242:
243: END update_tpc_evt_change;
244:
245: -- ----------------------------------------------------------------------------
301: l_object_version_number number;
302: l_training_plan_member_id number;
303:
304: begin
305: hr_utility.set_location(' Entering:' || l_proc,10);
306:
307: -- SAVEPOINT validate_TPC_proc;
308:
309: if p_mode= 'INSERT' then
414:
415: p_object_version_number:=null;
416: p_return_status:= hr_multi_message.get_return_status_disable;
417:
418: hr_utility.set_location(' LEAVING:' || l_proc,20);
419:
420: end validate_TPC;
421:
422: -- ---------------------------------------------------------------------------