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 3001: IF AP_WEB_DB_HR_INT_PKG.IsPersonActive(p_ApproverId) = 'Y'

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

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

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

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

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

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

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

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

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

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

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

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

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