[Home] [Help]
PACKAGE: APPS.PER_ASG_AGGR
Source
1 PACKAGE per_asg_aggr AUTHID CURRENT_USER AS
2 /* $Header: peaggasg.pkh 120.4.12020000.3 2013/03/04 07:10:28 sampmand ship $ */
3
4 FUNCTION assg_aggr_possible (p_person_id IN NUMBER,
5 p_effective_date IN DATE,
6 p_message IN VARCHAR2) RETURN boolean;
7 PROCEDURE check_aggr_assg(p_person_id IN NUMBER,
8 p_effective_date IN DATE,
9 p_per_information9 IN VARCHAR2,
10 p_per_information10 IN VARCHAR2,
11 p_datetrack_update_mode in VARCHAR2 default null); --Bug 8370225
12
13 PROCEDURE set_paye_aggr(p_person_id IN NUMBER,
14 p_effective_date IN DATE,
15 p_assignment_id IN NUMBER,
16 p_payroll_id IN NUMBER);
17
18 FUNCTION get_paye_agg_status(p_person_id IN NUMBER,
19 p_effective_date IN DATE,
20 p_assignment_id IN NUMBER,
21 p_payroll_id IN NUMBER) return varchar2;
22
23 --Bug 10213888
24
25 l_datetrack_mode varchar2(40);
26
27 PROCEDURE set_date_track_mode(l_dt_mode VARCHAR2);
28
29 --Bug 10213888
30
31
32 /*RTI Payroll ID Population Procedures*/
33 PROCEDURE update_rti_agg_person
34 (p_person_id IN per_all_people_f.person_id%TYPE
35 ,p_effective_date IN date);
36
37 PROCEDURE update_rti_agg_new_person
38 (p_person_id IN per_all_people_f.person_id%TYPE
39 ,p_hire_date IN date);
40
41 PROCEDURE update_rti_agg_update_asg
42 (p_assignment_id IN per_all_assignments_f.assignment_id%type
43 ,p_effective_date IN date);
44
45 PROCEDURE update_asg_rti_starter_flag
46 (p_person_id IN per_all_people_f.person_id%TYPE
47 ,p_effective_date IN DATE);
48
49 PROCEDURE update_rti_starter_asg
50 (p_assignment_id IN per_all_assignments_f.assignment_id%type
51 ,p_effective_date IN date);
52
53
54 END per_asg_aggr;