DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_NEW_MESSAGES

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

244:
245: i NUMBER := 0;
246: max_lines_dsp NUMBER ; --
247: l_line_count NUMBER := 0; -- # lines/shipments on document
248: line_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601
249: l_num_records_to_display NUMBER; -- actual # of records to be displayed in table
250:
251: --
252: -- curr_len NUMBER := 0;

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

1040: i NUMBER := 0;
1041: max_actions_dsp NUMBER := 20;
1042: l_action_count NUMBER; -- # of action history records
1043: l_num_records_to_display NUMBER; -- actual # of records to display in table
1044: action_mesg fnd_new_messages.message_text%TYPE; --Bug 4695601
1045: curr_len NUMBER := 0;
1046: prior_len NUMBER := 0;
1047:
1048: /* Bug 2788683 start */

Line 1860: from fnd_new_messages fm,fnd_languages fl

1856: avalue => l_doc_disp);
1857: BEGIN
1858: select message_text
1859: into l_msg_text
1860: from fnd_new_messages fm,fnd_languages fl
1861: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_APPROVAL'
1862: and fm.language_code = fl.language_code
1863: and fl.nls_language = l_language
1864: and fm.application_id = 201; -- Include application_id to better use PK index