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 78: -- or inserted into per_job_extra_info entity which stores the job information

74: );
75:
76: -- This Procedure is kicked off by the workflow when jei_infomration2
77: -- which stores the jobs billability information. whenever the row is updated
78: -- or inserted into per_job_extra_info entity which stores the job information
79: -- and types a database triggers fires and kicks of the workflow
80: -- This procedure makes calls to forecast regenerate apis and create resource
81: -- denorm apis to to update the new billability for the resource
82:

Line 86: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type

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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type

Line 87: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type

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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type

Line 88: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type

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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type

Line 89: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

Line 90: ,P_job_level_new IN per_job_extra_info.jei_information4%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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 91: ,P_job_level_old IN per_job_extra_info.jei_information4%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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%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
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type

89: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type
90: ,P_job_level_new IN per_job_extra_info.jei_information4%type
91: ,P_job_level_old IN per_job_extra_info.jei_information4%type
92: ,p_schedulable_flag_new IN per_job_extra_info.jei_information6%type
93: ,p_schedulable_flag_old IN per_job_extra_info.jei_information6%type
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ,x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
97: