DBA Data[Home] [Help]

APPS.EDR_PSIG_PAGE_FLOW dependencies on FND_USER

Line 1462: l_performer_name FND_USER.USER_NAME%TYPE ;

1458:
1459: SIGNER_LIST_REC CURR_LIST_SIGNERS%ROWTYPE;
1460: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;
1461: l_WorkflowProcess VARCHAR2(30) ;
1462: l_performer_name FND_USER.USER_NAME%TYPE ;
1463: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1464: l_item_key VARCHAR2(100);
1465:
1466: --Bug 4577122: Start

Line 1463: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;

1459: SIGNER_LIST_REC CURR_LIST_SIGNERS%ROWTYPE;
1460: l_itemtype WF_ITEMS.ITEM_TYPE%TYPE ;
1461: l_WorkflowProcess VARCHAR2(30) ;
1462: l_performer_name FND_USER.USER_NAME%TYPE ;
1463: l_performer_display_name FND_USER.DESCRIPTION%TYPE ;
1464: l_item_key VARCHAR2(100);
1465:
1466: --Bug 4577122: Start
1467: l_ignore_wfattr_notfound boolean := true;

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

2026:
2027: --read the profile option to find out when the requester needs the notification
2028: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2029:
2030: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2031:
2032: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',
2033: USER_ID => l_requester_id );
2034: