DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on WF_DIRECTORY

Line 166: role_info_tbl wf_directory.wf_local_roles_tbl_type;

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

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

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

Line 521: WF_DIRECTORY.GetUserName('PER',

517:
518: ------------------------------------------------------------
519: l_debug_info := 'Get Name Info Associated With Preparer_Id';
520: ------------------------------------------------------------
521: WF_DIRECTORY.GetUserName('PER',
522: p_preparer_id,
523: l_preparer_name,
524: l_preparer_display_name);
525:

Line 534: WF_DIRECTORY.GetUserName('PER',

530:
531: ------------------------------------------------------------
532: l_debug_info := 'Get Name Info Associated With Employee_Id';
533: ------------------------------------------------------------
534: WF_DIRECTORY.GetUserName('PER',
535: p_employee_id,
536: l_emp_name,
537: l_employee_display_name);
538:

Line 611: WF_DIRECTORY.GetUserName('PER',

607: l_approver_display_name := NULL;
608:
609: IF (p_approver_id IS NOT NULL) THEN
610:
611: WF_DIRECTORY.GetUserName('PER',
612: p_approver_id,
613: l_approver_name,
614: l_approver_display_name);
615:

Line 5822: WF_DIRECTORY.GetUserName('PER',

5818:
5819: ----------------------------------------------------------
5820: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
5821: ----------------------------------------------------------
5822: WF_DIRECTORY.GetUserName('PER',
5823: l_preparer_id,
5824: l_preparer_name,
5825: l_preparer_display_name);
5826:

Line 5848: WF_DIRECTORY.GetUserName('PER',

5844:
5845: ----------------------------------------------------------
5846: l_debug_info := 'Get Employee Name Info For Employee_Id';
5847: ----------------------------------------------------------
5848: WF_DIRECTORY.GetUserName('PER',
5849: l_employee_id,
5850: l_employee_name,
5851: l_employee_display_name);
5852:

Line 6815: WF_DIRECTORY.GetUserName('PER',

6811:
6812: ----------------------------------------------------------
6813: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
6814: ----------------------------------------------------------
6815: WF_DIRECTORY.GetUserName('PER',
6816: l_preparer_id,
6817: l_preparer_name,
6818: l_preparer_display_name);
6819:

Line 6846: WF_DIRECTORY.GetUserName('PER',

6842:
6843: ----------------------------------------------------------
6844: l_debug_info := 'Get Employee Name Info For Employee_Id';
6845: ----------------------------------------------------------
6846: WF_DIRECTORY.GetUserName('PER',
6847: l_employee_id,
6848: l_employee_name,
6849: l_employee_display_name);
6850:

Line 7472: WF_DIRECTORY.GetUserName('PER',

7468:
7469: ----------------------------------------------------------
7470: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
7471: ----------------------------------------------------------
7472: WF_DIRECTORY.GetUserName('PER',
7473: l_preparer_id,
7474: l_preparer_name,
7475: l_preparer_display_name);
7476:

Line 7503: WF_DIRECTORY.GetUserName('PER',

7499:
7500: ----------------------------------------------------------
7501: l_debug_info := 'Get Employee Name Info For Employee_Id';
7502: ----------------------------------------------------------
7503: WF_DIRECTORY.GetUserName('PER',
7504: l_employee_id,
7505: l_employee_name,
7506: l_employee_display_name);
7507:

Line 7635: WF_DIRECTORY.GetUserName('PER',

7631:
7632: IF (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(l_item_key),
7633: l_override_approver_id)) THEN
7634:
7635: WF_DIRECTORY.GetUserName('PER',
7636: l_override_approver_id,
7637: l_approver_name,
7638: l_approver_display_name);
7639:

Line 7904: WF_DIRECTORY.GetUserName('PER',

7900:
7901: --------------------------------------------------------------------
7902: l_debug_info := 'Retrieve Preparer_Name Info for given preparer_id';
7903: --------------------------------------------------------------------
7904: WF_DIRECTORY.GetUserName('PER',
7905: l_preparer_id,
7906: l_preparer_name,
7907: l_preparer_display_name);
7908:

Line 7933: WF_DIRECTORY.GetUserName('PER',

7929:
7930: --------------------------------------------------------------------
7931: l_debug_info := 'Retrieve Employee_Name Info for given Employee_id';
7932: --------------------------------------------------------------------
7933: WF_DIRECTORY.GetUserName('PER',
7934: l_employee_id,
7935: l_employee_name,
7936: l_employee_display_name);
7937:

Line 8086: WF_DIRECTORY.GetUserName('PER',

8082:
8083: ------------------------------------------------------------
8084: l_debug_info := 'Retrieve Manager_Name Info for Manager_Id';
8085: ------------------------------------------------------------
8086: WF_DIRECTORY.GetUserName('PER',
8087: p_manager_id,
8088: l_manager_name,
8089: l_manager_display_name);
8090:

Line 10199: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

10195: l_debug_info VARCHAR2(1000);
10196:
10197: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10198: l_entered_by NUMBER := fnd_global.user_id;
10199: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10200:
10201: l_orig_language_code ap_expense_params.note_language_code%type := null;
10202: l_orig_language fnd_languages.nls_language%type := null;
10203: l_new_language_code ap_expense_params.note_language_code%type := null;

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

10266: l_debug_info := 'Get the User Id';
10267: -----------------------------------------
10268: begin
10269:
10270: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);
10271: AP_WEB_OA_MAINFLOW_PKG.GetUserId(l_role_info_tbl(1).orig_system_id, l_entered_by);
10272:
10273: exception
10274: when no_data_found then

Line 10335: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

10331: l_approvalStatusIn varchar2(20);
10332:
10333: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
10334: l_entered_by NUMBER := fnd_global.user_id;
10335: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10336:
10337: l_orig_language_code ap_expense_params.note_language_code%type := null;
10338: l_orig_language fnd_languages.nls_language%type := null;
10339: l_new_language_code ap_expense_params.note_language_code%type := null;

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

10532: l_debug_info := 'Get the User Id';
10533: -----------------------------------------
10534: begin
10535: IF(l_entered_by IS NULL) THEN
10536: WF_DIRECTORY.GetRoleInfo2(wf_engine.context_user, l_role_info_tbl);
10537: AP_WEB_OA_MAINFLOW_PKG.GetUserId(l_role_info_tbl(1).orig_system_id, l_entered_by);
10538: END IF;
10539: exception
10540: when no_data_found then

Line 10818: WF_DIRECTORY.GetUserName('PER',

10814:
10815: ----------------------------------------------------------
10816: l_debug_info := 'Get Preparer Name Info For Preparer_Id';
10817: ----------------------------------------------------------
10818: WF_DIRECTORY.GetUserName('PER',
10819: l_preparer_id,
10820: l_preparer_name,
10821: l_preparer_display_name);
10822:

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

16334: l_masterUserKey);
16335:
16336:
16337: if (l_nextApproversOut(i).orig_system = 'PER') then
16338: WF_DIRECTORY.GetUserName(l_nextApproversOut(i).orig_system,
16339: l_nextApproversOut(i).orig_system_id,
16340: l_manager_name,
16341: l_manager_display_name);
16342: else

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

16340: l_manager_name,
16341: l_manager_display_name);
16342: else
16343: -- 6143415: To support position hierarchy
16344: WF_DIRECTORY.GetRoleName(l_nextApproversOut(i).orig_system,
16345: l_nextApproversOut(i).orig_system_id,
16346: l_manager_name,
16347: l_manager_display_name);
16348: end if;