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

Line 1: PACKAGE BODY AP_WEB_DB_HR_INT_PKG AS

1: PACKAGE BODY AP_WEB_DB_HR_INT_PKG AS
2: /* $Header: apwdbhrb.pls 120.31.12010000.5 2009/10/21 09:53:59 dsadipir ship $ */
3:
4: --------------------------------------------------------------------------------
5: FUNCTION GetUserIdForEmpCursor(

Line 141: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

137: (
138: SELECT employee_id person_id, full_name
139: FROM per_employees_x emp
140: WHERE upper(full_name) like upper(p_upper_approver_name_fuzzy)
141: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
142: UNION ALL
143: SELECT person_id, full_name
144: FROM per_cont_workers_current_x emp
145: WHERE upper(full_name) like upper(p_upper_approver_name_fuzzy)

Line 254: and not AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'

250: from
251: ( select organization_id
252: from per_employees_x emp
253: where employee_id = P_EmployeeID
254: and not AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'
255: union all
256: select organization_id
257: from per_cont_workers_current_x emp
258: where person_id = P_EmployeeID);

Line 294: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

290: emp.default_code_combination_id,
291: employee_id person_id
292: FROM per_employees_x emp
293: WHERE emp.employee_id = p_employee_id
294: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
295: UNION ALL
296: SELECT cwk.full_name,
297: cwk.npw_number employee_num,
298: cwk.default_code_combination_id,

Line 317: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

313: emp.default_code_combination_id,
314: employee_id person_id
315: FROM per_employees_x emp
316: WHERE emp.employee_id = p_employee_id
317: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
318: UNION ALL
319: SELECT cwk.full_name,
320: cwk.npw_number employee_num,
321: cwk.default_code_combination_id,

Line 520: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

516: WHERE mgr.person_id = (
517: SELECT emp.supervisor_id
518: FROM per_employees_x emp
519: WHERE emp.employee_id = p_employee_id
520: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
521: UNION ALL
522: SELECT emp.supervisor_id
523: FROM per_cont_workers_current_x emp
524: WHERE emp.person_id = p_employee_id

Line 768: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

764: WHERE mgr.person_id = (
765: SELECT emp.supervisor_id
766: FROM per_employees_x emp
767: WHERE emp.employee_id = p_employee_id
768: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
769: UNION ALL
770: SELECT emp.supervisor_id
771: FROM per_cont_workers_current_x emp
772: WHERE emp.person_id = p_employee_id

Line 890: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(

886:
887: BEGIN
888:
889:
890: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(
891: p_employee_id,
892: l_manager_id,
893: l_manager_name,
894: l_manager_status);

Line 937: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_DB_HR_INT_PKG.GetEmpNameNumber',

933: END IF;
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_DB_HR_INT_PKG.GetEmpNameNumber',
938: l_debug_info);
939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END GetEmpNameNumber;
941:

Line 961: END AP_WEB_DB_HR_INT_PKG;

957: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUserIdFromName' );
958: APP_EXCEPTION.RAISE_EXCEPTION;
959: END GetUserIdFromName;
960:
961: END AP_WEB_DB_HR_INT_PKG;