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_INACTIVE_EMP_WF_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 815: IF ((AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo( l_employee_id ,l_supervisor_id, l_manager_name, l_preparer_org_id)= FALSE) OR l_supervisor_id is NULL) THEN

811: l_debug_info := 'Get the Manager Information Associated With Inactive Employee Id';
812: -----------------------------------------------------------------------------------
813:
814:
815: IF ((AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo( l_employee_id ,l_supervisor_id, l_manager_name, l_preparer_org_id)= FALSE) OR l_supervisor_id is NULL) THEN
816: p_result := 'COMPLETE:N';
817: l_supervisor_id := NULL;
818: ELSE
819:

Line 834: IF ((AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo( l_employee_id ,l_supervisor_id, l_manager_name, l_preparer_org_id)= FALSE) OR l_supervisor_id is NULL) THEN

830: l_inact_emp_cost_center,
831: l_inact_emp_manager_id);
832:
833: IF l_dummy_inact_emp_mang_name IS NULL THEN
834: IF ((AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo( l_employee_id ,l_supervisor_id, l_manager_name, l_preparer_org_id)= FALSE) OR l_supervisor_id is NULL) THEN
835: p_result := 'COMPLETE:N';
836: l_supervisor_id := NULL;
837: ELSE
838: l_inact_emp_manager_id := l_supervisor_id;

Line 1226: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;

1222: -- Assumptions:
1223: --
1224: -- Notes: Inactive Employee Workflow Processs
1225:
1226: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1227: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1228: l_number_of_emp_user NUMBER;
1229: l_check_mang_sec_attribute BOOLEAN := FALSE;
1230: l_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;

Line 1227: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

1223: --
1224: -- Notes: Inactive Employee Workflow Processs
1225:
1226: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1227: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1228: l_number_of_emp_user NUMBER;
1229: l_check_mang_sec_attribute BOOLEAN := FALSE;
1230: l_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1231: l_temp_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;

Line 1230: l_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;

1226: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1227: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1228: l_number_of_emp_user NUMBER;
1229: l_check_mang_sec_attribute BOOLEAN := FALSE;
1230: l_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1231: l_temp_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1232: l_preparer_emp_id NUMBER;
1233: l_debug_info VARCHAR2(200);
1234: l_inactive_employee_id NUMBER;

Line 1231: l_temp_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;

1227: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1228: l_number_of_emp_user NUMBER;
1229: l_check_mang_sec_attribute BOOLEAN := FALSE;
1230: l_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1231: l_temp_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1232: l_preparer_emp_id NUMBER;
1233: l_debug_info VARCHAR2(200);
1234: l_inactive_employee_id NUMBER;
1235: l_employee_id AP_WEB_DB_HR_INT_PKG.usrSecAttr_webUserID;

Line 1235: l_employee_id AP_WEB_DB_HR_INT_PKG.usrSecAttr_webUserID;

1231: l_temp_emplist_for_webuser AP_WEB_DB_HR_INT_PKG.EmpNameCursor;
1232: l_preparer_emp_id NUMBER;
1233: l_debug_info VARCHAR2(200);
1234: l_inactive_employee_id NUMBER;
1235: l_employee_id AP_WEB_DB_HR_INT_PKG.usrSecAttr_webUserID;
1236: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
1237: l_preparer_web_user_id NUMBER;
1238: l_preparer_name VARCHAR2(30);
1239:

Line 1236: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;

1232: l_preparer_emp_id NUMBER;
1233: l_debug_info VARCHAR2(200);
1234: l_inactive_employee_id NUMBER;
1235: l_employee_id AP_WEB_DB_HR_INT_PKG.usrSecAttr_webUserID;
1236: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
1237: l_preparer_web_user_id NUMBER;
1238: l_preparer_name VARCHAR2(30);
1239:
1240:

Line 1296: IF ( AP_WEB_DB_HR_INT_PKG.GetAllEmpListForWebUserCursor(

1292: ------------------------------------------------------------
1293: l_debug_info := 'Getting WebUser for preparer employee ID';
1294: ------------------------------------------------------------
1295:
1296: IF ( AP_WEB_DB_HR_INT_PKG.GetAllEmpListForWebUserCursor(
1297: l_preparer_web_user_id,
1298: l_emplist_for_webuser) = TRUE ) THEN
1299: LOOP
1300: FETCH l_emplist_for_webuser INTO l_employee_id, l_employee_name;

Line 1362: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

1358: l_preparer_emp_id NUMBER;
1359: l_inact_employee_id NUMBER;
1360: l_error VARCHAR2(2000);
1361: l_debug_info VARCHAR2(200);
1362: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1363: l_preparer_web_user_id NUMBER;
1364: l_inact_employee_display_name VARCHAR2(100);
1365: l_preparer_display_name VARCHAR2(100);
1366: l_preparer_name VARCHAR2(100);

Line 1574: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;

1570: l_preparer_emp_id NUMBER;
1571: l_inact_employee_id NUMBER;
1572: l_error VARCHAR2(2000);
1573: l_debug_info VARCHAR2(200);
1574: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1575: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1576: l_preparer_web_user_id NUMBER;
1577: l_inact_emp_web_user_id NUMBER;
1578: l_preparer_name VARCHAR2(50);

Line 1575: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

1571: l_inact_employee_id NUMBER;
1572: l_error VARCHAR2(2000);
1573: l_debug_info VARCHAR2(200);
1574: l_preparer_Userid AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1575: l_preparer_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1576: l_preparer_web_user_id NUMBER;
1577: l_inact_emp_web_user_id NUMBER;
1578: l_preparer_name VARCHAR2(50);
1579: l_inact_employee_name VARCHAR2(50);

Line 2342: if (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(p_preparer_id,l_preparer_org_id) = TRUE ) then

2338:
2339: --------------------------------------------------------
2340: l_debug_info := 'Get Preperer Org Info Item Attribute';
2341: --------------------------------------------------------
2342: if (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(p_preparer_id,l_preparer_org_id) = TRUE ) then
2343:
2344: --------------------------------------------------------
2345: l_debug_info := 'Set Preperer Org Info Item Attribute';
2346: --------------------------------------------------------