DBA Data[Home] [Help]

APPS.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_EXPENSE_WF

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

345: END IF;
346: ------------------------------------------------------------
347: l_debugInfo := 'Get manager_Id';
348: ------------------------------------------------------------
349: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);
350:
351: ------------------------------------------------------------
352: l_debugInfo := 'Get Name Info Associated With managerId';
353: ------------------------------------------------------------

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

612: END IF;
613: ------------------------------------------------------------
614: l_debugInfo := 'Get manager_Id';
615: ------------------------------------------------------------
616: AP_WEB_EXPENSE_WF.GetManager(p_employeeId, l_managerId);
617:
618: ------------------------------------------------------------
619: l_debugInfo := 'Get Name Info Associated With managerId';
620: ------------------------------------------------------------

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

734:
735:
736: WHILE i<=p_dunning_number LOOP
737:
738: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
739: IF l_job_level < nvl(p_esc_level,999999999) THEN
740:
741: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_managerId);
742: IF (l_managerId IS NULL) THEN

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

737:
738: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
739: IF l_job_level < nvl(p_esc_level,999999999) THEN
740:
741: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_managerId);
742: IF (l_managerId IS NULL) THEN
743: l_managerId := l_temp_employee_id;
744: EXIT;
745: END IF;

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

744: EXIT;
745: END IF;
746:
747:
748: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
749:
750: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
751: IF (l_next_manager_id IS NOT NULL) THEN
752: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);

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

746:
747:
748: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
749:
750: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
751: IF (l_next_manager_id IS NOT NULL) THEN
752: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);
753: IF(l_next_mgr_job_level > nvl(p_esc_level,999999999)) THEN
754: l_temp_employee_id := l_managerId;

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

748: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_managerId,l_job_level);
749:
750: AP_WEB_EXPENSE_WF.GetManager(l_managerId , l_next_manager_id);
751: IF (l_next_manager_id IS NOT NULL) THEN
752: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_next_manager_id , l_next_mgr_job_level);
753: IF(l_next_mgr_job_level > nvl(p_esc_level,999999999)) THEN
754: l_temp_employee_id := l_managerId;
755: EXIT;
756: END IF;

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

773: l_temp_employee_id := l_managerId;
774: END IF;
775:
776: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);
777: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_sup2_manager_id);
778: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_sup2_manager_id , l_sup2_manager_job_level);
779: IF (l_sup2_manager_job_level > nvl(p_esc_level,999999999)) THEN
780: l_sup2_manager_display_name := null;
781: ELSE

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

774: END IF;
775:
776: WF_DIRECTORY.GetUserName('PER', l_managerId, l_managerName, l_managerDisplayName);
777: AP_WEB_EXPENSE_WF.GetManager(l_temp_employee_id, l_sup2_manager_id);
778: AP_WEB_EXPENSE_WF.GetJobLevelAndSupervisor(l_sup2_manager_id , l_sup2_manager_job_level);
779: IF (l_sup2_manager_job_level > nvl(p_esc_level,999999999)) THEN
780: l_sup2_manager_display_name := null;
781: ELSE
782: WF_DIRECTORY.GetUserName('PER', l_sup2_manager_id, l_sup2_manager_name, l_sup2_manager_display_name);

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

1507: document_type := display_type;
1508:
1509: EXCEPTION
1510: WHEN OTHERS THEN
1511: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateList',
1512: document_id, l_debugInfo);
1513: raise;
1514: END GenerateList;
1515:

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

1750: document_type := display_type;
1751:
1752: EXCEPTION
1753: WHEN OTHERS THEN
1754: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateUnsubmittedList',
1755: document_id, l_debugInfo);
1756: raise;
1757: END GenUnsubmittedClobList;
1758:

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

1772: l_temp_clob CLOB;
1773: l_colon NUMBER;
1774: BEGIN
1775:
1776: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1777:
1778: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1779: GenerateDunningClobList(document_id,
1780: display_type,

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

1797: document := document || '';
1798:
1799: end if;
1800:
1801: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1802:
1803: EXCEPTION
1804: WHEN OTHERS THEN
1805: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',

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

1801: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1802:
1803: EXCEPTION
1804: WHEN OTHERS THEN
1805: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',
1806: document_id, l_debug_info);
1807: raise;
1808: END GenerateDunningList;
1809:

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

2164: --Amulya Mishra : Notification esc project :
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningClobList',
2169: document_id, l_debugInfo);
2170: raise;
2171: END GenerateDunningClobList;
2172:

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

2292: document_type := display_type;
2293:
2294: EXCEPTION
2295: WHEN OTHERS THEN
2296: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofUnsubmittedrecords',
2297: document_id, l_debugInfo);
2298: raise;
2299: END getNumofUnsubmittedrecords;
2300:

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

2413: document_type := display_type;
2414:
2415: EXCEPTION
2416: WHEN OTHERS THEN
2417: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'getNumofDunningrecords',
2418: document_id, l_debugInfo);
2419: raise;
2420: END getNumofDunningrecords;
2421:

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

2551: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2552:
2553: l_debugInfo := 'Loop over all the Dunning Charges ';
2554:
2555: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
2556:
2557: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
2558: NULL;
2559: END IF;

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

2663:
2664:
2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateManagerDunningList',
2668: document_id, l_debugInfo);
2669: raise;
2670: END GenerateManagerDunningList;
2671:

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

2947:
2948:
2949: EXCEPTION
2950: WHEN OTHERS THEN
2951: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateNextManagerDunningList',
2952: document_id, l_debugInfo);
2953: raise;
2954: END GenerateNextManagerDunningList;
2955:

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

3019: l_employee_id NUMBER;
3020:
3021:
3022: BEGIN
3023: AP_WEB_EXPENSE_WF.GetManager(p_employee_id, l_supervisor_id);
3024:
3025: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
3026: NULL;
3027: END IF;

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

3369: END IF;
3370:
3371: WHILE TRUE LOOP
3372:
3373: AP_WEB_EXPENSE_WF.GetManager(l_employee_id, l_temp_manager_id );
3374: IF l_temp_manager_id = p_final_manager_id THEN
3375: EXIT;
3376: ELSE
3377: l_employee_id := l_temp_manager_id ;

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

3569: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);
3570:
3571: EXCEPTION
3572: WHEN OTHERS THEN
3573: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebNextEscManager',
3574: l_itemKey, l_debugInfo);
3575: raise;
3576: END GetWebNextEscManager;
3577:

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

3667: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3668:
3669: l_debugInfo := 'Loop over all the Dunning Charges ';
3670:
3671: AP_WEB_EXPENSE_WF.GetManager(l_employeeId, l_supervisor_id);
3672:
3673: DELETE FROM ap_ccard_esc_next_gt;
3674:
3675: IF (NOT GetEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN

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

3738: commit;
3739:
3740: EXCEPTION
3741: WHEN OTHERS THEN
3742: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebEscManager',
3743: null, l_debugInfo);
3744: raise;
3745: END GetWebEscManager;
3746: