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_HR_UPDATE_API dependencies on PER_JOB_EXTRA_INFO

Line 155: FROM per_job_extra_info

151:
152: If v_job_id is NOT NULL then
153: SELECT jei_information3
154: INTO utilization_flag
155: FROM per_job_extra_info
156: WHERE job_id = v_job_id
157: AND information_type = v_job_info_type
158: AND jei_information3 IS NOT NULL; -- Bug 2898766
159: End if;

Line 217: FROM per_job_extra_info

213:
214: If v_job_id is NOT NULL then
215: SELECT jei_information2
216: INTO Billable_flag
217: FROM per_job_extra_info
218: WHERE job_id = v_job_id
219: AND information_type = v_job_info_type
220: AND jei_information2 IS NOT NULL; -- Bug 2898766
221: End if;

Line 274: FROM per_job_extra_info

270:
271: IF l_job_id is NOT NULL THEN
272: SELECT jei_information6
273: INTO l_schedulable_flag
274: FROM per_job_extra_info
275: WHERE job_id = l_job_id
276: AND information_type = l_job_info_type
277: AND jei_information6 IS NOT NULL;
278:

Line 2481: If (P_table_name = 'PER_JOB_EXTRA_INFO' or

2477: -- Initialize the Error stack
2478: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
2479: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2480:
2481: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2482: P_table_name = 'PER_VALID_GRADES' or
2483: P_table_name = 'PER_GRADES' or
2484: P_table_name = 'PA_ALL_ORGANIZATIONS') and
2485: (P_job_id is NOT NULL) then

Line 2700: -- or inserted into per_job_extra_info entity which stores the job information

2696: END call_billable_resoruce_denorm;
2697:
2698: -- This Procedure is kicked off by the workflow when jei_infomration2
2699: -- which stores the jobs billability information. whenever the row is updated
2700: -- or inserted into per_job_extra_info entity which stores the job information
2701: -- and types a database triggers fires and kicks of the workflow
2702: -- This procedure makes calls to forecast regenerate apis and create resource
2703: -- denorm apis to to update the new billability for the resource
2704: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because at the end

Line 2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type

2706: -- in a loop to update the forecast items
2707: PROCEDURE per_job_extra_billability
2708: (p_calling_mode IN VARCHAR2
2709: ,P_job_id IN per_jobs.job_id%type
2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type

Line 2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type

2707: PROCEDURE per_job_extra_billability
2708: (p_calling_mode IN VARCHAR2
2709: ,P_job_id IN per_jobs.job_id%type
2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type

Line 2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type

2708: (p_calling_mode IN VARCHAR2
2709: ,P_job_id IN per_jobs.job_id%type
2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type

Line 2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

2709: ,P_job_id IN per_jobs.job_id%type
2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

Line 2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type

2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2718: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type

2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2718: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2719: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type

2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2718: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2719: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2720: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2714: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2715: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2716: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2717: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2718: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2719: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2720: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2721: PRAGMA AUTONOMOUS_TRANSACTION;

Line 2975: (P_table_name => 'PER_JOB_EXTRA_INFO'

2971:
2972: -- call forecast api to regenerate the forcast items due to change in
2973: -- billability flag
2974: call_forcast_api
2975: (P_table_name => 'PER_JOB_EXTRA_INFO'
2976: ,P_Job_id => P_job_id
2977: ,x_return_status => x_return_status
2978: ,x_msg_data => x_msg_data
2979: ,x_msg_count => x_msg_count );