APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_GENERAL

Line 76: AND evt.business_group_id = OTA_GENERAL.get_business_group_id

72: AND decode(evt.enrolment_end_date, NULL, to_date('4712/12/31','YYYY/MM/DD'),
73: to_date( to_char(evt.enrolment_end_date, 'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI'))
74: AND evt.event_status IN ('P','N')
75: AND nvl(p_event_id,-1)= decode(p_event_id,NULL,-1,evt.EVENT_ID)
76: AND evt.business_group_id = OTA_GENERAL.get_business_group_id
77: ORDER BY evt.event_id;
78:
79: FORALL i IN 1 .. l_rec.event_id.COUNT
80:

Line 219: AND evt.business_group_id = OTA_GENERAL.get_business_group_id

215: AND decode(evt.enrolment_end_date, NULL, to_date('4712/12/31','YYYY/MM/DD'),
216: to_date( to_char(evt.enrolment_end_date, 'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI'))
217: AND evt.event_status IN ('P','N')
218: AND nvl(p_event_id,-1)= decode(p_event_id,NULL,-1,evt.EVENT_ID)
219: AND evt.business_group_id = OTA_GENERAL.get_business_group_id
220: ORDER BY evt.event_id;
221:
222: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_rec.event_id.COUNT:'||l_rec.event_id.COUNT);
223:

Line 2303: AND cert.business_group_id = OTA_GENERAL.get_business_group_id

2299: AND trunc(sysdate) BETWEEN trunc(cert.start_date_active) and nvl(cert.end_date_active, trunc(sysdate))
2300: AND nvl(p_cert_id,-1)= decode(p_cert_id,NULL,-1,cert.certification_id)
2301: AND ((cert.renewable_flag = 'N' and trunc(sysdate) <= nvl( cert.INITIAL_COMPLETION_DATE ,trunc(sysdate)))
2302: or cert.renewable_flag = 'Y')
2303: AND cert.business_group_id = OTA_GENERAL.get_business_group_id
2304: AND exists (select 1 from ota_certification_members crm where cert.certification_id = crm.certification_id)
2305: ORDER BY cert.certification_id;
2306:
2307:

Line 3079: l_create_enrollment,NULL,l_assignment_info.organization_id,ota_general.get_business_group_id,req_cert_id,

3075: INSERT INTO OTA_MAND_MULTI_ENR_REQ_MEMBERS(mandatory_enr_request_id,person_id,assignment_id,error_message,
3076: completed_course_prereq,completed_competence_prereq,create_enrollment,event_id,organization_id,mbr_bg_id,certification_id,
3077: person_action_id,action_status_cd)
3078: VALUES(req_mandatory_enr_request_id,l_person_id,l_assignment_info.assignment_id,NULL,l_completed_crs_prereq,l_completed_comp_prereq,
3079: l_create_enrollment,NULL,l_assignment_info.organization_id,ota_general.get_business_group_id,req_cert_id,
3080: l_person_action_id,'U');
3081: l_numberof_records_processed := l_numberof_records_processed + 1;
3082: END IF;--learner_is_notSelected_inCert
3083: p_person_action_id := l_person_action_id;