APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 54: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;

50: l_cert_mbr_enrollment_id number;
51: l_object_version_number number;
52: l_effective_date date;
53:
54: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
55: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
56: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
57:
58: CURSOR csr_get_course_id IS

Line 55: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;

51: l_object_version_number number;
52: l_effective_date date;
53:
54: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
55: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
56: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
57:
58: CURSOR csr_get_course_id IS
59: SELECT object_id

Line 283: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;

279: l_proc varchar2(72) := g_package||' Update Cert Enrollment';
280: l_object_version_number number := p_object_version_number;
281: l_effective_date date;
282:
283: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
284: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
285: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
286: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_enrollment_id%TYPE := p_cert_prd_enrollment_id;
287:

Line 284: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;

280: l_object_version_number number := p_object_version_number;
281: l_effective_date date;
282:
283: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE := p_member_status_code;
284: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE := p_completion_date;
285: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
286: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_enrollment_id%TYPE := p_cert_prd_enrollment_id;
287:
288: CURSOR csr_get_course_id IS

Line 292: ota_cert_mbr_enrollments cme,

288: CURSOR csr_get_course_id IS
289: SELECT cmb.object_id,
290: cpe.cert_prd_enrollment_id
291: FROM ota_certification_members cmb,
292: ota_cert_mbr_enrollments cme,
293: ota_cert_prd_enrollments cpe
294: WHERE cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
295: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
296: AND cme.cert_member_id = cmb.certification_member_id;