[Home] [Help]
626: x_buyer_display_name varchar2(240);
627:
628: l_userkey varchar2(40);
629: l_doc_num_rel varchar2(30);
630: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
631: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186
632: l_revision_num PO_HEADERS.revision_num%TYPE; -- Bug 3215186
633: l_ga_flag varchar2(1) := null; -- FPI GA
634:
8416: funcmode in varchar2,
8417: result out NOCOPY varchar2 )
8418: is
8419: x_progress varchar2(3) := '000';
8420: x_acceptance_result fnd_new_messages.message_text%type := null; -- Bug 2821341
8421: x_org_id number;
8422: x_user_id number;
8423: x_document_id number;
8424: x_document_type_code varchar2(30);
8582: funcmode in varchar2,
8583: result out NOCOPY varchar2 )
8584: is
8585: x_progress varchar2(3) := '000';
8586: x_acceptance_result fnd_new_messages.message_text%type := null; -- Bug 2821341
8587: x_org_id number;
8588: x_document_id number;
8589: x_document_type_code varchar2(30);
8590: x_vendor varchar2(80);
9577: l_email_address wf_local_roles.email_address%TYPE;
9578: l_notification_preference wf_local_roles.notification_preference%TYPE;
9579: l_language wf_local_roles.LANGUAGE%TYPE;
9580: l_territory wf_local_roles.territory%TYPE;
9581: l_note fnd_new_messages.message_text%TYPE;
9582:
9583: BEGIN
9584: -- SQL What : Get the employee_id corresponding to the last NULL action record.
9585: -- Sql Why : To get hold the language of the employee.
9623: -- SQL What : Get the message in the approvers language.
9624: -- Sql Why : To maintain the NO ACTION message in approver language.
9625: SELECT message_text
9626: INTO l_note
9627: FROM fnd_new_messages fm,
9628: fnd_languages fl
9629: WHERE fm.message_name = 'ICX_POR_NOTIF_TIMEOUT'
9630: AND fm.language_code = fl.language_code
9631: AND fl.nls_language = l_language;