DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OTA_LP_ENROLLMENTS

Line 2324: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)

2320: hr_utility.set_location('Leaving :'||l_proc,15);
2321: RETURN NULL;
2322: END get_learner_name;
2323:
2324: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
2325: RETURN number IS
2326:
2327: CURSOR c_customer_id IS
2328: select ACCT_ROLE.cust_account_id CUSTOMER_ID

Line 2362: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)

2358: End get_customer_id;
2359:
2360: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
2361: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
2362: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2363: RETURN VARCHAR2 IS
2364:
2365: CURSOR c_organization_name IS
2366: select name from hr_all_organization_units_tl