APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on FND_USER

Line 189: | P_SupervisorId Fnd User Id of the supervisor

185: | This is necessary because HR's security profile is based on access as of
186: | today and we need to have it as of the date range being queried for.
187: |
188: | Parameters:
189: | P_SupervisorId Fnd User Id of the supervisor
190: | P_PersionId Employee Id of the user who's data is being queried
191: | P_PeriodType The period type for the query (month/quarter ...)
192: | P_Date The date which falls in the period type being queried
193: |

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

209: L_EndDate DATE;
210: L_SupervisorEmpId NUMBER(15);
211: BEGIN
212:
213: -- In this call P_SupervisorId is the fnd user id
214: -- So we must get the emp id for this user
215:
216: SELECT employee_id
217: INTO L_SupervisorEmpId

Line 218: FROM fnd_user

214: -- So we must get the emp id for this user
215:
216: SELECT employee_id
217: INTO L_SupervisorEmpId
218: FROM fnd_user
219: WHERE user_id = P_SupervisorId;
220:
221: -- Get the date range for the period
222: GetPeriodDateRange ( P_PeriodType ,

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

240: /*=========================================================================================
241: | Function
242: |
243: | Description: This function is a wrapper on the recursive function to find out if the user
244: | has acces to view the data based on the fnd user and date range specified.
245: | NOTE:
246: | This is necessary because HR's security profile is based on access as of
247: | today and we need to have it as of the date range being queried for.
248: |

Line 251: | P_SupervisorId Fnd User Id of the supervisor

247: | today and we need to have it as of the date range being queried for.
248: |
249: |
250: | Parameters:
251: | P_SupervisorId Fnd User Id of the supervisor
252: | P_PersionId Employee Id of the user who's data is being queried
253: | P_StartDate Start date of the date range in the query
254: | P_EndDate End date of the date range in the query
255: |

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

270: L_SupervisorEmpId NUMBER(15);
271:
272: BEGIN
273:
274: -- In this call P_SupervisorId is the fnd user id
275: -- So we must get the emp id for this user
276:
277: SELECT employee_id
278: INTO L_SupervisorEmpId

Line 279: FROM fnd_user

275: -- So we must get the emp id for this user
276:
277: SELECT employee_id
278: INTO L_SupervisorEmpId
279: FROM fnd_user
280: WHERE user_id = P_SupervisorId;
281:
282: -- Call the recursive func. now
283: RETURN IsSupervisor( L_SupervisorEmpId, P_PersonId, P_StartDate, P_EndDate);