APPS.PAY_GB_P11D_PDF_CONTROL dependencies on HR_UTILITY

Line 137: hr_utility.trace(l_select);

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

Line 138: hr_utility.trace(l_from);

134: )) ';
135: end if;
136: l_group := ' group by paf.person_id, pai_payroll.action_information13 )';
137: hr_utility.trace(l_select);
138: hr_utility.trace(l_from);
139: hr_utility.trace(l_where);
140: hr_utility.trace(l_group);
141: l_sql := l_select || l_from || l_where || l_group;
142:

Line 139: hr_utility.trace(l_where);

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

Line 140: hr_utility.trace(l_group);

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

Line 180: hr_utility.trace(l_asg_count);

176: return l_val;
177: end;
178: begin
179: l_asg_count := get_assignment_count;
180: hr_utility.trace(l_asg_count);
181: hr_utility.trace(p_chunk_size);
182: if l_asg_count > 0 then
183: if l_asg_count <= p_chunk_size then
184: hr_utility.trace('All assignments in 1 chunk');

Line 181: hr_utility.trace(p_chunk_size);

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

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

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

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

211: else
212: -- assignment count > chunk_size
213: l_remainder := get_mod(l_asg_count,p_chunk_size);
214: l_full_chunk := get_div(l_asg_count,p_chunk_size);
215: hr_utility.trace('Remainder ' || l_remainder);
216: hr_utility.trace('Chunk ' || l_full_chunk);
217: if (l_remainder > 0) then
218: l_full_chunk := l_full_chunk + 1;
219: end if;

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

212: -- assignment count > chunk_size
213: l_remainder := get_mod(l_asg_count,p_chunk_size);
214: l_full_chunk := get_div(l_asg_count,p_chunk_size);
215: hr_utility.trace('Remainder ' || l_remainder);
216: hr_utility.trace('Chunk ' || l_full_chunk);
217: if (l_remainder > 0) then
218: l_full_chunk := l_full_chunk + 1;
219: end if;
220: write_header;

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

219: end if;
220: write_header;
221: l_temp := 0;
222: for x in 1..l_full_chunk loop
223: hr_utility.trace('Processing chunk : ' || x);
224: l_id := fnd_request.submit_request(application => 'PER',
225: program => 'PER_P11D_REP',
226: argument1 => p_print_address_page,
227: argument2 => p_print_p11d,