PACKAGE: APPS.PA_PAY_UTIL

Source

1 PACKAGE PA_PAY_UTIL AUTHID CURRENT_USER AS
2  /* $Header: PAPYUTLS.pls 120.6 2011/03/25 12:31:29 racheruv noship $ */
3 PROCEDURE update_pa_audit
4 (
5   P_PAYROLL_ACTION_ID IN  NUMBER
6 , P_PAYROLL_ID        IN  NUMBER
7 , P_TIME_PERIOD_ID    IN  VARCHAR2
8 , P_PERSON_ID         IN  NUMBER
9 , P_ASSIGNMENT_ID     IN  NUMBER
10 , X_RETURN_STATUS     OUT NOCOPY VARCHAR2
11 );
12 
13  g_expenditure_item_id number;
14  g_project_number      pa_projects_all.segment1%TYPE;
15  g_task_number         pa_tasks.task_number%TYPE;
16  g_job_name            per_jobs_v.name%TYPE;
17  g_work_type_name      pa_work_types_vl.name%TYPE;
18  g_location_code       hr_locations.location_code%TYPE;
19 
20 FUNCTION get_project(p_assignment_id NUMBER,
21                      p_earned_date   DATE)
22   return varchar2;
23 
24 FUNCTION get_task(p_assignment_id NUMBER,
25                   p_earned_date   DATE)
26   return varchar2;
27 
28 FUNCTION get_location(p_assignment_id NUMBER,
29                       p_earned_date   DATE)
30   return varchar2;
31 
32 FUNCTION get_job(p_assignment_id NUMBER,
33                  p_earned_date   DATE)
34   return varchar2;
35 
36 FUNCTION get_work_type(p_assignment_id NUMBER,
37                        p_earned_date   DATE)
38   return varchar2;
39 
40  procedure get_hr_rate(p_person_id      		in NUMBER,
41                        p_assignment_id  		in number,
42                        p_ei_date        		in date,
43                        p_ei_id          		in varchar2,
44                        p_rbc_elem_type_id	    in number,
45                        x_rate           		OUT NOCOPY varchar2);
46 
47  PROCEDURE set_global_ei(p_ei_id number);
48 
49 END;