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.

[Home] [Help]

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 277: FROM per_job_extra_info

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

Line 2488: If (P_table_name = 'PER_JOB_EXTRA_INFO' or

2484: -- Initialize the Error stack
2485: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.call_forcast_api');
2486: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2487:
2488: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2489: P_table_name = 'PER_VALID_GRADES' or
2490: P_table_name = 'PER_GRADES' or
2491: P_table_name = 'PA_ALL_ORGANIZATIONS') and
2492: (P_job_id is NOT NULL) then

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

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

Line 2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type

2713: -- in a loop to update the forecast items
2714: PROCEDURE per_job_extra_billability
2715: (p_calling_mode IN VARCHAR2
2716: ,P_job_id IN per_jobs.job_id%type
2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type

Line 2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type

2714: PROCEDURE per_job_extra_billability
2715: (p_calling_mode IN VARCHAR2
2716: ,P_job_id IN per_jobs.job_id%type
2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type

Line 2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type

2715: (p_calling_mode IN VARCHAR2
2716: ,P_job_id IN per_jobs.job_id%type
2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type

Line 2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

2716: ,P_job_id IN per_jobs.job_id%type
2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

Line 2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type

2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2725: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type

2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2725: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2726: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type

2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2725: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2726: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2727: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895

Line 2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
2721: ,P_job_level_new IN per_job_extra_info.jei_information4%type
2722: ,P_job_level_old IN per_job_extra_info.jei_information4%type
2723: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
2724: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
2725: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2726: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2727: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
2728: PRAGMA AUTONOMOUS_TRANSACTION;

Line 2982: (P_table_name => 'PER_JOB_EXTRA_INFO'

2978:
2979: -- call forecast api to regenerate the forcast items due to change in
2980: -- billability flag
2981: call_forcast_api
2982: (P_table_name => 'PER_JOB_EXTRA_INFO'
2983: ,P_Job_id => P_job_id
2984: ,x_return_status => x_return_status
2985: ,x_msg_data => x_msg_data
2986: ,x_msg_count => x_msg_count );