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_ALL_ORGANIZATIONS

Line 22: -- 2.Whenever the new record is inserted into Pa_All_Organizations with Pa_Org_Use_type

18: -- 1.Whenever the default operating Unit which is
19: -- stored in Hr_Organization_Information.Org_information1 changes / modified ,the
20: -- trigger kicks off the workflow and calls this api to Update the Pa_Resource_OU
21: -- entity.
22: -- 2.Whenever the new record is inserted into Pa_All_Organizations with Pa_Org_Use_type
23: -- is of type 'Expenditure' or the exisitng record in Pa_all_Organiations
24: -- is updated with inactive_date then trigger fires and kicks of the workflow,calls this
25: -- api to Update the Pa_Resource_OU.
26: PROCEDURE Default_OU_Change

Line 54: PROCEDURE pull_resources( p_organization_id IN pa_all_organizations.organization_id%type

50:
51: --This API pulls all resources into PA from HR for a given organization
52: --Created by virangan 11-JUN-2001
53:
54: PROCEDURE pull_resources( p_organization_id IN pa_all_organizations.organization_id%type
55: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57: ,x_msg_count OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
58:

Line 68: ,P_Default_OU IN pa_all_organizations.org_id%type

64:
65: PROCEDURE make_resource_inactive
66: (P_calling_mode IN VARCHAR2
67: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
68: ,P_Default_OU IN pa_all_organizations.org_id%type
69: ,P_inactive_date IN pa_all_organizations.inactive_date%type
70: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL --Added for bug 5330402
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 69: ,P_inactive_date IN pa_all_organizations.inactive_date%type

65: PROCEDURE make_resource_inactive
66: (P_calling_mode IN VARCHAR2
67: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
68: ,P_Default_OU IN pa_all_organizations.org_id%type
69: ,P_inactive_date IN pa_all_organizations.inactive_date%type
70: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL --Added for bug 5330402
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 70: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL --Added for bug 5330402

66: (P_calling_mode IN VARCHAR2
67: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
68: ,P_Default_OU IN pa_all_organizations.org_id%type
69: ,P_inactive_date IN pa_all_organizations.inactive_date%type
70: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL --Added for bug 5330402
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
74: );

Line 219: -- end date active to sysdate when pa_all_organizations.inactive_date

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
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

Line 221: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type

217:
218: -- This Procedure updates the pa_resource_OU and set the resources
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

Line 222: ,P_default_OU_new IN Pa_all_organizations.org_id%type

218: -- This Procedure updates the pa_resource_OU and set the resources
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