APPS.OTA_CPE_UTIL dependencies on WF_ITEMS

Line 52: l_item_key wf_items.item_key%type;

48: (event_type ='SELFPACED' and cpe.cert_period_end_date >= course_start_date)
49: AND (evt.course_end_date is null or (evt.course_end_date IS NOT NULL AND
50: evt.course_end_date >= cpe.cert_period_start_date)) );
51:
52: l_item_key wf_items.item_key%type;
53:
54: begin
55:
56: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1706: l_item_key wf_items.item_key%type;

1702: l_curr_date date;
1703: l_certification_status_code varchar2(30);
1704: l_is_period_update boolean := false;
1705: l_cert_period_completion_date ota_cert_prd_enrollments.completion_date%type;
1706: l_item_key wf_items.item_key%type;
1707: l_old_status_code ota_cert_enrollments.certification_status_code%type;
1708: l_cert_upd_comp varchar2(1);
1709: Begin
1710: