[Home] [Help]
176: IN DATE
177: ) IS
178: SELECT time_building_block_id, object_version_number, start_time, comment_text, created_by,
179: creation_date, last_updated_by, last_update_date, last_update_login
180: FROM hxc_time_building_blocks
181: WHERE resource_id = p_resource_id
182: AND SCOPE = 'TIMECARD'
183: AND start_time = p_start_period
184: AND stop_time = p_end_period
199: ) IS
200: SELECT detail.time_building_block_id detail_id, detail.object_version_number detail_ovn,
201: detail.measure, DAY.start_time, detail.start_time time_in, detail.stop_time time_out,
202: detail.comment_text
203: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
204: WHERE DAY.parent_building_block_id = timecard_id
205: AND DAY.parent_building_block_ovn = timecard_ovn
206: AND detail.date_to = hr_general.end_of_time
207: AND detail.SCOPE = 'DETAIL'
412: )
413: RETURN BOOLEAN IS
414: CURSOR csr_get_timecard IS
415: SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
416: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
417: WHERE DAY.parent_building_block_id = p_bb_id
418: /*ADVICE(509): Cursor references an external variable (use a parameter) [209] */
419:
420: AND DAY.parent_building_block_ovn = p_bb_ovn
491: )
492: RETURN BOOLEAN IS
493: CURSOR csr_get_timecard IS
494: SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
495: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
496: WHERE DAY.parent_building_block_id = p_bb_id
497: /*ADVICE(588): Cursor references an external variable (use a parameter) [209] */
498:
499: AND DAY.parent_building_block_ovn = p_bb_ovn
4090: /*ADVICE(3536): This definition hides another one [556] */
4091: IN DATE
4092: ) IS
4093: SELECT time_building_block_id, object_version_number, comment_text
4094: FROM hxc_time_building_blocks
4095: WHERE SCOPE = 'TIMECARD'
4096: AND date_to = hr_general.end_of_time
4097: AND resource_id = p_resource_id
4098: AND start_time = p_start_period
4105: p_timecard_ovn IN NUMBER,
4106: p_resource_id IN NUMBER
4107: ) IS
4108: SELECT '1'
4109: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
4110: WHERE DAY.SCOPE = 'DAY'
4111: AND DAY.resource_id = p_resource_id
4112: AND DAY.parent_building_block_id = p_timecard_id
4113: AND DAY.parent_building_block_ovn = p_timecard_ovn
4135:
4136: CURSOR c_tc_in_term_period_exists(
4137: p_resource_id number, p_start_date date, p_end_date date) IS
4138: SELECT 'Y'
4139: from hxc_time_building_blocks
4140: where resource_id=p_resource_id
4141: and scope='TIMECARD'
4142: and trunc(start_time)=trunc(p_start_date)
4143: and trunc(stop_time)=trunc(p_end_date)
4936:
4937: CURSOR c_tc_in_term_period_exists(
4938: p_resource_id number, p_start_date date, p_end_date date) IS
4939: SELECT 'Y'
4940: from hxc_time_building_blocks
4941: where resource_id=p_resource_id
4942: and scope='TIMECARD'
4943: and trunc(start_time)=trunc(p_start_date)
4944: and trunc(stop_time)=trunc(p_end_date)
5346: IN DATE
5347: ) IS
5348: SELECT time_building_block_id, object_version_number, date_to, date_from, approval_style_id,
5349: approval_status, comment_text,application_set_id
5350: FROM hxc_time_building_blocks
5351: WHERE resource_id = p_resource_id
5352: AND SCOPE = 'TIMECARD'
5353: AND date_to = hr_general.end_of_time
5354: AND start_time = p_start_period
5367: p_parent_building_block_id IN NUMBER,
5368: p_parent_ovn IN NUMBER
5369: ) IS
5370: SELECT time_building_block_id, object_version_number, date_to, date_from,application_set_id
5371: FROM hxc_time_building_blocks
5372: WHERE resource_id = p_resource_id
5373: AND parent_building_block_id = p_parent_building_block_id
5374: AND parent_building_block_ovn = p_parent_ovn
5375: AND date_to = hr_general.end_of_time
5385: p_parent_ovn IN NUMBER
5386: ) IS
5387: SELECT time_building_block_id detail_id, object_version_number detail_ovn, measure, date_to,
5388: date_from, start_time, stop_time, comment_text,application_set_id
5389: FROM hxc_time_building_blocks
5390: WHERE resource_id = p_resource_id
5391: AND parent_building_block_id = p_parent_building_block_id
5392: AND parent_building_block_ovn = p_parent_ovn
5393: AND date_to = hr_general.end_of_time
5469: l_timecard_status VARCHAR2 (10);
5470: l_emp_start_date DATE;
5471: l_emp_terminate_date DATE;
5472: l_audit_enabled VARCHAR2 (150);
5473: l_application_set_id hxc_time_building_blocks.application_set_id%type:=NULL;
5474: l_day_changed VARCHAR2(1):='N';
5475: l_timecard_changed VARCHAR2(1):='N';
5476: BEGIN
5477: g_debug :=hr_utility.debug_enabled;
5760: /*ADVICE(5039): NUMBER has no precision [315] */
5761: := NULL;
5762: /*ADVICE(5041): Initialization to NULL is superfluous [417] */
5763:
5764: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE := 0;
5765: l_detail_ovn NUMBER
5766: /*ADVICE(5045): NUMBER has no precision [315] */
5767: := 0;
5768: l_detail_time_in DATE;
5814: /*ADVICE(5093): NUMBER has no precision [315] */
5815: ;
5816: l_old_attribute_value VARCHAR2 (150);
5817: l_new_attribute_value VARCHAR2 (150);
5818: l_application_set_id hxc_time_building_blocks.application_set_id%type:=NULL;
5819:
5820: CURSOR c_detail (
5821: p_detailid IN NUMBER
5822: ) IS
5835: /*ADVICE(5113): This definition hides another one [556] */
5836: IN DATE
5837: ) IS
5838: SELECT comment_text
5839: FROM hxc_time_building_blocks
5840: WHERE resource_id = p_resource_id
5841: AND SCOPE = 'TIMECARD'
5842: AND date_to = hr_general.end_of_time
5843: AND start_time = p_start_period