eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_MIGRATION_REPORT dependencies on FND_FILE

Line 166: fnd_file.put_line(fnd_file.output, l_print_string);

162: l_temp_string := rpad(l_temp_string,widthArray(i)+pSpacer,fnd_global.local_chr(32));
163: l_print_string := l_print_string || l_temp_string;
164: --
165: end loop;
166: fnd_file.put_line(fnd_file.output, l_print_string);
167: end loop;
168: end wrapAndPrint;
169: --
170: -- Generate reprot

Line 206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');

202: acty.name in (dynamicPreApprover, dynamicPostApprover) and
203: sysdate between act.start_date and nvl(act.end_date - (ame_util.oneSecond), sysdate) and
204: sysdate between acty.start_date and nvl(acty.end_date - (ame_util.oneSecond), sysdate);
205: begin
206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');
207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));

Line 207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');

203: sysdate between act.start_date and nvl(act.end_date - (ame_util.oneSecond), sysdate) and
204: sysdate between acty.start_date and nvl(acty.end_date - (ame_util.oneSecond), sysdate);
205: begin
206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');
207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

Line 208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

204: sysdate between acty.start_date and nvl(acty.end_date - (ame_util.oneSecond), sysdate);
205: begin
206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');
207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
212: if approversToBeMigrated.count > 0 then

Line 209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));

205: begin
206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');
207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
212: if approversToBeMigrated.count > 0 then
213: curr_person_id := -1;

Line 210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));

206: fnd_file.put_line(fnd_file.output, rpad('Test 1', 11, ' ')||': HR People - To be migrated');
207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
212: if approversToBeMigrated.count > 0 then
213: curr_person_id := -1;
214: for i in 1..approversToBeMigrated.count loop

Line 211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

207: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) that will get migrated to WF_ROLES');
208: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
209: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
210: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
211: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
212: if approversToBeMigrated.count > 0 then
213: curr_person_id := -1;
214: for i in 1..approversToBeMigrated.count loop
215: if(curr_person_id <> approversToBeMigrated(i).id) then

Line 217: fnd_file.put_line(fnd_file.output, '--');

213: curr_person_id := -1;
214: for i in 1..approversToBeMigrated.count loop
215: if(curr_person_id <> approversToBeMigrated(i).id) then
216: curr_person_id := approversToBeMigrated(i).id;
217: fnd_file.put_line(fnd_file.output, '--');
218: fnd_file.put_line(fnd_file.output, '--');
219: wrapAndPrint(pTotalPrintColumns => 2
220: ,pStartPos => 1
221: ,pValue1 => personList(curr_person_id).full_name

Line 218: fnd_file.put_line(fnd_file.output, '--');

214: for i in 1..approversToBeMigrated.count loop
215: if(curr_person_id <> approversToBeMigrated(i).id) then
216: curr_person_id := approversToBeMigrated(i).id;
217: fnd_file.put_line(fnd_file.output, '--');
218: fnd_file.put_line(fnd_file.output, '--');
219: wrapAndPrint(pTotalPrintColumns => 2
220: ,pStartPos => 1
221: ,pValue1 => personList(curr_person_id).full_name
222: ,pWidth1 => 50

Line 246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

242: end if;
243: --
244: --
245: --
246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));

Line 247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');

243: --
244: --
245: --
246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));

Line 248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');

244: --
245: --
246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

Line 249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

245: --
246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
253: if migratedApprovers.count > 0 then

Line 250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));

246: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
253: if migratedApprovers.count > 0 then
254: curr_person_id := -1;

Line 251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));

247: fnd_file.put_line(fnd_file.output, rpad('Test 2', 11, ' ')||': HR People - Already migrated');
248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
253: if migratedApprovers.count > 0 then
254: curr_person_id := -1;
255: for i in 1..migratedApprovers.count loop

Line 252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

248: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This lists down all the people (used within AME) already migrated to WF_ROLES');
249: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
250: fnd_file.put_line(fnd_file.output, rpad('Name', 52, ' ') ||rpad('WF_ROLES.NAME', 50,' '));
251: fnd_file.put_line(fnd_file.output, lpad(' ', 5, ' ')||rpad('Source Table', 32, ' ')||rpad('Source Object', 42,' ') || rpad('Description', 50,' '));
252: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
253: if migratedApprovers.count > 0 then
254: curr_person_id := -1;
255: for i in 1..migratedApprovers.count loop
256: if(curr_person_id <> migratedApprovers(i).id) then

Line 258: fnd_file.put_line(fnd_file.output, '--');

254: curr_person_id := -1;
255: for i in 1..migratedApprovers.count loop
256: if(curr_person_id <> migratedApprovers(i).id) then
257: curr_person_id := migratedApprovers(i).id;
258: fnd_file.put_line(fnd_file.output, '--');
259: fnd_file.put_line(fnd_file.output, '--');
260: wrapAndPrint(pTotalPrintColumns => 2
261: ,pStartPos => 1
262: ,pValue1 => personList(curr_person_id).full_name

Line 259: fnd_file.put_line(fnd_file.output, '--');

255: for i in 1..migratedApprovers.count loop
256: if(curr_person_id <> migratedApprovers(i).id) then
257: curr_person_id := migratedApprovers(i).id;
258: fnd_file.put_line(fnd_file.output, '--');
259: fnd_file.put_line(fnd_file.output, '--');
260: wrapAndPrint(pTotalPrintColumns => 2
261: ,pStartPos => 1
262: ,pValue1 => personList(curr_person_id).full_name
263: ,pWidth1 => 50

Line 287: fnd_file.put_line(fnd_file.output, '--');

283: end if;
284: --
285: --
286: --
287: fnd_file.put_line(fnd_file.output, '--');
288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');

Line 288: fnd_file.put_line(fnd_file.output, '--');

284: --
285: --
286: --
287: fnd_file.put_line(fnd_file.output, '--');
288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');

Line 289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

285: --
286: --
287: fnd_file.put_line(fnd_file.output, '--');
288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');

Line 290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');

286: --
287: fnd_file.put_line(fnd_file.output, '--');
288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

Line 291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');

287: fnd_file.put_line(fnd_file.output, '--');
288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));

Line 292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');

288: fnd_file.put_line(fnd_file.output, '--');
289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));

Line 293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');

289: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));
297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

Line 294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

290: fnd_file.put_line(fnd_file.output, rpad('Test 3', 11, ' ')||': FND User');
291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));
297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
298: if invalidUsers.count > 0 then

Line 295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));

291: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': This table lists all the FND User (linked to a person) used within AME.');
292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));
297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
298: if invalidUsers.count > 0 then
299: for i in 1..invalidUsers.count loop

Line 296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));

292: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': Before migration these approvers are shown as FND Users.');
293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));
297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
298: if invalidUsers.count > 0 then
299: for i in 1..invalidUsers.count loop
300: wrapAndPrint(pTotalPrintColumns => 4

Line 297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

293: fnd_file.put_line(fnd_file.output, lpad(' ', 11, ' ')||': After migration these approvers will be shown as HR People.');
294: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
295: fnd_file.put_line(fnd_file.output, rpad('Source', 32, ' ') ||rpad('Source Name', 32,' ') || rpad('Migrated From', 32,' ') ||rpad('Migrated To', 30,' '));
296: fnd_file.put_line(fnd_file.output, lpad('(User Name)', 75, ' ') ||lpad('(HR People)', 32,' '));
297: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
298: if invalidUsers.count > 0 then
299: for i in 1..invalidUsers.count loop
300: wrapAndPrint(pTotalPrintColumns => 4
301: ,pStartPos => 1

Line 315: fnd_file.put_line(fnd_file.output, '--');

311: end if;
312: --
313: --dynamic pre/post-approver types - which need to be migrated to the corresponding approval groups
314: --
315: fnd_file.put_line(fnd_file.output, '--');
316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');

Line 316: fnd_file.put_line(fnd_file.output, '--');

312: --
313: --dynamic pre/post-approver types - which need to be migrated to the corresponding approval groups
314: --
315: fnd_file.put_line(fnd_file.output, '--');
316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');

Line 317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

313: --dynamic pre/post-approver types - which need to be migrated to the corresponding approval groups
314: --
315: fnd_file.put_line(fnd_file.output, '--');
316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

Line 318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');

314: --
315: fnd_file.put_line(fnd_file.output, '--');
316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));

Line 319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');

315: fnd_file.put_line(fnd_file.output, '--');
316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));
323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

Line 320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');

316: fnd_file.put_line(fnd_file.output, '--');
317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));
323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
324: for r in dynamicActionTypes loop

Line 321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

317: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));
323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
324: for r in dynamicActionTypes loop
325: wrapAndPrint(pTotalPrintColumns => 3

Line 322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));

318: fnd_file.put_line(fnd_file.output, rpad('Test 4', 11, ' ')||': Dynamic Approval Types');
319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));
323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
324: for r in dynamicActionTypes loop
325: wrapAndPrint(pTotalPrintColumns => 3
326: ,pStartPos => 1

Line 323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

319: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': "dynamic pre-approver" and "dynamic post-approver" actions will be moved over to use Approval Groups.');
320: fnd_file.put_line(fnd_file.output, rpad(' ', 11, ' ')||' And the groups will be created with prefix "Dyn. Pre" and "Dyn. Post" respectively');
321: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
322: fnd_file.put_line(fnd_file.output, rpad('Action Type', 32, ' ') ||rpad('Action', 52,' ')|| rpad('"source attribute"', 30,' '));
323: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
324: for r in dynamicActionTypes loop
325: wrapAndPrint(pTotalPrintColumns => 3
326: ,pStartPos => 1
327: ,pValue1 => r.action_type

Line 334: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

330: ,pWidth2 => 50
331: ,pValue3 => r.source_attribute
332: ,pWidth3 => 30);
333: end loop;
334: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
335: --------------------------------------------------------------------
336: -- get custom handlers which require to be re-written
337: --------------------------------------------------------------------
338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');

Line 338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');

334: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
335: --------------------------------------------------------------------
336: -- get custom handlers which require to be re-written
337: --------------------------------------------------------------------
338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');
339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');
340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));
342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

Line 339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');

335: --------------------------------------------------------------------
336: -- get custom handlers which require to be re-written
337: --------------------------------------------------------------------
338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');
339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');
340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));
342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
343: for r in customHandlers loop

Line 340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

336: -- get custom handlers which require to be re-written
337: --------------------------------------------------------------------
338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');
339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');
340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));
342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
343: for r in customHandlers loop
344: wrapAndPrint(pTotalPrintColumns => 2

Line 341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));

337: --------------------------------------------------------------------
338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');
339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');
340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));
342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
343: for r in customHandlers loop
344: wrapAndPrint(pTotalPrintColumns => 2
345: ,pStartPos => 1

Line 342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));

338: fnd_file.put_line(fnd_file.output, rpad('Test 5', 11, ' ')||': Custom Handlers');
339: fnd_file.put_line(fnd_file.output, rpad('Data Changes', 11, ' ')||': The following Custom Handlers (Action Types) will need to be re-written.');
340: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
341: fnd_file.put_line(fnd_file.output, rpad('Action Type Name', 52, ' ') ||rpad('Handler Name', 50,' '));
342: fnd_file.put_line(fnd_file.output, rpad('-', 132, '-'));
343: for r in customHandlers loop
344: wrapAndPrint(pTotalPrintColumns => 2
345: ,pStartPos => 1
346: ,pValue1 => r.name

Line 351: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));

347: ,pWidth1 => 50
348: ,pValue2 => r.procedure_name
349: ,pWidth2 => 50);
350: end loop;
351: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
352: fnd_file.put_line(fnd_file.output, '*** End of Report ***');
353: end printReport;
354: --
355: -- P U B L I C R O U T I N E S

Line 352: fnd_file.put_line(fnd_file.output, '* End of Report *');

348: ,pValue2 => r.procedure_name
349: ,pWidth2 => 50);
350: end loop;
351: fnd_file.put_line(fnd_file.output, rpad('=', 132, '='));
352: fnd_file.put_line(fnd_file.output, '*** End of Report ***');
353: end printReport;
354: --
355: -- P U B L I C R O U T I N E S
356: --