DBA Data[Home] [Help]

APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_ATTRIBUTE_TABLE_TYPE

Line 431: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )

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;
435: l_block_ind NUMBER;

Line 517: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

513: END LOOP;
514: l_det_id := l_day_id;
515: l_att_id := -1;
516: l_att_ind := 1;
517: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
518: l_att_ind := -1;
519: FOR i IN l_abs_tab.FIRST..l_abs_tab.LAST
520: LOOP
521: <>

Line 674: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )

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;
678: l_block_ind NUMBER;

Line 744: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

740:
741:
742: -- Bug 8911152
743: -- Adding call to create layout attribute.
744: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
745: p_attribute_array.EXTEND(1);
746: l_att_ind := p_attribute_array.FIRST;
747: l_att_id := -1;
748:

Line 781: --p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

777: -- No longer need this initialization cos we are creating
778: -- the layout attribute above.
779: --l_att_id := -1;
780: --l_att_ind := 1;
781: --p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
782: l_att_ind := l_att_ind +1;
783: FOR i IN l_abs_tab.FIRST..l_abs_tab.LAST
784: LOOP
785: << CONTINUE_TO_NEXT>>

Line 1370: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )

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;
1374:

Line 1504: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE )

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;
1508:

Line 1595: l_attribute_array hxc_attribute_table_type;

1591:
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';

Line 1604: l_attribute_array := hxc_attribute_table_type ();

1600: l_timecard_exists varchar2(1) := 'N';
1601:
1602: BEGIN
1603:
1604: l_attribute_array := hxc_attribute_table_type ();
1605: l_block_array := hxc_block_table_type();
1606:
1607: BEGIN
1608:

Line 1630: -- convert the app_attributes_info into hxc_attribute_table_type

1626: p_start_date,
1627: p_end_date,
1628: l_lock_rowid);
1629:
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

Line 1736: l_attribute_array hxc_attribute_table_type;

1732: IS
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;

Line 1750: l_attribute_array := hxc_attribute_table_type ();

1746: l_timecard_exists varchar2(1) := 'N';
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;

Line 1790: -- convert the app_attributes_info into hxc_attribute_table_type

1786: l_start_date,
1787: l_end_date,
1788: l_lock_rowid);
1789:
1790: -- convert the app_attributes_info into hxc_attribute_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: );

Line 1885: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE ,

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:
1889: l_index BINARY_INTEGER;

Line 2006: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

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:
2010:

Line 2579: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE,

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
2583: