APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_LEARNER_ACCESS_UTIL

Line 1: package body ota_learner_access_util as

1: package body ota_learner_access_util as
2: /* $Header: otlrnacc.pkb 120.40.12020000.2 2013/02/13 13:38:40 atadepal ship $ */
3:
4: person_ug_map_rec_table ota_learner_access_util.person_ug_map_table;
5: t_ug_learner_list_table ota_learner_access_util.ug_learner_list_table;

Line 4: person_ug_map_rec_table ota_learner_access_util.person_ug_map_table;

1: package body ota_learner_access_util as
2: /* $Header: otlrnacc.pkb 120.40.12020000.2 2013/02/13 13:38:40 atadepal ship $ */
3:
4: person_ug_map_rec_table ota_learner_access_util.person_ug_map_table;
5: t_ug_learner_list_table ota_learner_access_util.ug_learner_list_table;
6:
7: cursor csr_evt_tree(
8: p_event_id ota_events.event_id%type) is

Line 5: t_ug_learner_list_table ota_learner_access_util.ug_learner_list_table;

1: package body ota_learner_access_util as
2: /* $Header: otlrnacc.pkb 120.40.12020000.2 2013/02/13 13:38:40 atadepal ship $ */
3:
4: person_ug_map_rec_table ota_learner_access_util.person_ug_map_table;
5: t_ug_learner_list_table ota_learner_access_util.ug_learner_list_table;
6:
7: cursor csr_evt_tree(
8: p_event_id ota_events.event_id%type) is
9: select o.offering_id, i.activity_version_id, i.category_usage_id,

Line 2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);

2332: begin
2333: for elements in csr_user_group_elements(p_user_group_id, p_business_group_id, p_ignore_ug_date_check) loop
2334:
2335: l_user_group_operator := elements.user_group_operator;
2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);

Line 2646: end ota_learner_access_util;

2642: end if;
2643: end if;
2644: end is_full_access_learner_group;
2645:
2646: end ota_learner_access_util;