APPS.OTA_INITIALIZATION_WF dependencies on OTA_FORUM_MESSAGES

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

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

Line 1805: p_Forum_message_id in ota_forum_messages.forum_message_id%type)

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

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

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

Line 1834: l_person_id ota_forum_messages.person_id%type;

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

Line 1835: l_contact_id ota_forum_messages.contact_id%type;

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

Line 1837: l_message_body ota_forum_messages.message_body%type;

1833: l_subject ota_forum_threads.subject%type;
1834: l_person_id ota_forum_messages.person_id%type;
1835: l_contact_id ota_forum_messages.contact_id%type;
1836: l_creation_date varchar2(50);
1837: l_message_body ota_forum_messages.message_body%type;
1838: l_author_name varchar2(300);
1839:
1840:
1841:

Line 1931: l_person_id ota_forum_messages.person_id%type;

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

Line 1932: l_contact_id ota_forum_messages.contact_id%type;

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