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_CERT_APPROVAL_SS dependencies on OTA_CERTIFICATIONS_VL

Line 665: l_name ota_certifications_vl.name%type;

661: ,p_review_data out nocopy varchar2
662: )
663: is
664:
665: l_name ota_certifications_vl.name%type;
666: l_description ota_certifications_vl.description%type;
667: l_objectives ota_certifications_vl.objectives%type;
668: l_purpose ota_certifications_vl.purpose%type;
669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;

Line 666: l_description ota_certifications_vl.description%type;

662: )
663: is
664:
665: l_name ota_certifications_vl.name%type;
666: l_description ota_certifications_vl.description%type;
667: l_objectives ota_certifications_vl.objectives%type;
668: l_purpose ota_certifications_vl.purpose%type;
669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;
670: l_init_comp_dur varchar2(100);

Line 667: l_objectives ota_certifications_vl.objectives%type;

663: is
664:
665: l_name ota_certifications_vl.name%type;
666: l_description ota_certifications_vl.description%type;
667: l_objectives ota_certifications_vl.objectives%type;
668: l_purpose ota_certifications_vl.purpose%type;
669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;
670: l_init_comp_dur varchar2(100);
671: l_renewal_dur varchar2(100);

Line 668: l_purpose ota_certifications_vl.purpose%type;

664:
665: l_name ota_certifications_vl.name%type;
666: l_description ota_certifications_vl.description%type;
667: l_objectives ota_certifications_vl.objectives%type;
668: l_purpose ota_certifications_vl.purpose%type;
669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;
670: l_init_comp_dur varchar2(100);
671: l_renewal_dur varchar2(100);
672: l_notif_days varchar2(100);

Line 669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;

665: l_name ota_certifications_vl.name%type;
666: l_description ota_certifications_vl.description%type;
667: l_objectives ota_certifications_vl.objectives%type;
668: l_purpose ota_certifications_vl.purpose%type;
669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;
670: l_init_comp_dur varchar2(100);
671: l_renewal_dur varchar2(100);
672: l_notif_days varchar2(100);
673: l_initial_comments ota_certifications_vl.initial_period_comments%type;

Line 673: l_initial_comments ota_certifications_vl.initial_period_comments%type;

669: l_init_comp_date ota_certifications_vl.initial_completion_date%type;
670: l_init_comp_dur varchar2(100);
671: l_renewal_dur varchar2(100);
672: l_notif_days varchar2(100);
673: l_initial_comments ota_certifications_vl.initial_period_comments%type;
674: l_certification_id ota_cert_enrollments.certification_id%type;
675:
676: /* cursor get_certification_info(crs_Certification_id number)
677: is

Line 683: from ota_certifications_vl

679: to_char(initial_completion_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')),
680: initial_completion_duration || initial_compl_duration_units,
681: renewal_duration || renewal_duration_units,
682: notify_days_before_expire,initial_period_comments
683: from ota_certifications_vl
684: where certification_id = crs_certification_id;
685: */
686:
687: begin