APPS.PO_WF_PO_NOTIFICATION dependencies on FND_NEW_MESSAGES

Line 329: line_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601

325:
326: i NUMBER := 0;
327: max_lines_dsp NUMBER ; --
328: l_line_count NUMBER := 0; -- # lines/shipments on document
329: line_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601
330: l_num_records_to_display NUMBER; -- actual # of records to be displayed in table
331:
332: --
333: curr_len NUMBER := 0; --

Line 1310: action_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601

1306: i NUMBER := 0;
1307: max_actions_dsp NUMBER := 20;
1308: l_action_count NUMBER; -- # of action history records
1309: l_num_records_to_display NUMBER; -- actual # of records to display in table
1310: action_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601
1311: curr_len NUMBER := 0;
1312: prior_len NUMBER := 0;
1313:
1314: /* Bug 2788683 start */

Line 2741: from fnd_new_messages fm,fnd_languages fl

2737: avalue => l_doc_disp);
2738: BEGIN
2739: select message_text
2740: into l_msg_text
2741: from fnd_new_messages fm,fnd_languages fl
2742: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_APPROVAL'
2743: and fm.language_code = fl.language_code
2744: and fl.nls_language = l_language
2745: and fm.application_id = 201; -- Include application_id to better use PK index

Line 2763: from fnd_new_messages fm,fnd_languages fl

2759: Fetching and setting REQUIRES_REVIEW_MSG attribute */
2760: BEGIN
2761: select message_text
2762: into l_msg_text
2763: from fnd_new_messages fm,fnd_languages fl
2764: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_REVIEW'
2765: and fm.language_code = fl.language_code
2766: and fl.nls_language = l_language
2767: and fm.application_id = 201;

Line 2783: from fnd_new_messages fm,fnd_languages fl

2779:
2780: BEGIN
2781: select message_text
2782: into l_msg_text
2783: from fnd_new_messages fm,fnd_languages fl
2784: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_ESIGN'
2785: and fm.language_code = fl.language_code
2786: and fl.nls_language = l_language
2787: and fm.application_id = 201;