1 PACKAGE PER_ASSIGNMENTS_F3_PKG AUTHID CURRENT_USER AS
2 /* $Header: peasg01t.pkh 120.3.12020000.3 2012/07/05 01:02:38 amnaraya ship $ */
3 -----------------------------------------------------------------------------
4 procedure process_end_status(
5 p_ass_id number,
6 p_sess_date date,
7 p_eff_end_date date,
8 p_eot date);
9 -----------------------------------------------------------------------------
10 procedure process_term_status(
11 p_ass_id number,
12 p_sess_date date);
13 -----------------------------------------------------------------------------
14 procedure validate_primary_flag(
15 p_val_st_date date,
16 p_pd_os_id number,
17 p_ass_id number);
18 -----------------------------------------------------------------------------
19 procedure test_for_cancel_term(
20 p_ass_id number,
21 p_val_start_date date,
22 p_val_end_date date,
23 p_mode varchar2,
24 p_per_sys_st varchar2,
25 p_s_per_sys_st varchar2,
26 p_cancel_atd IN OUT NOCOPY date,
27 p_cancel_lspd IN OUT NOCOPY date,
28 p_reterm_atd IN OUT NOCOPY date,
29 p_reterm_lspd IN OUT NOCOPY date);
30 -----------------------------------------------------------------------------
31 procedure check_future_primary(
32 p_dt_mode varchar2,
33 p_val_start_date date,
34 p_prim_flag varchar2,
35 p_eff_start_date date,
36 p_s_prim_flag varchar2,
37 p_prim_change_flag IN OUT NOCOPY varchar2,
38 p_new_prim_flag IN OUT NOCOPY varchar2,
39 p_ass_id number,
40 p_eff_end_date date,
41 p_pd_os_id number,
42 p_show_cand_prim_assgts IN OUT NOCOPY varchar2,
43 p_prim_date_from IN OUT NOCOPY date,
44 p_new_prim_ass_id IN OUT NOCOPY varchar2);
45 -----------------------------------------------------------------------------
46 procedure pre_update_bundle2(
47 p_upd_mode varchar2,
48 p_del_mode varchar2,
49 p_sess_date date,
50 p_per_sys_st varchar2,
51 p_val_st_date date,
52 p_new_end_date date,
53 p_val_end_date date,
54 p_ass_id number,
55 p_pay_id number,
56 p_eot date,
57 p_eff_end_date date,
58 p_prim_flag varchar2,
59 p_new_prim_flag IN OUT NOCOPY varchar2,
60 p_pd_os_id number,
61 p_s_per_sys_st varchar2,
62 p_ass_number varchar2,
63 p_s_ass_number varchar2,
64 p_row_id varchar2,
65 p_s_prim_flag varchar2,
66 p_bg_id number,
67 p_eff_st_date date,
68 p_grd_id number,
69 p_sp_ceil_st_id number,
70 p_ceil_seq number,
71 p_re_entry_point IN OUT NOCOPY number,
72 p_returned_warning IN OUT NOCOPY varchar2,
73 p_prim_change_flag IN OUT NOCOPY varchar2,
74 p_prim_date_from IN OUT NOCOPY date,
75 p_new_prim_ass_id IN OUT NOCOPY varchar2,
76 p_cancel_atd IN OUT NOCOPY date,
77 p_cancel_lspd IN OUT NOCOPY date,
78 p_reterm_atd IN OUT NOCOPY date,
79 p_reterm_lspd IN OUT NOCOPY date,
80 p_copy_y_to_prim_ch IN OUT NOCOPY varchar2,
81 p_pay_basis_id number, --fix for bug 4764140
82 p_ins_new_sal_flag VARCHAR2 DEFAULT 'N' -- fix for bug 8439611
83 );
84 -----------------------------------------------------------------------------
85 --
86 -- UPDATE_AND_DELETE_BUNDLE: procedure to bundle procedure calls which follow
87 -- each other at pre_update and pre_delete time (on PERWSEMA).
88 --
89 -- p_re_entry_point is used to re-enter code after warnings and prevent
90 -- code being re-run. A p_re_entry_point of 0 implies successful completion.
91 --
92 -- A null p_re_entry_point should be passed to run whole procedure.
93 -- p_only_one_entry_point is 'Y' if only the given entry point is to be
94 -- run through. eg If p_re_entry_point=2 and p_only_one_entry_point='Y' then
95 -- only the code relating to PAYROLL_CHANGE_VALIDATE will be run and then
96 -- the procedure will finish.
97 -- Normally the value of p_only_one_entry_point will be 'N' where the code
98 -- will run through until the end of the proc unless it hits a warning or
99 -- error.
100 --
101 procedure update_and_delete_bundle(
102 p_dt_mode varchar2,
103 p_val_st_date date,
104 p_eff_st_date date,
105 p_eff_end_date date,
106 p_pd_os_id number,
107 p_per_sys_st varchar2,
108 p_ass_id number,
109 p_val_end_date date,
110 p_dt_upd_mode varchar2,
111 p_dt_del_mode varchar2,
112 p_sess_date date,
113 p_pay_id number,
114 p_grd_id number,
115 p_sp_ceil_st_id number,
116 p_ceil_seq number,
117 p_new_end_date IN OUT NOCOPY date,
118 p_returned_warning IN OUT NOCOPY varchar2,
119 p_re_entry_point IN OUT NOCOPY number,
120 p_only_one_entry_point varchar2,
121 p_pay_basis_id number, --fix for bug 4764140
122 p_ins_new_sal_flag VARCHAR2 DEFAULT 'N' -- fix for bug 8439611
123 );
124 -----------------------------------------------------------------------------
125 END PER_ASSIGNMENTS_F3_PKG;