[Home] [Help]
2384: hr_utility.set_location('Leaving :'||l_proc,15);
2385: RETURN NULL;
2386: END get_learner_name;
2387:
2388: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
2389: RETURN number IS
2390:
2391: CURSOR c_customer_id IS
2392: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2422: End get_customer_id;
2423:
2424: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2425: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2426: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2427: RETURN VARCHAR2 IS
2428:
2429: CURSOR c_organization_name IS
2430: select name from hr_all_organization_units_tl
3479: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2 is
3480:
3481: CURSOR lp_cls_enroll_p IS
3482: SELECT lpe.lp_enrollment_id
3483: FROM ota_lp_enrollments lpe,
3484: ota_lp_member_enrollments lpme
3485: WHERE lpe.lp_enrollment_id = lpme.lp_enrollment_id AND
3486: lpe.enrollment_source_code = 'ADMIN' AND
3487: lpe.person_id = p_person_id AND
3488: lpme.event_id = p_event_id;
3489:
3490: CURSOR lp_cls_enroll_c IS
3491: SELECT lpe.lp_enrollment_id
3492: FROM ota_lp_enrollments lpe,
3493: ota_lp_member_enrollments lpme
3494: WHERE lpe.lp_enrollment_id = lpme.lp_enrollment_id AND
3495: lpe.enrollment_source_code = 'ADMIN' AND
3496: lpe.contact_id = p_contact_id AND
3501: 'IS_MANAGER',decode(p_booking_status_type, 'A','UD', 'UE')) enroll_image
3502: FROM DUAL;
3503:
3504: l_enroll_image varchar2(30);
3505: l_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%type;
3506:
3507: begin
3508:
3509: OPEN cls_enroll_image;