eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_USERS

Line 1778: the internal user name of the owner in wf_users. To pass it as

1774: -- Bug 711141 fix (setting process owner here)
1775: wf_engine.SetItemOwner (itemtype => itemtype, itemkey => itemkey,
1776: /* { Bug 2148872: owner => 'PER:' || l_preparer_id);
1777: wf_engine.SetItemOwner needs 'owner' parameter to be passed as
1778: the internal user name of the owner in wf_users. To pass it as
1779: "PER:person_id" has been disallowed by WF. */
1780: owner => x_username); -- Bug 2148872 }
1781: -- Context Setting revamp (begin)
1782: l_printer := fnd_profile.value('PRINTER');

Line 3886: l_po_email_performer WF_USERS.NAME%TYPE;

3882: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

Line 3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;

3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;

Line 3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;

3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
3892: l_performer_exists NUMBER;

Line 3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;

3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
3892: l_performer_exists NUMBER;
3893: l_notification_preference VARCHAR2(20) := 'MAILHTM2'; -- Bug 3788367

Line 3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
3892: l_performer_exists NUMBER;
3893: l_notification_preference VARCHAR2(20) := 'MAILHTM2'; -- Bug 3788367
3894: l_when_to_archive VARCHAR2(80);

Line 3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;

3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
3888: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
3889: l_po_email_performer_prof WF_USERS.NAME%TYPE;
3890: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
3891: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
3892: l_performer_exists NUMBER;
3893: l_notification_preference VARCHAR2(20) := 'MAILHTM2'; -- Bug 3788367
3894: l_when_to_archive VARCHAR2(80);
3895: l_archive_result VARCHAR2(2);

Line 4035: FROM wf_users

4031: --ER 5688144: End
4032:
4033: SELECT COUNT(*)
4034: INTO l_performer_exists
4035: FROM wf_users
4036: WHERE name = l_po_email_performer;
4037: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4038: wf_users view instead of wf_local_users table */
4039: x_progress := '003';

Line 4038: wf_users view instead of wf_local_users table */

4034: INTO l_performer_exists
4035: FROM wf_users
4036: WHERE name = l_po_email_performer;
4037: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4038: wf_users view instead of wf_local_users table */
4039: x_progress := '003';
4040: IF (l_performer_exists = 0) THEN
4041: --EMAILPO FPH--
4042: -- Pass in the correct adhocuser language and territory for CreateAdHocUser and SetAdhocUserAttr instead of null

Line 4061: FROM wf_users

4057: --ER 5688144: End
4058:
4059: SELECT COUNT(*)
4060: INTO l_performer_exists
4061: FROM wf_users
4062: WHERE name = l_po_email_performer_prof;
4063: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4064: wf_users view instead of wf_local_users table */
4065: --EMAILPO FPH START--

Line 4064: wf_users view instead of wf_local_users table */

4060: INTO l_performer_exists
4061: FROM wf_users
4062: WHERE name = l_po_email_performer_prof;
4063: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4064: wf_users view instead of wf_local_users table */
4065: --EMAILPO FPH START--
4066: -- For second email also the language and territory settings should be same as for the first one above
4067: x_progress := '004';
4068: IF (l_performer_exists = 0) THEN

Line 5297: FROM wf_users WF

5293: /* 1578061 add orig system condition to enhance performance. */
5294: CURSOR c_empid
5295: IS
5296: SELECT ORIG_SYSTEM_ID
5297: FROM wf_users WF
5298: WHERE WF.name = p_username
5299: AND ORIG_SYSTEM NOT IN ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
5300:
5301: x_progress VARCHAR2(3):= '000';