APPS.GL_WF_JE_APPROVAL_PKG dependencies on FND_USER

Line 276: p_preparer_fnd_user_id IN NUMBER,

272: -- start_approval_workflow
273: -- ****************************************************************************
274:
275: PROCEDURE start_approval_workflow (p_je_batch_id IN NUMBER,
276: p_preparer_fnd_user_id IN NUMBER,
277: p_preparer_resp_id IN NUMBER,
278: p_je_batch_name IN VARCHAR2) IS
279: l_itemtype VARCHAR2(10) := 'GLBATCH';
280: l_itemkey VARCHAR2(40);

Line 281: l_fnd_user_name VARCHAR2(100);

277: p_preparer_resp_id IN NUMBER,
278: p_je_batch_name IN VARCHAR2) IS
279: l_itemtype VARCHAR2(10) := 'GLBATCH';
280: l_itemkey VARCHAR2(40);
281: l_fnd_user_name VARCHAR2(100);
282: l_preparer_id NUMBER;
283: l_monitor_url VARCHAR2(500);
284: l_approval_run_id NUMBER;
285: l_business_group_id NUMBER;

Line 303: INTO l_fnd_user_name, l_preparer_id

299: FROM DUAL;
300:
301: -- Get AOL user name and person id
302: SELECT user_name, nvl(employee_id, -1)
303: INTO l_fnd_user_name, l_preparer_id
304: FROM fnd_user
305: WHERE user_id = p_preparer_fnd_user_id;
306:
307: -- generate the item key

Line 304: FROM fnd_user

300:
301: -- Get AOL user name and person id
302: SELECT user_name, nvl(employee_id, -1)
303: INTO l_fnd_user_name, l_preparer_id
304: FROM fnd_user
305: WHERE user_id = p_preparer_fnd_user_id;
306:
307: -- generate the item key
308: l_itemkey := to_char(p_je_batch_id) || '*' || to_char(l_approval_run_id);

Line 305: WHERE user_id = p_preparer_fnd_user_id;

301: -- Get AOL user name and person id
302: SELECT user_name, nvl(employee_id, -1)
303: INTO l_fnd_user_name, l_preparer_id
304: FROM fnd_user
305: WHERE user_id = p_preparer_fnd_user_id;
306:
307: -- generate the item key
308: l_itemkey := to_char(p_je_batch_id) || '*' || to_char(l_approval_run_id);
309:

Line 326: owner => l_fnd_user_name );

322:
323: -- Set the process owner
324: wf_engine.SetItemOwner( itemtype => l_itemtype,
325: itemkey => l_itemkey,
326: owner => l_fnd_user_name );
327:
328: -- Set the fnd user name
329: wf_engine.SetItemAttrText( itemtype => l_itemtype,
330: itemkey => l_itemkey,

Line 328: -- Set the fnd user name

324: wf_engine.SetItemOwner( itemtype => l_itemtype,
325: itemkey => l_itemkey,
326: owner => l_fnd_user_name );
327:
328: -- Set the fnd user name
329: wf_engine.SetItemAttrText( itemtype => l_itemtype,
330: itemkey => l_itemkey,
331: aname => 'FND_USER_NAME',
332: avalue => l_fnd_user_name );

Line 331: aname => 'FND_USER_NAME',

327:
328: -- Set the fnd user name
329: wf_engine.SetItemAttrText( itemtype => l_itemtype,
330: itemkey => l_itemkey,
331: aname => 'FND_USER_NAME',
332: avalue => l_fnd_user_name );
333:
334: -- Set batch id (JE batch ID)
335: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

Line 332: avalue => l_fnd_user_name );

328: -- Set the fnd user name
329: wf_engine.SetItemAttrText( itemtype => l_itemtype,
330: itemkey => l_itemkey,
331: aname => 'FND_USER_NAME',
332: avalue => l_fnd_user_name );
333:
334: -- Set batch id (JE batch ID)
335: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
336: itemkey => l_itemkey,

Line 355: -- Set UserID attribute (AOL userID from FND_USER table).

351: aname => 'PREPARER_ID',
352: avalue => l_preparer_id );
353: diagn_msg('Attribute PREPARER_ID set to ' || l_preparer_id);
354:
355: -- Set UserID attribute (AOL userID from FND_USER table).
356: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
357: itemkey => l_itemkey,
358: aname => 'PREPARER_FND_ID',
359: avalue => p_preparer_fnd_user_id );

Line 359: avalue => p_preparer_fnd_user_id );

355: -- Set UserID attribute (AOL userID from FND_USER table).
356: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
357: itemkey => l_itemkey,
358: aname => 'PREPARER_FND_ID',
359: avalue => p_preparer_fnd_user_id );
360:
361: -- Set ResponsibilityID attribute
362: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
363: itemkey => l_itemkey,