DBA Data[Home] [Help]

APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 79: start_date hxc_time_building_blocks.start_time%TYPE

75:
76: -- record for timecard information
77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 80: , end_date hxc_time_building_blocks.stop_time%TYPE

76: -- record for timecard information
77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE

Line 81: , resource_id hxc_time_building_blocks.resource_id%TYPE

77:
78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE

Line 82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

78: TYPE r_timecard_info IS RECORD (
79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)

Line 83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE

79: start_date hxc_time_building_blocks.start_time%TYPE
80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)
87: , deleted varchar2(1) );

Line 84: , approval_status hxc_time_building_blocks.approval_status%TYPE

80: , end_date hxc_time_building_blocks.stop_time%TYPE
81: , resource_id hxc_time_building_blocks.resource_id%TYPE
82: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
83: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
84: , approval_status hxc_time_building_blocks.approval_status%TYPE
85: , bg_id per_business_groups.business_group_id%TYPE
86: , new varchar2(1)
87: , deleted varchar2(1) );
88:

Line 318: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

314: FUNCTION asg_status_id ( p_assignment_id NUMBER
315: , p_effective_date VARCHAR2 ) RETURN NUMBER;
316:
317: PROCEDURE tc_edit_allowed (
318: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
319: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
320: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
321: ,p_edit_allowed IN OUT nocopy VARCHAR2
322: );

Line 319: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

315: , p_effective_date VARCHAR2 ) RETURN NUMBER;
316:
317: PROCEDURE tc_edit_allowed (
318: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
319: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
320: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
321: ,p_edit_allowed IN OUT nocopy VARCHAR2
322: );
323:

Line 374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

370: --
371: -- {End Of Comments}
372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2

Line 375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

371: -- {End Of Comments}
372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2
379: );

Line 376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE

372: --
373: PROCEDURE tc_edit_allowed (
374: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
375: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
376: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
377: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
378: ,p_edit_allowed IN OUT nocopy VARCHAR2
379: );
380: