APPS.WF_MAIL dependencies on WF_COMMENTS

Line 1762: from wf_comments

1758: l_requestee varchar2(32000);
1759:
1760: cursor c_questions is
1761: select user_comment
1762: from wf_comments
1763: where notification_id = nid
1764: and action in ('QUESTION', 'QUESTION_WA', 'QUESTION_RULE')
1765: order by comment_date desc ;
1766: begin

Line 4872: FROM wf_comments

4868: is
4869:
4870: CURSOR c_ques IS
4871: SELECT user_comment
4872: FROM wf_comments
4873: WHERE notification_id = p_nid
4874: AND action in ('QUESTION', 'QUESTION_WA', 'QUESTION_RULE')
4875: ORDER BY comment_date desc;
4876:

Line 4916: FROM wf_comments

4912: l_get_text boolean;
4913:
4914: CURSOR c_comm IS
4915: SELECT count(1)
4916: FROM wf_comments
4917: WHERE action_type in ('REASSIGN', 'QA')
4918: AND notification_id = p_nid;
4919:
4920: begin

Line 7107: -- update wf_notifications and wf_comments in QUESTION mode

7103: comment := 'NULL';
7104: end if;
7105: -- validate the role before calling updateinfo
7106:
7107: -- update wf_notifications and wf_comments in QUESTION mode
7108: if (length(to_user) > 0 and length(comment) > 0) then
7109: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
7110: end if;
7111: exception

Line 7125: -- update wf_notification and wf_comments apropriately

7121:
7122: -- PutMoreInfoMessage
7123: -- Reply processor. Read body of a reply for more information
7124: -- request, parse the body for the comments from the user and
7125: -- update wf_notification and wf_comments apropriately
7126: -- Used by the notification mail response processor.
7127: -- IN
7128: -- notification id
7129: -- mailer node name

Line 7191: -- update wf_notifications and wf_comments in ANSWER mode

7187: end if;
7188: end if;
7189: end if;
7190: end if;
7191: -- update wf_notifications and wf_comments in ANSWER mode
7192: to_user := NULL;
7193: wf_notification.UpdateInfo2(nid, to_user, from_addr, comment);
7194: exception
7195: when no_program_unit then

Line 8282: FROM wf_comments

8278: l_territory wf_roles.territory%TYPE;
8279:
8280: CURSOR c_ques IS
8281: SELECT from_role, to_role, user_comment
8282: FROM wf_comments
8283: WHERE notification_id = p_nid
8284: AND action in ('QUESTION', 'QUESTION_WA', 'QUESTION_RULE')
8285: ORDER BY comment_date desc;
8286:

Line 8294: -- Get details of last question asked from WF_COMMENTS table and

8290: wf_log_pkg.string(wf_log_pkg.level_procedure,
8291: 'wf.plsql.WF_MAIL.SendMoreInfoResponseWarning', 'BEGIN');
8292: END IF;
8293:
8294: -- Get details of last question asked from WF_COMMENTS table and
8295: -- Get role language, territory and codeset details.
8296:
8297: OPEN c_ques;
8298: FETCH c_ques INTO l_from_role, l_to_role, l_question;

Line 8315: -- if role not exist in wf_comments or email address exist

8311: l_orig_system_id,
8312: l_installed);
8313:
8314:
8315: -- if role not exist in wf_comments or email address exist
8316: -- in wf_comments then use p_from_email to get other details .
8317: --
8318: if( l_to_role = '' OR
8319: instr(l_to_role, '@') > 0 OR

Line 8316: -- in wf_comments then use p_from_email to get other details .

8312: l_installed);
8313:
8314:
8315: -- if role not exist in wf_comments or email address exist
8316: -- in wf_comments then use p_from_email to get other details .
8317: --
8318: if( l_to_role = '' OR
8319: instr(l_to_role, '@') > 0 OR
8320: l_to_emailaddress IS null ) then