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_CPE_UTIL dependencies on OTA_CERT_ENROLLMENTS

Line 74: function is_period_renewable(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type)

70: -- Internal Development Use Only.
71: --
72: -- {End Of Comments}
73: -- ---------------------------------------------------------------------------
74: function is_period_renewable(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type)
75: return varchar2;
76:
77: -- ---------------------------------------------------------------------------
78: -- |----------------------< calc_cre_dates >-------------------------|

Line 108: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

104: -- Internal Development Use Only.
105: --
106: -- {End Of Comments}
107: -- ---------------------------------------------------------------------------
108: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
109: p_certification_id in ota_cert_enrollments.certification_id%type,
110: p_mode in varchar2,
111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,

Line 109: p_certification_id in ota_cert_enrollments.certification_id%type,

105: --
106: -- {End Of Comments}
107: -- ---------------------------------------------------------------------------
108: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
109: p_certification_id in ota_cert_enrollments.certification_id%type,
110: p_mode in varchar2,
111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
113: p_cert_period_start_date in date default sysdate);

Line 111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,

107: -- ---------------------------------------------------------------------------
108: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
109: p_certification_id in ota_cert_enrollments.certification_id%type,
110: p_mode in varchar2,
111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
113: p_cert_period_start_date in date default sysdate);
114:
115: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

Line 112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,

108: PROCEDURE calc_cre_dates(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
109: p_certification_id in ota_cert_enrollments.certification_id%type,
110: p_mode in varchar2,
111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
113: p_cert_period_start_date in date default sysdate);
114:
115: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
116: p_cert_period_start_date in date default sysdate)

Line 115: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

111: p_earliest_enroll_date OUT nocopy ota_cert_enrollments.earliest_enroll_date%type,
112: p_expiration_date OUT nocopy ota_cert_enrollments.expiration_date%type,
113: p_cert_period_start_date in date default sysdate);
114:
115: Function get_next_prd_dur_days(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
116: p_cert_period_start_date in date default sysdate)
117: return varchar2;
118:
119: FUNCTION get_cert_mbr_status (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE,

Line 127: FUNCTION get_cre_status (p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

123:
124: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)
125: RETURN varchar2;
126:
127: FUNCTION get_cre_status (p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,
128: p_mode in varchar2 default 'm')
129: RETURN varchar2;
130:
131: FUNCTION get_cpe_edit_enabled(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE)

Line 138: procedure create_cpe_rec(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,

134: FUNCTION chk_prd_end_date(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
135: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%TYPE,
136: p_mass_update_flag in varchar2 default 'N') return varchar2;
137:
138: procedure create_cpe_rec(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type,
139: p_expiration_date in date,
140: p_cert_period_start_date in date default sysdate,
141: p_cert_prd_enrollment_id OUT NOCOPY ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
142: p_certification_status_code OUT NOCOPY VARCHAR2,

Line 150: p_certification_status_code in ota_cert_enrollments.certification_status_code%type,

146: p_return_code OUT NOCOPY varchar2);
147:
148: procedure update_admin_changes(p_cert_enrollment_id in ota_cert_prd_enrollments.cert_enrollment_id%type,
149: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
150: p_certification_status_code in ota_cert_enrollments.certification_status_code%type,
151: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null,
152: p_return_status out NOCOPY VARCHAR2,
153: p_cert_period_completion_date in ota_cert_prd_enrollments.completion_date%type default trunc(sysdate),
154: p_cert_upd_comp in varchar2 default 'N');

Line 164: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,

160: Procedure sync_cert_status_to_class_enrl(
161: ERRBUF OUT NOCOPY VARCHAR2,
162: RETCODE OUT NOCOPY VARCHAR2);
163:
164: FUNCTION get_latest_cpe_col(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%TYPE,
165: p_col_name in varchar2 default 'Period_Status_Meaning') return varchar2;
166:
167: function get_elapsed_due_date(p_certification_id in ota_certifications_b.certification_id%type) return date;
168: