DBA Data[Home] [Help]

APPS.HXT_TIME_GEN dependencies on HXT_SUM_HOURS_WORKED_F

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;