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 1553: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information

1549: END Update_OU_resource;
1550:
1551:
1552: -- This Procedure is called from workflow process to update/create resources in projects
1553: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information
1554: -- and Pa_All_Organization entities.
1555: -- 1.Whenever the default operating Unit which is
1556: -- stored in Hr_Organization_Information.Org_information1 changes / modified ,the
1557: -- trigger kicks off the workflow and calls this api to Update the Pa_Resource_OU

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

1552: -- This Procedure is called from workflow process to update/create resources in projects
1553: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information
1554: -- and Pa_All_Organization entities.
1555: -- 1.Whenever the default operating Unit which is
1556: -- stored in Hr_Organization_Information.Org_information1 changes / modified ,the
1557: -- trigger kicks off the workflow and calls this api to Update the Pa_Resource_OU
1558: -- entity.
1559: -- 2.Whenever the new record is inserted into Pa_All_Organizations with Pa_Org_Use_type
1560: -- is of type 'Expenditure' or the exisitng record in Pa_all_Organiations

Line 1567: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

1563: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit or rollback
1564: -- after every resource in the loop
1565: PROCEDURE Default_OU_Change
1566: ( P_calling_mode IN VARCHAR2
1567: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1568: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1569: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1571: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1568: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type

1564: -- after every resource in the loop
1565: PROCEDURE Default_OU_Change
1566: ( P_calling_mode IN VARCHAR2
1567: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1568: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1569: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1571: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1572: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1569: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type

1565: PROCEDURE Default_OU_Change
1566: ( P_calling_mode IN VARCHAR2
1567: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1568: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1569: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1571: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1572: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1573: ) IS

Line 1581: v_Default_OU Hr_Organization_Information.Org_Information1%type;

1577: v_error_message_code VARCHAR2(2000);
1578: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1579: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1580: v_Person_id Per_all_assignments_f.person_id%type;
1581: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1582: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1583: -- set to false since the api is being called from trigger
1584: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;
1585: v_internal VARCHAR2(1) := 'Y';

Line 1598: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is

1594: -- get all the resources who belongs to Expenditure type of organizaion and
1595: -- belongs to Expenditure Hierarchy ,Active_Assign, and of Primary assignment type
1596: -- is 'Y' and default OU inactive date is NUll
1597:
1598: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
1599:
1600: SELECT distinct
1601: ind.person_id
1602: ,ind.assignment_start_date

Line 1606: ,hr_organization_information hoi

1602: ,ind.assignment_start_date
1603: ,ind.assignment_end_date
1604: ,to_number(hoi.org_information1) default_OU
1605: FROM pa_r_project_resources_ind_v ind
1606: ,hr_organization_information hoi
1607: WHERE ind.organization_id =
1608: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
1609: AND ind.assignment_end_date >= sysdate
1610: AND hoi.organization_id = l_organization_id

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

1862: END Default_OU_Change;
1863:
1864:
1865: -- This Procedure is called from workflow process to update/create resources in projects
1866: -- The workflow would be kicked of by the database trigger on table Hr_Organization_Information
1867: -- It will update the job levels information if the Project Resource Job Group is changed
1868: -- Created by adabdull 2-JAN-2002
1869: PROCEDURE Proj_Res_Job_Group_Change
1870: ( p_calling_mode IN VARCHAR2

Line 1871: ,p_organization_id IN Hr_Organization_Information.Organization_id%type

1867: -- It will update the job levels information if the Project Resource Job Group is changed
1868: -- Created by adabdull 2-JAN-2002
1869: PROCEDURE Proj_Res_Job_Group_Change
1870: ( p_calling_mode IN VARCHAR2
1871: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1872: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1873: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1874: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1875: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1872: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type

1868: -- Created by adabdull 2-JAN-2002
1869: PROCEDURE Proj_Res_Job_Group_Change
1870: ( p_calling_mode IN VARCHAR2
1871: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1872: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1873: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1874: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1875: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1876: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1873: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type

1869: PROCEDURE Proj_Res_Job_Group_Change
1870: ( p_calling_mode IN VARCHAR2
1871: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1872: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1873: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1874: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1875: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1876: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1877: ) IS

Line 2070: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is

2066: l_msg_count NUMBER;
2067: l_dummy NUMBER;
2068: L_API_VERSION CONSTANT NUMBER := 1.0;
2069:
2070: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
2071:
2072: SELECT distinct ind.person_id
2073: FROM pa_r_project_resources_ind_v ind
2074: ,hr_organization_information hoi

Line 2074: ,hr_organization_information hoi

2070: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
2071:
2072: SELECT distinct ind.person_id
2073: FROM pa_r_project_resources_ind_v ind
2074: ,hr_organization_information hoi
2075: WHERE ind.organization_id =
2076: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
2077: AND ind.assignment_end_date >= sysdate
2078: AND hoi.organization_id = l_organization_id

Line 2162: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

2158: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit after every
2159: -- resource in the loop
2160: PROCEDURE make_resource_inactive
2161: (P_calling_mode IN VARCHAR2
2162: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
2163: ,P_Default_OU IN pa_all_organizations.org_id%type
2164: ,P_inactive_date IN pa_all_organizations.inactive_date%type
2165: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL -- Added for bug 5330402
2166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;

2173: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2174: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2175: v_Person_id Per_all_assignments_f.person_id%type;
2176: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2177: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2178: v_msg_data VARCHAR2(2000);
2179: v_msg_count NUMBER;
2180:
2181: -- get all the resources who are employees and belongs to expenditure

Line 2198: , hr_organization_information hrinf

2194: ,assn.effective_end_date
2195: , res.resource_id
2196: , hrinf.org_information1
2197: FROM per_all_assignments_f assn
2198: , hr_organization_information hrinf
2199: /* , per_person_types pertypes Commented for bug#2781713 */
2200: , per_assignment_status_types pastype
2201: , pa_resource_txn_attributes res
2202: , pa_all_organizations allorgs

Line 2249: , hr_organization_information hrinf

2245: ,assn.effective_end_date
2246: , res.resource_id
2247: -- , hrinf.org_information1
2248: FROM per_all_assignments_f assn
2249: , hr_organization_information hrinf
2250: /* , per_person_types pertypes Commented for bug#2781713 */
2251: , per_assignment_status_types pastype
2252: , pa_resource_txn_attributes res
2253: , pa_all_organizations allorgs

Line 2384: ,P_organization_id IN Hr_organization_information.organization_id%type default NULL

2380: (P_table_name IN VARCHAR2
2381: ,P_person_id IN PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE default NULL
2382: ,P_Job_id IN per_jobs.job_id%type default NULL
2383: ,P_billable_flag IN VARCHAR2 default NULL
2384: ,P_organization_id IN Hr_organization_information.organization_id%type default NULL
2385: ,p_start_date IN date default NULL
2386: ,P_end_date IN date default NULL
2387: ,P_resource_OU IN NUMBER default NULL
2388: ,P_resource_type IN VARCHAR2 default NULL

Line 2407: , hr_organization_information hrinf

2403: assn.person_id
2404: ,assn.effective_start_date
2405: ,assn.effective_end_date
2406: FROM per_all_assignments_f assn
2407: , hr_organization_information hrinf
2408: /* , per_person_types pertypes Commented for Bug#2781713 */
2409: , per_assignment_status_types pastype
2410: , per_all_people_f pep
2411: WHERE

Line 2439: CURSOR person_orgs(l_org_id Hr_Organization_Information.Organization_id%type) is

2435: ORDER BY 1,2;
2436:
2437: -- This cursor picks all the persons who are Employees and belongs to the
2438: -- expenditure hierarchy and belongs to organzation where organization_id = l_org_id
2439: CURSOR person_orgs(l_org_id Hr_Organization_Information.Organization_id%type) is
2440: SELECT distinct
2441: assn.person_id
2442: ,assn.effective_start_date
2443: ,assn.effective_end_date

Line 2445: , hr_organization_information hrinf

2441: assn.person_id
2442: ,assn.effective_start_date
2443: ,assn.effective_end_date
2444: FROM per_all_assignments_f assn
2445: , hr_organization_information hrinf
2446: /* , per_person_types pertypes Commented for Bug#2781713 */
2447: , per_assignment_status_types pastype
2448: , per_all_people_f pep
2449: WHERE

Line 2522: Elsif (P_table_name = 'HR_ORGANIZATION_INFORMATION')

2518:
2519: END LOOP;
2520: CLOSE person_jobs;
2521:
2522: Elsif (P_table_name = 'HR_ORGANIZATION_INFORMATION')
2523: and (P_organization_id is NOT NULL) then
2524:
2525: -- get all the persons who belongs to this organization and
2526: -- Call Forecast Item regeneration API to update the forecast

Line 3540: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type, P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type)

3536: END Update_Org;
3537:
3538: -- Start Bug : 4656855
3539: /* Function check_pjr_default_ou checks if org_id in pa_all_organizations = the PJR default operating unit */
3540: FUNCTION check_pjr_default_ou(P_Organization_id IN Hr_Organization_Information.Organization_id%type, P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type)
3541: RETURN VARCHAR2 IS
3542: -- This function returns 'Y' if org_id in pa_all_organizations = the PJR default operating unit
3543: -- otherwise , it returns 'N'
3544:

Line 3547: (SELECT 'Y' FROM hr_organization_information

3543: -- otherwise , it returns 'N'
3544:
3545: CURSOR c_check_pjr_default_ou IS
3546: SELECT 'Y' FROM dual WHERE exists
3547: (SELECT 'Y' FROM hr_organization_information
3548: WHERE organization_id = P_Organization_id
3549: and org_information_context = 'Exp Organization Defaults'
3550: and org_information1 = P_Default_OU_new);
3551:

Line 3627: from hr_organization_information

3623: l_default_ou number;
3624: BEGIN
3625: select to_number(org_information1)
3626: into l_default_ou
3627: from hr_organization_information
3628: where organization_id = p_org_id
3629: and org_information_context = 'Exp Organization Defaults';
3630:
3631: if l_default_ou is null then