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 365: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 366: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 400: PA_RESOURCE_PVT.update_resource_denorm

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

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

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

Line 447: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 448: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 479: PA_RESOURCE_PVT.update_resource_denorm

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

Line 519: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 520: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

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

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

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

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

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

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

Line 1474: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

1470: )IS
1471:
1472: v_return_status VARCHAR2(2000);
1473: v_error_message_code VARCHAR2(2000);
1474: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1475: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
1476: v_msg_data VARCHAR2(2000);
1477: v_msg_count NUMBER;
1478:

Line 1475: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

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

Line 1510: PA_RESOURCE_PVT.update_resource_denorm (

1506: v_resource_rec_old.resource_effective_start_date := rec.resource_effective_start_date;
1507: v_resource_rec_new.resource_effective_start_date := rec.resource_effective_start_date;
1508:
1509:
1510: PA_RESOURCE_PVT.update_resource_denorm (
1511: p_resource_denorm_old_rec => v_resource_rec_old
1512: ,p_resource_denorm_new_rec => v_resource_rec_new
1513: ,x_return_status => x_return_status
1514: ,x_msg_data => x_msg_data

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

2580:
2581: END call_forcast_api;
2582:
2583:
2584: -- This Procedure makes calls to PA_RESOURCE_PVT.update_resource_denorm api
2585: -- which actually updates the pa_resources_denorm entity
2586: PROCEDURE call_billable_resoruce_denorm
2587: (P_job_id_old per_jobs.job_id%type
2588: ,P_job_id_new per_jobs.job_id%type

Line 2601: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

2597: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2598: ) IS
2599: v_return_status VARCHAR2(2000);
2600: v_error_message_code VARCHAR2(2000);
2601: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2602: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2603: v_job_id_old PER_JOBS.JOB_ID%type;
2604: v_job_id_new PER_JOBS.JOB_ID%type;
2605: v_billable_flag_old pa_resources_denorm.billable_flag%type;

Line 2602: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

2598: ) IS
2599: v_return_status VARCHAR2(2000);
2600: v_error_message_code VARCHAR2(2000);
2601: v_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2602: v_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
2603: v_job_id_old PER_JOBS.JOB_ID%type;
2604: v_job_id_new PER_JOBS.JOB_ID%type;
2605: v_billable_flag_old pa_resources_denorm.billable_flag%type;
2606: v_billable_flag_new pa_resources_denorm.billable_flag%type;

Line 2670: PA_RESOURCE_PVT.update_resource_denorm

2666:
2667: -- Call PRM API update resource denorm which actually updates the
2668: -- pa_resource_denorm entity
2669:
2670: PA_RESOURCE_PVT.update_resource_denorm
2671: ( p_resource_denorm_old_rec => v_resource_rec_old
2672: ,p_resource_denorm_new_rec => v_resource_rec_new
2673: ,x_return_status => x_return_status
2674: ,x_msg_data => x_msg_data

Line 3170: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3166: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3167: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3168: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3169:
3170: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3171: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3172:
3173: l_return_status VARCHAR2(1);
3174:

Line 3171: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3167: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3168: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3169:
3170: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3171: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3172:
3173: l_return_status VARCHAR2(1);
3174:
3175: l_invol_term VARCHAR2(1); --bug 5683340

Line 3230: PA_RESOURCE_PVT.update_resource_denorm(

3226: l_resource_rec_old.resource_effective_end_date := rec.resource_effective_end_date;
3227: l_resource_rec_new.resource_effective_end_date := p_new_end_date;
3228:
3229: --Call Resource Denorm API
3230: PA_RESOURCE_PVT.update_resource_denorm(
3231: p_resource_denorm_old_rec => l_resource_rec_old
3232: ,p_resource_denorm_new_rec => l_resource_rec_new
3233: ,x_return_status => l_return_status
3234: ,x_msg_data => x_msg_data

Line 3244: pa_resource_pvt.delete_resource_denorm(

3240:
3241: ELSIF p_new_end_date < rec.resource_effective_start_date THEN
3242:
3243: --Delete this record
3244: pa_resource_pvt.delete_resource_denorm(
3245: p_person_id => p_person_id
3246: ,p_res_effective_start_date => rec.resource_effective_start_date
3247: ,x_return_status => l_return_status
3248: ,x_msg_data => x_msg_data

Line 3344: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3340:
3341: l_default_ou_old pa_resources_denorm.resource_org_id%TYPE;
3342: l_default_ou_new pa_resources_denorm.resource_org_id%TYPE;
3343:
3344: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3345: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3346:
3347: l_return_status VARCHAR2(1);
3348: l_org_type VARCHAR2(20);

Line 3345: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3341: l_default_ou_old pa_resources_denorm.resource_org_id%TYPE;
3342: l_default_ou_new pa_resources_denorm.resource_org_id%TYPE;
3343:
3344: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3345: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3346:
3347: l_return_status VARCHAR2(1);
3348: l_org_type VARCHAR2(20);
3349: l_resource_id NUMBER(15);

Line 3469: PA_RESOURCE_PVT.update_resource_denorm(

3465: l_resource_rec_old.resource_effective_end_date := rec.resource_effective_end_date;
3466: l_resource_rec_new.resource_effective_end_date := rec.resource_effective_end_date;
3467:
3468: --Call Resource Denorm API
3469: PA_RESOURCE_PVT.update_resource_denorm(
3470: p_resource_denorm_old_rec => l_resource_rec_old
3471: ,p_resource_denorm_new_rec => l_resource_rec_new
3472: ,x_return_status => l_return_status
3473: ,x_msg_data => x_msg_data

Line 3656: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3652: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3653: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3654: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3655:
3656: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3657: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3658: l_return_status VARCHAR2(1);
3659: l_resource_id NUMBER;
3660: l_resource_start_date DATE;

Line 3657: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3653: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3654: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3655:
3656: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3657: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3658: l_return_status VARCHAR2(1);
3659: l_resource_id NUMBER;
3660: l_resource_start_date DATE;
3661: l_resource_end_date DATE;

Line 3801: PA_RESOURCE_PVT.update_resource_denorm(

3797: log_message('start_date:'||rec.resource_effective_start_date||', end_Date:'||
3798: rec.resource_effective_end_date);
3799: END IF;
3800:
3801: PA_RESOURCE_PVT.update_resource_denorm(
3802: p_resource_denorm_old_rec => l_resource_rec_old
3803: ,p_resource_denorm_new_rec => l_resource_rec_new
3804: ,x_return_status => l_return_status
3805: ,x_msg_data => x_msg_data

Line 3866: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3862: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3863: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3864: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3865:
3866: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3867: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3868:
3869: l_return_status VARCHAR2(1);
3870: l_manager_name pa_resources_denorm.manager_name%TYPE;

Line 3867: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

3863: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3864: x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
3865:
3866: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3867: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
3868:
3869: l_return_status VARCHAR2(1);
3870: l_manager_name pa_resources_denorm.manager_name%TYPE;
3871:

Line 3911: PA_RESOURCE_PVT.update_resource_denorm(

3907:
3908: l_resource_rec_new.resource_effective_start_date := rec.resource_effective_start_date;
3909:
3910: --Call Resource Denorm API
3911: PA_RESOURCE_PVT.update_resource_denorm(
3912: p_resource_denorm_old_rec => l_resource_rec_old
3913: ,p_resource_denorm_new_rec => l_resource_rec_new
3914: ,x_return_status => l_return_status
3915: ,x_msg_data => x_msg_data

Line 4016: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

4012:
4013: l_resource_id pa_resources.resource_id%TYPE;
4014: l_return_status VARCHAR2(1);
4015:
4016: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4017: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4018: BEGIN
4019:
4020: --Initialize the Error stack

Line 4017: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;

4013: l_resource_id pa_resources.resource_id%TYPE;
4014: l_return_status VARCHAR2(1);
4015:
4016: l_resource_rec_old PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4017: l_resource_rec_new PA_RESOURCE_PVT.Resource_Denorm_Rec_Type;
4018: BEGIN
4019:
4020: --Initialize the Error stack
4021: PA_DEBUG.init_err_stack('PA_HR_UPDATE_API.Update_Name');

Line 4044: PA_RESOURCE_PVT.update_resource_denorm(

4040: l_resource_rec_old.resource_name := p_old_name;
4041: l_resource_rec_new.resource_name := p_new_name;
4042:
4043: --Call Resource Denorm API
4044: PA_RESOURCE_PVT.update_resource_denorm(
4045: p_resource_denorm_old_rec => l_resource_rec_old
4046: ,p_resource_denorm_new_rec => l_resource_rec_new
4047: ,x_return_status => l_return_status
4048: ,x_msg_data => x_msg_data