eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_CERT_ENROLLMENTS

Line 2509: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type:=0;

2505:
2506:
2507: l_per_bg_grp_prof_val number;
2508: l_ota_global_bg_prof_val number;
2509: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type:=0;
2510: l_cert_status_code NUMBER :=0;
2511:
2512: sql_stmnt clob;
2513: usergroup_whereclause clob;

Line 2573: update ota_cert_enrollments set is_automatic_subscription = 'Y'

2569: create_cert_req_member_record(learner.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2570: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2571: -- update the subscription, set is_automatic_subscription to Y
2572: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2573: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2574: where cert_enrollment_id = l_cert_enrollment_id;
2575:
2576: OPEN csr_get_person_name(learner.person_id);
2577: FETCH csr_get_person_name INTO l_person_name;

Line 2629: update ota_cert_enrollments set is_automatic_subscription = 'Y'

2625: create_cert_req_member_record(asg_learner.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2626: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2627: -- update the subscription, set is_automatic_subscription to Y
2628: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2629: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2630: where cert_enrollment_id = l_cert_enrollment_id;
2631: OPEN csr_get_person_name(asg_learner.person_id);
2632: FETCH csr_get_person_name INTO l_person_name;
2633: CLOSE csr_get_person_name;

Line 2762: update ota_cert_enrollments set is_automatic_subscription = 'Y'

2758: create_cert_req_member_record(v_person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2759: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2760: -- update the subscription, set is_automatic_subscription to Y
2761: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2762: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2763: where cert_enrollment_id = l_cert_enrollment_id;
2764:
2765: OPEN csr_get_person_name(v_person_id);
2766: FETCH csr_get_person_name INTO l_person_name;

Line 2827: update ota_cert_enrollments set is_automatic_subscription = 'Y'

2823: create_cert_req_member_record(lrnr_rec.person_id,request.mandatory_enr_request_id,request.certification_id,l_numberof_records_processed, 'U',l_person_action_id);
2824: ELSIF l_cert_status_code = l_upd_subc_exist THEN
2825: -- update the subscription, set is_automatic_subscription to Y
2826: --FND_FILE.PUT_LINE(FND_FILE.LOG,'Update existing subscription');
2827: update ota_cert_enrollments set is_automatic_subscription = 'Y'
2828: where cert_enrollment_id = l_cert_enrollment_id;
2829:
2830: OPEN csr_get_person_name(lrnr_rec.person_id);
2831: FETCH csr_get_person_name INTO l_person_name;

Line 2956: FROM ota_cert_enrollments

2952: CURSOR check_subscr_exists IS
2953: SELECT cert_enrollment_id,
2954: certification_status_code,
2955: nvl(is_automatic_subscription, 'N')
2956: FROM ota_cert_enrollments
2957: WHERE person_id = p_learner_id
2958: AND certification_id = p_certification_id;
2959: -- AND certification_status_code <> 'CANCELLED';
2960:

Line 2968: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;

2964: l_status_id NUMBER := NULL;
2965: l_status_number NUMBER;
2966: l_mandatory_enrollment_flag varchar2(1) := NULL;
2967: l_proc varchar2(72) := g_package||'learner_can_enroll_in_cert';
2968: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
2969: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
2970: l_is_automatic_subscription ota_cert_enrollments.is_automatic_subscription%type;
2971: BEGIN
2972:

Line 2969: l_certification_status_code ota_cert_enrollments.certification_status_code%type;

2965: l_status_number NUMBER;
2966: l_mandatory_enrollment_flag varchar2(1) := NULL;
2967: l_proc varchar2(72) := g_package||'learner_can_enroll_in_cert';
2968: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
2969: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
2970: l_is_automatic_subscription ota_cert_enrollments.is_automatic_subscription%type;
2971: BEGIN
2972:
2973: hr_utility.set_location(' Entering:'||l_proc, 5);

Line 2970: l_is_automatic_subscription ota_cert_enrollments.is_automatic_subscription%type;

2966: l_mandatory_enrollment_flag varchar2(1) := NULL;
2967: l_proc varchar2(72) := g_package||'learner_can_enroll_in_cert';
2968: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%type;
2969: l_certification_status_code ota_cert_enrollments.certification_status_code%type;
2970: l_is_automatic_subscription ota_cert_enrollments.is_automatic_subscription%type;
2971: BEGIN
2972:
2973: hr_utility.set_location(' Entering:'||l_proc, 5);
2974: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered learner can enrol in cert ');

Line 3017: req_cert_id IN ota_cert_enrollments.certification_id%type,

3013:
3014:
3015: PROCEDURE create_cert_req_member_record(l_person_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.person_id%type,
3016: req_mandatory_enr_request_id IN OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type,
3017: req_cert_id IN ota_cert_enrollments.certification_id%type,
3018: l_numberof_records_processed IN OUT NOCOPY NUMBER,
3019: l_create_enrollment IN varchar2 default 'Y',
3020: p_person_action_id OUT NOCOPY OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type) IS
3021:

Line 3134: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;

3130: l_mandaotory_enr_request_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.mandatory_enr_request_id%type;
3131: l_request_rec get_all_mandatory_enr_requests%rowtype;
3132: l_req_member_rec csr_get_request_members%rowtype;
3133: l_person_name per_all_people_f.full_name%type;
3134: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
3135: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
3136: l_certification_name ota_certifications_tl.name%type;
3137:
3138: l_proc varchar2(72) := g_package||'create_cert_subscriptions';

Line 3135: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;

3131: l_request_rec get_all_mandatory_enr_requests%rowtype;
3132: l_req_member_rec csr_get_request_members%rowtype;
3133: l_person_name per_all_people_f.full_name%type;
3134: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
3135: l_certification_status_code ota_cert_enrollments.CERTIFICATION_STATUS_CODE%TYPE;
3136: l_certification_name ota_certifications_tl.name%type;
3137:
3138: l_proc varchar2(72) := g_package||'create_cert_subscriptions';
3139:

Line 3210: update ota_cert_enrollments set is_automatic_subscription = 'Y'

3206: IF l_cert_enrollment_id IS NOT NULL THEN
3207: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_name||' | '||l_certification_name||' | '||l_cert_enrollment_id);
3208: IF l_req_member_rec.create_enrollment = 'U' THEN
3209: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_req_member_rec.create_enrollment = U');
3210: update ota_cert_enrollments set is_automatic_subscription = 'Y'
3211: where cert_enrollment_id = l_cert_enrollment_id;
3212: END IF;
3213:
3214: UPDATE OTA_MAND_MULTI_ENR_REQ_MEMBERS