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_INITIALIZATION_WF dependencies on OTA_CERTIFICATIONS_B

Line 1577: p_certification_id in ota_certifications_b.certification_id%type,

1573: -- Called from alert
1574:
1575: Procedure initialize_cert_ntf_wf(p_item_type in wf_items.item_type%type,
1576: p_person_id in number default null,
1577: p_certification_id in ota_certifications_b.certification_id%type,
1578: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
1579: p_cert_ntf_type in varchar2) is
1580:
1581:

Line 1586: From ota_certifications_b ceb

1582: cursor get_certification_info is
1583: Select cet.name
1584: ,cet.end_date_comments
1585: ,ceb.end_date_active
1586: From ota_certifications_b ceb
1587: ,ota_certifications_tl cet
1588: Where
1589: ceb.certification_id = cet.certification_id
1590: and cet.language = userenv('LANG')

Line 1595: l_end_date_active ota_certifications_b.end_date_active%type;

1591: and ceb.certification_id = p_certification_id;
1592:
1593: l_certification_name ota_certifications_tl.name%type;
1594: l_end_date_comments ota_certifications_tl.end_date_comments%type;
1595: l_end_date_active ota_certifications_b.end_date_active%type;
1596:
1597: l_process wf_activities.name%type := 'OTA_CERTIFICATION_NTF_JSP_PRC';
1598: l_item_key wf_items.item_key%type;
1599:

Line 1644: l_certification_id ota_certifications_b.certification_id%type;

1640: p_cert_ntf_type in varchar2) is
1641:
1642: l_proc varchar2(72) := g_package || ' process_cert_alert';
1643:
1644: l_certification_id ota_certifications_b.certification_id%type;
1645: l_cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
1646: l_person_id ota_cert_enrollments.person_id%type;
1647:
1648: l_item_type VARCHAR2(5) := 'OTWF';

Line 1655: From ota_certifications_b ceb

1651: cursor get_data_for_reminder_ntf is
1652: Select ceb.certification_id
1653: ,prd.cert_prd_enrollment_id
1654: ,enr.person_id
1655: From ota_certifications_b ceb
1656: ,ota_cert_enrollments enr
1657: ,ota_cert_prd_enrollments prd
1658: Where
1659: ceb.certification_id = enr.certification_id

Line 1675: From ota_certifications_b ceb

1671: cursor get_data_for_expiration_ntf is
1672: Select ceb.certification_id
1673: ,prd.cert_prd_enrollment_id
1674: ,enr.person_id
1675: From ota_certifications_b ceb
1676: ,ota_cert_enrollments enr
1677: ,ota_cert_prd_enrollments prd
1678: Where
1679: ceb.certification_id = enr.certification_id

Line 1692: From ota_certifications_b ceb

1688: cursor get_data_for_completion_ntf is
1689: Select ceb.certification_id
1690: ,prd.cert_prd_enrollment_id
1691: ,enr.person_id
1692: From ota_certifications_b ceb
1693: ,ota_cert_enrollments enr
1694: ,ota_cert_prd_enrollments prd
1695: Where
1696: ceb.certification_id = enr.certification_id

Line 1711: From ota_certifications_b ceb

1707: cursor get_data_for_renewal_ntf is
1708: Select ceb.certification_id
1709: ,prd.cert_prd_enrollment_id
1710: ,enr.person_id
1711: From ota_certifications_b ceb
1712: ,ota_cert_enrollments enr
1713: ,ota_cert_prd_enrollments prd
1714: Where
1715: ceb.certification_id = enr.certification_id

Line 1726: From ota_certifications_b ceb

1722: --get all enrollment records for cancellation ntf
1723: cursor get_data_for_cancellation_ntf is
1724: Select ceb.certification_id
1725: ,enr.person_id
1726: From ota_certifications_b ceb
1727: ,ota_cert_enrollments enr
1728: Where
1729: ceb.certification_id = enr.certification_id
1730: and enr.person_id is not null