eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_EVENTS

Line 26: p_event_id in ota_events.event_id%type,

22:
23: function learner_can_enroll(
24: p_person_id in per_people_f.person_id%type,
25: p_party_id in hz_parties.party_id%type,
26: p_event_id in ota_events.event_id%type,
27: p_public_event_flag in ota_events.public_event_flag%type,
28: p_max_internal in ota_events.maximum_internal_attendees%type,
29: p_event_start_date in otv_scheduled_events.course_start_date%type,
30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

Line 27: p_public_event_flag in ota_events.public_event_flag%type,

23: function learner_can_enroll(
24: p_person_id in per_people_f.person_id%type,
25: p_party_id in hz_parties.party_id%type,
26: p_event_id in ota_events.event_id%type,
27: p_public_event_flag in ota_events.public_event_flag%type,
28: p_max_internal in ota_events.maximum_internal_attendees%type,
29: p_event_start_date in otv_scheduled_events.course_start_date%type,
30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
31:

Line 28: p_max_internal in ota_events.maximum_internal_attendees%type,

24: p_person_id in per_people_f.person_id%type,
25: p_party_id in hz_parties.party_id%type,
26: p_event_id in ota_events.event_id%type,
27: p_public_event_flag in ota_events.public_event_flag%type,
28: p_max_internal in ota_events.maximum_internal_attendees%type,
29: p_event_start_date in otv_scheduled_events.course_start_date%type,
30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
31:
32:

Line 30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

26: p_event_id in ota_events.event_id%type,
27: p_public_event_flag in ota_events.public_event_flag%type,
28: p_max_internal in ota_events.maximum_internal_attendees%type,
29: p_event_start_date in otv_scheduled_events.course_start_date%type,
30: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
31:
32:
33: function learner_can_enroll(
34: p_person_id in per_people_f.person_id%type,

Line 36: p_event_id in ota_events.event_id%type,

32:
33: function learner_can_enroll(
34: p_person_id in per_people_f.person_id%type,
35: p_party_id in hz_parties.party_id%type,
36: p_event_id in ota_events.event_id%type,
37: p_event_start_date in otv_scheduled_events.course_start_date%type,
38: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
39:
40: function learner_can_enroll(

Line 38: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

34: p_person_id in per_people_f.person_id%type,
35: p_party_id in hz_parties.party_id%type,
36: p_event_id in ota_events.event_id%type,
37: p_event_start_date in otv_scheduled_events.course_start_date%type,
38: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
39:
40: function learner_can_enroll(
41: p_person_id in per_people_f.person_id%type,
42: p_party_id in hz_parties.party_id%type,

Line 43: p_event_id in ota_events.event_id%type) return varchar2;

39:
40: function learner_can_enroll(
41: p_person_id in per_people_f.person_id%type,
42: p_party_id in hz_parties.party_id%type,
43: p_event_id in ota_events.event_id%type) return varchar2;
44:
45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%type,
47: p_party_id in hz_parties.party_id%type,

Line 48: p_event_id in ota_events.event_id%type,

44:
45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%type,
47: p_party_id in hz_parties.party_id%type,
48: p_event_id in ota_events.event_id%type,
49: p_public_event_flag in ota_events.public_event_flag%type,
50: p_max_internal in ota_events.maximum_internal_attendees%type,
51: p_event_start_date in otv_scheduled_events.course_start_date%type,
52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

Line 49: p_public_event_flag in ota_events.public_event_flag%type,

45: function learner_can_self_enroll(
46: p_person_id in per_people_f.person_id%type,
47: p_party_id in hz_parties.party_id%type,
48: p_event_id in ota_events.event_id%type,
49: p_public_event_flag in ota_events.public_event_flag%type,
50: p_max_internal in ota_events.maximum_internal_attendees%type,
51: p_event_start_date in otv_scheduled_events.course_start_date%type,
52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
53:

Line 50: p_max_internal in ota_events.maximum_internal_attendees%type,

46: p_person_id in per_people_f.person_id%type,
47: p_party_id in hz_parties.party_id%type,
48: p_event_id in ota_events.event_id%type,
49: p_public_event_flag in ota_events.public_event_flag%type,
50: p_max_internal in ota_events.maximum_internal_attendees%type,
51: p_event_start_date in otv_scheduled_events.course_start_date%type,
52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
53:
54:

Line 52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

48: p_event_id in ota_events.event_id%type,
49: p_public_event_flag in ota_events.public_event_flag%type,
50: p_max_internal in ota_events.maximum_internal_attendees%type,
51: p_event_start_date in otv_scheduled_events.course_start_date%type,
52: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
53:
54:
55: function learner_can_self_enroll(
56: p_person_id in per_people_f.person_id%type,

Line 58: p_event_id in ota_events.event_id%type,

54:
55: function learner_can_self_enroll(
56: p_person_id in per_people_f.person_id%type,
57: p_party_id in hz_parties.party_id%type,
58: p_event_id in ota_events.event_id%type,
59: p_event_start_date in otv_scheduled_events.course_start_date%type,
60: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
61:
62: function learner_can_self_enroll(

Line 60: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

56: p_person_id in per_people_f.person_id%type,
57: p_party_id in hz_parties.party_id%type,
58: p_event_id in ota_events.event_id%type,
59: p_event_start_date in otv_scheduled_events.course_start_date%type,
60: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
61:
62: function learner_can_self_enroll(
63: p_person_id in per_people_f.person_id%type,
64: p_party_id in hz_parties.party_id%type,

Line 65: p_event_id in ota_events.event_id%type) return varchar2;

61:
62: function learner_can_self_enroll(
63: p_person_id in per_people_f.person_id%type,
64: p_party_id in hz_parties.party_id%type,
65: p_event_id in ota_events.event_id%type) return varchar2;
66:
67: function employee_can_enroll(
68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,

Line 69: p_event_id in ota_events.event_id%type,

65: p_event_id in ota_events.event_id%type) return varchar2;
66:
67: function employee_can_enroll(
68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,
70: p_public_event_flag ota_events.public_event_flag%type,
71: p_max_internal in ota_events.maximum_internal_attendees%type,
72: p_event_start_date in otv_scheduled_events.course_start_date%type,
73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

Line 70: p_public_event_flag ota_events.public_event_flag%type,

66:
67: function employee_can_enroll(
68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,
70: p_public_event_flag ota_events.public_event_flag%type,
71: p_max_internal in ota_events.maximum_internal_attendees%type,
72: p_event_start_date in otv_scheduled_events.course_start_date%type,
73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
74:

Line 71: p_max_internal in ota_events.maximum_internal_attendees%type,

67: function employee_can_enroll(
68: p_person_id in per_people_f.person_id%type,
69: p_event_id in ota_events.event_id%type,
70: p_public_event_flag ota_events.public_event_flag%type,
71: p_max_internal in ota_events.maximum_internal_attendees%type,
72: p_event_start_date in otv_scheduled_events.course_start_date%type,
73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
74:
75:

Line 73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

69: p_event_id in ota_events.event_id%type,
70: p_public_event_flag ota_events.public_event_flag%type,
71: p_max_internal in ota_events.maximum_internal_attendees%type,
72: p_event_start_date in otv_scheduled_events.course_start_date%type,
73: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
74:
75:
76: function ext_learner_can_enroll(
77: p_party_id in hz_parties.party_id%type,

Line 78: p_event_id in ota_events.event_id%type,

74:
75:
76: function ext_learner_can_enroll(
77: p_party_id in hz_parties.party_id%type,
78: p_event_id in ota_events.event_id%type,
79: p_public_event_flag ota_events.public_event_flag%type,
80: p_max_internal in ota_events.maximum_internal_attendees%type,
81: p_event_start_date in otv_scheduled_events.course_start_date%type,
82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

Line 79: p_public_event_flag ota_events.public_event_flag%type,

75:
76: function ext_learner_can_enroll(
77: p_party_id in hz_parties.party_id%type,
78: p_event_id in ota_events.event_id%type,
79: p_public_event_flag ota_events.public_event_flag%type,
80: p_max_internal in ota_events.maximum_internal_attendees%type,
81: p_event_start_date in otv_scheduled_events.course_start_date%type,
82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
83:

Line 80: p_max_internal in ota_events.maximum_internal_attendees%type,

76: function ext_learner_can_enroll(
77: p_party_id in hz_parties.party_id%type,
78: p_event_id in ota_events.event_id%type,
79: p_public_event_flag ota_events.public_event_flag%type,
80: p_max_internal in ota_events.maximum_internal_attendees%type,
81: p_event_start_date in otv_scheduled_events.course_start_date%type,
82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
83:
84:

Line 82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

78: p_event_id in ota_events.event_id%type,
79: p_public_event_flag ota_events.public_event_flag%type,
80: p_max_internal in ota_events.maximum_internal_attendees%type,
81: p_event_start_date in otv_scheduled_events.course_start_date%type,
82: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
83:
84:
85: function chk_delegate_ok_for_event(
86: p_delegate_id in per_people_f.person_id%type,

Line 87: p_event_id in ota_events.event_id%type,

83:
84:
85: function chk_delegate_ok_for_event(
86: p_delegate_id in per_people_f.person_id%type,
87: p_event_id in ota_events.event_id%type,
88: p_event_start_date in otv_scheduled_events.course_start_date%type,
89: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
90:
91:

Line 89: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;

85: function chk_delegate_ok_for_event(
86: p_delegate_id in per_people_f.person_id%type,
87: p_event_id in ota_events.event_id%type,
88: p_event_start_date in otv_scheduled_events.course_start_date%type,
89: p_parent_offering_id in ota_events.parent_offering_id%type default null) return varchar2;
90:
91:
92: function learner_can_see_category(
93: p_person_id in per_people_f.person_id%type,

Line 347: ,p_event_id ota_events.event_id%TYPE) RETURN VARCHAR2;

343: ,p_person_id in per_all_people_f.person_id%type
344: ,p_party_id in hz_parties.party_id%type) return varchar2;
345:
346: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
347: ,p_event_id ota_events.event_id%TYPE) RETURN VARCHAR2;
348: function get_event_start_date(
349: p_event_id ota_events.event_id%type,
350: p_date date) return date;
351:

Line 349: p_event_id ota_events.event_id%type,

345:
346: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
347: ,p_event_id ota_events.event_id%TYPE) RETURN VARCHAR2;
348: function get_event_start_date(
349: p_event_id ota_events.event_id%type,
350: p_date date) return date;
351:
352: FUNCTION learner_belongs_to_child_org(p_org_structure_version_id IN ota_event_associations. org_structure_version_id%type,
353: p_organization_id IN ota_event_associations.organization_id%type,