APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_TIMECARDS_F

Line 28: p_person_id IN hxt_timecards_f.for_person_id%TYPE

24: */
25: FUNCTION is_retrievable (
26: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
27: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
28: p_person_id IN hxt_timecards_f.for_person_id%TYPE
29: )
30: RETURN BOOLEAN
31: AS
32: l_proc VARCHAR2 (72);

Line 42: p_person_id IN hxt_timecards_f.for_person_id%TYPE

38:
39: FUNCTION timecard_id (
40: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
41: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
42: p_person_id IN hxt_timecards_f.for_person_id%TYPE
43: )
44: RETURN hxt_timecards_f.ID%TYPE
45: AS
46: l_proc VARCHAR2 (72);

Line 44: RETURN hxt_timecards_f.ID%TYPE

40: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
41: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
42: p_person_id IN hxt_timecards_f.for_person_id%TYPE
43: )
44: RETURN hxt_timecards_f.ID%TYPE
45: AS
46: l_proc VARCHAR2 (72);
47:
48: CURSOR csr_timecard_id_from_sum (

Line 58: p_person_id hxt_timecards_f.for_person_id%TYPE

54: WHERE ID = p_sum_id;
55:
56: CURSOR csr_timecard_id (
57: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
58: p_person_id hxt_timecards_f.for_person_id%TYPE
59: )
60: IS
61: SELECT HTF.ID
62: FROM hxt_timecards_f HTF, per_time_periods ptp

Line 62: FROM hxt_timecards_f HTF, per_time_periods ptp

58: p_person_id hxt_timecards_f.for_person_id%TYPE
59: )
60: IS
61: SELECT HTF.ID
62: FROM hxt_timecards_f HTF, per_time_periods ptp
63: WHERE HTF.for_person_id = p_person_id
64: AND HTF.time_period_id = ptp.time_period_id
65: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
66: AND TRUNC (ptp.end_date);

Line 68: l_timecard_id hxt_timecards_f.ID%TYPE;

64: AND HTF.time_period_id = ptp.time_period_id
65: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
66: AND TRUNC (ptp.end_date);
67:
68: l_timecard_id hxt_timecards_f.ID%TYPE;
69: BEGIN
70: IF g_debug
71: THEN
72: l_proc := g_package || 'timecard_id';

Line 296: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw

292: SELECT hshw.ID, hshw.effective_start_date, hshw.effective_end_date,
293: hshw.tim_id
294: INTO p_time_summary_id, p_time_sum_start_date, p_time_sum_end_date,
295: p_tim_id
296: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw
297: WHERE HTF.for_person_id = p_person_id
298: AND HTF.payroll_id = p_payroll_id
299: AND HTF.time_period_id = l_time_period_id
300: AND HTF.effective_end_date = hr_general.end_of_time

Line 1220: FROM hxt_timecards_fmv

1216: --
1217: CURSOR get_batch_status (p_tim_id hxt_timecards.ID%TYPE)
1218: IS
1219: SELECT batch_status_cd
1220: FROM hxt_timecards_fmv
1221: WHERE ID = p_tim_id;
1222:
1223: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;
1224:

Line 1223: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;

1219: SELECT batch_status_cd
1220: FROM hxt_timecards_fmv
1221: WHERE ID = p_tim_id;
1222:
1223: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;
1224:
1225: CURSOR get_debug
1226: IS
1227: SELECT 'X'

Line 1235: FROM hxt_timecards_f HTF, pay_batch_headers pbh

1231:
1232: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1233: IS
1234: SELECT HTF.ID
1235: FROM hxt_timecards_f HTF, pay_batch_headers pbh
1236: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1237: AND HTF.batch_id = pbh.batch_id
1238: ORDER BY for_person_id, time_period_id;
1239: