DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_PAY_UTIL

Line 812: pa_pay_util.g_project_number := NULL;

808: -- dbms_output.put_line('pp_person_id '||p_person_id);
809:
810: -- 12.2 payroll integration .. rbc reqmt
811:
812: pa_pay_util.g_project_number := NULL;
813: pa_pay_util.g_task_number := NULL;
814: pa_pay_util.g_location_code := NULL;
815: pa_pay_util.g_job_name := NULL;
816: pa_pay_util.g_work_type_name := NULL;

Line 813: pa_pay_util.g_task_number := NULL;

809:
810: -- 12.2 payroll integration .. rbc reqmt
811:
812: pa_pay_util.g_project_number := NULL;
813: pa_pay_util.g_task_number := NULL;
814: pa_pay_util.g_location_code := NULL;
815: pa_pay_util.g_job_name := NULL;
816: pa_pay_util.g_work_type_name := NULL;
817:

Line 814: pa_pay_util.g_location_code := NULL;

810: -- 12.2 payroll integration .. rbc reqmt
811:
812: pa_pay_util.g_project_number := NULL;
813: pa_pay_util.g_task_number := NULL;
814: pa_pay_util.g_location_code := NULL;
815: pa_pay_util.g_job_name := NULL;
816: pa_pay_util.g_work_type_name := NULL;
817:
818: if p_person_id is not null then

Line 815: pa_pay_util.g_job_name := NULL;

811:
812: pa_pay_util.g_project_number := NULL;
813: pa_pay_util.g_task_number := NULL;
814: pa_pay_util.g_location_code := NULL;
815: pa_pay_util.g_job_name := NULL;
816: pa_pay_util.g_work_type_name := NULL;
817:
818: if p_person_id is not null then
819:

Line 816: pa_pay_util.g_work_type_name := NULL;

812: pa_pay_util.g_project_number := NULL;
813: pa_pay_util.g_task_number := NULL;
814: pa_pay_util.g_location_code := NULL;
815: pa_pay_util.g_job_name := NULL;
816: pa_pay_util.g_work_type_name := NULL;
817:
818: if p_person_id is not null then
819:
820: select name

Line 821: into pa_pay_util.g_job_name

817:
818: if p_person_id is not null then
819:
820: select name
821: into pa_pay_util.g_job_name
822: from per_jobs_v
823: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_rate_calc_date);
824: select location_code
825: into pa_pay_util.g_location_code

Line 825: into pa_pay_util.g_location_code

821: into pa_pay_util.g_job_name
822: from per_jobs_v
823: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_rate_calc_date);
824: select location_code
825: into pa_pay_util.g_location_code
826: from hr_locations a, per_all_assignments_f b
827: where b.person_id = p_person_id
828: and a.location_use = 'HR'
829: and a.location_id = b.location_id

Line 836: into pa_pay_util.g_project_number

832: end if;
833:
834: -- get the project number and task number details
835: select segment1
836: into pa_pay_util.g_project_number
837: from pa_projects
838: where project_id = p_project_id;
839:
840: if p_task_id is not null then

Line 843: into pa_pay_util.g_task_number

839:
840: if p_task_id is not null then
841: -- get the task number details
842: select task_number
843: into pa_pay_util.g_task_number
844: from pa_tasks
845: where task_id = p_task_id;
846:
847: -- get the default work type information from the task

Line 850: into pa_pay_util.g_work_type_name

846:
847: -- get the default work type information from the task
848: begin
849: select name
850: into pa_pay_util.g_work_type_name
851: from pa_work_types_vl a, pa_tasks b
852: where a.work_type_id = b.work_type_id
853: and b.task_id = p_task_id;
854:

Line 857: pa_pay_util.g_work_type_name := NULL;

853: and b.task_id = p_task_id;
854:
855: exception
856: when no_data_found then
857: pa_pay_util.g_work_type_name := NULL;
858: end;
859: end if;
860: -- 12.2 payroll integration .. rbc reqmt
861:

Line 2534: pa_pay_util.g_project_number := NULL;

2530: END IF;
2531:
2532: /* 12.2 payroll intg .. set the globals for HR rates .. */
2533:
2534: pa_pay_util.g_project_number := NULL;
2535: pa_pay_util.g_task_number := NULL;
2536: pa_pay_util.g_location_code := NULL;
2537: pa_pay_util.g_job_name := NULL;
2538: pa_pay_util.g_work_type_name := NULL;

Line 2535: pa_pay_util.g_task_number := NULL;

2531:
2532: /* 12.2 payroll intg .. set the globals for HR rates .. */
2533:
2534: pa_pay_util.g_project_number := NULL;
2535: pa_pay_util.g_task_number := NULL;
2536: pa_pay_util.g_location_code := NULL;
2537: pa_pay_util.g_job_name := NULL;
2538: pa_pay_util.g_work_type_name := NULL;
2539:

Line 2536: pa_pay_util.g_location_code := NULL;

2532: /* 12.2 payroll intg .. set the globals for HR rates .. */
2533:
2534: pa_pay_util.g_project_number := NULL;
2535: pa_pay_util.g_task_number := NULL;
2536: pa_pay_util.g_location_code := NULL;
2537: pa_pay_util.g_job_name := NULL;
2538: pa_pay_util.g_work_type_name := NULL;
2539:
2540: if p_person_id is not null then

Line 2537: pa_pay_util.g_job_name := NULL;

2533:
2534: pa_pay_util.g_project_number := NULL;
2535: pa_pay_util.g_task_number := NULL;
2536: pa_pay_util.g_location_code := NULL;
2537: pa_pay_util.g_job_name := NULL;
2538: pa_pay_util.g_work_type_name := NULL;
2539:
2540: if p_person_id is not null then
2541: if p_forecast_job_id is null then

Line 2538: pa_pay_util.g_work_type_name := NULL;

2534: pa_pay_util.g_project_number := NULL;
2535: pa_pay_util.g_task_number := NULL;
2536: pa_pay_util.g_location_code := NULL;
2537: pa_pay_util.g_job_name := NULL;
2538: pa_pay_util.g_work_type_name := NULL;
2539:
2540: if p_person_id is not null then
2541: if p_forecast_job_id is null then
2542: select name

Line 2543: into pa_pay_util.g_job_name

2539:
2540: if p_person_id is not null then
2541: if p_forecast_job_id is null then
2542: select name
2543: into pa_pay_util.g_job_name
2544: from per_jobs_v
2545: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_asgn_start_date);
2546: end if;
2547:

Line 2549: into pa_pay_util.g_location_code

2545: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_asgn_start_date);
2546: end if;
2547:
2548: select location_code
2549: into pa_pay_util.g_location_code
2550: from hr_locations a, per_all_assignments_f b
2551: where b.person_id = p_person_id
2552: and a.location_use = 'HR'
2553: and a.location_id = b.location_id

Line 2558: into pa_pay_util.g_job_name

2554: and p_asgn_start_date between b.effective_start_date and nvl(p_asgn_start_date, b.effective_end_date);
2555:
2556: elsif p_forecast_job_id is not null then
2557: select name
2558: into pa_pay_util.g_job_name
2559: from per_jobs_v
2560: where job_id = p_forecast_job_id;
2561: end if;
2562:

Line 2565: into pa_pay_util.g_project_number

2561: end if;
2562:
2563: -- get the project number and task number details
2564: select segment1
2565: into pa_pay_util.g_project_number
2566: from pa_projects
2567: where project_id = p_project_id;
2568:
2569: if p_task_id is not null then

Line 2572: into pa_pay_util.g_task_number

2568:
2569: if p_task_id is not null then
2570: -- get the task number details
2571: select task_number
2572: into pa_pay_util.g_task_number
2573: from pa_tasks
2574: where task_id = p_task_id;
2575:
2576: -- get the default work type information from the task

Line 2579: into pa_pay_util.g_work_type_name

2575:
2576: -- get the default work type information from the task
2577: begin
2578: select name
2579: into pa_pay_util.g_work_type_name
2580: from pa_work_types_vl a, pa_tasks b
2581: where a.work_type_id = b.work_type_id
2582: and b.task_id = p_task_id;
2583:

Line 2586: pa_pay_util.g_work_type_name := NULL;

2582: and b.task_id = p_task_id;
2583:
2584: exception
2585: when no_data_found then
2586: pa_pay_util.g_work_type_name := NULL;
2587: end;
2588: end if;
2589:
2590: /* 12.2 payroll intg .. set globals for HR rates .. end */