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 HR_ORGANIZATION_INFORMATION

Line 16: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information

12: return VARCHAR2;
13:
14:
15: -- This Procedure is called from workflow process to update/create resources in projects
16: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information
17: -- and Pa_All_Organization entities.
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

Line 19: -- stored in Hr_Organization_Information.Org_information1 changes / modified ,the

15: -- This Procedure is called from workflow process to update/create resources in projects
16: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information
17: -- and Pa_All_Organization entities.
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

Line 28: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

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
27: ( P_calling_mode IN VARCHAR2
28: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
29: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
30: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 29: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type

25: -- api to Update the Pa_Resource_OU.
26: PROCEDURE Default_OU_Change
27: ( P_calling_mode IN VARCHAR2
28: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
29: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
30: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 30: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type

26: PROCEDURE Default_OU_Change
27: ( P_calling_mode IN VARCHAR2
28: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
29: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
30: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34: );

Line 38: -- The workflow would be kicked of by the database trigger on table Hr_Organization_Information

34: );
35:
36:
37: -- This Procedure is called from workflow process to update/create resources in projects
38: -- The workflow would be kicked of by the database trigger on table Hr_Organization_Information
39: -- It will update the job levels information if the Project Resource Job Group is changed
40: -- Created by adabdull 2-JAN-2002
41: PROCEDURE Proj_Res_Job_Group_Change
42: ( p_calling_mode IN VARCHAR2

Line 43: ,p_organization_id IN Hr_Organization_Information.Organization_id%type

39: -- It will update the job levels information if the Project Resource Job Group is changed
40: -- Created by adabdull 2-JAN-2002
41: PROCEDURE Proj_Res_Job_Group_Change
42: ( p_calling_mode IN VARCHAR2
43: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
44: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
45: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
46: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 44: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type

40: -- Created by adabdull 2-JAN-2002
41: PROCEDURE Proj_Res_Job_Group_Change
42: ( p_calling_mode IN VARCHAR2
43: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
44: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
45: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
46: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 45: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type

41: PROCEDURE Proj_Res_Job_Group_Change
42: ( p_calling_mode IN VARCHAR2
43: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
44: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
45: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
46: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49: );

Line 67: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

63: -- workflow.
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

Line 254: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type,

250: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
251: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
252: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
253:
254: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type,
255: P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type) RETURN VARCHAR2; -- Bug 4656855
256: pragma RESTRICT_REFERENCES (check_pjr_default_ou, WNDS, WNPS);
257:
258: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN VARCHAR2;

Line 255: P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type) RETURN VARCHAR2; -- Bug 4656855

251: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
252: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
253:
254: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type,
255: P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type) RETURN VARCHAR2; -- Bug 4656855
256: pragma RESTRICT_REFERENCES (check_pjr_default_ou, WNDS, WNPS);
257:
258: FUNCTION Belongs_ExpOrg(p_org_id IN per_all_assignments_f.organization_id%TYPE) RETURN VARCHAR2;
259: pragma RESTRICT_REFERENCES (Belongs_ExpOrg, WNDS, WNPS);