DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER dependencies on HXC_TIME_BUILDING_BLOCKS

Line 108: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

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

Line 109: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

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

Line 110: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type 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

Line 548: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type

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

Line 549: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type

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

Line 550: ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type 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

Line 1000: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type

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: /*

Line 1020: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is

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;

Line 1022: from hxc_time_building_blocks tbb

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:

Line 1027: CURSOR csr_chk_transfer (p_timecard_id hxc_time_building_blocks.time_building_block_id%type) IS

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

Line 1052: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

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: