DBA Data[Home] [Help]

APPS.PA_JOB_UTILS dependencies on PER_JOB_GROUPS

Line 70: ,P_job_group_id IN per_job_groups.job_group_id%type)

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
74: -- by looking at the 'Project Job Level' DFF segmeent of the

Line 90: RETURN per_job_groups.job_group_id%type;

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
94: -- in the system. Returns 'Y' if it does and returns 'N' if it does not

Line 113: P_job_group_id IN per_job_groups.job_group_id%type)

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:
117: -- This function returns the job in the Project Resource Job