APPS.PAY_GB_P11D_PDF_CONTROL dependencies on HR_UTILITY

Line 141: hr_utility.trace(l_select);

137: and nvl(hasa.assignment_id, paa.assignment_id) = paa.assignment_id
138: )) ';
139: end if;
140: l_group := ' group by paf.person_id, pai_payroll.action_information13 )';
141: hr_utility.trace(l_select);
142: hr_utility.trace(l_from);
143: hr_utility.trace(l_where);
144: hr_utility.trace(l_group);
145: l_sql := l_select || l_from || l_where || l_group;

Line 142: hr_utility.trace(l_from);

138: )) ';
139: end if;
140: l_group := ' group by paf.person_id, pai_payroll.action_information13 )';
141: hr_utility.trace(l_select);
142: hr_utility.trace(l_from);
143: hr_utility.trace(l_where);
144: hr_utility.trace(l_group);
145: l_sql := l_select || l_from || l_where || l_group;
146:

Line 143: hr_utility.trace(l_where);

139: end if;
140: l_group := ' group by paf.person_id, pai_payroll.action_information13 )';
141: hr_utility.trace(l_select);
142: hr_utility.trace(l_from);
143: hr_utility.trace(l_where);
144: hr_utility.trace(l_group);
145: l_sql := l_select || l_from || l_where || l_group;
146:
147: l_sql_cursor := dbms_sql.open_cursor;

Line 144: hr_utility.trace(l_group);

140: l_group := ' group by paf.person_id, pai_payroll.action_information13 )';
141: hr_utility.trace(l_select);
142: hr_utility.trace(l_from);
143: hr_utility.trace(l_where);
144: hr_utility.trace(l_group);
145: l_sql := l_select || l_from || l_where || l_group;
146:
147: l_sql_cursor := dbms_sql.open_cursor;
148: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);

Line 184: hr_utility.trace(l_asg_count);

180: return l_val;
181: end;
182: begin
183: l_asg_count := get_assignment_count;
184: hr_utility.trace(l_asg_count);
185: hr_utility.trace(p_chunk_size);
186: if l_asg_count > 0 then
187: if l_asg_count <= p_chunk_size then
188: hr_utility.trace('All assignments in 1 chunk');

Line 185: hr_utility.trace(p_chunk_size);

181: end;
182: begin
183: l_asg_count := get_assignment_count;
184: hr_utility.trace(l_asg_count);
185: hr_utility.trace(p_chunk_size);
186: if l_asg_count > 0 then
187: if l_asg_count <= p_chunk_size then
188: hr_utility.trace('All assignments in 1 chunk');
189: l_id := fnd_request.submit_request(application => 'PER',

Line 188: hr_utility.trace('All assignments in 1 chunk');

184: hr_utility.trace(l_asg_count);
185: hr_utility.trace(p_chunk_size);
186: if l_asg_count > 0 then
187: if l_asg_count <= p_chunk_size then
188: hr_utility.trace('All assignments in 1 chunk');
189: l_id := fnd_request.submit_request(application => 'PER',
190: program => 'PER_P11D_REP',
191: argument1 => p_print_address_page,
192: argument2 => p_print_p11d,

Line 223: hr_utility.trace('Remainder ' || l_remainder);

219: else
220: -- assignment count > chunk_size
221: l_remainder := get_mod(l_asg_count,p_chunk_size);
222: l_full_chunk := get_div(l_asg_count,p_chunk_size);
223: hr_utility.trace('Remainder ' || l_remainder);
224: hr_utility.trace('Chunk ' || l_full_chunk);
225: if (l_remainder > 0) then
226: l_full_chunk := l_full_chunk + 1;
227: end if;

Line 224: hr_utility.trace('Chunk ' || l_full_chunk);

220: -- assignment count > chunk_size
221: l_remainder := get_mod(l_asg_count,p_chunk_size);
222: l_full_chunk := get_div(l_asg_count,p_chunk_size);
223: hr_utility.trace('Remainder ' || l_remainder);
224: hr_utility.trace('Chunk ' || l_full_chunk);
225: if (l_remainder > 0) then
226: l_full_chunk := l_full_chunk + 1;
227: end if;
228: write_header;

Line 231: hr_utility.trace('Processing chunk : ' || x);

227: end if;
228: write_header;
229: l_temp := 0;
230: for x in 1..l_full_chunk loop
231: hr_utility.trace('Processing chunk : ' || x);
232: l_id := fnd_request.submit_request(application => 'PER',
233: program => 'PER_P11D_REP',
234: argument1 => p_print_address_page,
235: argument2 => p_print_p11d,