DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_SUM_HOURS_WORKED

Line 1178: --SIR012 INSERT INTO hxt_sum_hours_worked --C421

1174: RAISE l_seq_num_error;
1175: END IF;
1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115
1177: HXT_UTIL.DEBUG('Hours Worked Sequence Number is: '||TO_CHAR(l_sequence_number));--DEBUG ONLY --HXT115
1178: --SIR012 INSERT INTO hxt_sum_hours_worked --C421
1179: INSERT INTO hxt_sum_hours_worked_f --SIR012
1180: ( id,
1181: tim_id,
1182: -- C421 parent_id,

Line 1179: INSERT INTO hxt_sum_hours_worked_f --SIR012

1175: END IF;
1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115
1177: HXT_UTIL.DEBUG('Hours Worked Sequence Number is: '||TO_CHAR(l_sequence_number));--DEBUG ONLY --HXT115
1178: --SIR012 INSERT INTO hxt_sum_hours_worked --C421
1179: INSERT INTO hxt_sum_hours_worked_f --SIR012
1180: ( id,
1181: tim_id,
1182: -- C421 parent_id,
1183: date_worked,

Line 1216: from HXT_SUM_HOURS_WORKED --SIR012

1212: HXT_UTIL.DEBUG('Hours Worked Successfully inserted');--DEBUG ONLY --HXT115
1213:
1214: select rowid --SIR012
1215: into l_rowid --SIR012
1216: from HXT_SUM_HOURS_WORKED --SIR012
1217: where id = l_hours_worked_id; --SIR012
1218:
1219: /*Generate time details*/
1220: l_retcode := hxt_time_summary.Generate_Details(