DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on FND_USER

Line 440: l_next_approver_user_name fnd_user.user_name%TYPE;

436: l_document_id NUMBER;
437: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
438: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
439: l_next_approver_id NUMBER;
440: l_next_approver_user_name fnd_user.user_name%TYPE;
441: l_next_approver_disp_name wf_users.display_name%TYPE;
442: l_orig_system wf_users.orig_system%TYPE := 'PER';
443: l_sequence_num NUMBER;
444: l_approver_type VARCHAR2(30);

Line 448: l_preparer_user_name fnd_user.user_name%TYPE;

444: l_approver_type VARCHAR2(30);
445: E_FAILURE EXCEPTION;
446:
447: l_doc_string varchar2(200);
448: l_preparer_user_name fnd_user.user_name%TYPE;
449: l_org_id number;
450:
451: l_next_approver ame_util.approverRecord;
452: l_insertion_type VARCHAR2(30);

Line 634: l_preparer_user_name fnd_user.user_name%TYPE;

630: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
631:
632: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
633: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
634: l_preparer_user_name fnd_user.user_name%TYPE;
635:
636: BEGIN
637:
638: l_progress := ' Update_Approval_List_Response: 001- at beginning of function';

Line 758: l_preparer_user_name fnd_user.user_name%TYPE;

754: l_doc_string varchar2(200);
755: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
756: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
757: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
758: l_preparer_user_name fnd_user.user_name%TYPE;
759:
760:
761: BEGIN
762:

Line 929: l_user_name fnd_user.user_name%TYPE;

925: l_responder_id NUMBER := NULL;
926: l_forward_to_id NUMBER := NULL;
927: l_end_date DATE; -- notification end date
928:
929: l_user_name fnd_user.user_name%TYPE;
930: l_preparer_user_name fnd_user.user_name%TYPE;
931:
932: l_disp_user_name VARCHAR2(2000);
933: BEGIN

Line 930: l_preparer_user_name fnd_user.user_name%TYPE;

926: l_forward_to_id NUMBER := NULL;
927: l_end_date DATE; -- notification end date
928:
929: l_user_name fnd_user.user_name%TYPE;
930: l_preparer_user_name fnd_user.user_name%TYPE;
931:
932: l_disp_user_name VARCHAR2(2000);
933: BEGIN
934: