APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_TIMECARDS

Line 404: p_person_id IN hxt_timecards_f.for_person_id%TYPE,

400: -- Added variables to take in tc bb_id and ovn
401: FUNCTION is_retrievable (
402: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
403: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
404: p_person_id IN hxt_timecards_f.for_person_id%TYPE,
405: p_tc_bb_id IN NUMBER DEFAULT 0,
406: p_tc_ovn IN NUMBER DEFAULT 0
407: )
408: RETURN BOOLEAN

Line 436: p_person_id IN hxt_timecards_f.for_person_id%TYPE

432:
433: FUNCTION timecard_id (
434: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
435: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
436: p_person_id IN hxt_timecards_f.for_person_id%TYPE
437: )
438: RETURN hxt_timecards_f.ID%TYPE
439: AS
440: l_proc VARCHAR2 (72);

Line 438: RETURN hxt_timecards_f.ID%TYPE

434: p_sum_id IN hxt_sum_hours_worked_f.ID%TYPE,
435: p_date_worked IN hxt_sum_hours_worked_f.date_worked%TYPE,
436: p_person_id IN hxt_timecards_f.for_person_id%TYPE
437: )
438: RETURN hxt_timecards_f.ID%TYPE
439: AS
440: l_proc VARCHAR2 (72);
441:
442: CURSOR csr_timecard_id_from_sum (

Line 452: p_person_id hxt_timecards_f.for_person_id%TYPE

448: WHERE ID = p_sum_id;
449:
450: CURSOR csr_timecard_id (
451: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
452: p_person_id hxt_timecards_f.for_person_id%TYPE
453: )
454: IS
455: SELECT HTF.ID
456: FROM hxt_timecards_f HTF, per_time_periods ptp

Line 456: FROM hxt_timecards_f HTF, per_time_periods ptp

452: p_person_id hxt_timecards_f.for_person_id%TYPE
453: )
454: IS
455: SELECT HTF.ID
456: FROM hxt_timecards_f HTF, per_time_periods ptp
457: WHERE HTF.for_person_id = p_person_id
458: AND HTF.time_period_id = ptp.time_period_id
459: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
460: AND TRUNC (ptp.end_date);

Line 462: l_timecard_id hxt_timecards_f.ID%TYPE;

458: AND HTF.time_period_id = ptp.time_period_id
459: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
460: AND TRUNC (ptp.end_date);
461:
462: l_timecard_id hxt_timecards_f.ID%TYPE;
463: BEGIN
464:
465:
466: IF g_debug

Line 797: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw

793: SELECT hshw.ID, hshw.effective_start_date, hshw.effective_end_date,
794: hshw.tim_id
795: INTO p_time_summary_id, p_time_sum_start_date, p_time_sum_end_date,
796: p_tim_id
797: FROM hxt_timecards_f HTF, hxt_sum_hours_worked hshw
798: WHERE HTF.for_person_id = p_person_id
799: AND HTF.payroll_id = p_payroll_id
800: AND HTF.time_period_id = l_time_period_id
801: AND HTF.effective_end_date = hr_general.end_of_time

Line 1805: CURSOR get_batch_status (p_tim_id hxt_timecards.ID%TYPE)

1801: -- TYPE t_value IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
1802: -- TYPE t_segment IS TABLE OF varchar2(60) INDEX BY BINARY_INTEGER;
1803: --
1804: --
1805: CURSOR get_batch_status (p_tim_id hxt_timecards.ID%TYPE)
1806: IS
1807: SELECT batch_status_cd
1808: FROM hxt_timecards_fmv
1809: WHERE ID = p_tim_id;

Line 1808: FROM hxt_timecards_fmv

1804: --
1805: CURSOR get_batch_status (p_tim_id hxt_timecards.ID%TYPE)
1806: IS
1807: SELECT batch_status_cd
1808: FROM hxt_timecards_fmv
1809: WHERE ID = p_tim_id;
1810:
1811: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;
1812:

Line 1811: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;

1807: SELECT batch_status_cd
1808: FROM hxt_timecards_fmv
1809: WHERE ID = p_tim_id;
1810:
1811: l_batch_status_cd hxt_timecards_fmv.batch_status_cd%TYPE;
1812:
1813: CURSOR get_debug
1814: IS
1815: SELECT 'X'

Line 1823: FROM hxt_timecards_f HTF, pay_batch_headers pbh

1819:
1820: CURSOR csr_created_timecards (p_batch_ref VARCHAR2)
1821: IS
1822: SELECT HTF.ID
1823: FROM hxt_timecards_f HTF, pay_batch_headers pbh
1824: WHERE pbh.batch_reference LIKE p_batch_ref || '%'
1825: AND HTF.batch_id = pbh.batch_id
1826: ORDER BY for_person_id, time_period_id;
1827:

Line 2126: FROM hxt_sum_hours_worked hshw, hxt_timecards ht

2122: --
2123: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
2124: IS
2125: SELECT hshw.tim_id, ht.time_period_id
2126: FROM hxt_sum_hours_worked hshw, hxt_timecards ht
2127: WHERE hshw.ID = p_tim_sum_id AND hshw.tim_id = ht.ID;
2128:
2129: --
2130: l_created_tim_sum_id hxt_sum_hours_worked.ID%TYPE DEFAULT NULL;