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_RESOURCE_PVT

Line 368: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

364: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
365: ) IS
366: v_return_status VARCHAR2(2000);
367: v_error_message_code VARCHAR2(2000);
368: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
369: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
370: v_job_level_old NUMBER := 0;
371: v_job_level_new NUMBER;
372: v_job_id_old PER_JOBS.JOB_ID%type;

Line 369: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

365: ) IS
366: v_return_status VARCHAR2(2000);
367: v_error_message_code VARCHAR2(2000);
368: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
369: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
370: v_job_level_old NUMBER := 0;
371: v_job_level_new NUMBER;
372: v_job_id_old PER_JOBS.JOB_ID%type;
373: v_job_id_new PER_JOBS.JOB_ID%type;

Line 403: PA_RESOURCE_PVT.update_resource_denorm

399: v_resource_rec_new.resource_job_level := v_job_level_new;
400:
401: -- Call PRM API update resource denorm which actually updates the
402: -- pa_resource_denorm entity
403: PA_RESOURCE_PVT.update_resource_denorm
404: ( p_resource_denorm_old_rec => v_resource_rec_old
405: ,p_resource_denorm_new_rec => v_resource_rec_new
406: ,x_return_status => x_return_status
407: ,x_msg_data => x_msg_data

Line 436: -- This API makes calls to PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API

432:
433:
434: END call_create_resource_denorm;
435:
436: -- This API makes calls to PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API
437: -- which actually updates the pa_resources_denorm entity
438: -- This API will update the job level of the job id passed in of the
439: -- resources denorm records
440: PROCEDURE update_job_level_res_denorm

Line 450: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

446: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
447: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
448: ) IS
449:
450: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
451: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
452: l_job_level_old NUMBER;
453: l_job_level_new NUMBER;
454: l_job_id_old PER_JOBS.JOB_ID%type;

Line 451: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

447: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
448: ) IS
449:
450: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
451: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
452: l_job_level_old NUMBER;
453: l_job_level_new NUMBER;
454: l_job_id_old PER_JOBS.JOB_ID%type;
455: l_job_id_new PER_JOBS.JOB_ID%type;

Line 482: PA_RESOURCE_PVT.update_resource_denorm

478: l_resource_rec_new.resource_job_level := l_job_level_new;
479:
480: -- Call PRM API update resource denorm which actually updates the
481: -- pa_resource_denorm entity
482: PA_RESOURCE_PVT.update_resource_denorm
483: ( p_resource_denorm_old_rec => l_resource_rec_old
484: ,p_resource_denorm_new_rec => l_resource_rec_new
485: ,x_return_status => x_return_status
486: ,x_msg_data => x_msg_data

Line 522: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

518:
519: l_job_id PER_JOBS.JOB_ID%type;
520: l_job_level_old pa_resources_denorm.resource_job_level%type;
521: l_job_level_new pa_resources_denorm.resource_job_level%type;
522: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
523: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
524:
525: -- Cursor to get all affected job ids with the P_job_id level change
526: CURSOR get_job_ids(

Line 523: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

519: l_job_id PER_JOBS.JOB_ID%type;
520: l_job_level_old pa_resources_denorm.resource_job_level%type;
521: l_job_level_new pa_resources_denorm.resource_job_level%type;
522: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
523: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
524:
525: -- Cursor to get all affected job ids with the P_job_id level change
526: CURSOR get_job_ids(
527: l_job_id per_jobs.job_id%type

Line 567: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

563: l_job_level_new := P_job_level_new;
564:
565:
566: -- if the job level changes then update all the jobs which are affected and
567: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table
568: OPEN get_job_ids(l_job_id) ;
569: LOOP
570: fetch get_job_ids into l_job_id;
571: Exit when get_job_ids%NOTFOUND;

Line 1216: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

1212: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_valid_grades_job_id');
1213: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1214:
1215: -- if the grade id changes then update all the jobs which are affected and
1216: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table
1217: OPEN get_job_ids(P_job_id) ;
1218: LOOP
1219: fetch get_job_ids into v_job_id;
1220: Exit when get_job_ids%NOTFOUND;

Line 1329: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table

1325: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.per_grades_job_id');
1326: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1327:
1328: -- if the sequence is changes then update all the jobs which are affected due to
1329: -- call PA_RESOURCE_PVT.UPDATE_RESOURCE_DENORM API to update the resource_denorm_table
1330: OPEN get_job_ids(P_grade_id) ;
1331: LOOP
1332: fetch get_job_ids into v_job_id;
1333: Exit when get_job_ids%NOTFOUND;

Line 1477: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

1473: )IS
1474:
1475: v_return_status VARCHAR2(2000);
1476: v_error_message_code VARCHAR2(2000);
1477: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1478: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1479: v_msg_data VARCHAR2(2000);
1480: v_msg_count NUMBER;
1481: CURSOR res_denorm_recs IS

Line 1478: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

1474:
1475: v_return_status VARCHAR2(2000);
1476: v_error_message_code VARCHAR2(2000);
1477: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1478: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1479: v_msg_data VARCHAR2(2000);
1480: v_msg_count NUMBER;
1481: CURSOR res_denorm_recs IS
1482: SELECT resource_effective_start_date,

Line 1517: PA_RESOURCE_PVT.update_resource_denorm (

1513: v_resource_rec_old.resource_effective_start_date := rec.resource_effective_start_date;
1514: v_resource_rec_new.resource_effective_start_date := rec.resource_effective_start_date;
1515:
1516:
1517: PA_RESOURCE_PVT.update_resource_denorm (
1518: p_resource_denorm_old_rec => v_resource_rec_old
1519: ,p_resource_denorm_new_rec => v_resource_rec_new
1520: ,x_return_status => x_return_status
1521: ,x_msg_data => x_msg_data

Line 2591: -- This Procedure makes calls to PA_RESOURCE_PVT.update_resource_denorm api

2587:
2588: END call_forcast_api;
2589:
2590:
2591: -- This Procedure makes calls to PA_RESOURCE_PVT.update_resource_denorm api
2592: -- which actually updates the pa_resources_denorm entity
2593: PROCEDURE call_billable_resoruce_denorm
2594: (P_job_id_old per_jobs.job_id%type
2595: ,P_job_id_new per_jobs.job_id%type

Line 2608: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

2604: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2605: ) IS
2606: v_return_status VARCHAR2(2000);
2607: v_error_message_code VARCHAR2(2000);
2608: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2609: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2610: v_job_id_old PER_JOBS.JOB_ID%type;
2611: v_job_id_new PER_JOBS.JOB_ID%type;
2612: v_billable_flag_old pa_resources_denorm.billable_flag%type;

Line 2609: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

2605: ) IS
2606: v_return_status VARCHAR2(2000);
2607: v_error_message_code VARCHAR2(2000);
2608: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2609: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2610: v_job_id_old PER_JOBS.JOB_ID%type;
2611: v_job_id_new PER_JOBS.JOB_ID%type;
2612: v_billable_flag_old pa_resources_denorm.billable_flag%type;
2613: v_billable_flag_new pa_resources_denorm.billable_flag%type;

Line 2677: PA_RESOURCE_PVT.update_resource_denorm

2673:
2674: -- Call PRM API update resource denorm which actually updates the
2675: -- pa_resource_denorm entity
2676:
2677: PA_RESOURCE_PVT.update_resource_denorm
2678: ( p_resource_denorm_old_rec => v_resource_rec_old
2679: ,p_resource_denorm_new_rec => v_resource_rec_new
2680: ,x_return_status => x_return_status
2681: ,x_msg_data => x_msg_data

Line 3196: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3192: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3193: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3194: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3195:
3196: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3197: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3198:
3199: l_return_status VARCHAR2(1);
3200:

Line 3197: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3193: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3194: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3195:
3196: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3197: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3198:
3199: l_return_status VARCHAR2(1);
3200:
3201: l_invol_term VARCHAR2(1); --bug 5683340

Line 3288: PA_RESOURCE_PVT.update_resource_denorm(

3284: l_resource_rec_old.resource_effective_end_date := rec.resource_effective_end_date;
3285: l_resource_rec_new.resource_effective_end_date := p_new_end_date;
3286:
3287: --Call Resource Denorm API
3288: PA_RESOURCE_PVT.update_resource_denorm(
3289: p_resource_denorm_old_rec => l_resource_rec_old
3290: ,p_resource_denorm_new_rec => l_resource_rec_new
3291: ,x_return_status => l_return_status
3292: ,x_msg_data => x_msg_data

Line 3310: pa_resource_pvt.delete_resource_denorm(

3306: l_count := l_count + 1;
3307: --Bug 9838014 End
3308:
3309: --Delete this record
3310: pa_resource_pvt.delete_resource_denorm(
3311: p_person_id => p_person_id
3312: ,p_res_effective_start_date => rec.resource_effective_start_date
3313: ,x_return_status => l_return_status
3314: ,x_msg_data => x_msg_data

Line 3464: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3460:
3461: l_default_ou_old pa_resources_denorm.resource_org_id%TYPE;
3462: l_default_ou_new pa_resources_denorm.resource_org_id%TYPE;
3463:
3464: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3465: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3466:
3467: l_return_status VARCHAR2(1);
3468: l_org_type VARCHAR2(20);

Line 3465: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3461: l_default_ou_old pa_resources_denorm.resource_org_id%TYPE;
3462: l_default_ou_new pa_resources_denorm.resource_org_id%TYPE;
3463:
3464: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3465: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3466:
3467: l_return_status VARCHAR2(1);
3468: l_org_type VARCHAR2(20);
3469: l_resource_id NUMBER(15);

Line 3589: PA_RESOURCE_PVT.update_resource_denorm(

3585: l_resource_rec_old.resource_effective_end_date := rec.resource_effective_end_date;
3586: l_resource_rec_new.resource_effective_end_date := rec.resource_effective_end_date;
3587:
3588: --Call Resource Denorm API
3589: PA_RESOURCE_PVT.update_resource_denorm(
3590: p_resource_denorm_old_rec => l_resource_rec_old
3591: ,p_resource_denorm_new_rec => l_resource_rec_new
3592: ,x_return_status => l_return_status
3593: ,x_msg_data => x_msg_data

Line 3777: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3773: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3774: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3775: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3776:
3777: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3778: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3779: l_return_status VARCHAR2(1);
3780: l_resource_id NUMBER;
3781: l_resource_start_date DATE;

Line 3778: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3774: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3775: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3776:
3777: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3778: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3779: l_return_status VARCHAR2(1);
3780: l_resource_id NUMBER;
3781: l_resource_start_date DATE;
3782: l_resource_end_date DATE;

Line 3935: PA_RESOURCE_PVT.update_resource_denorm(

3931: log_message('start_date:'||rec.resource_effective_start_date||', end_Date:'||
3932: rec.resource_effective_end_date);
3933: END IF;
3934:
3935: PA_RESOURCE_PVT.update_resource_denorm(
3936: p_resource_denorm_old_rec => l_resource_rec_old
3937: ,p_resource_denorm_new_rec => l_resource_rec_new
3938: ,x_return_status => l_return_status
3939: ,x_msg_data => x_msg_data

Line 4002: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3998: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3999: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4000: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4001:
4002: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4003: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4004:
4005: l_return_status VARCHAR2(1);
4006: l_manager_name pa_resources_denorm.manager_name%TYPE;

Line 4003: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3999: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4000: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
4001:
4002: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4003: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4004:
4005: l_return_status VARCHAR2(1);
4006: l_manager_name pa_resources_denorm.manager_name%TYPE;
4007:

Line 4047: PA_RESOURCE_PVT.update_resource_denorm(

4043:
4044: l_resource_rec_new.resource_effective_start_date := rec.resource_effective_start_date;
4045:
4046: --Call Resource Denorm API
4047: PA_RESOURCE_PVT.update_resource_denorm(
4048: p_resource_denorm_old_rec => l_resource_rec_old
4049: ,p_resource_denorm_new_rec => l_resource_rec_new
4050: ,x_return_status => l_return_status
4051: ,x_msg_data => x_msg_data

Line 4155: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

4151:
4152: l_resource_id pa_resources.resource_id%TYPE;
4153: l_return_status VARCHAR2(1);
4154:
4155: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4156: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4157: BEGIN
4158:
4159: --Initialize the Error stack

Line 4156: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

4152: l_resource_id pa_resources.resource_id%TYPE;
4153: l_return_status VARCHAR2(1);
4154:
4155: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4156: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4157: BEGIN
4158:
4159: --Initialize the Error stack
4160: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Name');

Line 4183: PA_RESOURCE_PVT.update_resource_denorm(

4179: l_resource_rec_old.resource_name := p_old_name;
4180: l_resource_rec_new.resource_name := p_new_name;
4181:
4182: --Call Resource Denorm API
4183: PA_RESOURCE_PVT.update_resource_denorm(
4184: p_resource_denorm_old_rec => l_resource_rec_old
4185: ,p_resource_denorm_new_rec => l_resource_rec_new
4186: ,x_return_status => l_return_status
4187: ,x_msg_data => x_msg_data