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_PRD_ENROLLMENTS

Line 29: Function chk_cert_prd_compl(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type)

25: -- Internal Development Use Only.
26: --
27: -- {End Of Comments}
28: -- ---------------------------------------------------------------------------
29: Function chk_cert_prd_compl(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type)
30: return varchar2;
31:
32: Procedure crt_comp_upd_succ_att(p_event_id in ota_events.event_id%type,
33: p_person_id in number

Line 36: Function is_cert_success_complete(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

32: Procedure crt_comp_upd_succ_att(p_event_id in ota_events.event_id%type,
33: p_person_id in number
34: );
35:
36: Function is_cert_success_complete(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
37: p_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
38: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_start_date%type,
39: p_person_id in number)
40: return varchar2;

Line 37: p_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,

33: p_person_id in number
34: );
35:
36: Function is_cert_success_complete(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
37: p_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
38: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_start_date%type,
39: p_person_id in number)
40: return varchar2;
41:

Line 38: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_start_date%type,

34: );
35:
36: Function is_cert_success_complete(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
37: p_cert_period_start_date in ota_cert_prd_enrollments.cert_period_start_date%type,
38: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_start_date%type,
39: p_person_id in number)
40: return varchar2;
41:
42: Procedure update_cpe_status(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type

Line 42: Procedure update_cpe_status(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type

38: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_start_date%type,
39: p_person_id in number)
40: return varchar2;
41:
42: Procedure update_cpe_status(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type
43: ,p_certification_status_code OUT NOCOPY VARCHAR2
44: ,p_enroll_from in varchar2 default null
45: ,p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null
46: ,p_child_update_flag in varchar2 default 'Y'

Line 45: ,p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null

41:
42: Procedure update_cpe_status(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type
43: ,p_certification_status_code OUT NOCOPY VARCHAR2
44: ,p_enroll_from in varchar2 default null
45: ,p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null
46: ,p_child_update_flag in varchar2 default 'Y'
47: ,p_completion_date in date default sysdate);
48:
49: -- ---------------------------------------------------------------------------

Line 120: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_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,
120: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
121: p_code in number default 1)
122: RETURN varchar2;
123:
124: FUNCTION get_cert_mbr_name (p_cert_mbr_id in ota_certification_members.certification_member_id%TYPE)

Line 131: FUNCTION get_cpe_edit_enabled(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE)

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)
132: RETURN varchar2;
133:
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,

Line 134: FUNCTION chk_prd_end_date(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,

130:
131: FUNCTION get_cpe_edit_enabled(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE)
132: RETURN varchar2;
133:
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,

Line 135: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%TYPE,

131: FUNCTION get_cpe_edit_enabled(p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE)
132: RETURN varchar2;
133:
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,

Line 141: p_cert_prd_enrollment_id OUT NOCOPY ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

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,
143: p_is_recert in varchar2 default 'N');
144:
145: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

Line 145: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

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,
143: p_is_recert in varchar2 default 'N');
144:
145: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%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,

Line 148: procedure update_admin_changes(p_cert_enrollment_id in ota_cert_prd_enrollments.cert_enrollment_id%type,

144:
145: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%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,

Line 149: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

145: PROCEDURE delete_prd_cascade(p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%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),

Line 151: p_cert_period_end_date in ota_cert_prd_enrollments.cert_period_end_date%type default null,

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');
155:

Line 153: p_cert_period_completion_date in ota_cert_prd_enrollments.completion_date%type default trunc(sysdate),

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');
155:
156: Procedure update_cert_status_to_expired(
157: ERRBUF OUT NOCOPY VARCHAR2,