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_RETRIEVE_ABSENCES dependencies on HXC_BLOCK_TABLE_TYPE

Line 430: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

426: p_lock_rowid IN VARCHAR2,
427: p_source IN VARCHAR2,
428: p_timekeeper_id IN NUMBER,
429: p_iteration_count IN NUMBER,
430: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
431: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )
432: IS
433:
434: l_abs_tab abs_tab;

Line 465: p_block_array := HXC_BLOCK_TABLE_TYPE();

461:
462: IF l_abs_tab.COUNT > 0
463: THEN
464:
465: p_block_array := HXC_BLOCK_TABLE_TYPE();
466: p_block_array.EXTEND(1);
467: l_block_ind := p_block_array.first;
468: p_block_array(l_block_ind):= HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
469: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 673: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

669: p_start_date IN DATE,
670: p_end_date IN DATE,
671: p_approval_style_id IN NUMBER,
672: p_lock_rowid IN VARCHAR2,
673: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
674: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )
675: IS
676:
677: l_abs_tab ABS_TAB;

Line 711: p_block_array := HXC_BLOCK_TABLE_TYPE();

707:
708: IF l_abs_tab.COUNT > 0
709: THEN
710:
711: p_block_array := HXC_BLOCK_TABLE_TYPE();
712: p_block_array.EXTEND(1);
713: l_block_ind := p_block_array.first;
714: p_block_array(l_block_ind):= HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
715: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 1369: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

1365: p_lock_rowid IN VARCHAR2,
1366: p_source IN VARCHAR2 ,
1367: p_timekeeper_id IN NUMBER,
1368: p_iteration_count IN NUMBER,
1369: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
1370: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )
1371: IS
1372:
1373: l_index BINARY_INTEGER;

Line 1503: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

1499: p_start_date IN DATE,
1500: p_end_date IN DATE,
1501: p_approval_style_id IN NUMBER,
1502: p_lock_rowid IN VARCHAR2,
1503: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
1504: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )
1505: IS
1506:
1507: l_index BINARY_INTEGER;

Line 1596: l_block_array hxc_block_table_type;

1592: l_index BINARY_INTEGER;
1593: l_app_attribute_index BINARY_INTEGER;
1594:
1595: l_attribute_array hxc_attribute_table_type;
1596: l_block_array hxc_block_table_type;
1597:
1598: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;
1599: l_lock_rowid VARCHAR2(100) := '0';
1600: l_timecard_exists varchar2(1) := 'N';

Line 1605: l_block_array := hxc_block_table_type();

1601:
1602: BEGIN
1603:
1604: l_attribute_array := hxc_attribute_table_type ();
1605: l_block_array := hxc_block_table_type();
1606:
1607: BEGIN
1608:
1609: SELECT 'Y'

Line 1634: -- conver the timecard_block_info into hxc_block_table_type

1630: -- convert the app_attributes_info into hxc_attribute_table_type
1631: hxc_timestore_deposit_util.convert_app_attributes_to_type (p_attributes => l_attribute_array,
1632: p_app_attributes => p_app_attributes
1633: );
1634: -- conver the timecard_block_info into hxc_block_table_type
1635: l_block_array := hxc_timestore_deposit_util.convert_tbb_to_type(p_blocks);
1636:
1637: l_index := l_block_array.first;
1638: LOOP

Line 1737: l_block_array hxc_block_table_type;

1733:
1734: l_index BINARY_INTEGER;
1735: l_app_attribute_index BINARY_INTEGER;
1736: l_attribute_array hxc_attribute_table_type;
1737: l_block_array hxc_block_table_type;
1738:
1739: l_person_id hxc_time_building_blocks.resource_id%type;
1740: l_approval_style_id hxc_time_building_blocks.approval_style_id%type;
1741:

Line 1751: l_block_array := hxc_block_table_type();

1747:
1748: BEGIN
1749:
1750: l_attribute_array := hxc_attribute_table_type ();
1751: l_block_array := hxc_block_table_type();
1752:
1753: -- get person id, timecard start time and timecard stop time
1754: l_index := p_blocks.first;
1755: LOOP

Line 1795: -- conver the timecard_block_info into hxc_block_table_type

1791: hxc_timestore_deposit_util.convert_app_attributes_to_type
1792: (p_attributes => l_attribute_array,
1793: p_app_attributes => p_app_attributes
1794: );
1795: -- conver the timecard_block_info into hxc_block_table_type
1796: l_block_array := hxc_timestore_deposit_util.convert_tbb_to_type(p_blocks);
1797:
1798: IF l_block_array.COUNT = 0
1799: THEN

Line 1884: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,

1880: PROCEDURE add_abs_to_tc ( p_person_id IN NUMBER,
1881: p_start_date IN DATE,
1882: p_end_date IN DATE,
1883: p_approval_style_id IN NUMBER,
1884: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
1885: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE ,
1886: p_lock_rowid IN VARCHAR2 )
1887: IS
1888:

Line 2005: p_block_array := HXC_BLOCK_TABLE_TYPE();

2001: -- and return if there was an error in processing abs.
2002: IF g_pending_appr
2003: AND g_messages.COUNT >0
2004: THEN
2005: p_block_array := HXC_BLOCK_TABLE_TYPE();
2006: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2007: RETURN;
2008: END IF;
2009:

Line 2578: PROCEDURE verify_view_only_absences( p_blocks IN HXC_BLOCK_TABLE_TYPE,

2574: p_stop_time => p_stop_time);
2575: END manage_retrieval_audit;
2576:
2577:
2578: PROCEDURE verify_view_only_absences( p_blocks IN HXC_BLOCK_TABLE_TYPE,
2579: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE,
2580: p_lock_rowid IN VARCHAR2,
2581: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
2582: IS