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 358: (P_job_id_old per_jobs.job_id%type

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

Line 359: ,P_job_id_new per_jobs.job_id%type

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

Line 372: v_job_id_old PER_JOBS.JOB_ID%type;

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;
374: v_msg_data VARCHAR2(2000);
375: v_msg_count NUMBER;
376: BEGIN

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

Line 441: ( P_job_id_old per_jobs.job_id%type

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

Line 442: ,P_job_id_new per_jobs.job_id%type

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

Line 454: l_job_id_old PER_JOBS.JOB_ID%type;

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

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

Line 511: ( P_job_id per_jobs.job_id%type

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

Line 519: l_job_id PER_JOBS.JOB_ID%type;

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

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

Line 629: l_job_id PER_JOBS.JOB_ID%type;

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

Line 630: l_master_job_id PER_JOBS.JOB_ID%type;

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

Line 631: l_PRJG_job_id PER_JOBS.JOB_ID%type;

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

Line 924: ( P_job_id per_jobs.job_id%type

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

Line 933: l_job_id PER_JOBS.JOB_ID%type;

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

Line 934: l_master_job_id PER_JOBS.JOB_ID%type;

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

Line 942: l_job_id per_jobs.job_id%type

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

Line 1047: ( P_job_id per_jobs.job_id%type

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

Line 1055: l_job_id PER_JOBS.JOB_ID%type;

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

Line 1161: (P_job_id IN per_jobs.job_id%type

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

Line 1168: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;

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

Line 1171: v_job_id PER_JOBS.JOB_ID%type;

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

Line 1176: l_job_id per_jobs.job_id%type

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

Line 1273: v_job_group_id PER_JOBS.JOB_GROUP_ID%type;

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

Line 1276: v_job_id PER_JOBS.JOB_ID%type;

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

Line 1886: l_job_id per_jobs.job_id%type;

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
1885:
1886: l_job_id per_jobs.job_id%type;
1887: l_job_level NUMBER;
1888: l_proj_job_group_new NUMBER;
1889: l_proj_job_group_old NUMBER;
1890: l_job_group_id NUMBER;

Line 1895: FROM per_jobs

1891: P_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1892:
1893: CURSOR get_new_job_ids IS
1894: SELECT job_id
1895: FROM per_jobs
1896: WHERE job_group_id = l_proj_job_group_new
1897: AND business_group_id = p_organization_id;
1898:
1899: CURSOR get_old_job_ids IS

Line 1901: FROM per_jobs

1897: AND business_group_id = p_organization_id;
1898:
1899: CURSOR get_old_job_ids IS
1900: SELECT job_id
1901: FROM per_jobs
1902: WHERE job_group_id = l_proj_job_group_old
1903: AND business_group_id = p_organization_id;
1904:
1905: BEGIN

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

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

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

2404:
2405: --- This cursor picks all the persons who are Employees category and
2406: -- belongs to Expenditure Hierarchy
2407: -- and belongs to job id = paremeter
2408: Cursor person_jobs(l_job_id per_jobs.job_id%type)is
2409: SELECT distinct
2410: assn.person_id
2411: ,assn.effective_start_date
2412: ,assn.effective_end_date

Line 2594: (P_job_id_old per_jobs.job_id%type

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
2596: ,P_billable_flag_old pa_resources_denorm.billable_flag%type
2597: ,P_billable_flag_new pa_resources_denorm.billable_flag%type
2598: ,P_utilize_flag_old pa_resources_denorm.utilization_flag%type

Line 2595: ,P_job_id_new per_jobs.job_id%type

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
2596: ,P_billable_flag_old pa_resources_denorm.billable_flag%type
2597: ,P_billable_flag_new pa_resources_denorm.billable_flag%type
2598: ,P_utilize_flag_old pa_resources_denorm.utilization_flag%type
2599: ,P_utilize_flag_new pa_resources_denorm.utilization_flag%type

Line 2610: v_job_id_old PER_JOBS.JOB_ID%type;

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

Line 2611: v_job_id_new PER_JOBS.JOB_ID%type;

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

Line 2716: ,P_job_id IN per_jobs.job_id%type

2712: -- this procedure call call_forcast_api which do commit after every resource
2713: -- in a loop to update the forecast items
2714: PROCEDURE per_job_extra_billability
2715: (p_calling_mode IN VARCHAR2
2716: ,P_job_id IN per_jobs.job_id%type
2717: ,P_billable_flag_new IN per_job_extra_info.jei_information2%type
2718: ,P_billable_flag_old IN per_job_extra_info.jei_information2%type
2719: ,P_utilize_flag_old IN per_job_extra_info.jei_information3%type
2720: ,P_utilize_flag_new IN per_job_extra_info.jei_information3%type

Line 2732: v_job_id PER_JOBS.JOB_ID%type;

2728: PRAGMA AUTONOMOUS_TRANSACTION;
2729:
2730: v_return_status VARCHAR2(2000);
2731: v_error_message_code VARCHAR2(2000);
2732: v_job_id PER_JOBS.JOB_ID%type;
2733: v_msg_data VARCHAR2(2000);
2734: v_msg_count NUMBER;
2735: l_pull_res_flag VARCHAR2(1) := 'N';
2736: l_end_date_res_flag VARCHAR2(1) := 'N';

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

4293: RAISE ;
4294:
4295: END ;
4296:
4297: FUNCTION get_job_name(P_job_id IN per_jobs.job_id%type)
4298: RETURN per_jobs.name%type IS
4299:
4300: l_job_name varchar2(240);
4301:

Line 4298: RETURN per_jobs.name%type IS

4294:
4295: END ;
4296:
4297: FUNCTION get_job_name(P_job_id IN per_jobs.job_id%type)
4298: RETURN per_jobs.name%type IS
4299:
4300: l_job_name varchar2(240);
4301:
4302: BEGIN

Line 4306: FROM per_jobs

4302: BEGIN
4303:
4304: SELECT name
4305: INTO l_job_name
4306: FROM per_jobs
4307: WHERE job_id = P_job_id;
4308:
4309: RETURN (l_job_name) ;
4310: EXCEPTION