[Home] [Help]
648:
649: -- ----------------------------------------------------------------------
650: -- RETRIEVE THE DATA REQUIRED
651: -- ----------------------------------------------------------------------
652: ota_utility.Get_Default_Value_Dff( appl_short_name => 'OTA'
653: ,flex_field_name => 'OTA_DELEGATE_BOOKINGS'
654: ,p_attribute_category => l_attribute_category
655: ,p_attribute1 => l_attribute1
656: ,p_attribute2 => l_attribute2
1423: END;
1424:
1425: IF l_lp_enrollment_id IS NOT NULL THEN
1426: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1427: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1428: -- update lpe status to bulk_enr_req_members table
1429: UPDATE ota_bulk_enr_req_members
1430: SET enrollment_status = l_path_status_code, error_message = NULL
1431: WHERE person_id = l_req_member_rec.person_id
1498: END;
1499:
1500: IF l_cert_enrollment_id IS NOT NULL THEN
1501: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1502: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1503: -- update lpe status to bulk_enr_req_members table
1504: UPDATE ota_bulk_enr_req_members
1505: SET enrollment_status = l_certification_status_code, error_message = NULL
1506: WHERE person_id = l_req_member_rec.person_id
1695: UPDATE ota_bulk_enr_requests ber
1696: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
1697: WHERE bulk_enr_request_id = p_enr_request_id;
1698:
1699: p_object_type := ota_utility.get_lookup_meaning(
1700: 'OTA_OBJECT_TYPE'
1701: ,l_request_rec.object_type
1702: ,810);
1703: p_object_name := get_object_name(l_request_rec.object_type, l_request_rec.object_id );