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 1459: -- end date active to sysdate when pa_all_organizations.inactive_date

1455: END update_job_levels;
1456:
1457:
1458: -- This Procedure updates the pa_resource_OU and set the resources
1459: -- end date active to sysdate when pa_all_organizations.inactive_date
1460: -- is updated.
1461: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type
1462: ,P_default_OU_new IN Pa_all_organizations.org_id%type
1463: ,P_resource_id IN Pa_Resources_denorm.resource_id%type

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

1457:
1458: -- This Procedure updates the pa_resource_OU and set the resources
1459: -- end date active to sysdate when pa_all_organizations.inactive_date
1460: -- is updated.
1461: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type
1462: ,P_default_OU_new IN Pa_all_organizations.org_id%type
1463: ,P_resource_id IN Pa_Resources_denorm.resource_id%type
1464: default NULL
1465: ,P_person_id IN Pa_Resources_denorm.person_id%type

Line 1462: ,P_default_OU_new IN Pa_all_organizations.org_id%type

1458: -- This Procedure updates the pa_resource_OU and set the resources
1459: -- end date active to sysdate when pa_all_organizations.inactive_date
1460: -- is updated.
1461: PROCEDURE Update_OU_resource(P_default_OU_old IN Pa_all_organizations.org_id%type
1462: ,P_default_OU_new IN Pa_all_organizations.org_id%type
1463: ,P_resource_id IN Pa_Resources_denorm.resource_id%type
1464: default NULL
1465: ,P_person_id IN Pa_Resources_denorm.person_id%type
1466: default NULL

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

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
1568: -- is updated with inactive_date then trigger fires and kicks of the workflow,calls this
1569: -- api to Update the Pa_Resource_OU.
1570: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit or rollback

Line 1790: -- or due to insert in pa_all_organizations entity

1786: Elsif P_calling_mode = 'INSERT' then
1787: -- the P_calling_mode is 'INSERT'
1788: -- this api is called to populate resources whenever a new record is added in
1789: -- in Hr_organizatioin_information entity
1790: -- or due to insert in pa_all_organizations entity
1791:
1792: PA_R_PROJECT_RESOURCES_PUB.CREATE_RESOURCE (
1793: P_API_VERSION => L_API_VERSION
1794: ,P_COMMIT => v_commit

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

2054: -- This API pulls all resources into PA from HR for a given organization
2055: -- Created by virangan 11-JUN-2001
2056: -- Make this procedure a PRAGMA AUTONOMOUS_TRANSACTION because we'll commit after every
2057: -- resource in the loop
2058: PROCEDURE pull_resources( p_organization_id IN pa_all_organizations.organization_id%type
2059: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2060: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2061: ,x_msg_count OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895
2062: IS

Line 2170: ,P_Default_OU IN pa_all_organizations.org_id%type

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
2174: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2171: ,P_inactive_date IN pa_all_organizations.inactive_date%type

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
2174: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

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
2174: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2176: ) IS

Line 2209: , pa_all_organizations allorgs

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
2210: , per_all_people_f pep
2211: WHERE
2212: assn.assignment_status_type_id = pastype.assignment_status_type_id
2213: AND assn.person_id = res.person_id

Line 2235: FROM pa_all_organizations exporg

2231: AND allorgs.pa_org_use_type = 'EXPENDITURES'
2232: AND allorgs.inactive_date is Not null
2233: AND (allorgs.organization_id,allorgs.org_id) = (
2234: SELECT exporg.organization_id, exporg.org_id
2235: FROM pa_all_organizations exporg
2236: WHERE exporg.pa_org_use_type = 'EXPENDITURES'
2237: AND exporg.inactive_date is Not null
2238: AND exporg.organization_id = allorgs.organization_id
2239: AND exporg.org_id = allorgs.org_id

Line 2260: , pa_all_organizations allorgs

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
2261: , per_all_people_f pep
2262: WHERE
2263: assn.assignment_status_type_id = pastype.assignment_status_type_id
2264: AND assn.person_id = res.person_id

Line 2286: FROM pa_all_organizations exporg

2282: AND allorgs.pa_org_use_type = 'EXPENDITURES'
2283: -- AND allorgs.inactive_date is Not null
2284: AND (allorgs.organization_id,allorgs.org_id) = ( -- Removed the NVL as this is not required.Sunkalya.Bug#5330402
2285: SELECT exporg.organization_id, exporg.org_id
2286: FROM pa_all_organizations exporg
2287: WHERE exporg.pa_org_use_type = 'EXPENDITURES'
2288: -- AND exporg.inactive_date is Not null
2289: AND exporg.organization_id = allorgs.organization_id
2290: AND exporg.org_id = allorgs.org_id -- Removed the NVL as this is not required.Sunkalya.Bug#5330402

Line 2437: FROM pa_all_organizations exporg

2433: pep.current_npw_flag = 'Y') -- CWK Changes
2434: AND pep.person_id = assn.person_id
2435: AND assn.organization_id =
2436: (SELECT exporg.organization_id
2437: FROM pa_all_organizations exporg
2438: WHERE exporg.pa_org_use_type = 'EXPENDITURES'
2439: AND exporg.inactive_date is null
2440: AND exporg.organization_id = assn.organization_id
2441: AND rownum = 1 )

Line 2475: FROM pa_all_organizations exporg

2471: pep.current_npw_flag = 'Y') -- CWK Changes
2472: AND pep.person_id = assn.person_id
2473: AND assn.organization_id =
2474: (SELECT exporg.organization_id
2475: FROM pa_all_organizations exporg
2476: WHERE exporg.pa_org_use_type = 'EXPENDITURES'
2477: AND exporg.inactive_date is null
2478: AND exporg.organization_id = assn.organization_id
2479: AND rownum = 1 )

Line 2491: P_table_name = 'PA_ALL_ORGANIZATIONS') and

2487:
2488: If (P_table_name = 'PER_JOB_EXTRA_INFO' or
2489: P_table_name = 'PER_VALID_GRADES' or
2490: P_table_name = 'PER_GRADES' or
2491: P_table_name = 'PA_ALL_ORGANIZATIONS') and
2492: (P_job_id is NOT NULL) then
2493:
2494: -- get all the persons belongs to this job Id and
2495: -- Call Forecast Item regeneration API to update the forecast

Line 3660: /* Function check_pjr_default_ou checks if org_id in pa_all_organizations = the PJR default operating unit */

3656: raise;
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'

Line 3663: -- This function returns 'Y' if org_id in pa_all_organizations = the PJR default operating unit

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:
3666: CURSOR c_check_pjr_default_ou IS
3667: SELECT 'Y' FROM dual WHERE exists

Line 3711: FROM pa_all_organizations

3707: SELECT 'x'
3708: FROM dual
3709: WHERE exists
3710: (select organization_id
3711: FROM pa_all_organizations
3712: WHERE organization_id = p_org_id
3713: AND inactive_date is null
3714: AND pa_org_use_type = 'EXPENDITURES');
3715: