APPS.PO_REQAPPROVAL_INIT1 dependencies on FND_NEW_MESSAGES

Line 701: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186

697: x_buyer_username VARCHAR2(100);
698: x_buyer_display_name VARCHAR2(240);
699: l_userkey VARCHAR2(40);
700: l_doc_num_rel VARCHAR2(100);
701: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
702: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186
703: l_revision_num PO_HEADERS.revision_num%TYPE; -- Bug 3215186
704: l_ga_flag VARCHAR2(1) := NULL; -- FPI GA
705: /* RETROACTIVE FPI START */

Line 3897: l_note fnd_new_messages.message_text%TYPE;

3893: l_notification_preference VARCHAR2(20) := 'MAILHTM2'; -- Bug 3788367
3894: l_when_to_archive VARCHAR2(80);
3895: l_archive_result VARCHAR2(2);
3896: /* Bug 9108606 */
3897: l_note fnd_new_messages.message_text%TYPE;
3898: /* End Bug 9108606 */
3899: /*Bug 9283386*/
3900: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
3901: l_lang_code wf_languages.code%TYPE;

Line 3900: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

3896: /* Bug 9108606 */
3897: l_note fnd_new_messages.message_text%TYPE;
3898: /* End Bug 9108606 */
3899: /*Bug 9283386*/
3900: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
3901: l_lang_code wf_languages.code%TYPE;
3902: /*Bug 9283386*/
3903:
3904: --ER 5688144: retrieve vendor name for display name of email address

Line 4007: FROM fnd_new_messages fm,

4003: x_progress := '003';
4004: -- SQL What : Get the message in the Supliers language.
4005: SELECT message_text
4006: INTO l_note
4007: FROM fnd_new_messages fm,
4008: fnd_languages fl
4009: WHERE fm.message_name = 'PO_PDF_EMAIL_TEXT'
4010: AND fm.language_code = fl.language_code
4011: AND fl.nls_language = l_vendor_site_lang;

Line 7489: x_acceptance_result fnd_new_messages.message_text%type := NULL; -- Bug 2821341

7485: funcmode IN VARCHAR2,
7486: result OUT NOCOPY VARCHAR2 )
7487: IS
7488: x_progress VARCHAR2(3) := '000';
7489: x_acceptance_result fnd_new_messages.message_text%type := NULL; -- Bug 2821341
7490: x_org_id NUMBER;
7491: x_user_id NUMBER;
7492: x_document_id NUMBER;
7493: x_document_type_code VARCHAR2(30);

Line 7623: x_acceptance_result fnd_new_messages.message_text%type := NULL; -- Bug 2821341

7619: funcmode IN VARCHAR2,
7620: result OUT NOCOPY VARCHAR2 )
7621: IS
7622: x_progress VARCHAR2(3) := '000';
7623: x_acceptance_result fnd_new_messages.message_text%type := NULL; -- Bug 2821341
7624: x_org_id NUMBER;
7625: x_document_id NUMBER;
7626: x_document_type_code VARCHAR2(30);
7627: x_vendor VARCHAR2(80);

Line 8349: l_note fnd_new_messages.message_text%TYPE;

8345: l_email_address wf_local_roles.email_address%TYPE;
8346: l_notification_preference wf_local_roles.notification_preference%TYPE;
8347: l_language wf_local_roles.LANGUAGE%TYPE;
8348: l_territory wf_local_roles.territory%TYPE;
8349: l_note fnd_new_messages.message_text%TYPE;
8350: BEGIN
8351: -- SQL What : Get the employee_id corresponding to the last NULL action record.
8352: -- Sql Why : To get hold the language of the employee.
8353: BEGIN

Line 8384: FROM fnd_new_messages fm,

8380: -- SQL What : Get the message in the approvers language.
8381: -- Sql Why : To maintain the NO ACTION message in approver language.
8382: SELECT message_text
8383: INTO l_note
8384: FROM fnd_new_messages fm,
8385: fnd_languages fl
8386: WHERE fm.message_name = 'ICX_POR_NOTIF_TIMEOUT'
8387: AND fm.language_code = fl.language_code
8388: AND fl.nls_language = l_language;