DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_UTILITY

Line 652: ota_utility.Get_Default_Value_Dff( appl_short_name => 'OTA'

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

Line 1433: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));

1429: END;
1430:
1431: IF l_lp_enrollment_id IS NOT NULL THEN
1432: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1433: || ota_utility.get_lookup_meaning('OTA_LEARNING_PATH_STATUS',l_path_status_code, 810));
1434: -- update lpe status to bulk_enr_req_members table
1435: UPDATE ota_bulk_enr_req_members
1436: SET enrollment_status = l_path_status_code, error_message = NULL
1437: WHERE person_id = l_req_member_rec.person_id

Line 1508: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));

1504: END;
1505:
1506: IF l_cert_enrollment_id IS NOT NULL THEN
1507: FND_FILE.PUT_LINE(FND_FILE.LOG,'Subscription Status - '
1508: || ota_utility.get_lookup_meaning('OTA_CERT_ENROLL_STATUS',l_certification_status_code, 810));
1509: -- update lpe status to bulk_enr_req_members table
1510: UPDATE ota_bulk_enr_req_members
1511: SET enrollment_status = l_certification_status_code, error_message = NULL
1512: WHERE person_id = l_req_member_rec.person_id

Line 1990: p_object_type := ota_utility.get_lookup_meaning(

1986: UPDATE ota_bulk_enr_requests ber
1987: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
1988: WHERE bulk_enr_request_id = p_enr_request_id;
1989:
1990: p_object_type := ota_utility.get_lookup_meaning(
1991: 'OTA_OBJECT_TYPE'
1992: ,l_request_rec.object_type
1993: ,810);
1994: p_object_name := get_object_name(l_request_rec.object_type, l_request_rec.object_id );

Line 2011: p_object_type := ota_utility.get_lookup_meaning(

2007: UPDATE ota_bulk_enr_requests ber
2008: SET CONC_PROGRAM_REQUEST_ID = p_conc_request_id
2009: WHERE bulk_enr_request_id between p_enr_request_id and p_enr_request_id_end;
2010:
2011: p_object_type := ota_utility.get_lookup_meaning(
2012: 'OTA_OBJECT_TYPE'
2013: ,l_request_rec.object_type
2014: ,810);
2015: p_object_name := get_object_name(l_request_rec.object_type, l_request_rec.object_id );