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 PER_JOBS

Line 30: P_job_id IN per_jobs.job_id%type

26: END log_message;
27:
28: -- This API returns the job group id for the corresponding Job
29: FUNCTION get_job_group_id(
30: P_job_id IN per_jobs.job_id%type
31: ) RETURN per_job_groups.job_group_id%type
32: IS
33: v_job_grp_id per_job_groups.job_group_id%type;
34:

Line 72: P_job_id IN per_jobs.job_id%type

68:
69: -- This Function returns the job level DFF based on the job_id and Job_group_id
70: -- 24-Dec: Move the logic of the code to PA_JOB_UTILS and call the function here
71: FUNCTION get_job_level(
72: P_job_id IN per_jobs.job_id%type
73: ,P_job_group_id IN per_job_groups.job_group_id%type
74: ) RETURN NUMBER
75: IS
76: l_job_level NUMBER;

Line 107: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)

103:
104:
105: -- This Function returns boolean value of true if a job is master job otherwise
106: -- it returns false -- IN parameter will be job_id
107: FUNCTION check_master_job(P_job_id IN per_Jobs.job_id%type)
108: RETURN boolean
109: IS
110: l_flag BOOLEAN;
111:

Line 131: v_job_id per_jobs.job_id%type;

127: ) RETURN VARCHAR2
128: IS
129:
130: utilization_flag VARCHAR2(150);
131: v_job_id per_jobs.job_id%type;
132: v_job_info_type VARCHAR2(20) := 'Job Category';
133:
134: BEGIN
135:

Line 194: v_job_id per_jobs.job_id%type;

190: ) RETURN VARCHAR2
191: IS
192:
193: Billable_flag VARCHAR2(150);
194: v_job_id per_jobs.job_id%type;
195: v_job_info_type VARCHAR2(20) := 'Job Category';
196:
197: BEGIN
198:

Line 355: (P_job_id_old per_jobs.job_id%type

351:
352: -- This API makes calls to PA_REOSURCE_PVT.UPDATE_RESOURCE_DENORM api
353: -- which actually updates the pa_reosurces_denorm entity
354: PROCEDURE call_create_resource_denorm
355: (P_job_id_old per_jobs.job_id%type
356: ,P_job_id_new per_jobs.job_id%type
357: ,P_job_level_old NUMBER
358: ,P_job_level_new NUMBER
359: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 356: ,P_job_id_new per_jobs.job_id%type

352: -- This API makes calls to PA_REOSURCE_PVT.UPDATE_RESOURCE_DENORM api
353: -- which actually updates the pa_reosurces_denorm entity
354: PROCEDURE call_create_resource_denorm
355: (P_job_id_old per_jobs.job_id%type
356: ,P_job_id_new per_jobs.job_id%type
357: ,P_job_level_old NUMBER
358: ,P_job_level_new NUMBER
359: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
360: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 369: v_job_id_old PER_JOBS.JOB_ID%type;

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;
371: v_msg_data VARCHAR2(2000);
372: v_msg_count NUMBER;
373: BEGIN

Line 370: v_job_id_new PER_JOBS.JOB_ID%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;
371: v_msg_data VARCHAR2(2000);
372: v_msg_count NUMBER;
373: BEGIN
374: -- Initialize the Error stack

Line 438: ( P_job_id_old per_jobs.job_id%type

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
438: ( P_job_id_old per_jobs.job_id%type
439: ,P_job_id_new per_jobs.job_id%type
440: ,P_job_level_old NUMBER
441: ,P_job_level_new NUMBER
442: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 439: ,P_job_id_new per_jobs.job_id%type

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
438: ( P_job_id_old per_jobs.job_id%type
439: ,P_job_id_new per_jobs.job_id%type
440: ,P_job_level_old NUMBER
441: ,P_job_level_new NUMBER
442: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
443: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 451: l_job_id_old PER_JOBS.JOB_ID%type;

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;
453: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
454:
455: BEGIN

Line 452: l_job_id_new PER_JOBS.JOB_ID%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;
453: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
454:
455: BEGIN
456: -- Initialize the Error stack

Line 508: ( P_job_id per_jobs.job_id%type

504:
505: -- This API gets all jobs belonging to the master job id and updates
506: -- the resource denorm records that has the affected job id
507: PROCEDURE update_all_jobs
508: ( P_job_id per_jobs.job_id%type
509: ,P_job_level_old pa_resources_denorm.resource_job_level%type
510: ,P_job_level_new pa_resources_denorm.resource_job_level%type
511: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
512: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 516: l_job_id PER_JOBS.JOB_ID%type;

512: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
513: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
514: ) IS
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;

Line 524: l_job_id per_jobs.job_id%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
525: ) is
526: SELECT l_job_id effected_job_id
527: FROM sys.dual
528: ,per_job_groups pjg

Line 626: l_job_id PER_JOBS.JOB_ID%type;

622: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
623:
624: l_job_level_old NUMBER;
625: l_job_level_new NUMBER;
626: l_job_id PER_JOBS.JOB_ID%type;
627: l_master_job_id PER_JOBS.JOB_ID%type;
628: l_PRJG_job_id PER_JOBS.JOB_ID%type;
629: l_condition VARCHAR2(10);
630: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 627: l_master_job_id PER_JOBS.JOB_ID%type;

623:
624: l_job_level_old NUMBER;
625: l_job_level_new NUMBER;
626: l_job_id PER_JOBS.JOB_ID%type;
627: l_master_job_id PER_JOBS.JOB_ID%type;
628: l_PRJG_job_id PER_JOBS.JOB_ID%type;
629: l_condition VARCHAR2(10);
630: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
631:

Line 628: l_PRJG_job_id PER_JOBS.JOB_ID%type;

624: l_job_level_old NUMBER;
625: l_job_level_new NUMBER;
626: l_job_id PER_JOBS.JOB_ID%type;
627: l_master_job_id PER_JOBS.JOB_ID%type;
628: l_PRJG_job_id PER_JOBS.JOB_ID%type;
629: l_condition VARCHAR2(10);
630: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
631:
632: BEGIN

Line 921: ( P_job_id per_jobs.job_id%type

917:
918: -- Do updates on job level for PRJG job, master jobs and normal jobs
919: -- which has mapping to each other
920: PROCEDURE perform_job_updates
921: ( P_job_id per_jobs.job_id%type
922: ,P_job_level_old pa_resources_denorm.resource_job_level%type
923: ,P_job_level_new pa_resources_denorm.resource_job_level%type
924: ,P_job_group_id per_job_groups.job_group_id%type
925: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 930: l_job_id PER_JOBS.JOB_ID%type;

926: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
927: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
928: ) IS
929:
930: l_job_id PER_JOBS.JOB_ID%type;
931: l_master_job_id PER_JOBS.JOB_ID%type;
932: l_job_level_old pa_resources_denorm.resource_job_level%type;
933: l_job_level_new pa_resources_denorm.resource_job_level%type;
934: l_job_group_id per_job_groups.job_group_id%type;

Line 931: l_master_job_id PER_JOBS.JOB_ID%type;

927: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
928: ) IS
929:
930: l_job_id PER_JOBS.JOB_ID%type;
931: l_master_job_id PER_JOBS.JOB_ID%type;
932: l_job_level_old pa_resources_denorm.resource_job_level%type;
933: l_job_level_new pa_resources_denorm.resource_job_level%type;
934: l_job_group_id per_job_groups.job_group_id%type;
935: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 939: l_job_id per_jobs.job_id%type

935: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
936:
937: -- Cursor to get the associated master job id of the PRJG job id
938: CURSOR get_master_job (
939: l_job_id per_jobs.job_id%type
940: ,l_job_group_id per_job_groups.job_group_id%type
941: ) IS
942:
943: SELECT distinct pjr.from_job_id effected_job_id

Line 1044: ( P_job_id per_jobs.job_id%type

1040: -- Main API for job level change, job mapping change
1041: -- This API will update the resource denorm records with the job level change of a job id.
1042: -- It depends on the type of job : whether it is in the Project Resource Job Group or not
1043: PROCEDURE update_job_level_dff
1044: ( P_job_id per_jobs.job_id%type
1045: ,P_job_level_old pa_resources_denorm.resource_job_level%type
1046: ,P_job_level_new pa_resources_denorm.resource_job_level%type
1047: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1048: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1052: l_job_id PER_JOBS.JOB_ID%type;

1048: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1049: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1050: ) IS
1051:
1052: l_job_id PER_JOBS.JOB_ID%type;
1053: l_job_level_old pa_resources_denorm.resource_job_level%type;
1054: l_job_level_new pa_resources_denorm.resource_job_level%type;
1055: l_job_group_id per_job_groups.job_group_id%type;
1056: l_isPRJG VARCHAR2(1);

Line 1158: (P_job_id IN per_jobs.job_id%type

1154:
1155: -- This Procedure gets list of all the jobs which are afftected due to changes in
1156: -- grade_id in per_valid_grade entity
1157: PROCEDURE per_valid_grades_job_id
1158: (P_job_id IN per_jobs.job_id%type
1159: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1160: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1161: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
1162:

Line 1165: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;

1161: ,x_msg_count OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
1162:
1163: v_return_status VARCHAR2(2000);
1164: v_error_message_code VARCHAR2(2000);
1165: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;
1166: v_job_level_old NUMBER;
1167: v_job_level_new NUMBER;
1168: v_job_id PER_JOBS.JOB_ID%type;
1169: v_msg_data VARCHAR2(2000);

Line 1168: v_job_id PER_JOBS.JOB_ID%type;

1164: v_error_message_code VARCHAR2(2000);
1165: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;
1166: v_job_level_old NUMBER;
1167: v_job_level_new NUMBER;
1168: v_job_id PER_JOBS.JOB_ID%type;
1169: v_msg_data VARCHAR2(2000);
1170: v_msg_count NUMBER;
1171:
1172: CURSOR get_job_ids(

Line 1173: l_job_id per_jobs.job_id%type

1169: v_msg_data VARCHAR2(2000);
1170: v_msg_count NUMBER;
1171:
1172: CURSOR get_job_ids(
1173: l_job_id per_jobs.job_id%type
1174: ) is
1175: SELECT l_job_id effected_job_id
1176: FROM sys.dual
1177: ,per_job_groups pjg

Line 1270: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;

1266: ) IS
1267:
1268: v_return_status VARCHAR2(2000);
1269: v_error_message_code VARCHAR2(2000);
1270: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;
1271: v_job_level_new NUMBER;
1272: v_job_level_old NUMBER;
1273: v_job_id PER_JOBS.JOB_ID%type;
1274: v_row_num NUMBER := 0;

Line 1273: v_job_id PER_JOBS.JOB_ID%type;

1269: v_error_message_code VARCHAR2(2000);
1270: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;
1271: v_job_level_new NUMBER;
1272: v_job_level_old NUMBER;
1273: v_job_id PER_JOBS.JOB_ID%type;
1274: v_row_num NUMBER := 0;
1275: v_msg_data VARCHAR2(2000);
1276: v_msg_count NUMBER;
1277: CURSOR get_job_ids(l_grade_id per_grades.grade_id%type) is

Line 1879: l_job_id per_jobs.job_id%type;

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
1878:
1879: l_job_id per_jobs.job_id%type;
1880: l_job_level NUMBER;
1881: l_proj_job_group_new NUMBER;
1882: l_proj_job_group_old NUMBER;
1883: l_job_group_id NUMBER;

Line 1888: FROM per_jobs

1884: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1885:
1886: CURSOR get_new_job_ids IS
1887: SELECT job_id
1888: FROM per_jobs
1889: WHERE job_group_id = l_proj_job_group_new
1890: AND business_group_id = p_organization_id;
1891:
1892: CURSOR get_old_job_ids IS

Line 1894: FROM per_jobs

1890: AND business_group_id = p_organization_id;
1891:
1892: CURSOR get_old_job_ids IS
1893: SELECT job_id
1894: FROM per_jobs
1895: WHERE job_group_id = l_proj_job_group_old
1896: AND business_group_id = p_organization_id;
1897:
1898: BEGIN

Line 2382: ,P_Job_id IN per_jobs.job_id%type default NULL

2378: -- This will not affect the workflow process when doing any commit or rollback
2379: PROCEDURE call_forcast_api
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

Line 2401: Cursor person_jobs(l_job_id per_jobs.job_id%type)is

2397:
2398: --- This cursor picks all the persons who are Employees category and
2399: -- belongs to Expenditure Hierarchy
2400: -- and belongs to job id = paremeter
2401: Cursor person_jobs(l_job_id per_jobs.job_id%type)is
2402: SELECT distinct
2403: assn.person_id
2404: ,assn.effective_start_date
2405: ,assn.effective_end_date

Line 2587: (P_job_id_old per_jobs.job_id%type

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
2589: ,P_billable_flag_old pa_resources_denorm.billable_flag%type
2590: ,P_billable_flag_new pa_resources_denorm.billable_flag%type
2591: ,P_utilize_flag_old pa_resources_denorm.utilization_flag%type

Line 2588: ,P_job_id_new per_jobs.job_id%type

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
2589: ,P_billable_flag_old pa_resources_denorm.billable_flag%type
2590: ,P_billable_flag_new pa_resources_denorm.billable_flag%type
2591: ,P_utilize_flag_old pa_resources_denorm.utilization_flag%type
2592: ,P_utilize_flag_new pa_resources_denorm.utilization_flag%type

Line 2603: v_job_id_old PER_JOBS.JOB_ID%type;

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;
2607: v_utilize_flag_old pa_resources_denorm.utilization_flag%type;

Line 2604: v_job_id_new PER_JOBS.JOB_ID%type;

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;
2607: v_utilize_flag_old pa_resources_denorm.utilization_flag%type;
2608: v_utilize_flag_new pa_resources_denorm.utilization_flag%type;

Line 2709: ,P_job_id IN per_jobs.job_id%type

2705: -- this procedure call call_forcast_api which do commit after every resource
2706: -- in a loop to update the forecast items
2707: PROCEDURE per_job_extra_billability
2708: (p_calling_mode IN VARCHAR2
2709: ,P_job_id IN per_jobs.job_id%type
2710: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2711: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2712: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2713: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

Line 2725: v_job_id PER_JOBS.JOB_ID%type;

2721: PRAGMA AUTONOMOUS_TRANSACTION;
2722:
2723: v_return_status VARCHAR2(2000);
2724: v_error_message_code VARCHAR2(2000);
2725: v_job_id PER_JOBS.JOB_ID%type;
2726: v_msg_data VARCHAR2(2000);
2727: v_msg_count NUMBER;
2728: l_pull_res_flag VARCHAR2(1) := 'N';
2729: l_end_date_res_flag VARCHAR2(1) := 'N';

Line 4158: FUNCTION get_job_name(P_job_id IN per_jobs.job_id%type)

4154: RAISE ;
4155:
4156: END ;
4157:
4158: FUNCTION get_job_name(P_job_id IN per_jobs.job_id%type)
4159: RETURN per_jobs.name%type IS
4160:
4161: l_job_name varchar2(240);
4162:

Line 4159: RETURN per_jobs.name%type IS

4155:
4156: END ;
4157:
4158: FUNCTION get_job_name(P_job_id IN per_jobs.job_id%type)
4159: RETURN per_jobs.name%type IS
4160:
4161: l_job_name varchar2(240);
4162:
4163: BEGIN

Line 4167: FROM per_jobs

4163: BEGIN
4164:
4165: SELECT name
4166: INTO l_job_name
4167: FROM per_jobs
4168: WHERE job_id = P_job_id;
4169:
4170: RETURN (l_job_name) ;
4171: EXCEPTION