eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCES

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

278: x_ManagerName OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
279: x_error_message_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
280: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
281:
282: FUNCTION Get_People_Assigned(p_org_id in pa_resources_denorm.resource_organization_id%TYPE,
283: p_date in DATE,
284: p_emp_type IN VARCHAR DEFAULT 'EMP') RETURN number; --Added p_emp_type for bug 5680366
285:
286: -- PROCEDURE

Line 430: -- records in pa_resources_denorm

426: -- FUNCTION
427: -- Is_Future_Resource
428: -- PURPOSE
429: -- This procedure checks if a person has only future
430: -- records in pa_resources_denorm
431: --
432: -- HISTORY
433: -- 31-AUG-2001 created virangan
434: --

Line 442: -- records in pa_resources_denorm

438: -- FUNCTION
439: -- Is_Past_Resource
440: -- PURPOSE
441: -- This procedure checks if a person has only past
442: -- records in pa_resources_denorm
443: --
444: -- HISTORY
445: -- 01-JAN-2009 created asahoo
446: --

Line 454: -- records in pa_resources_denorm

450: -- FUNCTION
451: -- Is_Future_Rehire -- added for bug 8988264
452: -- PURPOSE
453: -- This procedure checks if a person has only future
454: -- records in pa_resources_denorm
455: --
456: -- HISTORY
457: -- 28-DEC-2009 created skkoppul
458: --

Line 466: -- in pa_resources_denorm

462: -- FUNCTION
463: -- Get_Resource_Start_Date_Rehire -- added for 8988264
464: -- PURPOSE
465: -- This procedure returns the start date of the resource
466: -- in pa_resources_denorm
467: --
468: -- HISTORY
469: -- 28-DEC-2009 created skkoppul
470: --

Line 479: -- in pa_resources_denorm

475: -- FUNCTION
476: -- Get_Resource_End_date
477: -- PURPOSE
478: -- This procedure returns the end date of the resource
479: -- in pa_resources_denorm
480: --
481: -- HISTORY
482: -- 12-Dec-2009 created NISINHA
483: --

Line 493: -- in pa_resources_denorm

489: -- FUNCTION
490: -- Get_Resource_Start_date
491: -- PURPOSE
492: -- This procedure returns the start date of the resource
493: -- in pa_resources_denorm
494: --
495: -- HISTORY
496: -- 31-AUG-2001 created virangan
497: --

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

513: -- FUNCTION
514: -- Get_Resource_Effective_date
515: -- PURPOSE
516: -- This procedure returns the effective date of the resource
517: -- in pa_resources_denorm. This is the resource_effective_start_date
518: -- for a future resource or sysdate for active resources
519: --
520: -- HISTORY
521: -- 17-SEP-2001 created virangan

Line 647: -- start date in the pa_resources_denorm table

643: -- PROCEDURE
644: -- validate_person
645: -- PURPOSE
646: -- This procedure checks if the resource is valid as of the
647: -- start date in the pa_resources_denorm table
648: --
649: PROCEDURE validate_person ( p_person_id IN NUMBER,
650: p_start_date IN DATE,
651: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 730: -- resource_id passed in using pa_resources table

726: -- PROCEDURE
727: -- get_resource_name
728: -- PURPOSE
729: -- This function returns the resource_name of the
730: -- resource_id passed in using pa_resources table
731: FUNCTION get_resource_name(p_resource_id IN NUMBER)
732: RETURN VARCHAR2;
733:
734: -- FUNCTION

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

835: -- PROCEDURE
836: -- set_fte_flag
837: -- PURPOSE
838: -- This procedure sets the new future_term_wf_flag
839: -- in table pa_resources for the passed person_id
840: -- HISTORY
841: -- 05-MAR-207 kjai Created for Bug 5683340
842: --
843: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

Line 844: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,

840: -- HISTORY
841: -- 05-MAR-207 kjai Created for Bug 5683340
842: --
843: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
844: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_msg_data OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER);
848: --

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

849: -- PROCEDURE
850: -- get_fte_flag
851: -- PURPOSE
852: -- This procedure gets the new future_term_wf_flag
853: -- in table pa_resources for the passed person_id
854: -- HISTORY
855: -- 05-MAR-207 kjai Created for Bug 5683340
856: --
857: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

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

854: -- HISTORY
855: -- 05-MAR-207 kjai Created for Bug 5683340
856: --
857: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
858: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_data OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER);
862: