DBA Data[Home] [Help]

PACKAGE: APPS.PER_ASSIGNMENTS_F1_PKG

Source


1 PACKAGE PER_ASSIGNMENTS_F1_PKG AUTHID CURRENT_USER AS
2 /* $Header: peasg01t.pkh 120.3.12020000.3 2012/07/05 01:02:38 amnaraya ship $ */
3 -----------------------------------------------------------------------------
4 -----------------------------------------------------------------------------
5 --
6 --  *****  Public procedures moved off client for performance. *****
7 --
8 -----------------------------------------------------------------------------
9 procedure post_update(
10 	p_upd_mode		varchar2,
11         p_new_prim_flag		varchar2,
12         p_val_st_date		date,
13         p_new_end_date		date,
14         p_eot			date,
15         p_pd_os_id		number,
16         p_ass_id		number,
17         p_new_prim_ass_id	IN OUT NOCOPY number,
18         p_prim_change_flag	IN OUT NOCOPY varchar2,
19         p_old_pg_id     number,  -- Bug#3924690.
20 	p_new_pg_id			number,
21     p_old_org_id        number,  -- Bug#13960540
22     p_new_org_id        number,  -- Bug#13960540
23     p_old_emp_cat       varchar2,  -- Bug#13960540
24     p_new_emp_cat       varchar2,  -- Bug#13960540
25 	p_grd_id		number,
26 	p_sess_date		date,
27 	p_s_grd_id		number,
28 	p_eff_end_date		date,
29 	p_per_sys_st		varchar2,
30         p_old_per_sys_st        varchar2,  --#2404335
31 	p_val_end_date		date,
32 	p_del_mode		varchar2,
33 	p_bg_id			number,
34 	p_old_pay_id		number,
35 	p_new_pay_id		number,
36 	p_group_name		varchar2,
37 	p_was_end_assign	varchar2,
38 	p_cancel_atd		date,
39 	p_cancel_lspd		date,
40 	p_reterm_atd		date,
41 	p_reterm_lspd		date,
42 	p_scl_id		number,
43 	p_scl_concat		varchar2,
44         p_end_salary            varchar2 ,
45 	p_warning		IN OUT NOCOPY varchar2,
46 	p_re_entry_point	IN OUT NOCOPY number,
47         p_future_spp_warning    OUT NOCOPY boolean);
48 -----------------------------------------------------------------------------
49 procedure post_insert(
50 	p_prim_change_flag	IN OUT NOCOPY varchar2,
51 	p_val_st_date		date,
52 	p_new_end_date		date,
53 	p_eot			date,
54 	p_pd_os_id		number,
55 	p_ass_id		number,
56 	p_new_prim_ass_id	IN OUT NOCOPY number,
57 	p_pg_id			number,
58 	p_group_name		varchar2,
59 	p_bg_id			number,
60 	p_dt_upd_mode		varchar2,
61         p_dt_del_mode		varchar2,
62         p_per_sys_st		varchar2,
63         p_sess_date		date,
64        	p_val_end_date		date,
65 	p_new_pay_id		number,
66 	p_old_pay_id		number,
67 	p_scl_id		number,
68 	p_scl_concat		varchar2,
69 	p_warning		IN OUT NOCOPY varchar2);
70 -----------------------------------------------------------------------------
71 procedure post_delete(
72 	p_ass_id		number,
73 	p_grd_id		number,
74 	p_sess_date		date,
75 	p_new_end_date		date,
76 	p_val_end_date		date,
77 	p_eff_end_date		date,
78 	p_del_mode		varchar2,
79 	p_val_st_date		date,
80 	p_new_prim_flag		varchar2,
81 	p_eot			date,
82 	p_pd_os_id		number,
83 	p_new_prim_ass_id	IN OUT NOCOPY number,
84 	p_prim_change_flag	IN OUT NOCOPY varchar2,
85 	p_per_sys_st		varchar2,
86 	p_bg_id			number,
87 	p_old_pay_id		number,
88 	p_new_pay_id		number,
89 	p_cancel_atd		date,
90         p_cancel_lspd		date,
91         p_reterm_atd		date,
92         p_reterm_lspd		date,
93 	p_warning		IN OUT NOCOPY varchar2,
94 	p_future_spp_warning OUT NOCOPY boolean,
95 	p_cost_warning          OUT NOCOPY boolean);
96 -----------------------------------------------------------------------------
97 END PER_ASSIGNMENTS_F1_PKG;