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 1838: the internal user name of the owner in wf_users. To pass it as

1834:
1835: /* { Bug 2148872: owner => 'PER:' || l_preparer_id);
1836:
1837: wf_engine.SetItemOwner needs 'owner' parameter to be passed as
1838: the internal user name of the owner in wf_users. To pass it as
1839: "PER:person_id" has been disallowed by WF. */
1840:
1841: owner => x_username); -- Bug 2148872 }
1842:

Line 4592: l_po_email_performer WF_USERS.NAME%TYPE;

4588: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

Line 4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;

4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;

Line 4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;

4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
4598: l_performer_exists number;

Line 4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;

4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
4598: l_performer_exists number;
4599: l_notification_preference varchar2(20) := 'MAILHTM2'; -- Bug 3788367

Line 4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
4598: l_performer_exists number;
4599: l_notification_preference varchar2(20) := 'MAILHTM2'; -- Bug 3788367
4600: l_when_to_archive varchar2(80);

Line 4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;

4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;
4594: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
4595: l_po_email_performer_prof WF_USERS.NAME%TYPE;
4596: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
4597: l_display_name_prof WF_USERS.DISPLAY_NAME%TYPE;
4598: l_performer_exists number;
4599: l_notification_preference varchar2(20) := 'MAILHTM2'; -- Bug 3788367
4600: l_when_to_archive varchar2(80);
4601: l_archive_result varchar2(2);

Line 4716: from wf_users where name = l_po_email_performer;

4712: l_po_email_performer := upper(l_po_email_performer);
4713: l_display_name := l_po_email_performer;
4714:
4715: select count(*) into l_performer_exists
4716: from wf_users where name = l_po_email_performer;
4717: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4718: wf_users view instead of wf_local_users table */
4719:
4720:

Line 4718: wf_users view instead of wf_local_users table */

4714:
4715: select count(*) into l_performer_exists
4716: from wf_users where name = l_po_email_performer;
4717: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4718: wf_users view instead of wf_local_users table */
4719:
4720:
4721: x_progress := '003';
4722:

Line 4750: from wf_users where name = l_po_email_performer_prof;

4746: l_display_name_prof := l_po_email_performer_prof;
4747:
4748:
4749: select count(*) into l_performer_exists
4750: from wf_users where name = l_po_email_performer_prof;
4751: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4752: wf_users view instead of wf_local_users table */
4753:
4754:

Line 4752: wf_users view instead of wf_local_users table */

4748:
4749: select count(*) into l_performer_exists
4750: from wf_users where name = l_po_email_performer_prof;
4751: /* Bug 2864242 The wf_local_users table is obsolete after the patch 2350501. So used the
4752: wf_users view instead of wf_local_users table */
4753:
4754:
4755: --EMAILPO FPH START--
4756: -- For second email also the language and territory settings should be same as for the first one above

Line 6228: from wf_users WF

6224: /* 1578061 add orig system condition to enhance performance. */
6225:
6226: cursor c_empid is
6227: select ORIG_SYSTEM_ID
6228: from wf_users WF
6229: where WF.name = p_username
6230: and ORIG_SYSTEM NOT IN ('HZ_PARTY', 'POS', 'ENG_LIST', 'CUST_CONT');
6231:
6232: x_progress varchar2(3):= '000';