DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_API dependencies on PER_JOBS

Line 85: ,P_job_id IN per_jobs.job_id%type

81: -- denorm apis to to update the new billability for the resource
82:
83: PROCEDURE per_job_extra_billability
84: (p_calling_mode IN VARCHAR2
85: ,P_job_id IN per_jobs.job_id%type
86: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
87: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
88: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
89: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

Line 182: P_job_id IN per_jobs.job_id%type

178:
179:
180: -- This API returns the job group id for the corresponding Job
181: FUNCTION get_job_group_id(
182: P_job_id IN per_jobs.job_id%type
183: ) RETURN per_job_groups.job_group_id%type;
184:
185: -- pragma RESTRICT_REFERENCES (get_job_group_id, WNDS, WNPS );
186:

Line 188: P_job_id IN per_jobs.job_id%type

184:
185: -- pragma RESTRICT_REFERENCES (get_job_group_id, WNDS, WNPS );
186:
187: FUNCTION get_job_name(
188: P_job_id IN per_jobs.job_id%type
189: ) RETURN per_jobs.name%type;
190:
191: -- pragma RESTRICT_REFERENCES (get_job_name, WNDS, WNPS );
192:

Line 189: ) RETURN per_jobs.name%type;

185: -- pragma RESTRICT_REFERENCES (get_job_group_id, WNDS, WNPS );
186:
187: FUNCTION get_job_name(
188: P_job_id IN per_jobs.job_id%type
189: ) RETURN per_jobs.name%type;
190:
191: -- pragma RESTRICT_REFERENCES (get_job_name, WNDS, WNPS );
192:
193: FUNCTION get_org_name(

Line 208: P_job_id IN per_jobs.job_id%type

204:
205:
206: -- This Function returns the job level(sequence) based on the job_id and Job_group_id
207: FUNCTION get_job_level(
208: P_job_id IN per_jobs.job_id%type
209: ,P_job_group_id IN per_job_groups.job_group_id%type
210: ) RETURN NUMBER;
211:
212: -- This Function returns boolean value of true if a job is master job otherwise

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

210: ) RETURN NUMBER;
211:
212: -- This Function returns boolean value of true if a job is master job otherwise
213: -- it returns false -- IN parameter will be job_id
214: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)
215: RETURN boolean;
216: -- pragma RESTRICT_REFERENCES (check_master_job, WNDS, WNPS );
217:
218: -- This Procedure updates the pa_resource_OU and set the resources