APPS.PA_JOB_UTILS dependencies on PER_JOBS

Line 60: ( p_job_id IN per_jobs.job_id%type

56: -- the pa_job_relationships entity.the IN parameters will be job_id and
57: -- job_group_id
58: --
59: PROCEDURE validate_job_relationship
60: ( p_job_id IN per_jobs.job_id%type
61: ,p_job_group_id IN per_jobs.job_group_id%type
62: ,x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
63: ,x_error_message_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
64: );

Line 61: ,p_job_group_id IN per_jobs.job_group_id%type

57: -- job_group_id
58: --
59: PROCEDURE validate_job_relationship
60: ( p_job_id IN per_jobs.job_id%type
61: ,p_job_group_id IN per_jobs.job_group_id%type
62: ,x_return_status OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
63: ,x_error_message_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
64: );
65:

Line 69: FUNCTION get_job_level(P_job_id IN per_jobs.job_id%type

65:
66:
67: -- This Function returns the job level(sequence) based on the job_id
68: -- and Job_group_id
69: FUNCTION get_job_level(P_job_id IN per_jobs.job_id%type
70: ,P_job_group_id IN per_job_groups.job_group_id%type)
71: RETURN NUMBER;
72:
73: -- This function returns the Job Level of the job passed in

Line 84: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)

80:
81:
82: -- This Function returns boolean value of true if a job is master job otherwise
83: -- it returns false -- IN parameter will be job_id
84: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)
85: RETURN boolean;
86:
87:
88: -- This API returns the job group id for the corresponding Job

Line 89: FUNCTION get_job_group_id(P_job_id IN per_jobs.job_id%type)

85: RETURN boolean;
86:
87:
88: -- This API returns the job group id for the corresponding Job
89: FUNCTION get_job_group_id(P_job_id IN per_jobs.job_id%type)
90: RETURN per_job_groups.job_group_id%type;
91:
92:
93: -- This function checks if a Project Resource Job Group Exists

Line 112: FUNCTION get_job_name (P_job_id IN per_jobs.job_id%type,

108: Function Get_Proj_Res_Job_Group(p_job_id IN NUMBER)
109: RETURN NUMBER;
110:
111:
112: FUNCTION get_job_name (P_job_id IN per_jobs.job_id%type,
113: P_job_group_id IN per_job_groups.job_group_id%type)
114: RETURN VARCHAR2;
115:
116: