DBA Data[Home] [Help]

APPS.GR_WF_UTIL_PVT dependencies on FND_USER

Line 412: l_performer_name FND_USER.USER_NAME%TYPE ;

408: /************* Local Variables *************/
409: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
410: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
411: l_runform VARCHAR2(100);
412: l_performer_name FND_USER.USER_NAME%TYPE ;
413: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
414: l_performer FND_USER.USER_NAME%TYPE ;
415: /* make sure that process runs with background engine
416: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)

Line 413: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

409: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
410: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
411: l_runform VARCHAR2(100);
412: l_performer_name FND_USER.USER_NAME%TYPE ;
413: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
414: l_performer FND_USER.USER_NAME%TYPE ;
415: /* make sure that process runs with background engine
416: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
417: the value to use for this is -1 */

Line 414: l_performer FND_USER.USER_NAME%TYPE ;

410: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
411: l_runform VARCHAR2(100);
412: l_performer_name FND_USER.USER_NAME%TYPE ;
413: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
414: l_performer FND_USER.USER_NAME%TYPE ;
415: /* make sure that process runs with background engine
416: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
417: the value to use for this is -1 */
418:

Line 487: FROM FND_USER

483: END IF;
484:
485: SELECT USER_NAME
486: INTO l_performer
487: FROM FND_USER
488: WHERE USER_ID = p_user;
489:
490: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
491: itemkey => l_itemkey,

Line 573: FROM FND_USER

569: approvers(1).user_id :=ame_util.PERSONIDTOUSERID(approvers(1).person_id);
570: end if;
571: SELECT USER_NAME
572: INTO l_user
573: FROM FND_USER
574: WHERE USER_ID = approvers(1).user_id;
575: ELSE
576: l_user := NULL;
577: END IF;

Line 961: l_performer_name FND_USER.USER_NAME%TYPE ;

957: PROCEDURE INIT_THRDPRTY_WF (P_message_icn NUMBER) IS
958: /************* Local Variables *************/
959: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
960: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
961: l_performer_name FND_USER.USER_NAME%TYPE ;
962: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
963: l_performer FND_USER.USER_NAME%TYPE ;
964: /* make sure that process runs with background engine
965: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)

Line 962: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

958: /************* Local Variables *************/
959: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
960: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
961: l_performer_name FND_USER.USER_NAME%TYPE ;
962: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
963: l_performer FND_USER.USER_NAME%TYPE ;
964: /* make sure that process runs with background engine
965: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
966: the value to use for this is -1 */

Line 963: l_performer FND_USER.USER_NAME%TYPE ;

959: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
960: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
961: l_performer_name FND_USER.USER_NAME%TYPE ;
962: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
963: l_performer FND_USER.USER_NAME%TYPE ;
964: /* make sure that process runs with background engine
965: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
966: the value to use for this is -1 */
967:

Line 1290: l_performer_name FND_USER.USER_NAME%TYPE ;

1286: /************* Local Variables *************/
1287: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
1288: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
1289: l_runform VARCHAR2(100);
1290: l_performer_name FND_USER.USER_NAME%TYPE ;
1291: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1292: l_item_desc IC_ITEM_MST_B.ITEM_DESC1%TYPE;
1293: l_performer FND_USER.USER_NAME%TYPE ;
1294: l_user_id FND_USER.USER_ID%TYPE ;

Line 1291: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

1287: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE;
1288: l_itemkey WF_ITEMS.ITEM_KEY%TYPE;
1289: l_runform VARCHAR2(100);
1290: l_performer_name FND_USER.USER_NAME%TYPE ;
1291: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1292: l_item_desc IC_ITEM_MST_B.ITEM_DESC1%TYPE;
1293: l_performer FND_USER.USER_NAME%TYPE ;
1294: l_user_id FND_USER.USER_ID%TYPE ;
1295: /* make sure that process runs with background engine

Line 1293: l_performer FND_USER.USER_NAME%TYPE ;

1289: l_runform VARCHAR2(100);
1290: l_performer_name FND_USER.USER_NAME%TYPE ;
1291: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1292: l_item_desc IC_ITEM_MST_B.ITEM_DESC1%TYPE;
1293: l_performer FND_USER.USER_NAME%TYPE ;
1294: l_user_id FND_USER.USER_ID%TYPE ;
1295: /* make sure that process runs with background engine
1296: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
1297: the value to use for this is -1 */

Line 1294: l_user_id FND_USER.USER_ID%TYPE ;

1290: l_performer_name FND_USER.USER_NAME%TYPE ;
1291: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1292: l_item_desc IC_ITEM_MST_B.ITEM_DESC1%TYPE;
1293: l_performer FND_USER.USER_NAME%TYPE ;
1294: l_user_id FND_USER.USER_ID%TYPE ;
1295: /* make sure that process runs with background engine
1296: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)
1297: the value to use for this is -1 */
1298:

Line 1365: FROM FND_USER

1361: avalue => l_to_item);
1362:
1363: SELECT USER_NAME
1364: INTO l_performer
1365: FROM FND_USER
1366: WHERE USER_ID = l_user_id;
1367:
1368: WF_ENGINE.SETITEMATTRTEXT(itemtype => l_itemtype,
1369: itemkey => l_itemkey,