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

1556: END Update_OU_resource;
1557:
1558:
1559: -- This Procedure is called from workflow process to update/create resources in projects
1560: -- the workflow would be kicked of by the database trigger on table Hr_Organization_Information
1561: -- and Pa_All_Organization entities.
1562: -- 1.Whenever the default operating Unit which is
1563: -- stored in Hr_Organization_Information.Org_information1 changes / modified ,the
1564: -- trigger kicks off the workflow and calls this api to Update the Pa_Resource_OU

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

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

Line 1574: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

1570: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit or rollback
1571: -- after every resource in the loop
1572: PROCEDURE Default_OU_Change
1573: ( P_calling_mode IN VARCHAR2
1574: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1575: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1576: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1578: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1575: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type

1571: -- after every resource in the loop
1572: PROCEDURE Default_OU_Change
1573: ( P_calling_mode IN VARCHAR2
1574: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1575: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1576: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1578: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1579: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1576: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type

1572: PROCEDURE Default_OU_Change
1573: ( P_calling_mode IN VARCHAR2
1574: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
1575: ,P_Default_OU_new IN Hr_Organization_Information.Org_Information1%type
1576: ,P_Default_OU_old IN Hr_Organization_Information.Org_Information1%type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1578: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1579: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1580: ) IS

Line 1588: v_Default_OU Hr_Organization_Information.Org_Information1%type;

1584: v_error_message_code VARCHAR2(2000);
1585: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
1586: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
1587: v_Person_id Per_all_assignments_f.person_id%type;
1588: v_Default_OU Hr_Organization_Information.Org_Information1%type;
1589: v_commit VARCHAR2(200) := FND_API.G_FALSE;
1590: -- set to false since the api is being called from trigger
1591: v_validate_only VARCHAR2(200) := FND_API.G_FALSE;
1592: v_internal VARCHAR2(1) := 'Y';

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

1601: -- get all the resources who belongs to Expenditure type of organizaion and
1602: -- belongs to Expenditure Hierarchy ,Active_Assign, and of Primary assignment type
1603: -- is 'Y' and default OU inactive date is NUll
1604:
1605: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
1606:
1607: SELECT distinct
1608: ind.person_id
1609: ,ind.assignment_start_date

Line 1613: ,hr_organization_information hoi

1609: ,ind.assignment_start_date
1610: ,ind.assignment_end_date
1611: ,to_number(hoi.org_information1) default_OU
1612: FROM pa_r_project_resources_ind_v ind
1613: ,hr_organization_information hoi
1614: WHERE ind.organization_id =
1615: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
1616: AND ind.assignment_end_date >= sysdate
1617: AND hoi.organization_id = l_organization_id

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

1869: END Default_OU_Change;
1870:
1871:
1872: -- This Procedure is called from workflow process to update/create resources in projects
1873: -- The workflow would be kicked of by the database trigger on table Hr_Organization_Information
1874: -- It will update the job levels information if the Project Resource Job Group is changed
1875: -- Created by adabdull 2-JAN-2002
1876: PROCEDURE Proj_Res_Job_Group_Change
1877: ( p_calling_mode IN VARCHAR2

Line 1878: ,p_organization_id IN Hr_Organization_Information.Organization_id%type

1874: -- It will update the job levels information if the Project Resource Job Group is changed
1875: -- Created by adabdull 2-JAN-2002
1876: PROCEDURE Proj_Res_Job_Group_Change
1877: ( p_calling_mode IN VARCHAR2
1878: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1879: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1880: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1881: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1882: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1879: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type

1875: -- Created by adabdull 2-JAN-2002
1876: PROCEDURE Proj_Res_Job_Group_Change
1877: ( p_calling_mode IN VARCHAR2
1878: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1879: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1880: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1881: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1882: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1883: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1880: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type

1876: PROCEDURE Proj_Res_Job_Group_Change
1877: ( p_calling_mode IN VARCHAR2
1878: ,p_organization_id IN Hr_Organization_Information.Organization_id%type
1879: ,p_proj_job_group_new IN Hr_Organization_Information.Org_Information1%type
1880: ,p_proj_job_group_old IN Hr_Organization_Information.Org_Information1%type
1881: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1882: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1883: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1884: ) IS

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

2073: l_msg_count NUMBER;
2074: l_dummy NUMBER;
2075: L_API_VERSION CONSTANT NUMBER := 1.0;
2076:
2077: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
2078:
2079: SELECT distinct ind.person_id
2080: FROM pa_r_project_resources_ind_v ind
2081: ,hr_organization_information hoi

Line 2081: ,hr_organization_information hoi

2077: CURSOR get_all_resource(l_organization_id Hr_Organization_Information.Organization_id%type) is
2078:
2079: SELECT distinct ind.person_id
2080: FROM pa_r_project_resources_ind_v ind
2081: ,hr_organization_information hoi
2082: WHERE ind.organization_id =
2083: /* Changed for Bug 2499051- l_organization_id */ hoi.organization_id
2084: AND ind.assignment_end_date >= sysdate
2085: AND hoi.organization_id = l_organization_id

Line 2169: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type

2165: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit after every
2166: -- resource in the loop
2167: PROCEDURE make_resource_inactive
2168: (P_calling_mode IN VARCHAR2
2169: ,P_Organization_id IN Hr_Organization_Information.Organization_id%type
2170: ,P_Default_OU IN pa_all_organizations.org_id%type
2171: ,P_inactive_date IN pa_all_organizations.inactive_date%type
2172: ,P_Default_OU_NEW IN pa_all_organizations.org_id%type DEFAULT NULL -- Added for bug 5330402
2173: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;

2180: v_assn_start_date Per_all_assignments_f.Effective_Start_Date%type;
2181: v_assn_end_date Per_all_assignments_f.Effective_End_Date%type;
2182: v_Person_id Per_all_assignments_f.person_id%type;
2183: v_resource_id Pa_Resource_txn_attributes.resource_id%type;
2184: v_Default_OU Hr_Organization_Information.Org_Information1%type;
2185: v_msg_data VARCHAR2(2000);
2186: v_msg_count NUMBER;
2187:
2188: -- get all the resources who are employees and belongs to expenditure

Line 2205: , hr_organization_information hrinf

2201: ,assn.effective_end_date
2202: , res.resource_id
2203: , hrinf.org_information1
2204: FROM per_all_assignments_f assn
2205: , hr_organization_information hrinf
2206: /* , per_person_types pertypes Commented for bug#2781713 */
2207: , per_assignment_status_types pastype
2208: , pa_resource_txn_attributes res
2209: , pa_all_organizations allorgs

Line 2256: , hr_organization_information hrinf

2252: ,assn.effective_end_date
2253: , res.resource_id
2254: -- , hrinf.org_information1
2255: FROM per_all_assignments_f assn
2256: , hr_organization_information hrinf
2257: /* , per_person_types pertypes Commented for bug#2781713 */
2258: , per_assignment_status_types pastype
2259: , pa_resource_txn_attributes res
2260: , pa_all_organizations allorgs

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

2387: (P_table_name IN VARCHAR2
2388: ,P_person_id IN PER_ALL_ASSIGNMENTS_F.PERSON_ID%TYPE default NULL
2389: ,P_Job_id IN per_jobs.job_id%type default NULL
2390: ,P_billable_flag IN VARCHAR2 default NULL
2391: ,P_organization_id IN Hr_organization_information.organization_id%type default NULL
2392: ,p_start_date IN date default NULL
2393: ,P_end_date IN date default NULL
2394: ,P_resource_OU IN NUMBER default NULL
2395: ,P_resource_type IN VARCHAR2 default NULL

Line 2414: , hr_organization_information hrinf

2410: assn.person_id
2411: ,assn.effective_start_date
2412: ,assn.effective_end_date
2413: FROM per_all_assignments_f assn
2414: , hr_organization_information hrinf
2415: /* , per_person_types pertypes Commented for Bug#2781713 */
2416: , per_assignment_status_types pastype
2417: , per_all_people_f pep
2418: WHERE

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

2442: ORDER BY 1,2;
2443:
2444: -- This cursor picks all the persons who are Employees and belongs to the
2445: -- expenditure hierarchy and belongs to organzation where organization_id = l_org_id
2446: CURSOR person_orgs(l_org_id Hr_Organization_Information.Organization_id%type) is
2447: SELECT distinct
2448: assn.person_id
2449: ,assn.effective_start_date
2450: ,assn.effective_end_date

Line 2452: , hr_organization_information hrinf

2448: assn.person_id
2449: ,assn.effective_start_date
2450: ,assn.effective_end_date
2451: FROM per_all_assignments_f assn
2452: , hr_organization_information hrinf
2453: /* , per_person_types pertypes Commented for Bug#2781713 */
2454: , per_assignment_status_types pastype
2455: , per_all_people_f pep
2456: WHERE

Line 2529: Elsif (P_table_name = 'HR_ORGANIZATION_INFORMATION')

2525:
2526: END LOOP;
2527: CLOSE person_jobs;
2528:
2529: Elsif (P_table_name = 'HR_ORGANIZATION_INFORMATION')
2530: and (P_organization_id is NOT NULL) then
2531:
2532: -- get all the persons who belongs to this organization and
2533: -- Call Forecast Item regeneration API to update the forecast

Line 3661: 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)

3657: END Update_Org;
3658:
3659: -- Start Bug : 4656855
3660: /* Function check_pjr_default_ou checks if org_id in pa_all_organizations = the PJR default operating unit */
3661: 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)
3662: RETURN VARCHAR2 IS
3663: -- This function returns 'Y' if org_id in pa_all_organizations = the PJR default operating unit
3664: -- otherwise , it returns 'N'
3665:

Line 3668: (SELECT 'Y' FROM hr_organization_information

3664: -- otherwise , it returns 'N'
3665:
3666: CURSOR c_check_pjr_default_ou IS
3667: SELECT 'Y' FROM dual WHERE exists
3668: (SELECT 'Y' FROM hr_organization_information
3669: WHERE organization_id = P_Organization_id
3670: and org_information_context = 'Exp Organization Defaults'
3671: and org_information1 = P_Default_OU_new);
3672:

Line 3748: from hr_organization_information

3744: l_default_ou number;
3745: BEGIN
3746: select to_number(org_information1)
3747: into l_default_ou
3748: from hr_organization_information
3749: where organization_id = p_org_id
3750: and org_information_context = 'Exp Organization Defaults';
3751:
3752: if l_default_ou is null then