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 AP_WEB_EXPENSE_WF

Line 359: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);

355: END IF;
356: ------------------------------------------------------------
357: l_debugInfo := 'Get manager_Id';
358: ------------------------------------------------------------
359: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);
360:
361: ------------------------------------------------------------
362: l_debugInfo := 'Get Name Info Associated With managerId';
363: ------------------------------------------------------------

Line 667: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);

663: END IF;
664: ------------------------------------------------------------
665: l_debugInfo := 'Get manager_Id';
666: ------------------------------------------------------------
667: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);
668:
669: ------------------------------------------------------------
670: l_debugInfo := 'Get Name Info Associated With managerId';
671: ------------------------------------------------------------

Line 789: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);

785:
786:
787: WHILE i<=p_dunning_number LOOP
788:
789: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
790: IF l_job_level < nvl(p_esc_level,999999999) THEN
791:
792: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_managerId);
793: IF (l_managerId IS NULL) THEN

Line 792: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_managerId);

788:
789: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
790: IF l_job_level < nvl(p_esc_level,999999999) THEN
791:
792: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_managerId);
793: IF (l_managerId IS NULL) THEN
794: l_managerId := l_temp_employee_id;
795: EXIT;
796: END IF;

Line 799: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);

795: EXIT;
796: END IF;
797:
798:
799: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
800:
801: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
802: IF (l_next_manager_id IS NOT NULL) THEN
803: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);

Line 801: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);

797:
798:
799: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
800:
801: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
802: IF (l_next_manager_id IS NOT NULL) THEN
803: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);
804: IF(l_next_mgr_job_level > nvl(p_esc_level,999999999)) THEN
805: l_temp_employee_id := l_managerId;

Line 803: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);

799: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
800:
801: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
802: IF (l_next_manager_id IS NOT NULL) THEN
803: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);
804: IF(l_next_mgr_job_level > nvl(p_esc_level,999999999)) THEN
805: l_temp_employee_id := l_managerId;
806: EXIT;
807: END IF;

Line 828: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_sup2_manager_id);

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;
832: ELSE

Line 829: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_sup2_manager_id , l_sup2_manager_job_level);

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;
832: ELSE
833: WF_DIRECTORY.GetUserName('PER', l_sup2_manager_id, l_sup2_manager_name, l_sup2_manager_display_name);

Line 927: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_managerId, p_surrogate_mgr_id)) THEN

923: ------------------------------------------------------
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);

Line 940: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_orig_manager_id, p_surrogate_mgr_id)) 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;
944: END IF;

Line 1585: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateList',

1581: document_type := display_type;
1582:
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateList',
1586: document_id, l_debugInfo);
1587: raise;
1588: END GenerateList;
1589:

Line 1828: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateUnsubmittedList',

1824: document_type := display_type;
1825:
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateUnsubmittedList',
1829: document_id, l_debugInfo);
1830: raise;
1831: END GenUnsubmittedClobList;
1832:

Line 1850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');

1846: l_temp_clob CLOB;
1847: l_colon NUMBER;
1848: BEGIN
1849:
1850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1851:
1852: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1853: GenerateDunningClobList(document_id,
1854: display_type,

Line 1875: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');

1871: document := document || '';
1872:
1873: end if;
1874:
1875: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1876:
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',

Line 1879: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',

1875: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1876:
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',
1880: document_id, l_debug_info);
1881: raise;
1882: END GenerateDunningList;
1883:

Line 2242: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningClobList',

2238: --Amulya Mishra : Notification esc project :
2239:
2240: EXCEPTION
2241: WHEN OTHERS THEN
2242: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningClobList',
2243: document_id, l_debugInfo);
2244: raise;
2245: END GenerateDunningClobList;
2246:

Line 2370: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofUnsubmittedrecords',

2366: document_type := display_type;
2367:
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofUnsubmittedrecords',
2371: document_id, l_debugInfo);
2372: raise;
2373: END getNumofUnsubmittedrecords;
2374:

Line 2491: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofDunningrecords',

2487: document_type := display_type;
2488:
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofDunningrecords',
2492: document_id, l_debugInfo);
2493: raise;
2494: END getNumofDunningrecords;
2495:

Line 2629: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

2625: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2626:
2627: l_debugInfo := 'Loop over all the Dunning Charges ';
2628:
2629: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
2630:
2631: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
2632: NULL;
2633: END IF;

Line 2741: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateManagerDunningList',

2737:
2738:
2739: EXCEPTION
2740: WHEN OTHERS THEN
2741: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateManagerDunningList',
2742: document_id, l_debugInfo);
2743: raise;
2744: END GenerateManagerDunningList;
2745:

Line 3025: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateNextManagerDunningList',

3021:
3022:
3023: EXCEPTION
3024: WHEN OTHERS THEN
3025: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateNextManagerDunningList',
3026: document_id, l_debugInfo);
3027: raise;
3028: END GenerateNextManagerDunningList;
3029:

Line 3097: AP_WEB_EXPENSE_WF.GetManager(p_employee_id, l_supervisor_id);

3093: l_employee_id NUMBER;
3094:
3095:
3096: BEGIN
3097: AP_WEB_EXPENSE_WF.GetManager(p_employee_id, l_supervisor_id);
3098:
3099: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3100: NULL;
3101: END IF;

Line 3446: AP_WEB_EXPENSE_WF.GetManager(l_employee_id, l_temp_manager_id );

3442: END IF;
3443:
3444: WHILE TRUE LOOP
3445:
3446: AP_WEB_EXPENSE_WF.GetManager(l_employee_id, l_temp_manager_id );
3447: IF l_temp_manager_id = p_final_manager_id THEN
3448: EXIT;
3449: ELSE
3450: l_employee_id := l_temp_manager_id ;

Line 3642: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebNextEscManager',

3638: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);
3639:
3640: EXCEPTION
3641: WHEN OTHERS THEN
3642: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebNextEscManager',
3643: l_itemKey, l_debugInfo);
3644: raise;
3645: END GetWebNextEscManager;
3646:

Line 3740: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);

3736: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3737:
3738: l_debugInfo := 'Loop over all the Dunning Charges ';
3739:
3740: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
3741:
3742: DELETE FROM ap_ccard_esc_next_gt;
3743:
3744: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN

Line 3811: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebEscManager',

3807: commit;
3808:
3809: EXCEPTION
3810: WHEN OTHERS THEN
3811: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebEscManager',
3812: null, l_debugInfo);
3813: raise;
3814: END GetWebEscManager;
3815: