APPS.PQP_EXPPREPROC_PKG dependencies on HR_UTILITY

Line 176: --hr_utility.trace_on('Y','ORACLE');

172: -- but we have to take into account assignments and
173: -- personal payment methods.
174: BEGIN
175:
176: --hr_utility.trace_on('Y','ORACLE');
177: hr_utility.set_location('procpyr',1);
178:
179: OPEN c_parameters(pactid);
180: FETCH c_parameters into leg_param,

Line 177: hr_utility.set_location('procpyr',1);

173: -- personal payment methods.
174: BEGIN
175:
176: --hr_utility.trace_on('Y','ORACLE');
177: hr_utility.set_location('procpyr',1);
178:
179: OPEN c_parameters(pactid);
180: FETCH c_parameters into leg_param,
181: l_consolidation_set_id,

Line 188: hr_utility.set_location('procpyr',1);

184: l_act_date,
185: l_jd_cd
186: ;
187: CLOSE c_parameters;
188: hr_utility.set_location('procpyr',1);
189:
190: l_off_date :=pqp_expreplod_pkg.get_offset_date
191: ( l_payroll_id
192: ,l_consolidation_set_id

Line 198: hr_utility.set_location('procpyr',2);

194:
195: OPEN c_actions(pactid,stperson,endperson,l_off_date);
196: num := 0;
197: LOOP
198: hr_utility.set_location('procpyr',2);
199: fetch c_actions into lockedactid,assignid;
200: if c_actions%found then num := num + 1; end if;
201: exit when c_actions%notfound;
202:

Line 206: hr_utility.set_location('procpyr',3);

202:
203: --
204:
205:
206: hr_utility.set_location('procpyr',3);
207: select pay_assignment_actions_s.nextval
208: into lockingactid
209: from dual;
210: --