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.HXC_TIMECARD_AUDIT dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_timecard_audit AS
2: /* $Header: hxctcaudit.pkb 120.18.12020000.4 2012/10/17 07:30:17 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: Function find_overall_status
7: (p_transaction_info in hxc_timecard.transaction_info
8: ) return varchar2 is

Line 351: hr_utility.trace('p_timecard_id = '||p_timecard_id);

347: BEGIN
348:
349: IF g_debug
350: THEN
351: hr_utility.trace('p_timecard_id = '||p_timecard_id);
352: hr_utility.trace('p_application_set = '||p_application_set);
353: END IF;
354:
355: IF p_application_set IS NULL

Line 352: hr_utility.trace('p_application_set = '||p_application_set);

348:
349: IF g_debug
350: THEN
351: hr_utility.trace('p_timecard_id = '||p_timecard_id);
352: hr_utility.trace('p_application_set = '||p_application_set);
353: END IF;
354:
355: IF p_application_set IS NULL
356: THEN

Line 367: hr_utility.trace('l_transferred_to = '||l_transferred_to);

363: CLOSE get_row;
364:
365: IF g_debug
366: THEN
367: hr_utility.trace('l_transferred_to = '||l_transferred_to);
368: hr_utility.trace('l_rowid = '||l_rowid);
369: END IF;
370:
371:

Line 368: hr_utility.trace('l_rowid = '||l_rowid);

364:
365: IF g_debug
366: THEN
367: hr_utility.trace('l_transferred_to = '||l_transferred_to);
368: hr_utility.trace('l_rowid = '||l_rowid);
369: END IF;
370:
371:
372: IF l_rowid IS NULL

Line 388: hr_utility.trace('l_transferred_to = '||l_transferred_to);

384: END LOOP;
385:
386: IF g_debug
387: THEN
388: hr_utility.trace('l_transferred_to = '||l_transferred_to);
389: END IF;
390:
391: -- Update the table.
392: UPDATE hxc_timecard_summary

Line 403: g_debug := hr_utility.debug_enabled;

399:
400:
401: BEGIN
402:
403: g_debug := hr_utility.debug_enabled;
404:
405: -- Bug 8888801
406: -- Initializing the tables for Insert/Update App specific
407: -- details.

Line 452: hr_utility.trace('In maintain details 1');

448: l_bg_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
449:
450:
451: if g_debug then
452: hr_utility.trace('In maintain details 1');
453: end if;
454:
455: hxc_timecard_block_utils.sort_blocks
456: (p_blocks => p_blocks

Line 483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));

479:
480: l_blk_ind := l_detail_blocks(l_detail_ind);
481:
482: --if g_debug then
483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);

Line 484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

480: l_blk_ind := l_detail_blocks(l_detail_ind);
481:
482: --if g_debug then
483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
488: --end if;

Line 485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));

481:
482: --if g_debug then
483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
488: --end if;
489:

Line 486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);

482: --if g_debug then
483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
488: --end if;
489:
490: -- Override status for deleted building blocks. These should always be passed to

Line 487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);

483: -- hr_utility.trace('resource_id is '||to_char(p_blocks(l_blk_ind).resource_id));
484: -- hr_utility.trace('tbb id is '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
485: -- hr_utility.trace('ovn is '||to_char(p_blocks(l_blk_ind).object_version_number));
486: -- hr_utility.trace('process is '||p_blocks(l_blk_ind).process);
487: -- hr_utility.trace('approval is '||p_blocks(l_blk_ind).approval_status);
488: --end if;
489:
490: -- Override status for deleted building blocks. These should always be passed to
491: -- recipient applications for processing once deleted.

Line 518: -- hr_utility.trace('gaz about to insert '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

514: IF ( p_blocks(l_blk_ind).time_building_block_id > 0 AND p_blocks(l_blk_ind).object_version_number = 1 AND p_blocks(l_blk_ind).process = 'Y' )
515: THEN
516:
517: --if g_debug then
518: -- hr_utility.trace('gaz about to insert '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
519: --end if;
520:
521: -- insert row
522:

Line 612: -- hr_utility.trace('gaz about to update '||to_char(p_blocks(l_blk_ind).time_building_Block_id));

608:
609: ELSIF ( p_blocks(l_blk_ind).object_version_number > 1 and p_blocks(l_blk_ind).process = 'Y' )
610: THEN
611: --if g_debug then
612: -- hr_utility.trace('gaz about to update '||to_char(p_blocks(l_blk_ind).time_building_Block_id));
613: --end if;
614:
615: -- update row
616:

Line 927: hr_utility.trace(dbms_utility.format_error_backtrace);

923: THEN
924: NULL;
925: WHEN OTHERS THEN
926:
927: hr_utility.trace(dbms_utility.format_error_backtrace);
928: IF g_debug
929: THEN
930: hr_utility.trace(SQLERRM);
931:

Line 930: hr_utility.trace(SQLERRM);

926:
927: hr_utility.trace(dbms_utility.format_error_backtrace);
928: IF g_debug
929: THEN
930: hr_utility.trace(SQLERRM);
931:
932: END IF;
933:
934: RAISE;

Line 1188: hr_utility.trace('RDB Snapshot Pref not enabled');

1184:
1185: IF nvl(l_resource_rdb_enabled,'N') <> 'Y' THEN
1186:
1187: if g_debug then
1188: hr_utility.trace('RDB Snapshot Pref not enabled');
1189: end if;
1190: return;
1191: END IF;
1192:

Line 1230: hr_utility.trace('maintain_rdb_snapshot');

1226:
1227:
1228:
1229: if g_debug then
1230: hr_utility.trace('maintain_rdb_snapshot');
1231:
1232: if (p_blocks.count>0) then
1233:
1234:

Line 1235: hr_utility.trace(' P_BLOCK TABLE START ');

1231:
1232: if (p_blocks.count>0) then
1233:
1234:
1235: hr_utility.trace(' P_BLOCK TABLE START ');
1236: hr_utility.trace(' *****************');
1237:
1238: l_index := p_blocks.FIRST;
1239:

Line 1236: hr_utility.trace(' *****************');

1232: if (p_blocks.count>0) then
1233:
1234:
1235: hr_utility.trace(' P_BLOCK TABLE START ');
1236: hr_utility.trace(' *****************');
1237:
1238: l_index := p_blocks.FIRST;
1239:
1240: LOOP

Line 1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );

1240: LOOP
1241: EXIT WHEN NOT p_blocks.EXISTS (l_index);
1242:
1243:
1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );
1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;

Line 1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;

1241: EXIT WHEN NOT p_blocks.EXISTS (l_index);
1242:
1243:
1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );
1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;

Line 1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;

1242:
1243:
1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );
1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;

Line 1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;

1243:
1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );
1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;

Line 1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;

1244: hr_utility.trace(' TIME_BUILDING_BLOCK_ID = '|| p_blocks(l_index).TIME_BUILDING_BLOCK_ID );
1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;

Line 1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;

1245: hr_utility.trace(' TYPE = '|| p_blocks(l_index).TYPE ) ;
1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;

Line 1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;

1246: hr_utility.trace(' MEASURE = '|| p_blocks(l_index).MEASURE) ;
1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;

Line 1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;

1247: hr_utility.trace(' UNIT_OF_MEASURE = '|| p_blocks(l_index).UNIT_OF_MEASURE ) ;
1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;

Line 1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;

1248: hr_utility.trace(' START_TIME = '|| p_blocks(l_index).START_TIME ) ;
1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;

Line 1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;

1249: hr_utility.trace(' STOP_TIME = '|| p_blocks(l_index).STOP_TIME ) ;
1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;

Line 1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;

1250: hr_utility.trace(' PARENT_BUILDING_BLOCK_ID = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_ID ) ;
1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;

Line 1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;

1251: hr_utility.trace(' PARENT_IS_NEW = '|| p_blocks(l_index).PARENT_IS_NEW ) ;
1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;

Line 1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;

1252: hr_utility.trace(' SCOPE = '|| p_blocks(l_index).SCOPE ) ;
1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;

Line 1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;

1253: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_blocks(l_index).OBJECT_VERSION_NUMBER ) ;
1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;

Line 1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;

1254: hr_utility.trace(' APPROVAL_STATUS = '|| p_blocks(l_index).APPROVAL_STATUS ) ;
1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;

Line 1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;

1255: hr_utility.trace(' RESOURCE_ID = '|| p_blocks(l_index).RESOURCE_ID ) ;
1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;

Line 1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;

1256: hr_utility.trace(' RESOURCE_TYPE = '|| p_blocks(l_index).RESOURCE_TYPE ) ;
1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;

Line 1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;

1257: hr_utility.trace(' APPROVAL_STYLE_ID = '|| p_blocks(l_index).APPROVAL_STYLE_ID ) ;
1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;

Line 1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;

1258: hr_utility.trace(' DATE_FROM = '|| p_blocks(l_index).DATE_FROM ) ;
1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;

Line 1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;

1259: hr_utility.trace(' DATE_TO = '|| p_blocks(l_index).DATE_TO ) ;
1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;
1267: hr_utility.trace('------------------------------------------------------');

Line 1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;

1260: hr_utility.trace(' COMMENT_TEXT = '|| p_blocks(l_index).COMMENT_TEXT ) ;
1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;
1267: hr_utility.trace('------------------------------------------------------');
1268:

Line 1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;

1261: hr_utility.trace(' PARENT_BUILDING_BLOCK_OVN = '|| p_blocks(l_index).PARENT_BUILDING_BLOCK_OVN ) ;
1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;
1267: hr_utility.trace('------------------------------------------------------');
1268:
1269: l_index := p_blocks.NEXT (l_index);

Line 1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;

1262: hr_utility.trace(' NEW = '|| p_blocks(l_index).NEW ) ;
1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;
1267: hr_utility.trace('------------------------------------------------------');
1268:
1269: l_index := p_blocks.NEXT (l_index);
1270:

Line 1267: hr_utility.trace('------------------------------------------------------');

1263: hr_utility.trace(' CHANGED = '|| p_blocks(l_index).CHANGED ) ;
1264: hr_utility.trace(' PROCESS = '|| p_blocks(l_index).PROCESS ) ;
1265: hr_utility.trace(' APPLICATION_SET_ID = '|| p_blocks(l_index).APPLICATION_SET_ID ) ;
1266: hr_utility.trace(' TRANSLATION_DISPLAY_KEY = '|| p_blocks(l_index).TRANSLATION_DISPLAY_KEY ) ;
1267: hr_utility.trace('------------------------------------------------------');
1268:
1269: l_index := p_blocks.NEXT (l_index);
1270:
1271: END LOOP;

Line 1273: hr_utility.trace(' p_blocks TABLE END ');

1269: l_index := p_blocks.NEXT (l_index);
1270:
1271: END LOOP;
1272:
1273: hr_utility.trace(' p_blocks TABLE END ');
1274: hr_utility.trace(' *****************');
1275:
1276: end if;
1277:

Line 1274: hr_utility.trace(' *****************');

1270:
1271: END LOOP;
1272:
1273: hr_utility.trace(' p_blocks TABLE END ');
1274: hr_utility.trace(' *****************');
1275:
1276: end if;
1277:
1278:

Line 1282: hr_utility.trace(' ATTRIBUTES TABLE START ');

1278:
1279: if (p_attributes.count>0) then
1280:
1281:
1282: hr_utility.trace(' ATTRIBUTES TABLE START ');
1283: hr_utility.trace(' *****************');
1284:
1285: l_index := p_attributes.FIRST;
1286:

Line 1283: hr_utility.trace(' *****************');

1279: if (p_attributes.count>0) then
1280:
1281:
1282: hr_utility.trace(' ATTRIBUTES TABLE START ');
1283: hr_utility.trace(' *****************');
1284:
1285: l_index := p_attributes.FIRST;
1286:
1287: LOOP

Line 1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);

1287: LOOP
1288: EXIT WHEN NOT p_attributes.EXISTS (l_index);
1289:
1290:
1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);
1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;

Line 1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;

1288: EXIT WHEN NOT p_attributes.EXISTS (l_index);
1289:
1290:
1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);
1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;

Line 1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;

1289:
1290:
1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);
1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;

Line 1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;

1290:
1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);
1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;

Line 1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;

1291: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| p_attributes(l_index).TIME_ATTRIBUTE_ID);
1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;

Line 1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;

1292: hr_utility.trace(' BUILDING_BLOCK_ID = '|| p_attributes(l_index).BUILDING_BLOCK_ID ) ;
1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;

Line 1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;

1293: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| p_attributes(l_index).ATTRIBUTE_CATEGORY) ;
1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;

Line 1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;

1294: hr_utility.trace(' ATTRIBUTE1 = '|| p_attributes(l_index).ATTRIBUTE1 ) ;
1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;

Line 1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;

1295: hr_utility.trace(' ATTRIBUTE2 (p_alias_definition_id) = '|| p_attributes(l_index).ATTRIBUTE2 ) ;
1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;

Line 1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;

1296: hr_utility.trace(' ATTRIBUTE3 (l_alias_value_id) = '|| p_attributes(l_index).ATTRIBUTE3 ) ;
1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;

Line 1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;

1297: hr_utility.trace(' ATTRIBUTE4 (p_alias_type) = '|| p_attributes(l_index).ATTRIBUTE4 ) ;
1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;

Line 1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;

1298: hr_utility.trace(' ATTRIBUTE5 = '|| p_attributes(l_index).ATTRIBUTE5 ) ;
1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;

Line 1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;

1299: hr_utility.trace(' ATTRIBUTE6 = '|| p_attributes(l_index).ATTRIBUTE6 ) ;
1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;

Line 1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;

1300: hr_utility.trace(' ATTRIBUTE7 = '|| p_attributes(l_index).ATTRIBUTE7 ) ;
1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;

Line 1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;

1301: hr_utility.trace(' ATTRIBUTE8 = '|| p_attributes(l_index).ATTRIBUTE8 ) ;
1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;

Line 1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;

1302: hr_utility.trace(' ATTRIBUTE9 = '|| p_attributes(l_index).ATTRIBUTE9 ) ;
1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;

Line 1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;

1303: hr_utility.trace(' ATTRIBUTE10 = '|| p_attributes(l_index).ATTRIBUTE10 ) ;
1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;

Line 1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;

1304: hr_utility.trace(' ATTRIBUTE11 = '|| p_attributes(l_index).ATTRIBUTE11 ) ;
1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;

Line 1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;

1305: hr_utility.trace(' ATTRIBUTE12 = '|| p_attributes(l_index).ATTRIBUTE12 ) ;
1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;

Line 1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;

1306: hr_utility.trace(' ATTRIBUTE13 = '|| p_attributes(l_index).ATTRIBUTE13 ) ;
1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;

Line 1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;

1307: hr_utility.trace(' ATTRIBUTE14 = '|| p_attributes(l_index).ATTRIBUTE14 ) ;
1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;

Line 1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;

1308: hr_utility.trace(' ATTRIBUTE15 = '|| p_attributes(l_index).ATTRIBUTE15 ) ;
1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;

Line 1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;

1309: hr_utility.trace(' ATTRIBUTE16 = '|| p_attributes(l_index).ATTRIBUTE16 ) ;
1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;

Line 1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;

1310: hr_utility.trace(' ATTRIBUTE17 = '|| p_attributes(l_index).ATTRIBUTE17 ) ;
1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;

Line 1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;

1311: hr_utility.trace(' ATTRIBUTE18 = '|| p_attributes(l_index).ATTRIBUTE18 ) ;
1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;

Line 1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;

1312: hr_utility.trace(' ATTRIBUTE19 = '|| p_attributes(l_index).ATTRIBUTE19 ) ;
1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;

Line 1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;

1313: hr_utility.trace(' ATTRIBUTE20 = '|| p_attributes(l_index).ATTRIBUTE20 ) ;
1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;

Line 1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;

1314: hr_utility.trace(' ATTRIBUTE21 = '|| p_attributes(l_index).ATTRIBUTE21 ) ;
1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;

Line 1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;

1315: hr_utility.trace(' ATTRIBUTE22 = '|| p_attributes(l_index).ATTRIBUTE22 ) ;
1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;

Line 1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;

1316: hr_utility.trace(' ATTRIBUTE23 = '|| p_attributes(l_index).ATTRIBUTE23 ) ;
1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );

Line 1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;

1317: hr_utility.trace(' ATTRIBUTE24 = '|| p_attributes(l_index).ATTRIBUTE24 ) ;
1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );

Line 1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;

1318: hr_utility.trace(' ATTRIBUTE25 = '|| p_attributes(l_index).ATTRIBUTE25 ) ;
1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );

Line 1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;

1319: hr_utility.trace(' ATTRIBUTE26 = '|| p_attributes(l_index).ATTRIBUTE26 ) ;
1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );

Line 1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );

1320: hr_utility.trace(' ATTRIBUTE27 = '|| p_attributes(l_index).ATTRIBUTE27 ) ;
1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );

Line 1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );

1321: hr_utility.trace(' ATTRIBUTE28 = '|| p_attributes(l_index).ATTRIBUTE28 ) ;
1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );

Line 1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );

1322: hr_utility.trace(' ATTRIBUTE29 (p_alias_ref_object) = '|| p_attributes(l_index).ATTRIBUTE29 ) ;
1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );

Line 1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );

1323: hr_utility.trace(' ATTRIBUTE30 (p_alias_value_name) = '|| p_attributes(l_index).ATTRIBUTE30 ) ;
1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );
1331: hr_utility.trace('------------------------------------------------------');

Line 1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );

1324: hr_utility.trace(' BLD_BLK_INFO_TYPE_ID = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE_ID );
1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );
1331: hr_utility.trace('------------------------------------------------------');
1332:

Line 1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );

1325: hr_utility.trace(' OBJECT_VERSION_NUMBER = '|| p_attributes(l_index).OBJECT_VERSION_NUMBER );
1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );
1331: hr_utility.trace('------------------------------------------------------');
1332:
1333: l_index := p_attributes.NEXT (l_index);

Line 1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );

1326: hr_utility.trace(' NEW = '|| p_attributes(l_index).NEW );
1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );
1331: hr_utility.trace('------------------------------------------------------');
1332:
1333: l_index := p_attributes.NEXT (l_index);
1334:

Line 1331: hr_utility.trace('------------------------------------------------------');

1327: hr_utility.trace(' CHANGED = '|| p_attributes(l_index).CHANGED );
1328: hr_utility.trace(' BLD_BLK_INFO_TYPE = '|| p_attributes(l_index).BLD_BLK_INFO_TYPE );
1329: hr_utility.trace(' PROCESS = '|| p_attributes(l_index).PROCESS );
1330: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| p_attributes(l_index).BUILDING_BLOCK_OVN );
1331: hr_utility.trace('------------------------------------------------------');
1332:
1333: l_index := p_attributes.NEXT (l_index);
1334:
1335: END LOOP;

Line 1337: hr_utility.trace(' ATTRIBUTES TABLE END ');

1333: l_index := p_attributes.NEXT (l_index);
1334:
1335: END LOOP;
1336:
1337: hr_utility.trace(' ATTRIBUTES TABLE END ');
1338: hr_utility.trace(' *****************');
1339:
1340: end if;
1341:

Line 1338: hr_utility.trace(' *****************');

1334:
1335: END LOOP;
1336:
1337: hr_utility.trace(' ATTRIBUTES TABLE END ');
1338: hr_utility.trace(' *****************');
1339:
1340: end if;
1341:
1342: end if; -- g_debug

Line 1493: hr_utility.trace(' PAY ATTRIBUTES TABLE START ');

1489:
1490: if (PAY_TIME_ATTRIBUTE_ID.count>0) then
1491:
1492:
1493: hr_utility.trace(' PAY ATTRIBUTES TABLE START ');
1494: hr_utility.trace(' *****************');
1495:
1496: FOR i in PAY_TIME_ATTRIBUTE_ID.first .. PAY_TIME_ATTRIBUTE_ID.last LOOP
1497:

Line 1494: hr_utility.trace(' *****************');

1490: if (PAY_TIME_ATTRIBUTE_ID.count>0) then
1491:
1492:
1493: hr_utility.trace(' PAY ATTRIBUTES TABLE START ');
1494: hr_utility.trace(' *****************');
1495:
1496: FOR i in PAY_TIME_ATTRIBUTE_ID.first .. PAY_TIME_ATTRIBUTE_ID.last LOOP
1497:
1498:

Line 1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));

1495:
1496: FOR i in PAY_TIME_ATTRIBUTE_ID.first .. PAY_TIME_ATTRIBUTE_ID.last LOOP
1497:
1498:
1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));
1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;

Line 1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;

1496: FOR i in PAY_TIME_ATTRIBUTE_ID.first .. PAY_TIME_ATTRIBUTE_ID.last LOOP
1497:
1498:
1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));
1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));

Line 1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;

1497:
1498:
1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));
1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;

Line 1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));

1498:
1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));
1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;

Line 1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;

1499: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PAY_TIME_ATTRIBUTE_ID(i));
1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;

Line 1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));

1500: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PAY_BUILDING_BLOCK_ID(i)) ;
1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;

Line 1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;

1501: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PAY_ATTRIBUTE_CATEGORY(i)) ;
1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));

Line 1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;

1502: hr_utility.trace(' ATTRIBUTE1 = '|| PAY_ATTRIBUTE1(i));
1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));

Line 1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;

1503: hr_utility.trace(' ATTRIBUTE2 = '|| PAY_ATTRIBUTE2(i)) ;
1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));
1511: hr_utility.trace('------------------------------------------------------');

Line 1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;

1504: hr_utility.trace(' ATTRIBUTE3 = '|| PAY_ATTRIBUTE3(i));
1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));
1511: hr_utility.trace('------------------------------------------------------');
1512:

Line 1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));

1505: hr_utility.trace(' ATTRIBUTE4 = '|| PAY_ATTRIBUTE4(i)) ;
1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));
1511: hr_utility.trace('------------------------------------------------------');
1512:
1513:

Line 1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));

1506: hr_utility.trace(' ATTRIBUTE5 = '|| PAY_ATTRIBUTE5(i)) ;
1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));
1511: hr_utility.trace('------------------------------------------------------');
1512:
1513:
1514:

Line 1511: hr_utility.trace('------------------------------------------------------');

1507: hr_utility.trace(' ATTRIBUTE6 = '|| PAY_ATTRIBUTE6(i)) ;
1508: hr_utility.trace(' ATTRIBUTE7 = '|| PAY_ATTRIBUTE7(i)) ;
1509: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PAY_BUILDING_BLOCK_OVN(i));
1510: hr_utility.trace(' MEASURE = '|| PAY_MEASURE(i));
1511: hr_utility.trace('------------------------------------------------------');
1512:
1513:
1514:
1515: END LOOP;

Line 1517: hr_utility.trace(' PAY ATTRIBUTES TABLE END ');

1513:
1514:
1515: END LOOP;
1516:
1517: hr_utility.trace(' PAY ATTRIBUTES TABLE END ');
1518: hr_utility.trace(' *****************');
1519:
1520:
1521: else

Line 1518: hr_utility.trace(' *****************');

1514:
1515: END LOOP;
1516:
1517: hr_utility.trace(' PAY ATTRIBUTES TABLE END ');
1518: hr_utility.trace(' *****************');
1519:
1520:
1521: else
1522:

Line 1523: hr_utility.trace('NO PAY ATTR');

1519:
1520:
1521: else
1522:
1523: hr_utility.trace('NO PAY ATTR');
1524:
1525: end if;
1526:
1527:

Line 1533: hr_utility.trace(' PA ATTRIBUTES TABLE START ');

1529:
1530: if (PA_TIME_ATTRIBUTE_ID.count>0) then
1531:
1532:
1533: hr_utility.trace(' PA ATTRIBUTES TABLE START ');
1534: hr_utility.trace(' *****************');
1535:
1536: FOR i in PA_TIME_ATTRIBUTE_ID.first .. PA_TIME_ATTRIBUTE_ID.last LOOP
1537:

Line 1534: hr_utility.trace(' *****************');

1530: if (PA_TIME_ATTRIBUTE_ID.count>0) then
1531:
1532:
1533: hr_utility.trace(' PA ATTRIBUTES TABLE START ');
1534: hr_utility.trace(' *****************');
1535:
1536: FOR i in PA_TIME_ATTRIBUTE_ID.first .. PA_TIME_ATTRIBUTE_ID.last LOOP
1537:
1538:

Line 1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));

1535:
1536: FOR i in PA_TIME_ATTRIBUTE_ID.first .. PA_TIME_ATTRIBUTE_ID.last LOOP
1537:
1538:
1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));
1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;

Line 1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;

1536: FOR i in PA_TIME_ATTRIBUTE_ID.first .. PA_TIME_ATTRIBUTE_ID.last LOOP
1537:
1538:
1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));
1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;

Line 1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;

1537:
1538:
1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));
1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;

Line 1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;

1538:
1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));
1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;

Line 1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;

1539: hr_utility.trace(' TIME_ATTRIBUTE_ID = '|| PA_TIME_ATTRIBUTE_ID(i));
1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;

Line 1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;

1540: hr_utility.trace(' BUILDING_BLOCK_ID = '|| PA_BUILDING_BLOCK_ID(i)) ;
1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;

Line 1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;

1541: hr_utility.trace(' ATTRIBUTE_CATEGORY = '|| PA_ATTRIBUTE_CATEGORY(i)) ;
1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));

Line 1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;

1542: hr_utility.trace(' ATTRIBUTE1 = '|| PA_ATTRIBUTE1(i)) ;
1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));

Line 1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;

1543: hr_utility.trace(' ATTRIBUTE2 = '|| PA_ATTRIBUTE2(i)) ;
1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));
1551: hr_utility.trace('------------------------------------------------------');

Line 1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;

1544: hr_utility.trace(' ATTRIBUTE3 = '|| PA_ATTRIBUTE3(i)) ;
1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));
1551: hr_utility.trace('------------------------------------------------------');
1552:

Line 1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));

1545: hr_utility.trace(' ATTRIBUTE4 = '|| PA_ATTRIBUTE4(i)) ;
1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));
1551: hr_utility.trace('------------------------------------------------------');
1552:
1553: END LOOP;

Line 1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));

1546: hr_utility.trace(' ATTRIBUTE5 = '|| PA_ATTRIBUTE5(i)) ;
1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));
1551: hr_utility.trace('------------------------------------------------------');
1552:
1553: END LOOP;
1554:

Line 1551: hr_utility.trace('------------------------------------------------------');

1547: hr_utility.trace(' ATTRIBUTE6 = '|| PA_ATTRIBUTE6(i)) ;
1548: hr_utility.trace(' ATTRIBUTE7 = '|| PA_ATTRIBUTE7(i)) ;
1549: hr_utility.trace(' BUILDING_BLOCK_OVN = '|| PA_BUILDING_BLOCK_OVN(i));
1550: hr_utility.trace(' MEASURE = '|| PA_MEASURE(i));
1551: hr_utility.trace('------------------------------------------------------');
1552:
1553: END LOOP;
1554:
1555: hr_utility.trace(' PA ATTRIBUTES TABLE END ');

Line 1555: hr_utility.trace(' PA ATTRIBUTES TABLE END ');

1551: hr_utility.trace('------------------------------------------------------');
1552:
1553: END LOOP;
1554:
1555: hr_utility.trace(' PA ATTRIBUTES TABLE END ');
1556: hr_utility.trace(' *****************');
1557:
1558: else
1559:

Line 1556: hr_utility.trace(' *****************');

1552:
1553: END LOOP;
1554:
1555: hr_utility.trace(' PA ATTRIBUTES TABLE END ');
1556: hr_utility.trace(' *****************');
1557:
1558: else
1559:
1560: hr_utility.trace('NO PA ATTR');

Line 1560: hr_utility.trace('NO PA ATTR');

1556: hr_utility.trace(' *****************');
1557:
1558: else
1559:
1560: hr_utility.trace('NO PA ATTR');
1561:
1562: end if;
1563:
1564:

Line 1633: hr_utility.trace('NO P_ATTRIBUTES');

1629:
1630: else
1631:
1632: if g_debug then
1633: hr_utility.trace('NO P_ATTRIBUTES');
1634: end if;
1635:
1636: end if; -- p_attributes.COUNT
1637:

Line 1639: hr_utility.trace('Came out of maintain_rdb_snapshot');

1635:
1636: end if; -- p_attributes.COUNT
1637:
1638: if g_debug then
1639: hr_utility.trace('Came out of maintain_rdb_snapshot');
1640: end if;
1641:
1642: END maintain_rdb_snapshot;
1643: