APPS.OTA_INITIALIZATION_WF dependencies on OTA_FORUM_MESSAGES

Line 1800: Procedure init_forum_notif(p_Forum_id in ota_forum_messages.forum_id%type,

1796: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1797: ||','||SUBSTR(SQLERRM, 1, 500));
1798: end process_cert_alert;
1799: --
1800: Procedure init_forum_notif(p_Forum_id in ota_forum_messages.forum_id%type,
1801: p_Forum_message_id in ota_forum_messages.forum_message_id%type)
1802: is
1803:
1804: l_proc varchar2(72) := g_package||'init_forum_notif';

Line 1801: p_Forum_message_id in ota_forum_messages.forum_message_id%type)

1797: ||','||SUBSTR(SQLERRM, 1, 500));
1798: end process_cert_alert;
1799: --
1800: Procedure init_forum_notif(p_Forum_id in ota_forum_messages.forum_id%type,
1801: p_Forum_message_id in ota_forum_messages.forum_message_id%type)
1802: is
1803:
1804: l_proc varchar2(72) := g_package||'init_forum_notif';
1805:

Line 1814: from ota_forum_messages ofm ,ota_forum_threads fth ,ota_forums_tl oft

1810: cursor get_message_details
1811: is
1812: select oft.name,fth.subject,ofm.person_id,ofm.contact_id,
1813: ofm.creation_date,ofm.message_body
1814: from ota_forum_messages ofm ,ota_forum_threads fth ,ota_forums_tl oft
1815: where oft.forum_id = ofm.forum_id
1816: and ofm.forum_thread_id = fth.forum_thread_id
1817: and ofm.forum_message_id = p_Forum_message_id
1818: and oft.language= USERENV('LANG');

Line 1830: l_person_id ota_forum_messages.person_id%type;

1826:
1827:
1828: l_forum_name ota_forums_tl.name%type;
1829: l_subject ota_forum_threads.subject%type;
1830: l_person_id ota_forum_messages.person_id%type;
1831: l_contact_id ota_forum_messages.contact_id%type;
1832: l_creation_date varchar2(50);
1833: l_message_body ota_forum_messages.message_body%type;
1834: l_author_name varchar2(300);

Line 1831: l_contact_id ota_forum_messages.contact_id%type;

1827:
1828: l_forum_name ota_forums_tl.name%type;
1829: l_subject ota_forum_threads.subject%type;
1830: l_person_id ota_forum_messages.person_id%type;
1831: l_contact_id ota_forum_messages.contact_id%type;
1832: l_creation_date varchar2(50);
1833: l_message_body ota_forum_messages.message_body%type;
1834: l_author_name varchar2(300);
1835:

Line 1833: l_message_body ota_forum_messages.message_body%type;

1829: l_subject ota_forum_threads.subject%type;
1830: l_person_id ota_forum_messages.person_id%type;
1831: l_contact_id ota_forum_messages.contact_id%type;
1832: l_creation_date varchar2(50);
1833: l_message_body ota_forum_messages.message_body%type;
1834: l_author_name varchar2(300);
1835:
1836:
1837:

Line 1927: l_person_id ota_forum_messages.person_id%type;

1923: l_item_key wf_items.item_key%type;
1924: l_item_type wf_items.item_type%type := 'OTWF';
1925: l_process wf_activities.name%type := 'OTA_COURSE_EVAL_PRC';
1926:
1927: l_person_id ota_forum_messages.person_id%type;
1928: l_contact_id ota_forum_messages.contact_id%type;
1929: l_event_id ota_events.event_id%type;
1930: l_status_type ota_booking_status_types.type%type;
1931:

Line 1928: l_contact_id ota_forum_messages.contact_id%type;

1924: l_item_type wf_items.item_type%type := 'OTWF';
1925: l_process wf_activities.name%type := 'OTA_COURSE_EVAL_PRC';
1926:
1927: l_person_id ota_forum_messages.person_id%type;
1928: l_contact_id ota_forum_messages.contact_id%type;
1929: l_event_id ota_events.event_id%type;
1930: l_status_type ota_booking_status_types.type%type;
1931:
1932: cursor csr_booking_status is