APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on WF_MESSAGES

Line 105: l_message_type wf_messages.type%type;

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

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

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

Line 148: l_message_type wf_messages.type%type;

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

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

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

Line 333: l_message_type wf_messages.type%Type;

329: ,p_doc_ids in g_document_ids)
330: return number is
331: --
332: pragma autonomous_transaction;
333: l_message_type wf_messages.type%Type;
334: l_message_name wf_messages.name%Type;
335: l_nid number;
336: l_doc_text varchar2(2000);
337: --

Line 334: l_message_name wf_messages.name%Type;

330: return number is
331: --
332: pragma autonomous_transaction;
333: l_message_type wf_messages.type%Type;
334: l_message_name wf_messages.name%Type;
335: l_nid number;
336: l_doc_text varchar2(2000);
337: --
338: begin