[Home] [Help]
404: IS SELECT payroll_id,
405: time_period_id,
406: batch_id,
407: for_person_id
408: FROM hxt_timecards
409: WHERE id = p_tim_id;
410:
411: l_person_id NUMBER;
412: l_batch_id NUMBER;
443: CURSOR get_rollback_eligibility(p_timecard_id IN NUMBER)
444: IS SELECT timecard_id
445: FROM hxc_rollback_timecards_all
446: WHERE timecard_id = p_timecard_id
447: AND timecard_type = 'HXT_TIMECARDS_F';
448:
449: l_id NUMBER;
450:
451:
476: IS
477:
478: CURSOR get_data_set_id(p_timecard_id NUMBER)
479: IS SELECT data_set_id
480: FROM hxt_timecards_f
481: WHERE id = p_timecard_id;
482:
483: l_data_set_id NUMBER;
484:
599: IS SELECT payroll_id,
600: time_period_id,
601: batch_id,
602: for_person_id
603: FROM hxt_timecards
604: WHERE id = p_tim_id;
605:
606: l_person_id NUMBER;
607: l_batch_id NUMBER;
1835: IS
1836:
1837: CURSOR get_row
1838: IS SELECT ROWIDTOCHAR(tim.ROWID)
1839: FROM hxt_timecards_f tim,
1840: FND_sessions sess
1841: WHERE id = p_tim_id
1842: AND session_id = USERENV('SESSIONID')
1843: AND effective_date BETWEEN effective_start_date
1852: FETCH get_row INTO l_rowid;
1853: CLOSE get_row;
1854:
1855:
1856: UPDATE hxt_timecards_f
1857: SET batch_id = p_batch_id
1858: WHERE ROWID = CHARTOROWID(l_rowid);
1859:
1860:
1877:
1878: IF p_tim_tab.COUNT > 0
1879: THEN
1880: FORALL i IN p_tim_tab.FIRST..p_tim_tab.LAST
1881: UPDATE hxt_timecards
1882: SET batch_id = p_batch_id
1883: WHERE id = p_tim_tab(i)
1884: AND batch_id = p_replacement_batch_id;
1885:
1934:
1935: CURSOR check_retro_batches(p_batch_id IN NUMBER)
1936: IS SELECT retro_batch_id,
1937: tim_id
1938: FROM hxt_timecards_f tim,
1939: hxt_det_hours_worked_f det
1940: WHERE tim.batch_id = p_batch_id
1941: AND tim.id = det.tim_id;
1942:
1942:
1943:
1944: CURSOR get_timecards(p_batch_id IN NUMBER)
1945: IS SELECT id
1946: FROM hxt_timecards
1947: WHERE batch_id = p_batch_id;
1948:
1949: CURSOR get_timecards_person(p_batch_id IN NUMBER,
1950: p_person_id IN NUMBER)
1948:
1949: CURSOR get_timecards_person(p_batch_id IN NUMBER,
1950: p_person_id IN NUMBER)
1951: IS SELECT id
1952: FROM hxt_timecards
1953: WHERE batch_id = p_batch_id
1954: AND for_person_id = p_person_id;
1955:
1956:
1958: CURSOR check_retro_batches_person(p_person_id IN NUMBER,
1959: p_batch_id IN NUMBER)
1960: IS SELECT retro_batch_id,
1961: tim_id
1962: FROM hxt_timecards_f tim,
1963: hxt_det_hours_worked_f det
1964: WHERE tim.batch_id = p_batch_id
1965: AND tim.id = det.tim_id
1966: AND tim.for_person_id = p_person_id;
3193:
3194:
3195: l_replacement_batch := replacement_batch(p_batch_id);
3196:
3197: UPDATE hxt_timecards
3198: SET batch_id = l_replacement_batch
3199: WHERE id = p_tim_id;
3200:
3201: INSERT INTO hxt_reversed_batch_tc_all
3226:
3227: DELETE FROM hxt_sum_hours_worked_f
3228: WHERE tim_id = p_tim_id;
3229:
3230: DELETE FROM hxt_timecards_f
3231: WHERE id = p_tim_id;
3232:
3233: put_log('All Details for this timecard are deleted from OTM',g_cache);
3234:
3242: IS
3243:
3244: CURSOR get_outstanding_details
3245: IS SELECT det.tim_id
3246: FROM hxt_timecards tim,
3247: hxt_det_hours_worked det,
3248: hxt_batch_states hbs
3249: WHERE tim.id = p_tim_id
3250: AND det.tim_id = tim.id
3474: IS
3475:
3476: CURSOR get_outstanding_details
3477: IS SELECT det.tim_id
3478: FROM hxt_timecards tim,
3479: hxt_det_hours_worked det,
3480: hxt_batch_states hbs
3481: WHERE tim.id = p_tim_id
3482: AND det.tim_id = tim.id
3880:
3881:
3882: l_query VARCHAR2(4000) :=
3883: 'SELECT id,batch_id
3884: FROM hxt_timecards_f tim,
3885: per_time_periods ptp
3886: WHERE tim.payroll_id = :payroll_id
3887: AND tim.time_period_id = :period_id
3888: AND ptp.time_period_id = tim.time_period_id
3890:
3891:
3892: l_asg_sql VARCHAR2(400) :=
3893: 'SELECT id
3894: FROM hxt_timecards_f tim,
3895: per_all_assignments_f
3896: WHERE payroll_id = :payroll_id
3897: AND time_period_id = :period_id';
3898: