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_CERTIFICATIONS_B

Line 92: p_certification_id ota_certifications_b.certification_id%type) is

88: c3.parent_cat_usage_id = c4.category_usage_id(+);
89:
90:
91: cursor csr_cert_tree(
92: p_certification_id ota_certifications_b.certification_id%type) is
93: select i.category_usage_id,
94: c1.parent_cat_usage_id as parent_cat_usage_id_1,
95: c2.parent_cat_usage_id as parent_cat_usage_id_2,
96: c3.parent_cat_usage_id as parent_cat_usage_id_3,

Line 353: p_certification_id in ota_certifications_b.certification_id%type,

349:
350:
351: cursor csr_cert_assoc(
352: p_self_enroll_only varchar2,
353: p_certification_id in ota_certifications_b.certification_id%type,
354: p_category_usage_id ota_category_usages.category_usage_id%type,
355: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
356: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
357: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 372: p_certification_id in ota_certifications_b.certification_id%type,

368:
369: cursor csr_cert_assoc_ext(
370: p_self_enroll_only varchar2,
371: p_party_id hz_parties.party_id%type,
372: p_certification_id in ota_certifications_b.certification_id%type,
373: p_category_usage_id ota_category_usages.category_usage_id%type,
374: p_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type,
375: p_parent_cat_usage_id_2 ota_category_usages.category_usage_id%type,
376: p_parent_cat_usage_id_3 ota_category_usages.category_usage_id%type,

Line 1901: p_certification_id in ota_certifications_b.certification_id%type,

1897:
1898:
1899: function emp_has_access_to_cert(
1900: p_person_id in per_people_f.person_id%type,
1901: p_certification_id in ota_certifications_b.certification_id%type,
1902: p_self_enroll_only in varchar2) return varchar2 is
1903:
1904: l_now date := sysdate;
1905: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 1953: p_certification_id in ota_certifications_b.certification_id%type,

1949:
1950:
1951: function ext_has_access_to_cert(
1952: p_party_id in hz_parties.party_id%type,
1953: p_certification_id in ota_certifications_b.certification_id%type,
1954: p_self_enroll_only in varchar2) return varchar2 is
1955:
1956: l_category_usage_id ota_category_usages.category_usage_id%type;
1957: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;

Line 1988: p_certification_id in ota_certifications_b.certification_id%type,

1984:
1985:
1986: function emp_can_enroll_in_cert(
1987: p_person_id in per_people_f.person_id%type,
1988: p_certification_id in ota_certifications_b.certification_id%type,
1989: p_public_flag ota_certifications_b.public_flag%type,
1990: p_start_date_active in ota_certifications_b.start_date_active%type,
1991: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1992: begin

Line 1989: p_public_flag ota_certifications_b.public_flag%type,

1985:
1986: function emp_can_enroll_in_cert(
1987: p_person_id in per_people_f.person_id%type,
1988: p_certification_id in ota_certifications_b.certification_id%type,
1989: p_public_flag ota_certifications_b.public_flag%type,
1990: p_start_date_active in ota_certifications_b.start_date_active%type,
1991: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1992: begin
1993: if p_public_flag = 'Y' then

Line 1990: p_start_date_active in ota_certifications_b.start_date_active%type,

1986: function emp_can_enroll_in_cert(
1987: p_person_id in per_people_f.person_id%type,
1988: p_certification_id in ota_certifications_b.certification_id%type,
1989: p_public_flag ota_certifications_b.public_flag%type,
1990: p_start_date_active in ota_certifications_b.start_date_active%type,
1991: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
1992: begin
1993: if p_public_flag = 'Y' then
1994: return 'Y';

Line 2003: p_certification_id in ota_certifications_b.certification_id%type,

1999:
2000:
2001: function emp_can_self_enroll_in_cert(
2002: p_person_id in per_people_f.person_id%type,
2003: p_certification_id in ota_certifications_b.certification_id%type,
2004: p_public_flag ota_certifications_b.public_flag%type,
2005: p_start_date_active in ota_certifications_b.start_date_active%type,
2006: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2007: begin

Line 2004: p_public_flag ota_certifications_b.public_flag%type,

2000:
2001: function emp_can_self_enroll_in_cert(
2002: p_person_id in per_people_f.person_id%type,
2003: p_certification_id in ota_certifications_b.certification_id%type,
2004: p_public_flag ota_certifications_b.public_flag%type,
2005: p_start_date_active in ota_certifications_b.start_date_active%type,
2006: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2007: begin
2008: -- A public certification disregards its learner access records. Learner access records

Line 2005: p_start_date_active in ota_certifications_b.start_date_active%type,

2001: function emp_can_self_enroll_in_cert(
2002: p_person_id in per_people_f.person_id%type,
2003: p_certification_id in ota_certifications_b.certification_id%type,
2004: p_public_flag ota_certifications_b.public_flag%type,
2005: p_start_date_active in ota_certifications_b.start_date_active%type,
2006: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2007: begin
2008: -- A public certification disregards its learner access records. Learner access records
2009: -- are the only way a certification can be made self-enrollable. Therefore, the employee cannot

Line 2021: p_certification_id in ota_certifications_b.certification_id%type,

2017:
2018:
2019: function ext_can_enroll_in_cert(
2020: p_party_id in hz_parties.party_id%type,
2021: p_certification_id in ota_certifications_b.certification_id%type,
2022: p_public_flag ota_certifications_b.public_flag%type,
2023: p_start_date_active in ota_certifications_b.start_date_active%type,
2024: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2025: begin

Line 2022: p_public_flag ota_certifications_b.public_flag%type,

2018:
2019: function ext_can_enroll_in_cert(
2020: p_party_id in hz_parties.party_id%type,
2021: p_certification_id in ota_certifications_b.certification_id%type,
2022: p_public_flag ota_certifications_b.public_flag%type,
2023: p_start_date_active in ota_certifications_b.start_date_active%type,
2024: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2025: begin
2026: if p_public_flag = 'Y' then

Line 2023: p_start_date_active in ota_certifications_b.start_date_active%type,

2019: function ext_can_enroll_in_cert(
2020: p_party_id in hz_parties.party_id%type,
2021: p_certification_id in ota_certifications_b.certification_id%type,
2022: p_public_flag ota_certifications_b.public_flag%type,
2023: p_start_date_active in ota_certifications_b.start_date_active%type,
2024: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2025: begin
2026: if p_public_flag = 'Y' then
2027: return 'Y';

Line 2036: p_certification_id in ota_certifications_b.certification_id%type,

2032:
2033:
2034: function ext_can_self_enroll_in_cert(
2035: p_party_id in hz_parties.party_id%type,
2036: p_certification_id in ota_certifications_b.certification_id%type,
2037: p_public_flag ota_certifications_b.public_flag%type,
2038: p_start_date_active in ota_certifications_b.start_date_active%type,
2039: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2040: begin

Line 2037: p_public_flag ota_certifications_b.public_flag%type,

2033:
2034: function ext_can_self_enroll_in_cert(
2035: p_party_id in hz_parties.party_id%type,
2036: p_certification_id in ota_certifications_b.certification_id%type,
2037: p_public_flag ota_certifications_b.public_flag%type,
2038: p_start_date_active in ota_certifications_b.start_date_active%type,
2039: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2040: begin
2041: -- A public certification disregards its learner access records. Learner access records

Line 2038: p_start_date_active in ota_certifications_b.start_date_active%type,

2034: function ext_can_self_enroll_in_cert(
2035: p_party_id in hz_parties.party_id%type,
2036: p_certification_id in ota_certifications_b.certification_id%type,
2037: p_public_flag ota_certifications_b.public_flag%type,
2038: p_start_date_active in ota_certifications_b.start_date_active%type,
2039: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2040: begin
2041: -- A public certification disregards its learner access records. Learner access records
2042: -- are the only way a certification can be made self-enrollable. Therefore, the ext learner cannot

Line 2055: p_certification_id in ota_certifications_b.certification_id%type,

2051:
2052: function learner_can_enroll_in_cert(
2053: p_person_id in per_people_f.person_id%type,
2054: p_party_id in hz_parties.party_id%type,
2055: p_certification_id in ota_certifications_b.certification_id%type,
2056: p_public_flag ota_certifications_b.public_flag%type,
2057: p_start_date_active in ota_certifications_b.start_date_active%type,
2058: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2059: begin

Line 2056: p_public_flag ota_certifications_b.public_flag%type,

2052: function learner_can_enroll_in_cert(
2053: p_person_id in per_people_f.person_id%type,
2054: p_party_id in hz_parties.party_id%type,
2055: p_certification_id in ota_certifications_b.certification_id%type,
2056: p_public_flag ota_certifications_b.public_flag%type,
2057: p_start_date_active in ota_certifications_b.start_date_active%type,
2058: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2059: begin
2060: if p_person_id is not null then

Line 2057: p_start_date_active in ota_certifications_b.start_date_active%type,

2053: p_person_id in per_people_f.person_id%type,
2054: p_party_id in hz_parties.party_id%type,
2055: p_certification_id in ota_certifications_b.certification_id%type,
2056: p_public_flag ota_certifications_b.public_flag%type,
2057: p_start_date_active in ota_certifications_b.start_date_active%type,
2058: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2059: begin
2060: if p_person_id is not null then
2061: return emp_can_enroll_in_cert(p_person_id, p_certification_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 2070: p_certification_id in ota_certifications_b.certification_id%type,

2066:
2067:
2068: function learner_can_enroll_in_cert(
2069: p_user_id in fnd_user.user_id%type,
2070: p_certification_id in ota_certifications_b.certification_id%type,
2071: p_public_flag ota_certifications_b.public_flag%type,
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2074:

Line 2071: p_public_flag ota_certifications_b.public_flag%type,

2067:
2068: function learner_can_enroll_in_cert(
2069: p_user_id in fnd_user.user_id%type,
2070: p_certification_id in ota_certifications_b.certification_id%type,
2071: p_public_flag ota_certifications_b.public_flag%type,
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2074:
2075: v_employee_id fnd_user.employee_id%type;

Line 2072: p_start_date_active in ota_certifications_b.start_date_active%type,

2068: function learner_can_enroll_in_cert(
2069: p_user_id in fnd_user.user_id%type,
2070: p_certification_id in ota_certifications_b.certification_id%type,
2071: p_public_flag ota_certifications_b.public_flag%type,
2072: p_start_date_active in ota_certifications_b.start_date_active%type,
2073: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2074:
2075: v_employee_id fnd_user.employee_id%type;
2076: v_party_id hz_parties.party_id%type;

Line 2090: p_certification_id in ota_certifications_b.certification_id%type,

2086:
2087: function lrn_can_self_enroll_in_cert(
2088: p_person_id in per_people_f.person_id%type,
2089: p_party_id in hz_parties.party_id%type,
2090: p_certification_id in ota_certifications_b.certification_id%type,
2091: p_public_flag ota_certifications_b.public_flag%type,
2092: p_start_date_active in ota_certifications_b.start_date_active%type,
2093: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2094: begin

Line 2091: p_public_flag ota_certifications_b.public_flag%type,

2087: function lrn_can_self_enroll_in_cert(
2088: p_person_id in per_people_f.person_id%type,
2089: p_party_id in hz_parties.party_id%type,
2090: p_certification_id in ota_certifications_b.certification_id%type,
2091: p_public_flag ota_certifications_b.public_flag%type,
2092: p_start_date_active in ota_certifications_b.start_date_active%type,
2093: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2094: begin
2095: if p_person_id is not null then

Line 2092: p_start_date_active in ota_certifications_b.start_date_active%type,

2088: p_person_id in per_people_f.person_id%type,
2089: p_party_id in hz_parties.party_id%type,
2090: p_certification_id in ota_certifications_b.certification_id%type,
2091: p_public_flag ota_certifications_b.public_flag%type,
2092: p_start_date_active in ota_certifications_b.start_date_active%type,
2093: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2094: begin
2095: if p_person_id is not null then
2096: return emp_can_self_enroll_in_cert(p_person_id, p_certification_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 2105: p_certification_id in ota_certifications_b.certification_id%type,

2101:
2102:
2103: function lrn_can_self_enroll_in_cert(
2104: p_user_id in fnd_user.user_id%type,
2105: p_certification_id in ota_certifications_b.certification_id%type,
2106: p_public_flag ota_certifications_b.public_flag%type,
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2109:

Line 2106: p_public_flag ota_certifications_b.public_flag%type,

2102:
2103: function lrn_can_self_enroll_in_cert(
2104: p_user_id in fnd_user.user_id%type,
2105: p_certification_id in ota_certifications_b.certification_id%type,
2106: p_public_flag ota_certifications_b.public_flag%type,
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2109:
2110: v_employee_id fnd_user.employee_id%type;

Line 2107: p_start_date_active in ota_certifications_b.start_date_active%type,

2103: function lrn_can_self_enroll_in_cert(
2104: p_user_id in fnd_user.user_id%type,
2105: p_certification_id in ota_certifications_b.certification_id%type,
2106: p_public_flag ota_certifications_b.public_flag%type,
2107: p_start_date_active in ota_certifications_b.start_date_active%type,
2108: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2109:
2110: v_employee_id fnd_user.employee_id%type;
2111: v_party_id hz_parties.party_id%type;

Line 2151: p_certification_id in ota_certifications_b.certification_id%type

2147:
2148: END learner_can_enroll_in_path;
2149:
2150: function learner_can_enroll_in_cert(
2151: p_certification_id in ota_certifications_b.certification_id%type
2152: ,p_person_id in per_all_people_f.person_id%type
2153: ,p_party_id in hz_parties.party_id%type) return varchar2
2154: IS
2155: CURSOR csr_get_cert_details IS

Line 2157: FROM ota_certifications_b

2153: ,p_party_id in hz_parties.party_id%type) return varchar2
2154: IS
2155: CURSOR csr_get_cert_details IS
2156: SELECT public_flag, start_date_active
2157: FROM ota_certifications_b
2158: WHERE certification_id = p_certification_id;
2159:
2160: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2161: l_public_flag ota_certifications_b.public_flag%TYPE;

Line 2160: l_start_date_active ota_certifications_b.start_date_active%TYPE;

2156: SELECT public_flag, start_date_active
2157: FROM ota_certifications_b
2158: WHERE certification_id = p_certification_id;
2159:
2160: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2161: l_public_flag ota_certifications_b.public_flag%TYPE;
2162: BEGIN
2163: OPEN csr_get_cert_details;
2164: FETCH csr_get_cert_details INTO l_public_flag, l_start_date_active ;

Line 2161: l_public_flag ota_certifications_b.public_flag%TYPE;

2157: FROM ota_certifications_b
2158: WHERE certification_id = p_certification_id;
2159:
2160: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2161: l_public_flag ota_certifications_b.public_flag%TYPE;
2162: BEGIN
2163: OPEN csr_get_cert_details;
2164: FETCH csr_get_cert_details INTO l_public_flag, l_start_date_active ;
2165: IF csr_get_cert_details%NOTFOUND THEN