[Home] [Help]
1: Package Body OTA_LP_ENROLLMENT_API as
2: /* $Header: otlpeapi.pkb 120.7.12010000.2 2009/05/21 09:36:15 pekasi ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: otlpeapi.pkb 120.7.12010000.2 2009/05/21 09:36:15 pekasi ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' OTA_LP_ENROLLMENT_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< CREATE_LP_ENROLLMENT >------------------|
10: -- ----------------------------------------------------------------------------
951: ,p_attribute28 => l_attribute28
952: ,p_attribute29 => l_attribute29
953: ,p_attribute30 => l_attribute30);
954:
955: ota_lp_enrollment_api.create_lp_enrollment(
956: p_effective_date => trunc(sysdate)
957: ,p_validate => p_validate
958: ,p_learning_path_id => p_learning_path_id
959: ,p_person_id => p_person_id
1123: --Bug 4615753
1124: --this update is reqd for no_of_completed_courses values at lpe
1125: --which wouldn't be populated otherwise and call to chk_complete_path_ok
1126: --would never return 'S' even if all its components are in Completed status
1127: ota_lp_enrollment_api.update_lp_enrollment
1128: (p_effective_date => sysdate
1129: ,p_validate => p_validate
1130: ,p_lp_enrollment_id => p_lp_enrollment_id
1131: ,p_object_version_number => l_lpe_rec.object_version_number
1143: OPEN csr_get_lpe_details;
1144: FETCH csr_get_lpe_details INTO l_lpe_rec;
1145: CLOSE csr_get_lpe_details;
1146:
1147: ota_lp_enrollment_api.update_lp_enrollment
1148: (p_effective_date => sysdate
1149: ,p_validate => p_validate
1150: ,p_lp_enrollment_id => p_lp_enrollment_id
1151: ,p_object_version_number => l_lpe_rec.object_version_number
1186:
1187: hr_utility.set_location(' Leaving:' || l_proc,50);
1188: raise;
1189: END subscribe_to_learning_path;
1190: end ota_lp_enrollment_api;
1191: