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 PA_RESOURCES_DENORM

Line 223: ,P_resource_id IN Pa_Resources_denorm.resource_id%type

219: -- end date active to sysdate when pa_all_organizations.inactive_date
220: -- is updated.
221: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type
222: ,P_default_OU_new IN Pa_all_organizations.org_id%type
223: ,P_resource_id IN Pa_Resources_denorm.resource_id%type
224: default NULL
225: ,P_person_id IN Pa_Resources_denorm.person_id%type
226: default NULL
227: ,P_start_date IN Date default NULL

Line 225: ,P_person_id IN Pa_Resources_denorm.person_id%type

221: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type
222: ,P_default_OU_new IN Pa_all_organizations.org_id%type
223: ,P_resource_id IN Pa_Resources_denorm.resource_id%type
224: default NULL
225: ,P_person_id IN Pa_Resources_denorm.person_id%type
226: default NULL
227: ,P_start_date IN Date default NULL
228: ,P_end_date_old IN Date default NULL
229: ,P_end_date_new IN Date default NULL

Line 324: -- Procedure to delete the records in pa_resources_denorm when the corresponding records

320: x_msg_data out NOCOPY varchar2); --File.Sql.39 bug 4440895
321:
322: FUNCTION Get_Country_name(p_country_code VARCHAR2) RETURN VARCHAR2 ;
323:
324: -- Procedure to delete the records in pa_resources_denorm when the corresponding records
325: -- in per_all_assignments_f are deleted.
326: PROCEDURE Delete_PA_Resource_Denorm(
327: p_person_id IN per_all_people_f.person_id%TYPE,
328: p_old_start_date IN per_all_assignments_f.effective_start_date%TYPE,