DBA Data[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;