APPS.AP_WEB_PROJECT_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 24: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;

20: l_PAEnable VARCHAR2(30);
21: l_PAEnableProfile VARCHAR2(30) := NULL;
22: l_PAEnablePreviousVal VARCHAR2(30);
23: l_Mesg VARCHAR2(100);
24: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
25: l_FNDUsersEmployeeID AP_WEB_DB_HR_INT_PKG.fndUser_employeeID;
26: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
27:
28: BEGIN

Line 25: l_FNDUsersEmployeeID AP_WEB_DB_HR_INT_PKG.fndUser_employeeID;

21: l_PAEnableProfile VARCHAR2(30) := NULL;
22: l_PAEnablePreviousVal VARCHAR2(30);
23: l_Mesg VARCHAR2(100);
24: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
25: l_FNDUsersEmployeeID AP_WEB_DB_HR_INT_PKG.fndUser_employeeID;
26: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
27:
28: BEGIN
29:

Line 26: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

22: l_PAEnablePreviousVal VARCHAR2(30);
23: l_Mesg VARCHAR2(100);
24: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
25: l_FNDUsersEmployeeID AP_WEB_DB_HR_INT_PKG.fndUser_employeeID;
26: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
27:
28: BEGIN
29:
30: -- Assume that the session is not project enabled

Line 48: IF (AP_WEB_DB_HR_INT_PKG.IsPersonCwk(P_EmployeeID) = 'Y' AND

44: END IF;
45:
46: -- For Contingent workers, call PA API to determine whether
47: -- PA.FP.M is installed.
48: IF (AP_WEB_DB_HR_INT_PKG.IsPersonCwk(P_EmployeeID) = 'Y' AND
49: PA_PO_INTEGRATION.is_pjc_po_cwk_intg_enab <> 'Y') THEN
50: RETURN;
51: END IF;
52:

Line 56: IF ( NOT AP_WEB_DB_HR_INT_PKG.GetEmpIdForUser(

52:
53: -- Check whether third party is being used since different logic is used
54: -- to handle the case where an employee may correspond to multiple
55: -- FND users.
56: IF ( NOT AP_WEB_DB_HR_INT_PKG.GetEmpIdForUser(
57: P_FNDUserID,
58: l_FNDUsersEmployeeID) ) THEN
59: l_FNDUsersEmployeeID := NULL;
60: END IF;

Line 93: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

89: -- If value is the same for all FND user then return the value, otherwise
90: -- return not projects enabled.
91: l_PAEnablePreviousVal := NULL;
92:
93: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(
94: p_EmployeeID,
95: l_userIdCursor) = TRUE ) THEN
96: LOOP
97: EXIT WHEN l_userIdCursor%NOTFOUND OR