104: Procedure save_timecard
105: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
106: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
107: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
108: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
109: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
110: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
111: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
112: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
105: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
106: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
107: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
108: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
109: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
110: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
111: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
112: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
113: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
106: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
107: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
108: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
109: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
110: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
111: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
112: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
113: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
114: ) is
544: Procedure submit_timecard
545: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
546: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
547: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
548: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
549: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
550: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
551: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
552: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
545: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
546: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
547: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
548: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
549: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
550: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
551: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
552: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
553: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
546: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
547: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
548: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
549: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
550: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type DEFAULT NULL
551: ,p_tk_audit_enabled in VARCHAR2 DEFAULT NULL
552: ,p_tk_notify_to in VARCHAR2 DEFAULT NULL
553: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
554: ) IS
996: -- Delete Timecard Procedure
997: -- This procedure....
998: ----------------------------------------------------------------------------
999: Procedure delete_timecard
1000: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
1001: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1002: ) is
1003:
1004: /*
1016: where timecard_id = p_timecard_id;
1017:
1018: /*
1019: cursor c_timecard_ovn
1020: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1021: select tbb.object_version_number
1022: from hxc_time_building_blocks tbb
1023: where tbb.time_building_block_id = p_timecard_id
1024: and tbb.date_to = hr_general.end_of_time;
1018: /*
1019: cursor c_timecard_ovn
1020: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1021: select tbb.object_version_number
1022: from hxc_time_building_blocks tbb
1023: where tbb.time_building_block_id = p_timecard_id
1024: and tbb.date_to = hr_general.end_of_time;
1025: */
1026:
1023: where tbb.time_building_block_id = p_timecard_id
1024: and tbb.date_to = hr_general.end_of_time;
1025: */
1026:
1027: CURSOR csr_chk_transfer (p_timecard_id hxc_time_building_blocks.time_building_block_id%type) IS
1028: SELECT 1
1029: FROM dual
1030: WHERE EXISTS (
1031: SELECT 1
1048: l_timecard_props hxc_timecard_prop_table_type;
1049:
1050: l_dummy boolean := true;
1051:
1052: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1053: l_timecard_index number;
1054:
1055: l_status_error BOOLEAN := FALSE;
1056: