[Home] [Help]
132: hxc_block_type (p_time_building_block_id,
133: p_type,
134: p_measure,
135: p_unit_of_measure,
136: fnd_date.date_to_canonical (p_start_time),
137: fnd_date.date_to_canonical (p_stop_time),
138: p_parent_building_block_id,
139: p_parent_is_new,
140: p_scope,
133: p_type,
134: p_measure,
135: p_unit_of_measure,
136: fnd_date.date_to_canonical (p_start_time),
137: fnd_date.date_to_canonical (p_stop_time),
138: p_parent_building_block_id,
139: p_parent_is_new,
140: p_scope,
141: p_object_version_number,
142: p_approval_status,
143: p_resource_id,
144: p_resource_type,
145: p_approval_style_id,
146: fnd_date.date_to_canonical (p_date_from),
147: fnd_date.date_to_canonical (p_date_to),
148: p_comment_text,
149: p_parent_building_block_ovn,
150: p_new,
143: p_resource_id,
144: p_resource_type,
145: p_approval_style_id,
146: fnd_date.date_to_canonical (p_date_from),
147: fnd_date.date_to_canonical (p_date_to),
148: p_comment_text,
149: p_parent_building_block_ovn,
150: p_new,
151: p_changed,
1780: IF ((p_start_time <> hr_api.g_date) OR (p_start_time IS NULL))
1781: THEN
1782: -- Adding fix for Bug. no. 3327697
1783: p_app_blocks (l_building_block_index).start_time :=
1784: fnd_date.date_to_canonical (p_start_time);
1785: END IF;
1786:
1787: IF ((p_stop_time <> hr_api.g_date) OR (p_stop_time IS NULL))
1788: THEN
1787: IF ((p_stop_time <> hr_api.g_date) OR (p_stop_time IS NULL))
1788: THEN
1789: -- Adding fix for Bug. no. 3327697
1790: p_app_blocks (l_building_block_index).stop_time :=
1791: fnd_date.date_to_canonical (p_stop_time);
1792: END IF;
1793:
1794: p_app_blocks (l_building_block_index).parent_is_new := hxc_timecard.c_no;
1795: -- Don't know yet if I need this here or not
1794: p_app_blocks (l_building_block_index).parent_is_new := hxc_timecard.c_no;
1795: -- Don't know yet if I need this here or not
1796: -- p_app_blocks ( l_building_block_index).object_version_number := 1;
1797: p_app_blocks (l_building_block_index).date_from :=
1798: fnd_date.date_to_canonical (SYSDATE);
1799: p_app_blocks (l_building_block_index).date_to :=
1800: fnd_date.date_to_canonical (hr_general.end_of_time);
1801:
1802: IF ((p_comment_text <> hr_api.g_varchar2) OR (p_comment_text IS NULL))
1796: -- p_app_blocks ( l_building_block_index).object_version_number := 1;
1797: p_app_blocks (l_building_block_index).date_from :=
1798: fnd_date.date_to_canonical (SYSDATE);
1799: p_app_blocks (l_building_block_index).date_to :=
1800: fnd_date.date_to_canonical (hr_general.end_of_time);
1801:
1802: IF ((p_comment_text <> hr_api.g_varchar2) OR (p_comment_text IS NULL))
1803: THEN
1804: p_app_blocks (l_building_block_index).comment_text := p_comment_text;
1941: -- Set the date_to of the TBB to the sysdate, that will 'delete' the TBB
1942: -- This is, as you can see a soft delete, the TBB will not be visible for the
1943: -- user anymore, but it will stay in the DB (with a date_to of sysdate)
1944: p_app_blocks (l_building_block_index).date_to :=
1945: fnd_date.date_to_canonical (p_effective_date);
1946: -- indicate that this TBB has changed (delete)
1947: p_app_blocks (l_building_block_index).NEW := hxc_timecard.c_no;
1948: p_app_blocks (l_building_block_index).changed := hxc_timecard.c_yes;
1949:
2438: (hxc_preference_evaluation.resource_preferences
2439: (p_resource_id => p_app_blocks (p_app_blocks.FIRST).resource_id,
2440: p_pref_code => 'TS_PER_APPLICATION_SET',
2441: p_attribute_n => 1,
2442: p_evaluation_date => fnd_date.canonical_to_date
2443: (p_app_blocks
2444: (p_app_blocks.FIRST).start_time
2445: )
2446: )