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 1914: p_certification_id in ota_certifications_b.certification_id%type,

1910:
1911:
1912: function emp_has_access_to_cert(
1913: p_person_id in per_people_f.person_id%type,
1914: p_certification_id in ota_certifications_b.certification_id%type,
1915: p_self_enroll_only in varchar2) return varchar2 is
1916:
1917: l_now date := sysdate;
1918: l_category_usage_id ota_category_usages.category_usage_id%type;

Line 1966: p_certification_id in ota_certifications_b.certification_id%type,

1962:
1963:
1964: function ext_has_access_to_cert(
1965: p_party_id in hz_parties.party_id%type,
1966: p_certification_id in ota_certifications_b.certification_id%type,
1967: p_self_enroll_only in varchar2) return varchar2 is
1968:
1969: l_category_usage_id ota_category_usages.category_usage_id%type;
1970: l_parent_cat_usage_id_1 ota_category_usages.category_usage_id%type;

Line 2001: p_certification_id in ota_certifications_b.certification_id%type,

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

Line 2002: p_public_flag ota_certifications_b.public_flag%type,

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

Line 2003: p_start_date_active in ota_certifications_b.start_date_active%type,

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

Line 2016: p_certification_id in ota_certifications_b.certification_id%type,

2012:
2013:
2014: function emp_can_self_enroll_in_cert(
2015: p_person_id in per_people_f.person_id%type,
2016: p_certification_id in ota_certifications_b.certification_id%type,
2017: p_public_flag ota_certifications_b.public_flag%type,
2018: p_start_date_active in ota_certifications_b.start_date_active%type,
2019: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2020: begin

Line 2017: p_public_flag ota_certifications_b.public_flag%type,

2013:
2014: function emp_can_self_enroll_in_cert(
2015: p_person_id in per_people_f.person_id%type,
2016: p_certification_id in ota_certifications_b.certification_id%type,
2017: p_public_flag ota_certifications_b.public_flag%type,
2018: p_start_date_active in ota_certifications_b.start_date_active%type,
2019: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2020: begin
2021: -- A public certification disregards its learner access records. Learner access records

Line 2018: p_start_date_active in ota_certifications_b.start_date_active%type,

2014: function emp_can_self_enroll_in_cert(
2015: p_person_id in per_people_f.person_id%type,
2016: p_certification_id in ota_certifications_b.certification_id%type,
2017: p_public_flag ota_certifications_b.public_flag%type,
2018: p_start_date_active in ota_certifications_b.start_date_active%type,
2019: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2020: begin
2021: -- A public certification disregards its learner access records. Learner access records
2022: -- are the only way a certification can be made self-enrollable. Therefore, the employee cannot

Line 2034: p_certification_id in ota_certifications_b.certification_id%type,

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

Line 2035: p_public_flag ota_certifications_b.public_flag%type,

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

Line 2036: p_start_date_active in ota_certifications_b.start_date_active%type,

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

Line 2049: p_certification_id in ota_certifications_b.certification_id%type,

2045:
2046:
2047: function ext_can_self_enroll_in_cert(
2048: p_party_id in hz_parties.party_id%type,
2049: p_certification_id in ota_certifications_b.certification_id%type,
2050: p_public_flag ota_certifications_b.public_flag%type,
2051: p_start_date_active in ota_certifications_b.start_date_active%type,
2052: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2053: begin

Line 2050: p_public_flag ota_certifications_b.public_flag%type,

2046:
2047: function ext_can_self_enroll_in_cert(
2048: p_party_id in hz_parties.party_id%type,
2049: p_certification_id in ota_certifications_b.certification_id%type,
2050: p_public_flag ota_certifications_b.public_flag%type,
2051: p_start_date_active in ota_certifications_b.start_date_active%type,
2052: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2053: begin
2054: -- A public certification disregards its learner access records. Learner access records

Line 2051: p_start_date_active in ota_certifications_b.start_date_active%type,

2047: function ext_can_self_enroll_in_cert(
2048: p_party_id in hz_parties.party_id%type,
2049: p_certification_id in ota_certifications_b.certification_id%type,
2050: p_public_flag ota_certifications_b.public_flag%type,
2051: p_start_date_active in ota_certifications_b.start_date_active%type,
2052: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2053: begin
2054: -- A public certification disregards its learner access records. Learner access records
2055: -- are the only way a certification can be made self-enrollable. Therefore, the ext learner cannot

Line 2068: p_certification_id in ota_certifications_b.certification_id%type,

2064:
2065: function learner_can_enroll_in_cert(
2066: p_person_id in per_people_f.person_id%type,
2067: p_party_id in hz_parties.party_id%type,
2068: p_certification_id in ota_certifications_b.certification_id%type,
2069: p_public_flag ota_certifications_b.public_flag%type,
2070: p_start_date_active in ota_certifications_b.start_date_active%type,
2071: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2072: begin

Line 2069: p_public_flag ota_certifications_b.public_flag%type,

2065: function learner_can_enroll_in_cert(
2066: p_person_id in per_people_f.person_id%type,
2067: p_party_id in hz_parties.party_id%type,
2068: p_certification_id in ota_certifications_b.certification_id%type,
2069: p_public_flag ota_certifications_b.public_flag%type,
2070: p_start_date_active in ota_certifications_b.start_date_active%type,
2071: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2072: begin
2073: if p_person_id is not null then

Line 2070: p_start_date_active in ota_certifications_b.start_date_active%type,

2066: p_person_id in per_people_f.person_id%type,
2067: p_party_id in hz_parties.party_id%type,
2068: p_certification_id in ota_certifications_b.certification_id%type,
2069: p_public_flag ota_certifications_b.public_flag%type,
2070: p_start_date_active in ota_certifications_b.start_date_active%type,
2071: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2072: begin
2073: if p_person_id is not null then
2074: return emp_can_enroll_in_cert(p_person_id, p_certification_id, p_public_flag, p_start_date_active, p_category_usage_id);

Line 2083: p_certification_id in ota_certifications_b.certification_id%type,

2079:
2080:
2081: function learner_can_enroll_in_cert(
2082: p_user_id in fnd_user.user_id%type,
2083: p_certification_id in ota_certifications_b.certification_id%type,
2084: p_public_flag ota_certifications_b.public_flag%type,
2085: p_start_date_active in ota_certifications_b.start_date_active%type,
2086: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2087:

Line 2084: p_public_flag ota_certifications_b.public_flag%type,

2080:
2081: function learner_can_enroll_in_cert(
2082: p_user_id in fnd_user.user_id%type,
2083: p_certification_id in ota_certifications_b.certification_id%type,
2084: p_public_flag ota_certifications_b.public_flag%type,
2085: p_start_date_active in ota_certifications_b.start_date_active%type,
2086: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2087:
2088: v_employee_id fnd_user.employee_id%type;

Line 2085: p_start_date_active in ota_certifications_b.start_date_active%type,

2081: function learner_can_enroll_in_cert(
2082: p_user_id in fnd_user.user_id%type,
2083: p_certification_id in ota_certifications_b.certification_id%type,
2084: p_public_flag ota_certifications_b.public_flag%type,
2085: p_start_date_active in ota_certifications_b.start_date_active%type,
2086: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2087:
2088: v_employee_id fnd_user.employee_id%type;
2089: v_party_id hz_parties.party_id%type;

Line 2103: p_certification_id in ota_certifications_b.certification_id%type,

2099:
2100: function lrn_can_self_enroll_in_cert(
2101: p_person_id in per_people_f.person_id%type,
2102: p_party_id in hz_parties.party_id%type,
2103: p_certification_id in ota_certifications_b.certification_id%type,
2104: p_public_flag ota_certifications_b.public_flag%type,
2105: p_start_date_active in ota_certifications_b.start_date_active%type,
2106: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2107: begin

Line 2104: p_public_flag ota_certifications_b.public_flag%type,

2100: function lrn_can_self_enroll_in_cert(
2101: p_person_id in per_people_f.person_id%type,
2102: p_party_id in hz_parties.party_id%type,
2103: p_certification_id in ota_certifications_b.certification_id%type,
2104: p_public_flag ota_certifications_b.public_flag%type,
2105: p_start_date_active in ota_certifications_b.start_date_active%type,
2106: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2107: begin
2108: if p_person_id is not null then

Line 2105: p_start_date_active in ota_certifications_b.start_date_active%type,

2101: p_person_id in per_people_f.person_id%type,
2102: p_party_id in hz_parties.party_id%type,
2103: p_certification_id in ota_certifications_b.certification_id%type,
2104: p_public_flag ota_certifications_b.public_flag%type,
2105: p_start_date_active in ota_certifications_b.start_date_active%type,
2106: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2107: begin
2108: if p_person_id is not null then
2109: 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 2118: p_certification_id in ota_certifications_b.certification_id%type,

2114:
2115:
2116: function lrn_can_self_enroll_in_cert(
2117: p_user_id in fnd_user.user_id%type,
2118: p_certification_id in ota_certifications_b.certification_id%type,
2119: p_public_flag ota_certifications_b.public_flag%type,
2120: p_start_date_active in ota_certifications_b.start_date_active%type,
2121: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2122:

Line 2119: p_public_flag ota_certifications_b.public_flag%type,

2115:
2116: function lrn_can_self_enroll_in_cert(
2117: p_user_id in fnd_user.user_id%type,
2118: p_certification_id in ota_certifications_b.certification_id%type,
2119: p_public_flag ota_certifications_b.public_flag%type,
2120: p_start_date_active in ota_certifications_b.start_date_active%type,
2121: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2122:
2123: v_employee_id fnd_user.employee_id%type;

Line 2120: p_start_date_active in ota_certifications_b.start_date_active%type,

2116: function lrn_can_self_enroll_in_cert(
2117: p_user_id in fnd_user.user_id%type,
2118: p_certification_id in ota_certifications_b.certification_id%type,
2119: p_public_flag ota_certifications_b.public_flag%type,
2120: p_start_date_active in ota_certifications_b.start_date_active%type,
2121: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2 is
2122:
2123: v_employee_id fnd_user.employee_id%type;
2124: v_party_id hz_parties.party_id%type;

Line 2164: p_certification_id in ota_certifications_b.certification_id%type

2160:
2161: END learner_can_enroll_in_path;
2162:
2163: function learner_can_enroll_in_cert(
2164: p_certification_id in ota_certifications_b.certification_id%type
2165: ,p_person_id in per_all_people_f.person_id%type
2166: ,p_party_id in hz_parties.party_id%type) return varchar2
2167: IS
2168: CURSOR csr_get_cert_details IS

Line 2170: FROM ota_certifications_b

2166: ,p_party_id in hz_parties.party_id%type) return varchar2
2167: IS
2168: CURSOR csr_get_cert_details IS
2169: SELECT public_flag, start_date_active
2170: FROM ota_certifications_b
2171: WHERE certification_id = p_certification_id;
2172:
2173: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2174: l_public_flag ota_certifications_b.public_flag%TYPE;

Line 2173: l_start_date_active ota_certifications_b.start_date_active%TYPE;

2169: SELECT public_flag, start_date_active
2170: FROM ota_certifications_b
2171: WHERE certification_id = p_certification_id;
2172:
2173: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2174: l_public_flag ota_certifications_b.public_flag%TYPE;
2175: BEGIN
2176: OPEN csr_get_cert_details;
2177: FETCH csr_get_cert_details INTO l_public_flag, l_start_date_active ;

Line 2174: l_public_flag ota_certifications_b.public_flag%TYPE;

2170: FROM ota_certifications_b
2171: WHERE certification_id = p_certification_id;
2172:
2173: l_start_date_active ota_certifications_b.start_date_active%TYPE;
2174: l_public_flag ota_certifications_b.public_flag%TYPE;
2175: BEGIN
2176: OPEN csr_get_cert_details;
2177: FETCH csr_get_cert_details INTO l_public_flag, l_start_date_active ;
2178: IF csr_get_cert_details%NOTFOUND THEN