APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_CERT_MBR_ENROLLMENTS

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

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

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

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

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

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

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

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

Line 290: ota_cert_mbr_enrollments cme,

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