APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCES_DENORM

Line 263: FUNCTION Get_People_Assigned(p_org_id in pa_resources_denorm.resource_organization_id%TYPE,

259: x_ManagerName OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
260: x_error_message_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
261: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
262:
263: FUNCTION Get_People_Assigned(p_org_id in pa_resources_denorm.resource_organization_id%TYPE,
264: p_date in DATE,
265: p_emp_type IN VARCHAR DEFAULT 'EMP') RETURN number; --Added p_emp_type for bug 5680366
266:
267: -- PROCEDURE

Line 411: -- records in pa_resources_denorm

407: -- FUNCTION
408: -- Is_Future_Resource
409: -- PURPOSE
410: -- This procedure checks if a person has only future
411: -- records in pa_resources_denorm
412: --
413: -- HISTORY
414: -- 31-AUG-2001 created virangan
415: --

Line 423: -- in pa_resources_denorm

419: -- FUNCTION
420: -- Get_Resource_Start_date
421: -- PURPOSE
422: -- This procedure returns the start date of the resource
423: -- in pa_resources_denorm
424: --
425: -- HISTORY
426: -- 31-AUG-2001 created virangan
427: --

Line 447: -- in pa_resources_denorm. This is the resource_effective_start_date

443: -- FUNCTION
444: -- Get_Resource_Effective_date
445: -- PURPOSE
446: -- This procedure returns the effective date of the resource
447: -- in pa_resources_denorm. This is the resource_effective_start_date
448: -- for a future resource or sysdate for active resources
449: --
450: -- HISTORY
451: -- 17-SEP-2001 created virangan

Line 577: -- start date in the pa_resources_denorm table

573: -- PROCEDURE
574: -- validate_person
575: -- PURPOSE
576: -- This procedure checks if the resource is valid as of the
577: -- start date in the pa_resources_denorm table
578: --
579: PROCEDURE validate_person ( p_person_id IN NUMBER,
580: p_start_date IN DATE,
581: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895