1 package hr_nonrun_asact as
2 /* $Header: pynonrun.pkh 120.0.12010000.1 2008/07/27 23:14:26 appldev ship $ */
3 --
4 /*
5 /*
6 Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
7
8 Name : hr_nonrun_asact
9
10 Description : Non payroll run assignment action processing.
11
12 Test List
13 ---------
14 Procedure Name Date Test Id Status
15 +----------------------------+----------+-----------+-------+--------------+
16 hr_nonrun_asact dsaxby 00-DEC-0000 ---------.
17
18 Change List
19 -----------
20 Date Name Vers Bug No Description
21 ----------- ---------- ----- ------- -----------------------------------
22 23-FEB-2004 NBRISTOW 115.12 Added the get_next chunk procedures
23 16-DEC-2003 NBristow 115.11 Changed parameters to the insact
24 procedure.
25 20-AUG-2003 RThirlby 115.10 Added new procedure
26 ins_additional_asg_action.
27 06-JAN-2003 alogue 115.8 2734876 Pass use_pop_person variable to assact.
28 19-AUG-2002 kkawol 115.35 Added start_date and end_date to insact.
29 23-JUL-2002 NBRISTOW 115.6 Added object type and id to
30 pay_assignment_actions.
31 24-JAN-2002 TBATTOO 115.4 Changes for multi asg prepayments
32 05-SEP-2001 NBRISTOW 115.3 Added source_ation_id to insact.
33 24-AUG-2001 ALOGUE 115.2 Pass p_actype to reinterlock.
34 19-MAY-2000 NBRISTOW 115.1 Added reinterlock.
35 05-AUG-1998 NBRISTOW 110.2 Added insint.
36 06-MAY-1998 NBRISTOW 40.4 Added insact, so that legislations
37 can call this function for the
38 Archiver coding.
39 22-MAR-1993 DSAXBY 3.6 Added processing for QuickPaint.
40 08-JAN-1993 DSAXBY 3.5 Add restrictions by date_earned.
41 06-JAN-1993 DSAXBY 3.4 Mistake in sql statements.
42 05-JAN-1993 DSAXBY 3.3 Further change to sql.
43 05-JAN-1993 DSAXBY 3.2 Used PAY_ACTION_CLASSIFICATIONS.
44 18-DEC-1992 DSAXBY 3.1 Altered range row where clause.
45 02-DEC-1992 DSAXBY 3.0 First created.
46 */
47 ---------------------------get_next_pop_chunk----------------------------
48 /*
49 NAME
50 get_next_pop_chunk - Get the Next Popultaion chunk to process
51 DESCRIPTION
52 Locks and returns person range information from
53 pay_population_ranges. This is used to insert
54 a chunk of assignments at a time.
55 NOTES
56 <none>
57 */
58 procedure get_next_pop_chunk
59 (
60 pactid in number, -- payroll_action_id.
61 atype in varchar2, -- action type.
62 p_lckhandle in varchar2, -- dbms_lock id
63 lub in varchar2, -- last_updated_by.
64 lul in varchar2, -- last_update_login.
65 chunk_type in out nocopy varchar2, -- method for allocating chunk
66 threads in number default 1, -- Number of Threads
67 slave_no in number default 1, -- Slave no
68 curr_chunk in number default 1, -- current chunk
69 max_chunks in number default 9999, -- Max no of Chunks
70 stperson out nocopy number, -- starting_person_id.
71 endperson out nocopy number, -- ending_person_id.
72 chunk out nocopy number, -- chunk_number.
73 rand_chunk out nocopy number -- chunk_number.
74 );
75 --
76 ---------------------------get_next_proc_chunk----------------------------
77 /*
78 NAME
79 get_next_proc_chunk - Get the Next Process chunk to process
80 DESCRIPTION
81 Locks and returns person range information from
82 pay_population_ranges. This is used to insert
83 a chunk of assignments at a time.
84 NOTES
85 There is a COMMIT in this procedure to release
86 the locks and update tables.
87 */
88 procedure get_next_proc_chunk
89 (
90 pactid in number, -- payroll_action_id.
91 chunk_type in out nocopy varchar2, -- method for allocating chunk
92 threads in number default 1, -- Number of Threads
93 slave_no in number default 1, -- Slave no
94 curr_chunk in out nocopy number -- current chunk
95 );
96 --
97 ----------------------------------- asact ----------------------------------
98 /*
99 NAME
100 asact - insert assignment actions and interlocks
101 DESCRIPTION
102 Overall control of the insertion of assignment actions
103 and interlocks for the non run payroll actions.
104 NOTES
105 <none>
106 */
107 procedure asact
108 (
109 pactid in number, -- payroll_action_id
110 atype in varchar2, -- action_type.
111 itpflg in varchar2, -- time dependent legislation flag
112 ptype in number, -- payment_type_id.
113 lub in varchar2, -- last_updated_by.
114 lul in varchar2, -- last_update_login.
115 use_pop_person in number -- use population_ranges person_id column
116 );
117 --
118 ---------------------------------- insact ----------------------------------
119 /*
120 NAME
121 insact - insert assignment action row.
122 DESCRIPTION
123 inserts row into pay_assignment_actions. Does not commit.
124 NOTES
125 <none>
126 */
127 procedure insact
128 (
129 lockingactid in number, -- locking_action_id.
130 assignid in number default null, -- assignment_id
131 pactid in number, -- payroll_action_id
132 chunk in number, -- chunk_number
133 greid in number default null, -- GRE id.
134 prepayid in number default null, -- pre_payment_id.
135 status in varchar2 default 'U', -- action_status.
136 source_act in number default null, -- source_action_id
137 object_id in number default null, -- object id
138 object_type in varchar2 default null, -- object type
139 start_date in date default null, -- start date
140 end_date in date default null, -- end date
141 p_transient_action in boolean default false -- Transient Action
142 );
143 ---------------------------------- insint ----------------------------------
144 /*
145 NAME
146 insint - insert interlock row.
147 DESCRIPTION
148 Simply inserts an interlock row. Does not commit.
149 NOTES
150 <none>
151 */
152 procedure insint
153 (
154 lockingactid in number,
155 lockedactid in number
156 );
157 ---------------------------------- reinterlock ----------------------------------
158 /*
159 NAME
160 reinterlock - Re Inserts Interlocks.
161 DESCRIPTION
162 Simply re inserts interlock rows. Based on the primary (master) interlocked
163 action.
164 NOTES
165 <none>
166 */
167 procedure reinterlock
168 (
169 p_assact number,
170 p_actype varchar2 default 'U'
171 );
172 -----------------------------------------------------------------------------
173 -- Name: ins_additional_asg_action
174 -- Desc: Insert an assignment action to an already existing payroll action.
175 -----------------------------------------------------------------------------
176 Procedure ins_additional_asg_action(p_asg_id number default null
177 ,p_pact_id number
178 ,p_gre_id number default null
179 ,p_object_id number default null
180 ,p_object_type varchar2 default null
181 );
182 -----------------------------------------------------------------------------
183 end hr_nonrun_asact;