DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on WF_DIRECTORY

Line 163: role_info_tbl wf_directory.wf_local_roles_tbl_type;

159: ----------------------------------------------------------------------
160: l_debug_info VARCHAR2(500);
161: l_role_valid VARCHAR2(1);
162: tvalue varchar2(4000);
163: role_info_tbl wf_directory.wf_local_roles_tbl_type;
164: BEGIN
165:
166: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetFromRole');
167:

Line 170: Wf_Directory.GetRoleInfo2(p_from_role,role_info_tbl);

166: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetFromRole');
167:
168: l_role_valid := 'Y';
169: tvalue := p_from_role;
170: Wf_Directory.GetRoleInfo2(p_from_role,role_info_tbl);
171: tvalue := role_info_tbl(1).name;
172: -- If not internal name, check for display_name
173: if (tvalue is null) then
174: begin

Line 504: WF_DIRECTORY.GetUserName('PER',

500:
501: ------------------------------------------------------------
502: l_debug_info := 'Get Name Info Associated With Preparer_Id';
503: ------------------------------------------------------------
504: WF_DIRECTORY.GetUserName('PER',
505: p_preparer_id,
506: l_preparer_name,
507: l_preparer_display_name);
508:

Line 517: WF_DIRECTORY.GetUserName('PER',

513:
514: ------------------------------------------------------------
515: l_debug_info := 'Get Name Info Associated With Employee_Id';
516: ------------------------------------------------------------
517: WF_DIRECTORY.GetUserName('PER',
518: p_employee_id,
519: l_emp_name,
520: l_employee_display_name);
521:

Line 594: WF_DIRECTORY.GetUserName('PER',

590: l_approver_display_name := NULL;
591:
592: IF (p_approver_id IS NOT NULL) THEN
593:
594: WF_DIRECTORY.GetUserName('PER',
595: p_approver_id,
596: l_approver_name,
597: l_approver_display_name);
598:

Line 5464: WF_DIRECTORY.GetUserName('PER',

5460:
5461: ----------------------------------------------------------
5462: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
5463: ----------------------------------------------------------
5464: WF_DIRECTORY.GetUserName('PER',
5465: l_preparer_id,
5466: l_preparer_name,
5467: l_preparer_display_name);
5468:

Line 5490: WF_DIRECTORY.GetUserName('PER',

5486:
5487: ----------------------------------------------------------
5488: l_debug_info := 'Get Employee Name Info For Employee_Id';
5489: ----------------------------------------------------------
5490: WF_DIRECTORY.GetUserName('PER',
5491: l_employee_id,
5492: l_employee_name,
5493: l_employee_display_name);
5494:

Line 6434: WF_DIRECTORY.GetUserName('PER',

6430:
6431: ----------------------------------------------------------
6432: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
6433: ----------------------------------------------------------
6434: WF_DIRECTORY.GetUserName('PER',
6435: l_preparer_id,
6436: l_preparer_name,
6437: l_preparer_display_name);
6438:

Line 6465: WF_DIRECTORY.GetUserName('PER',

6461:
6462: ----------------------------------------------------------
6463: l_debug_info := 'Get Employee Name Info For Employee_Id';
6464: ----------------------------------------------------------
6465: WF_DIRECTORY.GetUserName('PER',
6466: l_employee_id,
6467: l_employee_name,
6468: l_employee_display_name);
6469:

Line 7022: WF_DIRECTORY.GetUserName('PER',

7018:
7019: ----------------------------------------------------------
7020: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
7021: ----------------------------------------------------------
7022: WF_DIRECTORY.GetUserName('PER',
7023: l_preparer_id,
7024: l_preparer_name,
7025: l_preparer_display_name);
7026:

Line 7053: WF_DIRECTORY.GetUserName('PER',

7049:
7050: ----------------------------------------------------------
7051: l_debug_info := 'Get Employee Name Info For Employee_Id';
7052: ----------------------------------------------------------
7053: WF_DIRECTORY.GetUserName('PER',
7054: l_employee_id,
7055: l_employee_name,
7056: l_employee_display_name);
7057:

Line 7185: WF_DIRECTORY.GetUserName('PER',

7181:
7182: IF (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(l_item_key),
7183: l_override_approver_id)) THEN
7184:
7185: WF_DIRECTORY.GetUserName('PER',
7186: l_override_approver_id,
7187: l_approver_name,
7188: l_approver_display_name);
7189:

Line 7459: WF_DIRECTORY.GetUserName('PER',

7455:
7456: --------------------------------------------------------------------
7457: l_debug_info := 'Retrieve Preparer_Name Info for given preparer_id';
7458: --------------------------------------------------------------------
7459: WF_DIRECTORY.GetUserName('PER',
7460: l_preparer_id,
7461: l_preparer_name,
7462: l_preparer_display_name);
7463:

Line 7488: WF_DIRECTORY.GetUserName('PER',

7484:
7485: --------------------------------------------------------------------
7486: l_debug_info := 'Retrieve Employee_Name Info for given Employee_id';
7487: --------------------------------------------------------------------
7488: WF_DIRECTORY.GetUserName('PER',
7489: l_employee_id,
7490: l_employee_name,
7491: l_employee_display_name);
7492:

Line 7641: WF_DIRECTORY.GetUserName('PER',

7637:
7638: ------------------------------------------------------------
7639: l_debug_info := 'Retrieve Manager_Name Info for Manager_Id';
7640: ------------------------------------------------------------
7641: WF_DIRECTORY.GetUserName('PER',
7642: p_manager_id,
7643: l_manager_name,
7644: l_manager_display_name);
7645:

Line 9753: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

9749: l_debug_info VARCHAR2(1000);
9750:
9751: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9752: l_entered_by NUMBER := fnd_global.user_id;
9753: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9754:
9755: l_orig_language_code ap_expense_params.note_language_code%type := null;
9756: l_orig_language fnd_languages.nls_language%type := null;
9757: l_new_language_code ap_expense_params.note_language_code%type := null;

Line 9824: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);

9820: l_debug_info := 'Get the User Id';
9821: -----------------------------------------
9822: begin
9823:
9824: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);
9825: AP_WEB_OA_MAINFLOW_PKG.GetUserId(l_role_info_tbl(1).orig_system_id, l_entered_by);
9826:
9827: exception
9828: when no_data_found then

Line 9884: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

9880: l_approver_name varchar2(240);
9881:
9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9883: l_entered_by NUMBER := fnd_global.user_id;
9884: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9885:
9886: l_orig_language_code ap_expense_params.note_language_code%type := null;
9887: l_orig_language fnd_languages.nls_language%type := null;
9888: l_new_language_code ap_expense_params.note_language_code%type := null;

Line 9974: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);

9970: l_debug_info := 'Get the User Id';
9971: -----------------------------------------
9972: begin
9973:
9974: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);
9975: AP_WEB_OA_MAINFLOW_PKG.GetUserId(l_role_info_tbl(1).orig_system_id, l_entered_by);
9976:
9977: exception
9978: when no_data_found then

Line 10207: WF_DIRECTORY.GetUserName('PER',

10203:
10204: ----------------------------------------------------------
10205: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
10206: ----------------------------------------------------------
10207: WF_DIRECTORY.GetUserName('PER',
10208: l_preparer_id,
10209: l_preparer_name,
10210: l_preparer_display_name);
10211:

Line 15278: WF_DIRECTORY.GetUserName(l_nextApproversOut(i).orig_system,

15274: l_masterUserKey);
15275:
15276:
15277: if (l_nextApproversOut(i).orig_system = 'PER') then
15278: WF_DIRECTORY.GetUserName(l_nextApproversOut(i).orig_system,
15279: l_nextApproversOut(i).orig_system_id,
15280: l_manager_name,
15281: l_manager_display_name);
15282: else

Line 15284: WF_DIRECTORY.GetRoleName(l_nextApproversOut(i).orig_system,

15280: l_manager_name,
15281: l_manager_display_name);
15282: else
15283: -- 6143415: To support position hierarchy
15284: WF_DIRECTORY.GetRoleName(l_nextApproversOut(i).orig_system,
15285: l_nextApproversOut(i).orig_system_id,
15286: l_manager_name,
15287: l_manager_display_name);
15288: end if;