1 PACKAGE PER_ASSIGNMENTS_F2_PKG AS
2 /* $Header: peasg01t.pkh 120.2.12010000.1 2008/07/28 04:08:32 appldev ship $ */
3 -----------------------------------------------------------------------------
4 --
5 -- Global record required for Payroll Object Group (POG) functionality
6 --
7 g_old_asg_rec per_asg_shd.g_rec_type;
8 --
9 procedure iu_non_payroll_checks (
10 p_per_id number,
11 p_sess_date date,
12 p_per_sys_st varchar2,
13 p_s_per_sys_st varchar2,
14 p_ass_st_type_id number,
15 p_bg_id number,
16 p_leg_code varchar2,
17 p_ass_id number,
18 p_emp_num varchar2,
19 p_ass_seq number,
20 p_ass_num varchar2);
21 -----------------------------------------------------------------------------
22 --
23 -- Initiates assignment, used to initialize PERWSEMA.
24 --
25 procedure initiate_assignment(
26 p_bus_grp_id number,
27 p_person_id number,
28 p_end_of_time date,
29 p_gl_set_of_books_id IN OUT NOCOPY number,
30 p_leg_code varchar2,
31 p_sess_date date,
32 p_period_of_service_id IN OUT NOCOPY number,
33 p_accounting_flexfield_ok_flag IN OUT NOCOPY varchar2,
34 p_no_scl IN OUT NOCOPY varchar2,
35 p_scl_id_flex_num IN OUT NOCOPY number,
36 p_def_user_st IN OUT NOCOPY varchar2,
37 p_def_st_id IN OUT NOCOPY number,
38 p_yes_meaning IN OUT NOCOPY varchar2,
39 p_no_meaning IN OUT NOCOPY varchar2,
40 p_pg_struct IN OUT NOCOPY varchar2,
41 p_valid_pos_flag IN OUT NOCOPY varchar2,
42 p_valid_job_flag IN OUT NOCOPY varchar2,
43 p_gl_flex_structure IN OUT NOCOPY number,
44 p_set_of_books_name IN OUT NOCOPY varchar2,
45 p_fsp_table_name IN OUT NOCOPY varchar2,
46 p_payroll_installed IN OUT NOCOPY varchar2,
47 p_scl_title IN OUT NOCOPY varchar2,
48 p_terms_required OUT NOCOPY varchar2,
49 p_person_id2 IN number DEFAULT NULL,
50 p_assignment_type IN varchar2 default NULL); -- 3609019
51 -----------------------------------------------------------------------------
52 --
53 -- *** Bundled procedures from update/delete to save on network usage
54 -- for PERWSEMA. ***
55 --
56 -----------------------------------------------------------------------------
57 procedure pre_update_bundle (
58 p_pos_id number,
59 p_org_id number,
60 p_ass_id number,
61 p_row_id varchar2,
62 p_eff_st_date date,
63 p_upd_mode varchar2,
64 p_per_sys_st varchar2,
65 p_s_pos_id IN OUT NOCOPY number,
66 p_s_ass_num IN OUT NOCOPY varchar2,
67 p_s_org_id IN OUT NOCOPY number,
68 p_s_pg_id IN OUT NOCOPY number,
69 p_s_job_id IN OUT NOCOPY number,
70 p_s_grd_id IN OUT NOCOPY number,
71 p_s_pay_id IN OUT NOCOPY number,
72 p_s_def_code_comb_id IN OUT NOCOPY number,
73 p_s_soft_code_kf_id IN OUT NOCOPY number,
74 p_s_per_sys_st IN OUT NOCOPY varchar2,
75 p_s_ass_st_type_id IN OUT NOCOPY number,
76 p_s_prim_flag IN OUT NOCOPY varchar2,
77 p_s_sp_ceil_step_id IN OUT NOCOPY number,
78 p_s_pay_bas IN OUT NOCOPY varchar2,
79 p_return_warning IN OUT NOCOPY varchar2,
80 p_sess_date date default null);
81 -----------------------------------------------------------------------------
82 procedure key_delrec(
83 p_del_mode varchar2,
84 p_val_st_date date,
85 p_eff_st_date date,
86 p_eff_end_date date,
87 p_pd_os_id number,
88 p_per_sys_st varchar2,
89 p_ass_id number,
90 p_grd_id number,
91 p_sp_ceil_st_id number,
92 p_ceil_seq number,
93 p_per_id number,
94 p_sess_date date,
95 p_new_end_date IN OUT NOCOPY date,
96 p_val_end_date date,
97 p_pay_id number,
98 p_pay_basis_id number );--fix for bug 4764140
99 -----------------------------------------------------------------------------
100 procedure pre_delete(
101 p_del_mode varchar2,
102 p_val_st_date date,
103 p_eff_st_date date,
104 p_eff_end_date date,
105 p_pd_os_id number,
106 p_per_sys_st varchar2,
107 p_ass_id number,
108 p_sess_date date,
109 p_new_end_date IN OUT NOCOPY date,
110 p_val_end_date date,
111 p_pay_id number,
112 p_grd_id number,
113 p_sp_ceil_st_id number,
114 p_ceil_seq number,
115 p_per_id number,
116 p_prim_flag varchar2,
117 p_prim_change_flag IN OUT NOCOPY varchar2,
118 p_new_prim_flag IN OUT NOCOPY varchar2,
119 p_re_entry_point IN OUT NOCOPY number,
120 p_returned_warning IN OUT NOCOPY varchar2,
121 p_cancel_atd IN OUT NOCOPY date,
122 p_cancel_lspd IN OUT NOCOPY date,
123 p_reterm_atd IN OUT NOCOPY date,
124 p_reterm_lspd IN OUT NOCOPY date,
125 p_prim_date_from IN OUT NOCOPY date,
126 p_new_prim_ass_id IN OUT NOCOPY number,
127 p_row_id varchar2,
128 p_s_pos_id IN OUT NOCOPY number,
129 p_s_ass_num IN OUT NOCOPY varchar2,
130 p_s_org_id IN OUT NOCOPY number,
131 p_s_pg_id IN OUT NOCOPY number,
132 p_s_job_id IN OUT NOCOPY number,
133 p_s_grd_id IN OUT NOCOPY number,
134 p_s_pay_id IN OUT NOCOPY number,
135 p_s_def_code_comb_id IN OUT NOCOPY number,
136 p_s_soft_code_kf_id IN OUT NOCOPY number,
137 p_s_per_sys_st IN OUT NOCOPY varchar2,
138 p_s_ass_st_type_id IN OUT NOCOPY number,
139 p_s_prim_flag IN OUT NOCOPY varchar2,
140 p_s_sp_ceil_step_id IN OUT NOCOPY number,
141 p_s_pay_bas IN OUT NOCOPY varchar2,
142 p_pay_basis_id number );--fix for bug 4764140
143 -----------------------------------------------------------------------------
144 END PER_ASSIGNMENTS_F2_PKG;