APPS.OTA_LRNR_ENROLL_UNENROLL_WF dependencies on OTA_CERTIFICATIONS_B

Line 9: p_certificationid in ota_certifications_b.certification_id%type)

5:
6: Procedure Cert_Enrollment(p_process in wf_process_activities.process_name%type,
7: p_itemtype in wf_items.item_type%type,
8: p_person_id in number ,
9: p_certificationid in ota_certifications_b.certification_id%type)
10:
11: is
12: l_proc varchar2(72) := g_package||'Cert_Enrollment';
13: l_process wf_activities.name%type := upper(p_process);

Line 19: l_cert_comp_date ota_certifications_b.initial_completion_date%type;

15: l_item_key wf_items.item_key%type;
16:
17:
18: l_cert_name ota_certifications_tl.name%type;
19: l_cert_comp_date ota_certifications_b.initial_completion_date%type;
20: l_cert_dur ota_certifications_b.initial_completion_duration%type;
21:
22:
23:

Line 20: l_cert_dur ota_certifications_b.initial_completion_duration%type;

16:
17:
18: l_cert_name ota_certifications_tl.name%type;
19: l_cert_comp_date ota_certifications_b.initial_completion_date%type;
20: l_cert_dur ota_certifications_b.initial_completion_duration%type;
21:
22:
23:
24: l_process_display_name varchar2(240);

Line 35: from ota_Certifications_tl ctl , ota_Certifications_b ctb

31:
32:
33: Cursor get_cert_details is
34: select ctl.name, ctb.initial_completion_date,ctb.initial_completion_duration
35: from ota_Certifications_tl ctl , ota_Certifications_b ctb
36: where ctl.certification_id = ctb.certification_id
37: and ctl.Language= USERENV('LANG')
38: and ctl.certification_id= p_certificationid;
39: