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 1579: p_certification_id in ota_certifications_b.certification_id%type,

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

Line 1588: From ota_certifications_b ceb

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

Line 1597: l_end_date_active ota_certifications_b.end_date_active%type;

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

Line 1646: l_certification_id ota_certifications_b.certification_id%type;

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

Line 1657: From ota_certifications_b ceb

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

Line 1678: From ota_certifications_b ceb

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

Line 1696: From ota_certifications_b ceb

1692: cursor get_data_for_completion_ntf is
1693: Select ceb.certification_id
1694: ,prd.cert_prd_enrollment_id
1695: ,enr.person_id
1696: From ota_certifications_b ceb
1697: ,ota_cert_enrollments enr
1698: ,ota_cert_prd_enrollments prd
1699: Where
1700: ceb.certification_id = enr.certification_id

Line 1715: From ota_certifications_b ceb

1711: cursor get_data_for_renewal_ntf is
1712: Select ceb.certification_id
1713: ,prd.cert_prd_enrollment_id
1714: ,enr.person_id
1715: From ota_certifications_b ceb
1716: ,ota_cert_enrollments enr
1717: ,ota_cert_prd_enrollments prd
1718: Where
1719: ceb.certification_id = enr.certification_id

Line 1730: From ota_certifications_b ceb

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