APPS.PON_THREAD_DISC_PKG dependencies on PON_TE_RECIPIENTS

Line 188: -- It inserts a record to pon_te_recipients if it

184: --
185: -- Pre-reqs: None
186: --
187: -- Function: This API is called by the Online Discussion code.
188: -- It inserts a record to pon_te_recipients if it
189: -- does not exists for given p_to_id and p_entry_id.
190: -- Else it will update the record with appropriate
191: -- read or replied flag.
192: --

Line 224: FROM pon_te_recipients

220:
221: BEGIN
222:
223: SELECT COUNT(1) INTO l_row_exists
224: FROM pon_te_recipients
225: WHERE to_id = p_recipient_id
226: AND entry_id = p_entry_id;
227:
228:

Line 246: UPDATE pon_te_recipients

242: END IF;
243:
244: IF (l_row_exists > 0) THEN
245:
246: UPDATE pon_te_recipients
247: SET read_flag = p_read_flag,
248: replied_flag = p_replied_flag
249: WHERE to_id = p_recipient_id
250: AND entry_id = p_entry_id;

Line 254: INSERT INTO pon_te_recipients(

250: AND entry_id = p_entry_id;
251:
252: ELSE
253:
254: INSERT INTO pon_te_recipients(
255: TO_ID,
256: READ_FLAG,
257: ENTRY_ID,
258: REPLIED_FLAG,

Line 313: FROM pon_te_recipients

309: l_replied_state VARCHAR(1);
310: l_module_name VARCHAR2(40) := 'UPDATE_RECIPIENT_TO_READ';
311: BEGIN
312: SELECT count(1) INTO l_num_entries
313: FROM pon_te_recipients
314: WHERE entry_id = p_entry_id
315: AND to_id = p_recipient_id;
316:
317: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 334: FROM pon_te_recipients

330: IF (l_num_entries = 0) THEN
331: insert_or_update_recipient( p_entry_id, p_recipient_id, 'Y', 'N', p_to_company_id, p_to_first_name, p_to_last_name, p_to_company_name);
332: ELSE
333: SELECT replied_flag INTO l_replied_state
334: FROM pon_te_recipients
335: WHERE entry_id = p_entry_id
336: AND to_id = p_recipient_id;
337:
338: insert_or_update_recipient( p_entry_id, p_recipient_id, 'Y', l_replied_state, null, null, null, null);

Line 398: FROM PON_TE_RECIPIENTS PTR

394: l_module_name VARCHAR2(40) := 'GET_REPLIED_BY_LIST';
395:
396: CURSOR memberlist(x_entry_id NUMBER,x_auctioneer_tp_id NUMBER, x_to_id NUMBER, x_message_type VARCHAR2) IS
397: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) as name
398: FROM PON_TE_RECIPIENTS PTR
399: WHERE PTR.REPLIED_FLAG='Y'
400: AND PTR.ENTRY_ID = x_entry_id
401: AND PTR.TO_COMPANY_ID = x_auctioneer_tp_id -- auctioneer's trading partner id
402: AND PTR.TO_ID <> x_to_id -- Replied by Others

Line 460: FROM PON_TE_RECIPIENTS PTR

456: l_from_company_id NUMBER;
457:
458: CURSOR memberlist(x_entry_id NUMBER, x_from_id NUMBER, x_message_type VARCHAR2, x_from_company_id NUMBER) IS
459: SELECT PON_LOCALE_PKG.get_party_display_name(PTR.TO_ID, PON_LOCALE_PKG.DEFAULT_NAME_DISPLAY_PATTERN, userenv('LANG')) || DECODE(x_message_type,'EXTERNAL',' - '|| PTR.TO_COMPANY_NAME) as name
460: FROM PON_TE_RECIPIENTS PTR
461: WHERE PTR.ENTRY_ID = x_entry_id
462: AND PTR.TO_ID <> x_from_id
463: AND ((x_message_type='EXTERNAL' AND PTR.TO_COMPANY_ID <> x_from_company_id)
464: OR x_message_type <> 'EXTERNAL');

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));