[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'
437: )
438: RETURN BOOLEAN IS
439: CURSOR csr_get_timecard IS
440: SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
441: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
442: WHERE DAY.parent_building_block_id = p_bb_id
443: /*ADVICE(509): Cursor references an external variable (use a parameter) [209] */
444:
445: AND DAY.parent_building_block_ovn = p_bb_ovn
516: )
517: RETURN BOOLEAN IS
518: CURSOR csr_get_timecard IS
519: SELECT detail.time_building_block_id bb_id, detail.object_version_number bb_ovn
520: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
521: WHERE DAY.parent_building_block_id = p_bb_id
522: /*ADVICE(588): Cursor references an external variable (use a parameter) [209] */
523:
524: AND DAY.parent_building_block_ovn = p_bb_ovn
5086: /*ADVICE(3536): This definition hides another one [556] */
5087: IN DATE
5088: ) IS
5089: SELECT time_building_block_id, object_version_number, comment_text
5090: FROM hxc_time_building_blocks
5091: WHERE SCOPE = 'TIMECARD'
5092: AND date_to = hr_general.end_of_time
5093: AND resource_id = p_resource_id
5094: AND start_time = p_start_period
5101: p_timecard_ovn IN NUMBER,
5102: p_resource_id IN NUMBER
5103: ) IS
5104: SELECT '1'
5105: FROM hxc_time_building_blocks detail, hxc_time_building_blocks DAY
5106: WHERE DAY.SCOPE = 'DAY'
5107: AND DAY.resource_id = p_resource_id
5108: AND DAY.parent_building_block_id = p_timecard_id
5109: AND DAY.parent_building_block_ovn = p_timecard_ovn
5131:
5132: CURSOR c_tc_in_term_period_exists(
5133: p_resource_id number, p_start_date date, p_end_date date) IS
5134: SELECT 'Y'
5135: from hxc_time_building_blocks
5136: where resource_id=p_resource_id
5137: and scope='TIMECARD'
5138: and trunc(start_time)=trunc(p_start_date)
5139: and trunc(stop_time)=trunc(p_end_date)
6288:
6289: CURSOR c_tc_in_term_period_exists(
6290: p_resource_id number, p_start_date date, p_end_date date) IS
6291: SELECT 'Y'
6292: from hxc_time_building_blocks
6293: where resource_id=p_resource_id
6294: and scope='TIMECARD'
6295: and trunc(start_time)=trunc(p_start_date)
6296: and trunc(stop_time)=trunc(p_end_date)
6698: IN DATE
6699: ) IS
6700: SELECT time_building_block_id, object_version_number, date_to, date_from, approval_style_id,
6701: approval_status, comment_text,application_set_id
6702: FROM hxc_time_building_blocks
6703: WHERE resource_id = p_resource_id
6704: AND SCOPE = 'TIMECARD'
6705: AND date_to = hr_general.end_of_time
6706: AND start_time = p_start_period
6719: p_parent_building_block_id IN NUMBER,
6720: p_parent_ovn IN NUMBER
6721: ) IS
6722: SELECT time_building_block_id, object_version_number, date_to, date_from,application_set_id
6723: FROM hxc_time_building_blocks
6724: WHERE resource_id = p_resource_id
6725: AND parent_building_block_id = p_parent_building_block_id
6726: AND parent_building_block_ovn = p_parent_ovn
6727: AND date_to = hr_general.end_of_time
6737: p_parent_ovn IN NUMBER
6738: ) IS
6739: SELECT time_building_block_id detail_id, object_version_number detail_ovn, measure, date_to,
6740: date_from, start_time, stop_time, comment_text,application_set_id
6741: FROM hxc_time_building_blocks
6742: WHERE resource_id = p_resource_id
6743: AND parent_building_block_id = p_parent_building_block_id
6744: AND parent_building_block_ovn = p_parent_ovn
6745: AND date_to = hr_general.end_of_time
6821: l_timecard_status VARCHAR2 (10);
6822: l_emp_start_date DATE;
6823: l_emp_terminate_date DATE;
6824: l_audit_enabled VARCHAR2 (150);
6825: l_application_set_id hxc_time_building_blocks.application_set_id%type:=NULL;
6826: l_day_changed VARCHAR2(1):='N';
6827: l_timecard_changed VARCHAR2(1):='N';
6828:
6829: l_found VARCHAR2(1):='N'; /* Bug 9014012 */
7228: /*ADVICE(5039): NUMBER has no precision [315] */
7229: := NULL;
7230: /*ADVICE(5041): Initialization to NULL is superfluous [417] */
7231:
7232: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE := 0;
7233: l_detail_ovn NUMBER
7234: /*ADVICE(5045): NUMBER has no precision [315] */
7235: := 0;
7236: l_detail_time_in DATE;
7282: /*ADVICE(5093): NUMBER has no precision [315] */
7283: ;
7284: l_old_attribute_value VARCHAR2 (150);
7285: l_new_attribute_value VARCHAR2 (150);
7286: l_application_set_id hxc_time_building_blocks.application_set_id%type:=NULL;
7287:
7288: /*
7289: Added for bug 8775740
7290: HR OTL Absence Integration.
7313: /*ADVICE(5113): This definition hides another one [556] */
7314: IN DATE
7315: ) IS
7316: SELECT comment_text
7317: FROM hxc_time_building_blocks
7318: WHERE resource_id = p_resource_id
7319: AND SCOPE = 'TIMECARD'
7320: AND date_to = hr_general.end_of_time
7321: AND start_time = p_start_period