APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCES

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

Line 660: -- resource_id passed in using pa_resources table

656: -- PROCEDURE
657: -- get_resource_name
658: -- PURPOSE
659: -- This function returns the resource_name of the
660: -- resource_id passed in using pa_resources table
661: FUNCTION get_resource_name(p_resource_id IN NUMBER)
662: RETURN VARCHAR2;
663:
664: -- FUNCTION

Line 769: -- in table pa_resources for the passed person_id

765: -- PROCEDURE
766: -- set_fte_flag
767: -- PURPOSE
768: -- This procedure sets the new future_term_wf_flag
769: -- in table pa_resources for the passed person_id
770: -- HISTORY
771: -- 05-MAR-207 kjai Created for Bug 5683340
772: --
773: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

Line 774: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,

770: -- HISTORY
771: -- 05-MAR-207 kjai Created for Bug 5683340
772: --
773: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
774: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
775: x_return_status OUT NOCOPY VARCHAR2,
776: x_msg_data OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER);
778: --

Line 783: -- in table pa_resources for the passed person_id

779: -- PROCEDURE
780: -- get_fte_flag
781: -- PURPOSE
782: -- This procedure gets the new future_term_wf_flag
783: -- in table pa_resources for the passed person_id
784: -- HISTORY
785: -- 05-MAR-207 kjai Created for Bug 5683340
786: --
787: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

Line 788: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,

784: -- HISTORY
785: -- 05-MAR-207 kjai Created for Bug 5683340
786: --
787: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
788: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_data OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER);
792: