APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on WF_MESSAGES

Line 106: l_message_type wf_messages.type%type;

102: )
103: RETURN number
104: IS
105: PRAGMA autonomous_transaction;
106: l_message_type wf_messages.type%type;
107: l_message_name wf_messages.name%type := 'IRC_TEXT_MSG';
108: l_nid number;
109: BEGIN
110: --

Line 107: l_message_name wf_messages.name%type := 'IRC_TEXT_MSG';

103: RETURN number
104: IS
105: PRAGMA autonomous_transaction;
106: l_message_type wf_messages.type%type;
107: l_message_name wf_messages.name%type := 'IRC_TEXT_MSG';
108: l_nid number;
109: BEGIN
110: --
111: l_message_type :=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');

Line 149: l_message_type wf_messages.type%type;

145: )
146: RETURN number
147: IS
148: PRAGMA autonomous_transaction;
149: l_message_type wf_messages.type%type;
150: l_message_name wf_messages.name%type := 'IRC_TEXT_HTML_MSG';
151: l_nid number;
152: BEGIN
153: --

Line 150: l_message_name wf_messages.name%type := 'IRC_TEXT_HTML_MSG';

146: RETURN number
147: IS
148: PRAGMA autonomous_transaction;
149: l_message_type wf_messages.type%type;
150: l_message_name wf_messages.name%type := 'IRC_TEXT_HTML_MSG';
151: l_nid number;
152: BEGIN
153: --
154: l_message_type :=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');

Line 337: l_message_type wf_messages.type%Type;

333: ,p_doc_ids in g_document_ids)
334: return number is
335: --
336: pragma autonomous_transaction;
337: l_message_type wf_messages.type%Type;
338: l_message_name wf_messages.name%Type;
339: l_nid number;
340: l_doc_text varchar2(2000);
341: --

Line 338: l_message_name wf_messages.name%Type;

334: return number is
335: --
336: pragma autonomous_transaction;
337: l_message_type wf_messages.type%Type;
338: l_message_name wf_messages.name%Type;
339: l_nid number;
340: l_doc_text varchar2(2000);
341: --
342: begin