APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on FND_USER

Line 200: | P_SupervisorId Fnd User Id of the supervisor

196: | This is necessary because HR's security profile is based on access as of
197: | today and we need to have it as of the date range being queried for.
198: |
199: | Parameters:
200: | P_SupervisorId Fnd User Id of the supervisor
201: | P_PersionId Employee Id of the user who's data is being queried
202: | P_PeriodType The period type for the query (month/quarter ...)
203: | P_Date The date which falls in the period type being queried
204: |

Line 224: -- In this call P_SupervisorId is the fnd user id

220: L_EndDate DATE;
221: L_SupervisorEmpId NUMBER(15);
222: BEGIN
223:
224: -- In this call P_SupervisorId is the fnd user id
225: -- So we must get the emp id for this user
226:
227: SELECT employee_id
228: INTO L_SupervisorEmpId

Line 229: FROM fnd_user

225: -- So we must get the emp id for this user
226:
227: SELECT employee_id
228: INTO L_SupervisorEmpId
229: FROM fnd_user
230: WHERE user_id = P_SupervisorId;
231:
232: -- Get the date range for the period
233: GetPeriodDateRange ( P_PeriodType ,

Line 255: | has acces to view the data based on the fnd user and date range specified.

251: /*=========================================================================================
252: | Function
253: |
254: | Description: This function is a wrapper on the recursive function to find out if the user
255: | has acces to view the data based on the fnd user and date range specified.
256: | NOTE:
257: | This is necessary because HR's security profile is based on access as of
258: | today and we need to have it as of the date range being queried for.
259: |

Line 262: | P_SupervisorId Fnd User Id of the supervisor

258: | today and we need to have it as of the date range being queried for.
259: |
260: |
261: | Parameters:
262: | P_SupervisorId Fnd User Id of the supervisor
263: | P_PersionId Employee Id of the user who's data is being queried
264: | P_StartDate Start date of the date range in the query
265: | P_EndDate End date of the date range in the query
266: |

Line 285: -- In this call P_SupervisorId is the fnd user id

281: L_SupervisorEmpId NUMBER(15);
282:
283: BEGIN
284:
285: -- In this call P_SupervisorId is the fnd user id
286: -- So we must get the emp id for this user
287:
288: SELECT employee_id
289: INTO L_SupervisorEmpId

Line 290: FROM fnd_user

286: -- So we must get the emp id for this user
287:
288: SELECT employee_id
289: INTO L_SupervisorEmpId
290: FROM fnd_user
291: WHERE user_id = P_SupervisorId;
292:
293: -- Call the recursive func. now
294: RETURN IsSupervisor( L_SupervisorEmpId, P_PersonId, P_StartDate, P_EndDate);