APPS.HXT_TIME_GEN dependencies on HXT_SUM_HOURS_WORKED

Line 508: -- l_group_id hxt_sum_hours_worked.group_id%TYPE default null;

504: l_early_start NUMBER;
505: l_late_stop NUMBER;
506: l_error NUMBER;
507: l_hours NUMBER;
508: -- l_group_id hxt_sum_hours_worked.group_id%TYPE default null;
509: BEGIN
510: -- Update location path with function name
511: g_err_loc := 'Autogen Workplan';
512: -- Get number of days to be generated

Line 932: --SIR012 INSERT into hxt_sum_hours_worked --C431

928: -- Insert hour worked record
929: g_sub_loc := 'INSERT into hxt_hours_worked';
930:
931:
932: --SIR012 INSERT into hxt_sum_hours_worked --C431
933: -- 1704149 Commented the lines which insert values into WHO columns.
934: INSERT INTO hxt_sum_hours_worked_f
935: (id, tim_id, date_worked, seqno,
936: hours, assignment_id, element_type_id, time_in, time_out

Line 934: INSERT INTO hxt_sum_hours_worked_f

930:
931:
932: --SIR012 INSERT into hxt_sum_hours_worked --C431
933: -- 1704149 Commented the lines which insert values into WHO columns.
934: INSERT INTO hxt_sum_hours_worked_f
935: (id, tim_id, date_worked, seqno,
936: hours, assignment_id, element_type_id, time_in, time_out
937: -- , created_by
938: -- , creation_date

Line 961: FROM hxt_sum_hours_worked_f

957:
958: -- begin SIR012. need rowid for call to generate_details.
959: SELECT ROWID
960: INTO l_rowid
961: FROM hxt_sum_hours_worked_f
962: WHERE id = l_hrw_id;
963:
964: -- Create detail records
965: g_sub_loc := 'HXT_TIME_SUMMARY.Generate_Details';

Line 1269: DELETE FROM hxt_sum_hours_worked_f

1265: LOOP
1266: DELETE FROM hxt_det_hours_worked_f
1267: WHERE tim_id = l_record.id;
1268:
1269: DELETE FROM hxt_sum_hours_worked_f
1270: WHERE tim_id = l_record.id;
1271:
1272: DELETE FROM hxt_timecards_f
1273: WHERE id = l_record.id;

Line 1386: --SIR012 DELETE from hxt_sum_hours_worked

1382:
1383: DELETE FROM hxt_det_hours_worked_f --C421
1384: WHERE tim_id = a_tim_id;
1385:
1386: --SIR012 DELETE from hxt_sum_hours_worked
1387: DELETE FROM hxt_sum_hours_worked
1388: WHERE tim_id = a_tim_id; --C421
1389:
1390: COMMIT;

Line 1387: DELETE FROM hxt_sum_hours_worked

1383: DELETE FROM hxt_det_hours_worked_f --C421
1384: WHERE tim_id = a_tim_id;
1385:
1386: --SIR012 DELETE from hxt_sum_hours_worked
1387: DELETE FROM hxt_sum_hours_worked
1388: WHERE tim_id = a_tim_id; --C421
1389:
1390: COMMIT;
1391: -- Delete existing hxt_errors records for this timecard