DBA Data[Home] [Help]

APPS.OTA_CPE_UTIL dependencies on OTA_CERTIFICATION_MEMBERS

Line 119: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,

115: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
116: p_cert_period_start_date in date default sysdate)
117: return varchar2;
118:
119: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,
120: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
121: p_code in number default 1)
122: RETURN varchar2;
123:

Line 124: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)

120: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
121: p_code in number default 1)
122: RETURN varchar2;
123:
124: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)
125: RETURN varchar2;
126:
127: FUNCTION get_cre_status (p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,
128: p_mode in varchar2 default 'm')