DBA Data[Home] [Help]

APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_BLOCK_TYPE

Line 468: p_block_array(l_block_ind):= HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

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,
470: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
471: --p_block_array(l_block_ind).TIME_BUILDING_BLOCK_ID := -2; original code
472: p_block_array(l_block_ind).TIME_BUILDING_BLOCK_ID := (-3 - (p_iteration_count*30000)); -- SVG added

Line 714: p_block_array(l_block_ind):= HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

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,
716: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
717: p_block_array(l_block_ind).TIME_BUILDING_BLOCK_ID := -2;
718: p_block_array(l_block_ind).TYPE := 'RANGE';

Line 940: RETURN hxc_block_type

936: p_person_id IN NUMBER,
937: p_approval_style_id IN NUMBER,
938: p_timecard_id IN NUMBER,
939: p_bb_id IN NUMBER)
940: RETURN hxc_block_type
941: IS
942:
943: l_block_type HXC_BLOCK_TYPE;
944:

Line 943: l_block_type HXC_BLOCK_TYPE;

939: p_bb_id IN NUMBER)
940: RETURN hxc_block_type
941: IS
942:
943: l_block_type HXC_BLOCK_TYPE;
944:
945: BEGIN
946:
947: l_block_type := HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 947: l_block_type := HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

943: l_block_type HXC_BLOCK_TYPE;
944:
945: BEGIN
946:
947: l_block_type := HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
948: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
949: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
950:
951: l_block_type.TIME_BUILDING_BLOCK_ID := p_bb_id;

Line 988: RETURN hxc_block_type

984: p_day_id IN NUMBER,
985: p_bb_id IN NUMBER,
986: p_bb_ovn IN NUMBER,
987: p_date_to IN DATE)
988: RETURN hxc_block_type
989: IS
990: l_block_type HXC_BLOCK_TYPE;
991:
992: BEGIN

Line 990: l_block_type HXC_BLOCK_TYPE;

986: p_bb_ovn IN NUMBER,
987: p_date_to IN DATE)
988: RETURN hxc_block_type
989: IS
990: l_block_type HXC_BLOCK_TYPE;
991:
992: BEGIN
993:
994:

Line 996: l_block_type :=HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

992: BEGIN
993:
994:
995:
996: l_block_type :=HXC_BLOCK_TYPE(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
997: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
998: NULL,NULL,NULL,NULL,NULL,NULL,NULL);
999:
1000: