DBA Data[Home] [Help]

APPS.AP_WEB_PROJECT_PKG dependencies on FND_USER

Line 5: P_EmployeeID IN FND_USER.employee_id%TYPE,

1: PACKAGE BODY AP_WEB_PROJECT_PKG AS
2: /* $Header: apwprojb.pls 120.10.12000000.2 2007/09/28 13:57:28 rveliche ship $ */
3:
4: PROCEDURE IsSessionProjectEnabled(
5: P_EmployeeID IN FND_USER.employee_id%TYPE,
6: P_FNDUserID IN FND_USER.user_id%TYPE,
7: P_Result OUT NOCOPY VARCHAR2)
8:
9: -- Determines whether the session is project enabled. Checks (1) PA is

Line 6: P_FNDUserID IN FND_USER.user_id%TYPE,

2: /* $Header: apwprojb.pls 120.10.12000000.2 2007/09/28 13:57:28 rveliche ship $ */
3:
4: PROCEDURE IsSessionProjectEnabled(
5: P_EmployeeID IN FND_USER.employee_id%TYPE,
6: P_FNDUserID IN FND_USER.user_id%TYPE,
7: P_Result OUT NOCOPY VARCHAR2)
8:
9: -- Determines whether the session is project enabled. Checks (1) PA is
10: -- installed, (2) project accounting profile option is enabled, and

Line 40: -- Be sure that both employee ID and FND User ID is not null. Otherwise

36: return;
37: end if;
38: end if;
39:
40: -- Be sure that both employee ID and FND User ID is not null. Otherwise
41: -- return not projects enabled
42: IF (P_FNDUserID IS NULL) OR (P_EmployeeID IS NULL) THEN
43: RETURN;
44: END IF;

Line 55: -- FND users.

51: END IF;
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;

Line 88: -- Project enabled profile option is the same for all fnd users

84: else
85:
86: -- Third party being used.
87: -- For each FNDUSER corresponding to the employee, verify that the
88: -- Project enabled profile option is the same for all fnd users
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:

Line 89: -- If value is the same for all FND user then return the value, otherwise

85:
86: -- Third party being used.
87: -- For each FNDUSER corresponding to the employee, verify that the
88: -- Project enabled profile option is the same for all fnd users
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(