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 331: l_employeeName wf_users.name%type;

327:
328: IS
329: l_itemType VARCHAR2(100) := 'APCCARD';
330: l_itemKey VARCHAR2(100);
331: l_employeeName wf_users.name%type;
332: l_employeeID NUMBER;
333: l_employeeDisplayName wf_users.display_name%type;
334: l_managerId NUMBER;
335: l_managerName wf_users.name%type;

Line 333: l_employeeDisplayName wf_users.display_name%type;

329: l_itemType VARCHAR2(100) := 'APCCARD';
330: l_itemKey VARCHAR2(100);
331: l_employeeName wf_users.name%type;
332: l_employeeID NUMBER;
333: l_employeeDisplayName wf_users.display_name%type;
334: l_managerId NUMBER;
335: l_managerName wf_users.name%type;
336: l_managerDisplayName wf_users.display_name%type;
337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;

Line 335: l_managerName wf_users.name%type;

331: l_employeeName wf_users.name%type;
332: l_employeeID NUMBER;
333: l_employeeDisplayName wf_users.display_name%type;
334: l_managerId NUMBER;
335: l_managerName wf_users.name%type;
336: l_managerDisplayName wf_users.display_name%type;
337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;

Line 336: l_managerDisplayName wf_users.display_name%type;

332: l_employeeID NUMBER;
333: l_employeeDisplayName wf_users.display_name%type;
334: l_managerId NUMBER;
335: l_managerName wf_users.name%type;
336: l_managerDisplayName wf_users.display_name%type;
337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
340: l_orgId number;

Line 585: l_employeeName wf_users.name%type;

581: IS
582: l_itemType VARCHAR2(100) := 'APCCARD';
583: l_itemKey VARCHAR2(100);
584: l_employeeId number;
585: l_employeeName wf_users.name%type;
586: l_managerId NUMBER;
587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;

Line 587: l_managerName wf_users.name%type;

583: l_itemKey VARCHAR2(100);
584: l_employeeId number;
585: l_employeeName wf_users.name%type;
586: l_managerId NUMBER;
587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;
590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

Line 588: l_managerDisplayName wf_users.display_name%type;

584: l_employeeId number;
585: l_employeeName wf_users.name%type;
586: l_managerId NUMBER;
587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;
590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;

Line 589: l_employeeDisplayName wf_users.display_name%type;

585: l_employeeName wf_users.name%type;
586: l_managerId NUMBER;
587: l_managerName wf_users.name%type;
588: l_managerDisplayName wf_users.display_name%type;
589: l_employeeDisplayName wf_users.display_name%type;
590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;
593: l_debugInfo VARCHAR2(200);

Line 605: l_esc_managerName wf_users.name%type;

601: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
602: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
603: l_aging_oustanding NUMBER;
604: l_total_outstanding NUMBER;
605: l_esc_managerName wf_users.name%type;
606: l_esc_managerId NUMBER;
607: l_total_amount NUMBER;
608: i NUMBER := 1;
609: l_job_level NUMBER;

Line 611: l_sup1_manager_name wf_users.name%type;

607: l_total_amount NUMBER;
608: i NUMBER := 1;
609: l_job_level NUMBER;
610: l_prev_job_level NUMBER;
611: l_sup1_manager_name wf_users.name%type;
612: l_sup1_manager_displaye_name wf_users.name%type;
613: l_sup2_manager_id NUMBER;
614: l_sup2_manager_name wf_users.name%type;
615: l_sup2_manager_display_name wf_users.name%type;

Line 612: l_sup1_manager_displaye_name wf_users.name%type;

608: i NUMBER := 1;
609: l_job_level NUMBER;
610: l_prev_job_level NUMBER;
611: l_sup1_manager_name wf_users.name%type;
612: l_sup1_manager_displaye_name wf_users.name%type;
613: l_sup2_manager_id NUMBER;
614: l_sup2_manager_name wf_users.name%type;
615: l_sup2_manager_display_name wf_users.name%type;
616: l_temp_employee_id NUMBER;

Line 614: l_sup2_manager_name wf_users.name%type;

610: l_prev_job_level NUMBER;
611: l_sup1_manager_name wf_users.name%type;
612: l_sup1_manager_displaye_name wf_users.name%type;
613: l_sup2_manager_id NUMBER;
614: l_sup2_manager_name wf_users.name%type;
615: l_sup2_manager_display_name wf_users.name%type;
616: l_temp_employee_id NUMBER;
617: l_orig_manager_id NUMBER;
618:

Line 615: l_sup2_manager_display_name wf_users.name%type;

611: l_sup1_manager_name wf_users.name%type;
612: l_sup1_manager_displaye_name wf_users.name%type;
613: l_sup2_manager_id NUMBER;
614: l_sup2_manager_name wf_users.name%type;
615: l_sup2_manager_display_name wf_users.name%type;
616: l_temp_employee_id NUMBER;
617: l_orig_manager_id NUMBER;
618:
619: l_prev_manager_id NUMBER;

Line 620: l_prev_manager_name wf_users.name%type;

616: l_temp_employee_id NUMBER;
617: l_orig_manager_id NUMBER;
618:
619: l_prev_manager_id NUMBER;
620: l_prev_manager_name wf_users.name%type;
621: l_prev_manager_display_name wf_users.name%type;
622:
623:
624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 621: l_prev_manager_display_name wf_users.name%type;

617: l_orig_manager_id NUMBER;
618:
619: l_prev_manager_id NUMBER;
620: l_prev_manager_name wf_users.name%type;
621: l_prev_manager_display_name wf_users.name%type;
622:
623:
624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
625: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 643: l_temp_mgr_name wf_users.name%type;

639: l_sup2_manager_job_level NUMBER;
640:
641: l_temp_mgr_id NUMBER;
642: l_temp_next_mgr_id NUMBER;
643: l_temp_mgr_name wf_users.name%type;
644: l_temp_next_mgr_name wf_users.name%type;
645: l_temp_mgr_dname wf_users.name%type;
646: l_temp_next_mgr_dname wf_users.name%type;
647:

Line 644: l_temp_next_mgr_name wf_users.name%type;

640:
641: l_temp_mgr_id NUMBER;
642: l_temp_next_mgr_id NUMBER;
643: l_temp_mgr_name wf_users.name%type;
644: l_temp_next_mgr_name wf_users.name%type;
645: l_temp_mgr_dname wf_users.name%type;
646: l_temp_next_mgr_dname wf_users.name%type;
647:
648:

Line 645: l_temp_mgr_dname wf_users.name%type;

641: l_temp_mgr_id NUMBER;
642: l_temp_next_mgr_id NUMBER;
643: l_temp_mgr_name wf_users.name%type;
644: l_temp_next_mgr_name wf_users.name%type;
645: l_temp_mgr_dname wf_users.name%type;
646: l_temp_next_mgr_dname wf_users.name%type;
647:
648:
649: --Amulya Mishra : Notification Esclation

Line 646: l_temp_next_mgr_dname wf_users.name%type;

642: l_temp_next_mgr_id NUMBER;
643: l_temp_mgr_name wf_users.name%type;
644: l_temp_next_mgr_name wf_users.name%type;
645: l_temp_mgr_dname wf_users.name%type;
646: l_temp_next_mgr_dname wf_users.name%type;
647:
648:
649: --Amulya Mishra : Notification Esclation
650:

Line 1174: l_employeeName wf_users.name%type;

1170:
1171: IS
1172: l_itemType VARCHAR2(100) := 'APCCARD';
1173: l_itemKey VARCHAR2(100);
1174: l_employeeName wf_users.name%type;
1175: l_employeeDisplayName wf_users.display_name%type;
1176: l_managerName wf_users.name%type;
1177: l_managerDisplayName wf_users.display_name%type;
1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;

Line 1175: l_employeeDisplayName wf_users.display_name%type;

1171: IS
1172: l_itemType VARCHAR2(100) := 'APCCARD';
1173: l_itemKey VARCHAR2(100);
1174: l_employeeName wf_users.name%type;
1175: l_employeeDisplayName wf_users.display_name%type;
1176: l_managerName wf_users.name%type;
1177: l_managerDisplayName wf_users.display_name%type;
1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1179: l_debugInfo VARCHAR2(200);

Line 1176: l_managerName wf_users.name%type;

1172: l_itemType VARCHAR2(100) := 'APCCARD';
1173: l_itemKey VARCHAR2(100);
1174: l_employeeName wf_users.name%type;
1175: l_employeeDisplayName wf_users.display_name%type;
1176: l_managerName wf_users.name%type;
1177: l_managerDisplayName wf_users.display_name%type;
1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1179: l_debugInfo VARCHAR2(200);
1180:

Line 1177: l_managerDisplayName wf_users.display_name%type;

1173: l_itemKey VARCHAR2(100);
1174: l_employeeName wf_users.name%type;
1175: l_employeeDisplayName wf_users.display_name%type;
1176: l_managerName wf_users.name%type;
1177: l_managerDisplayName wf_users.display_name%type;
1178: l_exp_info_rec AP_WEB_DB_EXPRPT_PKG.ExpInfoRec;
1179: l_debugInfo VARCHAR2(200);
1180:
1181: BEGIN

Line 1289: l_employeeName wf_users.name%type;

1285: IS
1286: l_itemType VARCHAR2(100) := 'APCCARD';
1287: l_itemKey VARCHAR2(100);
1288: l_employeeId number;
1289: l_employeeName wf_users.name%type;
1290: l_employeeDisplayName wf_users.display_name%type;
1291: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1292: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1293: l_sysdate VARCHAR2(30);

Line 1290: l_employeeDisplayName wf_users.display_name%type;

1286: l_itemType VARCHAR2(100) := 'APCCARD';
1287: l_itemKey VARCHAR2(100);
1288: l_employeeId number;
1289: l_employeeName wf_users.name%type;
1290: l_employeeDisplayName wf_users.display_name%type;
1291: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1292: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
1293: l_sysdate VARCHAR2(30);
1294: l_today DATE;

Line 3435: l_manager_name wf_users.display_name%type;

3431: p_final_manager_id IN NUMBER) RETURN VARCHAR2 IS
3432:
3433: l_temp_manager_id NUMBER;
3434: l_employee_id NUMBER := p_employee_id;
3435: l_manager_name wf_users.display_name%type;
3436: l_direct_report_name wf_users.display_name%type;
3437:
3438: ----------------------------------------------------------------------
3439: BEGIN

Line 3436: l_direct_report_name wf_users.display_name%type;

3432:
3433: l_temp_manager_id NUMBER;
3434: l_employee_id NUMBER := p_employee_id;
3435: l_manager_name wf_users.display_name%type;
3436: l_direct_report_name wf_users.display_name%type;
3437:
3438: ----------------------------------------------------------------------
3439: BEGIN
3440: IF p_employee_id IS NULL OR p_final_manager_id IS NULL THEN

Line 3823: l_employeeName wf_users.name%type;

3819: p_endDate IN VARCHAR2)
3820: IS
3821: l_itemType VARCHAR2(100) := 'APCCARD';
3822: l_itemKey VARCHAR2(100);
3823: l_employeeName wf_users.name%type;
3824: l_employeeID NUMBER;
3825: l_employeeDisplayName wf_users.display_name%type;
3826: l_debugInfo VARCHAR2(200);
3827: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;

Line 3825: l_employeeDisplayName wf_users.display_name%type;

3821: l_itemType VARCHAR2(100) := 'APCCARD';
3822: l_itemKey VARCHAR2(100);
3823: l_employeeName wf_users.name%type;
3824: l_employeeID NUMBER;
3825: l_employeeDisplayName wf_users.display_name%type;
3826: l_debugInfo VARCHAR2(200);
3827: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
3828: l_orgId number;
3829: BEGIN