APPS.HXT_TIME_CLOCK dependencies on HXT_TIMECARDS

Line 57: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;

53: l_person_id per_people_f.person_id%TYPE DEFAULT NULL;
54: l_last_name per_people_f.last_name%TYPE DEFAULT NULL;
55: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
56: l_bus_grp_id per_assignments_f.business_group_id%TYPE DEFAULT NULL;
57: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;
58: l_date_worked DATE DEFAULT NULL;
59: l_time_period_id per_time_periods.time_period_id%TYPE DEFAULT NULL;
60: l_start_date DATE DEFAULT NULL;
61: l_end_date DATE DEFAULT NULL;

Line 62: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE DEFAULT NULL;

58: l_date_worked DATE DEFAULT NULL;
59: l_time_period_id per_time_periods.time_period_id%TYPE DEFAULT NULL;
60: l_start_date DATE DEFAULT NULL;
61: l_end_date DATE DEFAULT NULL;
62: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE DEFAULT NULL;
63: l_timecard_exists BOOLEAN DEFAULT TRUE;
64: l_hours NUMBER DEFAULT NULL;
65: l_person_id_data_err EXCEPTION;
66: l_person_id_sys_err EXCEPTION;

Line 587: Check the HXT_TIMECARDS table to see if a timecard

583: RETURN 2;
584: END get_time_period;
585: /****************************************************
586: check_for_timecard()
587: Check the HXT_TIMECARDS table to see if a timecard
588: already exists for the person punching the clock
589: ****************************************************/
590: FUNCTION check_for_timecard( i_person_id IN NUMBER,
591: i_time_period_id IN NUMBER,

Line 601: FROM hxt_timecards

597: batch_id
598: INTO o_timecard_id,
599: o_auto_gen_flag,
600: g_batch_err_id
601: FROM hxt_timecards
602: WHERE for_person_id = i_person_id
603: AND time_period_id = i_time_period_id;
604: RETURN 0;
605: EXCEPTION

Line 630: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;

626: --BEGIN GLOBAL
627: -- l_batch_id pay_pdt_batch_headers.batch_id%TYPE DEFAULT NULL;
628: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
629: --END GLOBAL
630: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;
631: BEGIN
632: /* Obtain a batch id for the new timecard */
633: --BEGIN SIR343
634: -- l_retcode := find_existing_batch(l_batch_id);

Line 663: /* Insert new timecard info to hxt_timecards */

659: IF l_timecard_id = NULL THEN
660: RAISE l_tim_id_creation_error;
661: END IF;
662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
663: /* Insert new timecard info to hxt_timecards */
664: --SIR012 INSERT into hxt_timecards
665: INSERT into hxt_timecards_f --SIR012
666: ( id,
667: for_person_id,

Line 664: --SIR012 INSERT into hxt_timecards

660: RAISE l_tim_id_creation_error;
661: END IF;
662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
663: /* Insert new timecard info to hxt_timecards */
664: --SIR012 INSERT into hxt_timecards
665: INSERT into hxt_timecards_f --SIR012
666: ( id,
667: for_person_id,
668: payroll_id,

Line 665: INSERT into hxt_timecards_f --SIR012

661: END IF;
662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
663: /* Insert new timecard info to hxt_timecards */
664: --SIR012 INSERT into hxt_timecards
665: INSERT into hxt_timecards_f --SIR012
666: ( id,
667: for_person_id,
668: payroll_id,
669: time_period_id,

Line 834: -- FROM hxt_timecards tim

830: -- AND bat.batch_id = (SELECT MAX(bat2.batch_id)
831: -- FROM pay_pdt_batch_headers bat2
832: -- WHERE bat2.batch_status = 'H')
833: -- AND l_max_batches > (SELECT COUNT(tim.id)
834: -- FROM hxt_timecards tim
835: -- WHERE tim.batch_id = bat.batch_id);
836: --BEGIN SIR343
837: -- SELECT bat.batch_id
838: -- INTO o_batch_id

Line 845: -- FROM hxt_timecards tim

841: -- AND bat.batch_id = (SELECT MAX(bat2.batch_id)
842: -- FROM pay_batch_headers bat2
843: -- WHERE bat2.batch_status = 'U')
844: -- AND l_max_batches > (SELECT COUNT(tim.id)
845: -- FROM hxt_timecards tim
846: -- WHERE tim.batch_id = bat.batch_id);
847: SELECT MAX(bat.batch_id)
848: INTO o_batch_id
849: FROM pay_batch_headers bat

Line 853: FROM hxt_timecards tim

849: FROM pay_batch_headers bat
850: WHERE bat.batch_status = 'U'
851: AND bat.batch_reference like 'C_%'
852: AND not exists (SELECT 'x'
853: FROM hxt_timecards tim
854: WHERE tim.batch_id = bat.batch_id
855: AND (tim.time_period_id <> i_time_period_id
856: OR tim.payroll_id <> i_payroll_id))
857: AND l_max_batches > (SELECT COUNT(tim2.id)

Line 858: FROM hxt_timecards tim2

854: WHERE tim.batch_id = bat.batch_id
855: AND (tim.time_period_id <> i_time_period_id
856: OR tim.payroll_id <> i_payroll_id))
857: AND l_max_batches > (SELECT COUNT(tim2.id)
858: FROM hxt_timecards tim2
859: WHERE tim2.batch_id = bat.batch_id);
860: --END SIR343
861: --END GLOBAL
862: RETURN 0;