DBA Data[Home] [Help]

APPS.EDR_PSIG_PAGE_FLOW dependencies on FND_USER

Line 1484: l_performer_name FND_USER.USER_NAME%TYPE ;

1480:
1481: SIGNER_LIST_REC CURR_LIST_SIGNERS%ROWTYPE;
1482: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;
1483: l_WorkflowProcess VARCHAR2(30) ;
1484: l_performer_name FND_USER.USER_NAME%TYPE ;
1485: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1486: l_item_key VARCHAR2(100);
1487:
1488: --Bug 4577122: Start

Line 1485: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

1481: SIGNER_LIST_REC CURR_LIST_SIGNERS%ROWTYPE;
1482: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;
1483: l_WorkflowProcess VARCHAR2(30) ;
1484: l_performer_name FND_USER.USER_NAME%TYPE ;
1485: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1486: l_item_key VARCHAR2(100);
1487:
1488: --Bug 4577122: Start
1489: l_ignore_wfattr_notfound boolean := true;

Line 2055: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);

2051:
2052: --read the profile option to find out when the requester needs the notification
2053: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2054:
2055: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2056:
2057: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',
2058: USER_ID => l_requester_id );
2059: