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.3 2008/11/10 10:19:39 rveliche 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 519: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

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

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

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

Line 889: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(

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

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

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

Line 960: END AP_WEB_DB_HR_INT_PKG;

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