DBA Data[Home] [Help]

APPS.FUN_CONTACTUS_EMAIL dependencies on WF_ENGINE

Line 45: l_text_name_array wf_engine.nametabtyp;

41: p_problem_summary IN VARCHAR2,
42: p_alternative_contact IN VARCHAR2)
43: IS
44: l_text_offset NUMBER :=0;
45: l_text_name_array wf_engine.nametabtyp;
46: l_text_value_array wf_engine.texttabtyp;
47:
48: l_role_name VARCHAR2(250);
49: l_role_display_name VARCHAR2(250);

Line 46: l_text_value_array wf_engine.texttabtyp;

42: p_alternative_contact IN VARCHAR2)
43: IS
44: l_text_offset NUMBER :=0;
45: l_text_name_array wf_engine.nametabtyp;
46: l_text_value_array wf_engine.texttabtyp;
47:
48: l_role_name VARCHAR2(250);
49: l_role_display_name VARCHAR2(250);
50:

Line 74: wf_engine.createprocess('FUNCTUS',

70: /*------------------------------------------------------------------+
71: | Create a process using the WF definition for sending emails to |
72: | helpdesk analyst |
73: +------------------------------------------------------------------*/
74: wf_engine.createprocess('FUNCTUS',
75: p_request_id,
76: 'FUN_SEND_EMAIL',
77: '',
78: p_from_role);

Line 93: wf_engine.setitemattrnumber('FUNCTUS', p_request_id,

89:
90: /*------------------------------------------------------------------+
91: | Set attribute values |
92: +------------------------------------------------------------------*/
93: wf_engine.setitemattrnumber('FUNCTUS', p_request_id,
94: 'FUN_REQUEST_ID', p_request_id);
95:
96: /*------------------------------------------------------------------+
97: | Set the recipient to adhoc role |

Line 140: wf_engine.setitemattrtextarray('FUNCTUS', p_request_id,

136: l_text_offset := l_text_offset + 1;
137: l_text_name_array(l_text_offset) := 'FUN_ALTERNATIVE_CONTACT';
138: l_text_value_array(l_text_offset) := p_alternative_contact;
139:
140: wf_engine.setitemattrtextarray('FUNCTUS', p_request_id,
141: l_text_name_array, l_text_value_array);
142:
143: /*----------------------------------+
144: | Start the notification process |

Line 146: wf_engine.startprocess('FUNCTUS',

142:
143: /*----------------------------------+
144: | Start the notification process |
145: +----------------------------------*/
146: wf_engine.startprocess('FUNCTUS',
147: p_request_id);
148:
149:
150: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then