DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_DIRECTORY

Line 126: WF_DIRECTORY.GetUserName('PER',

122:
123: ------------------------------------------------------------
124: l_debugInfo := 'Get Name Info Associated With employee_Id';
125: ------------------------------------------------------------
126: WF_DIRECTORY.GetUserName('PER',
127: p_employeeId,
128: l_employeeName,
129: l_employeeDisplayName);
130:

Line 348: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);

344: BEGIN
345: ------------------------------------------------------------
346: l_debugInfo := 'Get Name Info Associated With employee_Id';
347: ------------------------------------------------------------
348: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
349:
350: /* Bug 3877939: If a record does not exist in WF_Directory, then
351: * the program should not error out.
352: */

Line 350: /* Bug 3877939: If a record does not exist in WF_Directory, then

346: l_debugInfo := 'Get Name Info Associated With employee_Id';
347: ------------------------------------------------------------
348: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
349:
350: /* Bug 3877939: If a record does not exist in WF_Directory, then
351: * the program should not error out.
352: */
353: IF l_employeeName IS NULL THEN
354: RETURN;

Line 364: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);

360:
361: ------------------------------------------------------------
362: l_debugInfo := 'Get Name Info Associated With managerId';
363: ------------------------------------------------------------
364: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);
365:
366: ---------------------------------------------------------
367: l_debugInfo := ' Generate new key';
368: ---------------------------------------------------------

Line 656: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);

652:
653: ------------------------------------------------------------
654: l_debugInfo := 'Get Name Info Associated With employee_Id';
655: ------------------------------------------------------------
656: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
657:
658: /* Bug 3877939: If a record does not exist in WF_Directory, then
659: * the program should not error out.
660: */

Line 658: /* Bug 3877939: If a record does not exist in WF_Directory, then

654: l_debugInfo := 'Get Name Info Associated With employee_Id';
655: ------------------------------------------------------------
656: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
657:
658: /* Bug 3877939: If a record does not exist in WF_Directory, then
659: * the program should not error out.
660: */
661: IF l_employeeName IS NULL THEN
662: RETURN;

Line 672: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);

668:
669: ------------------------------------------------------------
670: l_debugInfo := 'Get Name Info Associated With managerId';
671: ------------------------------------------------------------
672: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);
673:
674: ---------------------------------------------------------
675: l_debugInfo := ' Generate new key';
676: ---------------------------------------------------------

Line 827: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);

823: IF p_esc_level = 0 THEN
824: l_temp_employee_id := l_managerId;
825: END IF;
826:
827: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);
828: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_sup2_manager_id);
829: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_sup2_manager_id , l_sup2_manager_job_level);
830: IF (l_sup2_manager_job_level > nvl(p_esc_level,999999999)) THEN
831: l_sup2_manager_display_name := null;

Line 833: WF_DIRECTORY.GetUserName('PER', l_sup2_manager_id, l_sup2_manager_name, l_sup2_manager_display_name);

829: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_sup2_manager_id , l_sup2_manager_job_level);
830: IF (l_sup2_manager_job_level > nvl(p_esc_level,999999999)) THEN
831: l_sup2_manager_display_name := null;
832: ELSE
833: WF_DIRECTORY.GetUserName('PER', l_sup2_manager_id, l_sup2_manager_name, l_sup2_manager_display_name);
834: END IF;
835:
836:
837:

Line 928: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);

924: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
925: ------------------------------------------------------
926: l_temp_mgr_name := l_managerName;
927: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_managerId, p_surrogate_mgr_id)) THEN
928: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
929: END IF;
930: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
931: --WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);
932:

Line 939: WF_DIRECTORY.GetUserName('PER', l_orig_manager_id, l_managerName, l_managerDisplayName);

935: IF (P_send_notifications = 'ES') THEN
936:
937: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ALREADY_NOTIFIED', p_manager_notified);
938: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NEXT_MANAGER_NAME', l_temp_mgr_name);
939: WF_DIRECTORY.GetUserName('PER', l_orig_manager_id, l_managerName, l_managerDisplayName);
940: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_orig_manager_id, p_surrogate_mgr_id)) THEN
941: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
942: ELSE
943: l_temp_mgr_name := l_managerName;

Line 941: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);

937: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ALREADY_NOTIFIED', p_manager_notified);
938: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NEXT_MANAGER_NAME', l_temp_mgr_name);
939: WF_DIRECTORY.GetUserName('PER', l_orig_manager_id, l_managerName, l_managerDisplayName);
940: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_orig_manager_id, p_surrogate_mgr_id)) THEN
941: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
942: ELSE
943: l_temp_mgr_name := l_managerName;
944: END IF;
945:

Line 1196: WF_DIRECTORY.GetUserName('PER', l_exp_info_rec.emp_id, l_employeeName, l_employeeDisplayName);

1192:
1193: ------------------------------------------------------------
1194: l_debugInfo := 'Get Name Info Associated With employee_Id';
1195: ------------------------------------------------------------
1196: WF_DIRECTORY.GetUserName('PER', l_exp_info_rec.emp_id, l_employeeName, l_employeeDisplayName);
1197:
1198: /* Bug 3877939: If a record does not exist in WF_Directory, then
1199: * the program should not error out.
1200: */

Line 1198: /* Bug 3877939: If a record does not exist in WF_Directory, then

1194: l_debugInfo := 'Get Name Info Associated With employee_Id';
1195: ------------------------------------------------------------
1196: WF_DIRECTORY.GetUserName('PER', l_exp_info_rec.emp_id, l_employeeName, l_employeeDisplayName);
1197:
1198: /* Bug 3877939: If a record does not exist in WF_Directory, then
1199: * the program should not error out.
1200: */
1201: IF l_employeeName IS NULL THEN
1202: RETURN;

Line 1210: WF_DIRECTORY.GetUserName('PER', p_current_approver, l_managerName, l_managerDisplayName);

1206: l_debugInfo := 'Get Name Info Associated With managerId';
1207: ------------------------------------------------------------
1208: --2628468, instead of using the manager, use the current approver
1209:
1210: WF_DIRECTORY.GetUserName('PER', p_current_approver, l_managerName, l_managerDisplayName);
1211:
1212: ---------------------------------------------------------
1213: l_debugInfo := ' Generate new key';
1214: -- p_expenseReportId is not used since this notification could be sent nore than once

Line 1308: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);

1304:
1305: ------------------------------------------------------------
1306: l_debugInfo := 'Get Name Info Associated With employee_Id';
1307: ------------------------------------------------------------
1308: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
1309:
1310: /* Bug 3877939: If a record does not exist in WF_Directory, then
1311: * the program should not error out.
1312: */

Line 1310: /* Bug 3877939: If a record does not exist in WF_Directory, then

1306: l_debugInfo := 'Get Name Info Associated With employee_Id';
1307: ------------------------------------------------------------
1308: WF_DIRECTORY.GetUserName('PER', p_employeeId, l_employeeName, l_employeeDisplayName);
1309:
1310: /* Bug 3877939: If a record does not exist in WF_Directory, then
1311: * the program should not error out.
1312: */
1313: IF l_employeeName IS NULL THEN
1314: RETURN;

Line 2952: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);

2948:
2949: --Bug 3310243
2950: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
2951:
2952: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);
2953: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);
2954: --Bug 3337443
2955: l_direct_report_name := GetDirectReport(l_employeeId , l_final_manager_id );
2956:

Line 2953: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);

2949: --Bug 3310243
2950: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
2951:
2952: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);
2953: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);
2954: --Bug 3337443
2955: l_direct_report_name := GetDirectReport(l_employeeId , l_final_manager_id );
2956:
2957: IF (display_type = 'text/plain') THEN

Line 3455: WF_DIRECTORY.GetUserName('PER', l_employee_id, l_manager_name, l_direct_report_name);

3451: END IF;
3452:
3453: END LOOP;
3454:
3455: WF_DIRECTORY.GetUserName('PER', l_employee_id, l_manager_name, l_direct_report_name);
3456: return l_direct_report_name;
3457:
3458: EXCEPTION
3459: WHEN OTHERS THEN

Line 3604: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);

3600: l_total_amt_outstanding := nvl(l_total_amt_outstanding,0) + nvl(l_total_amt_dispute,0);
3601:
3602: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
3603:
3604: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);
3605: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);
3606: l_direct_report_name := GetDirectReport(l_employeeId , l_final_manager_id );
3607:
3608:

Line 3605: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);

3601:
3602: l_total_num_outstanding := nvl(l_total_outstanding,0) + nvl(l_total_dispute,0);
3603:
3604: WF_DIRECTORY.GetUserName('PER', l_supervisor_id, l_supervisor_name, l_supervisor_display_name);
3605: WF_DIRECTORY.GetUserName('PER', l_employeeId, l_employee_name, l_employee_display_name);
3606: l_direct_report_name := GetDirectReport(l_employeeId , l_final_manager_id );
3607:
3608:
3609: IF l_level = l_dunning_number THEN

Line 3831: WF_DIRECTORY.GetUserName('PER',

3827: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
3828: l_orgId number;
3829: BEGIN
3830:
3831: WF_DIRECTORY.GetUserName('PER',
3832: p_employeeId,
3833: l_employeeName,
3834: l_employeeDisplayName);
3835: