APPS.AP_WEB_UTILITIES_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 73: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;

69: function isCreditCardEnabled(p_employeeId in AP_WEB_DB_CCARD_PKG.cards_employeeID) return boolean
70: IS
71: l_has VARCHAR2(1);
72: l_cCardEnabled VARCHAR2(1);
73: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
74: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
75:
76: BEGIN
77: -- get Credit Card enable option

Line 74: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

70: IS
71: l_has VARCHAR2(1);
72: l_cCardEnabled VARCHAR2(1);
73: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
74: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
75:
76: BEGIN
77: -- get Credit Card enable option
78: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

Line 78: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

74: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
75:
76: BEGIN
77: -- get Credit Card enable option
78: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(
79: p_employeeId,
80: l_userIdCursor) = TRUE ) THEN
81: LOOP
82: FETCH l_userIdCursor INTO l_FNDUserID;

Line 247: l_EmpInfoRec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

243: p_employee_num IN OUT NOCOPY VARCHAR2,
244: p_cost_center IN OUT NOCOPY VARCHAR2,
245: p_employee_id IN NUMBER) IS
246: -------------------------------------------------------------------
247: l_EmpInfoRec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
248: BEGIN
249:
250: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,
251: l_EmpInfoRec)) THEN

Line 250: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,

246: -------------------------------------------------------------------
247: l_EmpInfoRec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
248: BEGIN
249:
250: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,
251: l_EmpInfoRec)) THEN
252: p_employee_name := l_EmpInfoRec.employee_name;
253: p_employee_num := l_EmpInfoRec.employee_num;
254: END IF;

Line 3003: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'

2999: WHERE EMPLOYEE_ID = p_EmpId AND BOTHPAY_PARENT_ID IS NULL
3000: ORDER BY report_header_id DESC
3001: ) WHERE ROWNUM=1;
3002:
3003: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'
3004: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN
3005:
3006: --if approver is an active user of the system, return the approver's name
3007:

Line 3004: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN

3000: ORDER BY report_header_id DESC
3001: ) WHERE ROWNUM=1;
3002:
3003: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'
3004: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN
3005:
3006: --if approver is an active user of the system, return the approver's name
3007:
3008: GetEmployeeInfo(

Line 3027: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'

3023: ELSIF l_DefaultSource = 'PREFERENCES' AND p_ApproverId IS NOT NULL THEN
3024:
3025: --If preferences's default source is Preferences and Approver's name is provided by user
3026:
3027: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'
3028: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN
3029:
3030: --if approver is an active user of the system
3031:

Line 3028: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN

3024:
3025: --If preferences's default source is Preferences and Approver's name is provided by user
3026:
3027: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'
3028: AND AP_WEB_DB_HR_INT_PKG.HasValidFndUserAndWfAccount(p_ApproverId)= 'Y' THEN
3029:
3030: --if approver is an active user of the system
3031:
3032: GetEmployeeInfo(

Line 3042: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,

3038: IF p_appreq='D' THEN
3039:
3040: --if approver is not an active user of the system, default approver from the HRMS
3041:
3042: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,
3043: p_ApproverId,
3044: p_OverrideApproverName,
3045: l_ManagerOrgId);
3046: ELSE

Line 3061: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,

3057: --In case employee hasn't provided approver's name in preferences
3058:
3059: IF p_appreq='D' THEN
3060:
3061: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,
3062: p_ApproverId,
3063: p_OverrideApproverName,
3064: l_ManagerOrgId);
3065: ELSE

Line 3084: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,

3080: --If there is no data in the AP_WEB_PREFERENCES
3081: --then default approver from the HRMS
3082: IF l_DefaultSource IS NULL THEN
3083: IF p_appreq='D' THEN
3084: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,
3085: p_ApproverId,
3086: p_OverrideApproverName,
3087: l_ManagerOrgId);
3088: ELSE