eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_USERS

Line 101: l_employeeName wf_users.name%type;

97: ---------------------------------------------------------------------------
98: IS
99: l_itemType VARCHAR2(100) := 'APCCARD';
100: l_itemKey VARCHAR2(100);
101: l_employeeName wf_users.name%type;
102: l_employeeDisplayName wf_users.display_name%type;
103: l_threshold number := wf_engine.threshold;
104: l_debugInfo VARCHAR2(200);
105: l_account IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := NULL;

Line 102: l_employeeDisplayName wf_users.display_name%type;

98: IS
99: l_itemType VARCHAR2(100) := 'APCCARD';
100: l_itemKey VARCHAR2(100);
101: l_employeeName wf_users.name%type;
102: l_employeeDisplayName wf_users.display_name%type;
103: l_threshold number := wf_engine.threshold;
104: l_debugInfo VARCHAR2(200);
105: l_account IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := NULL;
106: l_invoiceNum AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;

Line 321: l_employeeName wf_users.name%type;

317:
318: IS
319: l_itemType VARCHAR2(100) := 'APCCARD';
320: l_itemKey VARCHAR2(100);
321: l_employeeName wf_users.name%type;
322: l_employeeID NUMBER;
323: l_employeeDisplayName wf_users.display_name%type;
324: l_managerId NUMBER;
325: l_managerName wf_users.name%type;

Line 323: l_employeeDisplayName wf_users.display_name%type;

319: l_itemType VARCHAR2(100) := 'APCCARD';
320: l_itemKey VARCHAR2(100);
321: l_employeeName wf_users.name%type;
322: l_employeeID NUMBER;
323: l_employeeDisplayName wf_users.display_name%type;
324: l_managerId NUMBER;
325: l_managerName wf_users.name%type;
326: l_managerDisplayName wf_users.display_name%type;
327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

Line 325: l_managerName wf_users.name%type;

321: l_employeeName wf_users.name%type;
322: l_employeeID NUMBER;
323: l_employeeDisplayName wf_users.display_name%type;
324: l_managerId NUMBER;
325: l_managerName wf_users.name%type;
326: l_managerDisplayName wf_users.display_name%type;
327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;

Line 326: l_managerDisplayName wf_users.display_name%type;

322: l_employeeID NUMBER;
323: l_employeeDisplayName wf_users.display_name%type;
324: l_managerId NUMBER;
325: l_managerName wf_users.name%type;
326: l_managerDisplayName wf_users.display_name%type;
327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
330: l_orgId number;

Line 541: l_employeeName wf_users.name%type;

537: IS
538: l_itemType VARCHAR2(100) := 'APCCARD';
539: l_itemKey VARCHAR2(100);
540: l_employeeId number;
541: l_employeeName wf_users.name%type;
542: l_managerId NUMBER;
543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;

Line 543: l_managerName wf_users.name%type;

539: l_itemKey VARCHAR2(100);
540: l_employeeId number;
541: l_employeeName wf_users.name%type;
542: l_managerId NUMBER;
543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;
546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

Line 544: l_managerDisplayName wf_users.display_name%type;

540: l_employeeId number;
541: l_employeeName wf_users.name%type;
542: l_managerId NUMBER;
543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;
546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;

Line 545: l_employeeDisplayName wf_users.display_name%type;

541: l_employeeName wf_users.name%type;
542: l_managerId NUMBER;
543: l_managerName wf_users.name%type;
544: l_managerDisplayName wf_users.display_name%type;
545: l_employeeDisplayName wf_users.display_name%type;
546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;
549: l_debugInfo VARCHAR2(200);

Line 561: l_esc_managerName wf_users.name%type;

557: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
558: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
559: l_aging_oustanding NUMBER;
560: l_total_outstanding NUMBER;
561: l_esc_managerName wf_users.name%type;
562: l_esc_managerId NUMBER;
563: l_total_amount NUMBER;
564: i NUMBER := 1;
565: l_job_level NUMBER;

Line 567: l_sup1_manager_name wf_users.name%type;

563: l_total_amount NUMBER;
564: i NUMBER := 1;
565: l_job_level NUMBER;
566: l_prev_job_level NUMBER;
567: l_sup1_manager_name wf_users.name%type;
568: l_sup1_manager_displaye_name wf_users.name%type;
569: l_sup2_manager_id NUMBER;
570: l_sup2_manager_name wf_users.name%type;
571: l_sup2_manager_display_name wf_users.name%type;

Line 568: l_sup1_manager_displaye_name wf_users.name%type;

564: i NUMBER := 1;
565: l_job_level NUMBER;
566: l_prev_job_level NUMBER;
567: l_sup1_manager_name wf_users.name%type;
568: l_sup1_manager_displaye_name wf_users.name%type;
569: l_sup2_manager_id NUMBER;
570: l_sup2_manager_name wf_users.name%type;
571: l_sup2_manager_display_name wf_users.name%type;
572: l_temp_employee_id NUMBER;

Line 570: l_sup2_manager_name wf_users.name%type;

566: l_prev_job_level NUMBER;
567: l_sup1_manager_name wf_users.name%type;
568: l_sup1_manager_displaye_name wf_users.name%type;
569: l_sup2_manager_id NUMBER;
570: l_sup2_manager_name wf_users.name%type;
571: l_sup2_manager_display_name wf_users.name%type;
572: l_temp_employee_id NUMBER;
573: l_orig_manager_id NUMBER;
574:

Line 571: l_sup2_manager_display_name wf_users.name%type;

567: l_sup1_manager_name wf_users.name%type;
568: l_sup1_manager_displaye_name wf_users.name%type;
569: l_sup2_manager_id NUMBER;
570: l_sup2_manager_name wf_users.name%type;
571: l_sup2_manager_display_name wf_users.name%type;
572: l_temp_employee_id NUMBER;
573: l_orig_manager_id NUMBER;
574:
575: l_prev_manager_id NUMBER;

Line 576: l_prev_manager_name wf_users.name%type;

572: l_temp_employee_id NUMBER;
573: l_orig_manager_id NUMBER;
574:
575: l_prev_manager_id NUMBER;
576: l_prev_manager_name wf_users.name%type;
577: l_prev_manager_display_name wf_users.name%type;
578:
579:
580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 577: l_prev_manager_display_name wf_users.name%type;

573: l_orig_manager_id NUMBER;
574:
575: l_prev_manager_id NUMBER;
576: l_prev_manager_name wf_users.name%type;
577: l_prev_manager_display_name wf_users.name%type;
578:
579:
580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
581: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 1106: l_employeeName wf_users.name%type;

1102:
1103: IS
1104: l_itemType VARCHAR2(100) := 'APCCARD';
1105: l_itemKey VARCHAR2(100);
1106: l_employeeName wf_users.name%type;
1107: l_employeeDisplayName wf_users.display_name%type;
1108: l_managerName wf_users.name%type;
1109: l_managerDisplayName wf_users.display_name%type;
1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

Line 1107: l_employeeDisplayName wf_users.display_name%type;

1103: IS
1104: l_itemType VARCHAR2(100) := 'APCCARD';
1105: l_itemKey VARCHAR2(100);
1106: l_employeeName wf_users.name%type;
1107: l_employeeDisplayName wf_users.display_name%type;
1108: l_managerName wf_users.name%type;
1109: l_managerDisplayName wf_users.display_name%type;
1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1111: l_debugInfo VARCHAR2(200);

Line 1108: l_managerName wf_users.name%type;

1104: l_itemType VARCHAR2(100) := 'APCCARD';
1105: l_itemKey VARCHAR2(100);
1106: l_employeeName wf_users.name%type;
1107: l_employeeDisplayName wf_users.display_name%type;
1108: l_managerName wf_users.name%type;
1109: l_managerDisplayName wf_users.display_name%type;
1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1111: l_debugInfo VARCHAR2(200);
1112:

Line 1109: l_managerDisplayName wf_users.display_name%type;

1105: l_itemKey VARCHAR2(100);
1106: l_employeeName wf_users.name%type;
1107: l_employeeDisplayName wf_users.display_name%type;
1108: l_managerName wf_users.name%type;
1109: l_managerDisplayName wf_users.display_name%type;
1110: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1111: l_debugInfo VARCHAR2(200);
1112:
1113: BEGIN

Line 1221: l_employeeName wf_users.name%type;

1217: IS
1218: l_itemType VARCHAR2(100) := 'APCCARD';
1219: l_itemKey VARCHAR2(100);
1220: l_employeeId number;
1221: l_employeeName wf_users.name%type;
1222: l_employeeDisplayName wf_users.display_name%type;
1223: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1224: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1225: l_sysdate VARCHAR2(30);

Line 1222: l_employeeDisplayName wf_users.display_name%type;

1218: l_itemType VARCHAR2(100) := 'APCCARD';
1219: l_itemKey VARCHAR2(100);
1220: l_employeeId number;
1221: l_employeeName wf_users.name%type;
1222: l_employeeDisplayName wf_users.display_name%type;
1223: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1224: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1225: l_sysdate VARCHAR2(30);
1226: l_today DATE;

Line 3362: l_manager_name wf_users.display_name%type;

3358: p_final_manager_id IN NUMBER) RETURN VARCHAR2 IS
3359:
3360: l_temp_manager_id NUMBER;
3361: l_employee_id NUMBER := p_employee_id;
3362: l_manager_name wf_users.display_name%type;
3363: l_direct_report_name wf_users.display_name%type;
3364:
3365: ----------------------------------------------------------------------
3366: BEGIN

Line 3363: l_direct_report_name wf_users.display_name%type;

3359:
3360: l_temp_manager_id NUMBER;
3361: l_employee_id NUMBER := p_employee_id;
3362: l_manager_name wf_users.display_name%type;
3363: l_direct_report_name wf_users.display_name%type;
3364:
3365: ----------------------------------------------------------------------
3366: BEGIN
3367: IF p_employee_id IS NULL OR p_final_manager_id IS NULL THEN

Line 3754: l_employeeName wf_users.name%type;

3750: p_endDate IN VARCHAR2)
3751: IS
3752: l_itemType VARCHAR2(100) := 'APCCARD';
3753: l_itemKey VARCHAR2(100);
3754: l_employeeName wf_users.name%type;
3755: l_employeeID NUMBER;
3756: l_employeeDisplayName wf_users.display_name%type;
3757: l_debugInfo VARCHAR2(200);
3758: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

Line 3756: l_employeeDisplayName wf_users.display_name%type;

3752: l_itemType VARCHAR2(100) := 'APCCARD';
3753: l_itemKey VARCHAR2(100);
3754: l_employeeName wf_users.name%type;
3755: l_employeeID NUMBER;
3756: l_employeeDisplayName wf_users.display_name%type;
3757: l_debugInfo VARCHAR2(200);
3758: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
3759: l_orgId number;
3760: BEGIN