DBA Data[Home] [Help]

APPS.IRC_REGISTER_EX_EMP_WF dependencies on WF_ENGINE

Line 42: l_current_email_address:=wf_engine.getItemAttrText

38: hr_utility.set_location(' Entering: '||l_proc, 10);
39: if (funcmode='RUN') then
40: hr_utility.set_location(l_proc,20);
41:
42: l_current_email_address:=wf_engine.getItemAttrText
43: (itemtype => itemtype,
44: itemkey => itemkey,
45: aname => 'CURRENT_EMAIL_ADDRESS');
46: l_responsibility_id:=wf_engine.getItemAttrNumber

Line 46: l_responsibility_id:=wf_engine.getItemAttrNumber

42: l_current_email_address:=wf_engine.getItemAttrText
43: (itemtype => itemtype,
44: itemkey => itemkey,
45: aname => 'CURRENT_EMAIL_ADDRESS');
46: l_responsibility_id:=wf_engine.getItemAttrNumber
47: (itemtype => itemtype,
48: itemkey => itemkey,
49: aname => 'RESPONSIBILITY_ID');
50: l_resp_appl_id:=wf_engine.getItemAttrNumber

Line 50: l_resp_appl_id:=wf_engine.getItemAttrNumber

46: l_responsibility_id:=wf_engine.getItemAttrNumber
47: (itemtype => itemtype,
48: itemkey => itemkey,
49: aname => 'RESPONSIBILITY_ID');
50: l_resp_appl_id:=wf_engine.getItemAttrNumber
51: (itemtype => itemtype,
52: itemkey => itemkey,
53: aname => 'RESP_APPL_ID');
54: l_security_group_id:=wf_engine.getItemAttrNumber

Line 54: l_security_group_id:=wf_engine.getItemAttrNumber

50: l_resp_appl_id:=wf_engine.getItemAttrNumber
51: (itemtype => itemtype,
52: itemkey => itemkey,
53: aname => 'RESP_APPL_ID');
54: l_security_group_id:=wf_engine.getItemAttrNumber
55: (itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'SECURITY_GROUP_ID');
58: l_first_name:=wf_engine.getItemAttrText

Line 58: l_first_name:=wf_engine.getItemAttrText

54: l_security_group_id:=wf_engine.getItemAttrNumber
55: (itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'SECURITY_GROUP_ID');
58: l_first_name:=wf_engine.getItemAttrText
59: (itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'FIRST_NAME');
62: l_last_name:=wf_engine.getItemAttrText

Line 62: l_last_name:=wf_engine.getItemAttrText

58: l_first_name:=wf_engine.getItemAttrText
59: (itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'FIRST_NAME');
62: l_last_name:=wf_engine.getItemAttrText
63: (itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'LAST_NAME');
66: l_middle_names:=wf_engine.getItemAttrText

Line 66: l_middle_names:=wf_engine.getItemAttrText

62: l_last_name:=wf_engine.getItemAttrText
63: (itemtype => itemtype,
64: itemkey => itemkey,
65: aname => 'LAST_NAME');
66: l_middle_names:=wf_engine.getItemAttrText
67: (itemtype => itemtype,
68: itemkey => itemkey,
69: aname => 'MIDDLE_NAMES');
70: l_previous_last_name:=wf_engine.getItemAttrText

Line 70: l_previous_last_name:=wf_engine.getItemAttrText

66: l_middle_names:=wf_engine.getItemAttrText
67: (itemtype => itemtype,
68: itemkey => itemkey,
69: aname => 'MIDDLE_NAMES');
70: l_previous_last_name:=wf_engine.getItemAttrText
71: (itemtype => itemtype,
72: itemkey => itemkey,
73: aname => 'PREVIOUS_LAST_NAME');
74: l_employee_number:=wf_engine.getItemAttrText

Line 74: l_employee_number:=wf_engine.getItemAttrText

70: l_previous_last_name:=wf_engine.getItemAttrText
71: (itemtype => itemtype,
72: itemkey => itemkey,
73: aname => 'PREVIOUS_LAST_NAME');
74: l_employee_number:=wf_engine.getItemAttrText
75: (itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'EMPLOYEE_NUMBER');
78: l_national_identifier:=wf_engine.getItemAttrText

Line 78: l_national_identifier:=wf_engine.getItemAttrText

74: l_employee_number:=wf_engine.getItemAttrText
75: (itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'EMPLOYEE_NUMBER');
78: l_national_identifier:=wf_engine.getItemAttrText
79: (itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'NATIONAL_IDENTIFIER');
82: l_date_of_birth:=wf_engine.getItemAttrDate

Line 82: l_date_of_birth:=wf_engine.getItemAttrDate

78: l_national_identifier:=wf_engine.getItemAttrText
79: (itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'NATIONAL_IDENTIFIER');
82: l_date_of_birth:=wf_engine.getItemAttrDate
83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'DATE_OF_BIRTH');
86: l_email_address:=wf_engine.getItemAttrText

Line 86: l_email_address:=wf_engine.getItemAttrText

82: l_date_of_birth:=wf_engine.getItemAttrDate
83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'DATE_OF_BIRTH');
86: l_email_address:=wf_engine.getItemAttrText
87: (itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'EMAIL_ADDRESS');
90: l_home_phone_number:=wf_engine.getItemAttrText

Line 90: l_home_phone_number:=wf_engine.getItemAttrText

86: l_email_address:=wf_engine.getItemAttrText
87: (itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'EMAIL_ADDRESS');
90: l_home_phone_number:=wf_engine.getItemAttrText
91: (itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'HOME_PHONE_NUMBER');
94: l_work_phone_number:=wf_engine.getItemAttrText

Line 94: l_work_phone_number:=wf_engine.getItemAttrText

90: l_home_phone_number:=wf_engine.getItemAttrText
91: (itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'HOME_PHONE_NUMBER');
94: l_work_phone_number:=wf_engine.getItemAttrText
95: (itemtype => itemtype,
96: itemkey => itemkey,
97: aname => 'WORK_PHONE_NUMBER');
98: l_address_line_1:=wf_engine.getItemAttrText

Line 98: l_address_line_1:=wf_engine.getItemAttrText

94: l_work_phone_number:=wf_engine.getItemAttrText
95: (itemtype => itemtype,
96: itemkey => itemkey,
97: aname => 'WORK_PHONE_NUMBER');
98: l_address_line_1:=wf_engine.getItemAttrText
99: (itemtype => itemtype,
100: itemkey => itemkey,
101: aname => 'ADDRESS_LINE_1');
102: l_manager_last_name:=wf_engine.getItemAttrText

Line 102: l_manager_last_name:=wf_engine.getItemAttrText

98: l_address_line_1:=wf_engine.getItemAttrText
99: (itemtype => itemtype,
100: itemkey => itemkey,
101: aname => 'ADDRESS_LINE_1');
102: l_manager_last_name:=wf_engine.getItemAttrText
103: (itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'MANAGER_LAST_NAME');
106: l_allow_access:=wf_engine.getItemAttrText

Line 106: l_allow_access:=wf_engine.getItemAttrText

102: l_manager_last_name:=wf_engine.getItemAttrText
103: (itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'MANAGER_LAST_NAME');
106: l_allow_access:=wf_engine.getItemAttrText
107: (itemtype => itemtype,
108: itemkey => itemkey,
109: aname => 'ALLOW_ACCESS');
110: l_language:=wf_engine.getItemAttrText

Line 110: l_language:=wf_engine.getItemAttrText

106: l_allow_access:=wf_engine.getItemAttrText
107: (itemtype => itemtype,
108: itemkey => itemkey,
109: aname => 'ALLOW_ACCESS');
110: l_language:=wf_engine.getItemAttrText
111: (itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'LANGUAGE');
114: l_user_name:=wf_engine.getItemAttrText

Line 114: l_user_name:=wf_engine.getItemAttrText

110: l_language:=wf_engine.getItemAttrText
111: (itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'LANGUAGE');
114: l_user_name:=wf_engine.getItemAttrText
115: (itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'USER_NAME');
118:

Line 192: wf_engine.CreateProcess (itemtype => itemtype,

188: select irc_wf_s.nextval
189: into itemkey
190: from dual;
191: --
192: wf_engine.CreateProcess (itemtype => itemtype,
193: itemkey => itemkey,
194: process => 'REG_REQUEST' );
195:
196: hr_utility.set_location(l_proc,20);

Line 198: wf_engine.setItemAttrText

194: process => 'REG_REQUEST' );
195:
196: hr_utility.set_location(l_proc,20);
197:
198: wf_engine.setItemAttrText
199: (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'CURRENT_EMAIL_ADDRESS',
202: avalue => p_current_email_address);

Line 203: wf_engine.setItemAttrNumber

199: (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'CURRENT_EMAIL_ADDRESS',
202: avalue => p_current_email_address);
203: wf_engine.setItemAttrNumber
204: (itemtype => itemtype,
205: itemkey => itemkey,
206: aname => 'RESPONSIBILITY_ID',
207: avalue => p_responsibility_id);

Line 208: wf_engine.setItemAttrNumber

204: (itemtype => itemtype,
205: itemkey => itemkey,
206: aname => 'RESPONSIBILITY_ID',
207: avalue => p_responsibility_id);
208: wf_engine.setItemAttrNumber
209: (itemtype => itemtype,
210: itemkey => itemkey,
211: aname => 'RESP_APPL_ID',
212: avalue => p_resp_appl_id);

Line 213: wf_engine.setItemAttrNumber

209: (itemtype => itemtype,
210: itemkey => itemkey,
211: aname => 'RESP_APPL_ID',
212: avalue => p_resp_appl_id);
213: wf_engine.setItemAttrNumber
214: (itemtype => itemtype,
215: itemkey => itemkey,
216: aname => 'SECURITY_GROUP_ID',
217: avalue => p_security_group_id);

Line 218: wf_engine.setItemAttrText

214: (itemtype => itemtype,
215: itemkey => itemkey,
216: aname => 'SECURITY_GROUP_ID',
217: avalue => p_security_group_id);
218: wf_engine.setItemAttrText
219: (itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'FIRST_NAME',
222: avalue => p_first_name);

Line 223: wf_engine.setItemAttrText

219: (itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'FIRST_NAME',
222: avalue => p_first_name);
223: wf_engine.setItemAttrText
224: (itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'LAST_NAME',
227: avalue => p_last_name);

Line 228: wf_engine.setItemAttrText

224: (itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'LAST_NAME',
227: avalue => p_last_name);
228: wf_engine.setItemAttrText
229: (itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'MIDDLE_NAMES',
232: avalue => p_middle_names);

Line 233: wf_engine.setItemAttrText

229: (itemtype => itemtype,
230: itemkey => itemkey,
231: aname => 'MIDDLE_NAMES',
232: avalue => p_middle_names);
233: wf_engine.setItemAttrText
234: (itemtype => itemtype,
235: itemkey => itemkey,
236: aname => 'PREVIOUS_LAST_NAME',
237: avalue => p_previous_last_name);

Line 238: wf_engine.setItemAttrText

234: (itemtype => itemtype,
235: itemkey => itemkey,
236: aname => 'PREVIOUS_LAST_NAME',
237: avalue => p_previous_last_name);
238: wf_engine.setItemAttrText
239: (itemtype => itemtype,
240: itemkey => itemkey,
241: aname => 'EMPLOYEE_NUMBER',
242: avalue => p_employee_number);

Line 243: wf_engine.setItemAttrText

239: (itemtype => itemtype,
240: itemkey => itemkey,
241: aname => 'EMPLOYEE_NUMBER',
242: avalue => p_employee_number);
243: wf_engine.setItemAttrText
244: (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'NATIONAL_IDENTIFIER',
247: avalue => p_national_identifier);

Line 248: wf_engine.setItemAttrDate

244: (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'NATIONAL_IDENTIFIER',
247: avalue => p_national_identifier);
248: wf_engine.setItemAttrDate
249: (itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'DATE_OF_BIRTH',
252: avalue => p_date_of_birth);

Line 253: wf_engine.setItemAttrText

249: (itemtype => itemtype,
250: itemkey => itemkey,
251: aname => 'DATE_OF_BIRTH',
252: avalue => p_date_of_birth);
253: wf_engine.setItemAttrText
254: (itemtype => itemtype,
255: itemkey => itemkey,
256: aname => 'EMAIL_ADDRESS',
257: avalue => p_email_address);

Line 258: wf_engine.setItemAttrText

254: (itemtype => itemtype,
255: itemkey => itemkey,
256: aname => 'EMAIL_ADDRESS',
257: avalue => p_email_address);
258: wf_engine.setItemAttrText
259: (itemtype => itemtype,
260: itemkey => itemkey,
261: aname => 'HOME_PHONE_NUMBER',
262: avalue => p_home_phone_number);

Line 263: wf_engine.setItemAttrText

259: (itemtype => itemtype,
260: itemkey => itemkey,
261: aname => 'HOME_PHONE_NUMBER',
262: avalue => p_home_phone_number);
263: wf_engine.setItemAttrText
264: (itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'WORK_PHONE_NUMBER',
267: avalue => p_work_phone_number);

Line 268: wf_engine.setItemAttrText

264: (itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'WORK_PHONE_NUMBER',
267: avalue => p_work_phone_number);
268: wf_engine.setItemAttrText
269: (itemtype => itemtype,
270: itemkey => itemkey,
271: aname => 'ADDRESS_LINE_1',
272: avalue => p_address_line_1);

Line 273: wf_engine.setItemAttrText

269: (itemtype => itemtype,
270: itemkey => itemkey,
271: aname => 'ADDRESS_LINE_1',
272: avalue => p_address_line_1);
273: wf_engine.setItemAttrText
274: (itemtype => itemtype,
275: itemkey => itemkey,
276: aname => 'MANAGER_LAST_NAME',
277: avalue => p_manager_last_name);

Line 278: wf_engine.setItemAttrText

274: (itemtype => itemtype,
275: itemkey => itemkey,
276: aname => 'MANAGER_LAST_NAME',
277: avalue => p_manager_last_name);
278: wf_engine.setItemAttrText
279: (itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'ALLOW_ACCESS',
282: avalue => p_allow_access);

Line 283: wf_engine.setItemAttrText

279: (itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'ALLOW_ACCESS',
282: avalue => p_allow_access);
283: wf_engine.setItemAttrText
284: (itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'LANGUAGE',
287: avalue => p_language);

Line 288: wf_engine.setItemAttrText

284: (itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'LANGUAGE',
287: avalue => p_language);
288: wf_engine.setItemAttrText
289: (itemtype => itemtype,
290: itemkey => itemkey,
291: aname => 'USER_NAME',
292: avalue => p_user_name);

Line 295: wf_engine.StartProcess (itemtype => itemtype,

291: aname => 'USER_NAME',
292: avalue => p_user_name);
293: hr_utility.set_location(l_proc,30);
294:
295: wf_engine.StartProcess (itemtype => itemtype,
296: itemkey => itemkey );
297: hr_utility.set_location('Leaving: '||l_proc,40);
298: exception
299: when others then