APPS.PON_THREAD_DISC_PKG dependencies on PON_THREAD_ENTRIES

Line 137: SELECT pon_thread_entries_s.nextval

133: l_now_date DATE;
134:
135: BEGIN
136:
137: SELECT pon_thread_entries_s.nextval
138: INTO l_entry_id FROM dual;
139:
140: l_now_date := sysdate;
141:

Line 142: INSERT INTO pon_thread_entries(

138: INTO l_entry_id FROM dual;
139:
140: l_now_date := sysdate;
141:
142: INSERT INTO pon_thread_entries(
143: ENTRY_ID,
144: PARENT_ENTRY_ID,
145: FROM_ID,
146: FROM_FIRST_NAME,

Line 482: FROM PON_THREAD_ENTRIES

478: /* Bug 5253337. Buyers viewing EXTERNAL Group messages should not be
479: shown in the 'To' field while viewing the message.*/
480: SELECT from_company_id
481: INTO l_from_company_id
482: FROM PON_THREAD_ENTRIES
483: WHERE entry_id = p_entry_id;
484:
485:
486: FOR teammember IN memberlist(p_entry_id, p_from_id, p_message_type, l_from_company_id ) LOOP

Line 542: FROM pon_thread_entries pte, pon_te_recipients ptr

538:
539: -- then we see if this is a sender or recipient with a record
540: SELECT decode(replied_flag, 'Y', l_msg_replied, decode(read_flag, 'Y', l_msg_read, l_msg_unread))
541: INTO l_message_status
542: FROM pon_thread_entries pte, pon_te_recipients ptr
543: WHERE pte.entry_id = p_entry_id
544: AND ptr.entry_id = pte.entry_id
545: AND ((pte.from_id = p_viewer_id AND pte.from_id = ptr.to_id)
546: OR (ptr.to_id = p_viewer_id AND pte.from_id <> ptr.to_id));