APPS.OTA_LP_ENROLLMENT_API dependencies on OTA_LP_ENROLLMENTS

Line 404: l_learning_path_id ota_lp_enrollments.learning_path_id%TYPE;

400: l_effective_date date;
401:
402: -- competency update associated with lps
403: l_item_key wf_items.item_key%TYPE;
404: l_learning_path_id ota_lp_enrollments.learning_path_id%TYPE;
405: l_person_id ota_lp_enrollments.person_id%TYPE;
406: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
407: l_proceed varchar2(1) := 'Y';
408:

Line 405: l_person_id ota_lp_enrollments.person_id%TYPE;

401:
402: -- competency update associated with lps
403: l_item_key wf_items.item_key%TYPE;
404: l_learning_path_id ota_lp_enrollments.learning_path_id%TYPE;
405: l_person_id ota_lp_enrollments.person_id%TYPE;
406: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
407: l_proceed varchar2(1) := 'Y';
408:
409:

Line 406: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;

402: -- competency update associated with lps
403: l_item_key wf_items.item_key%TYPE;
404: l_learning_path_id ota_lp_enrollments.learning_path_id%TYPE;
405: l_person_id ota_lp_enrollments.person_id%TYPE;
406: l_path_status_code ota_lp_enrollments.path_status_code%TYPE;
407: l_proceed varchar2(1) := 'Y';
408:
409:
410: CURSOR get_info_for_comp IS

Line 414: ota_lp_enrollments lpe

410: CURSOR get_info_for_comp IS
411: --Modified for Bug#3864084
412: SELECT lps.learning_path_id, lpe.person_id
413: FROM ota_learning_paths lps,
414: ota_lp_enrollments lpe
415: WHERE lps.learning_path_id = lpe.learning_path_id
416: AND lpe.lp_enrollment_id = p_lp_enrollment_id
417: AND lps.path_source_code = 'CATALOG';
418:

Line 423: ota_lp_enrollments lpe

419: --- modified by dbatra for source_type='SUITABILITY'
420: Cursor is_suitability_LP is
421: SELECT lps.learning_path_id
422: FROM ota_learning_paths lps,
423: ota_lp_enrollments lpe
424: WHERE lps.learning_path_id = lpe.learning_path_id
425: AND lpe.lp_enrollment_id = p_lp_enrollment_id
426: AND lps.source_function_code = 'SUITABILITY';
427:

Line 430: from ota_learning_paths lps, ota_lp_enrollments lpe

426: AND lps.source_function_code = 'SUITABILITY';
427:
428: cursor get_lp_type is
429: select lps.path_source_code , lpe.path_status_code
430: from ota_learning_paths lps, ota_lp_enrollments lpe
431: where lps.learning_path_id = lpe.learning_path_id
432: AND lpe.lp_enrollment_id = p_lp_enrollment_id;
433:
434: l_type ota_learning_paths.path_source_code%type;

Line 865: FROM ota_lp_enrollments

861: where learning_path_id = p_learning_path_id;
862:
863: CURSOR csr_get_lpe_details IS
864: select path_status_code, no_of_completed_courses, object_version_number, completion_date
865: FROM ota_lp_enrollments
866: where lp_enrollment_id = p_lp_enrollment_id;
867:
868: l_proc varchar2(72) := g_package || ' subscribe_to_learning_path';
869: l_lp_rec csr_get_lp_details%ROWTYPE;

Line 922: ,flex_field_name => 'OTA_LP_ENROLLMENTS'

918:
919: savepoint create_lp_subscription;
920: ota_utility.Get_Default_Value_Dff(
921: appl_short_name => 'OTA'
922: ,flex_field_name => 'OTA_LP_ENROLLMENTS'
923: ,p_attribute_category => l_attribute_category
924: ,p_attribute1 => l_attribute1
925: ,p_attribute2 => l_attribute2
926: ,p_attribute3 => l_attribute3