DAVE_TIME_SCAN_REC_DTL2 Function

To get detailed information for the selected time card rows, Use the DAVE time scan record DTL2 function.

Parameters

Parameter	Data Type	Comments
rpt_rs_key	TEXT	The row set key provided as an output by the DAVE_TIME_SCAN_SET function.
row_index	NUMBER	This parameter is optional. Use the row index to loop through by index or select a specific row by index. Values: 0 to row_count_ dtl, where row_count_ dtl is the number of detail records from DAVE_TIME_SCAN_SET output. Use negative one ( -1) for next record, similar to vo.next. You don't need to use index.

Parameter

Data Type

Comments

rpt_rs_key

TEXT

The row set key provided as an output by the DAVE_TIME_SCAN_SET function.

row_index

NUMBER

This parameter is optional. Use the row index to loop through by index or select a specific row by index.

Values:

0 to row_count_ dtl, where row_count_ dtl is the number of detail records from DAVE_TIME_SCAN_SET output.
Use negative one ( -1) for next record, similar to vo.next. You don't need to use index.

Outputs

Output	Data Type	Comments
status_log	TEXT	Request status, possible values are: 'N0_REC_FOUND' 'SUCCESS' 'FAILED'
status_log	TEXT	The log file containing detailed information related to the 'FAILED' status and corresponding process data.
tc_date	DATE	The actual date retrieved. The tc_date matches the eff_date parameter when the function uses the parameter.
is_use_day_type	TEXT	Indicate whether the day total should use the reported time card date, overtime date, or earned date. Valid values: Y, REFERENCE, OVERTIME: Use reference date or overtime days N, TIMECARD, or leave blank: Use time card date EARNED: Use Earned date
Overtime_Date	DATE	Date to use for the time entry when calculating overtime
Earned_Date	DATE	Date to use when processing the time entry for payment
measure	NUMBER	The summed time totals for the selected rows.
uom	TEXT	Unit of measure for the time date in the selected rows, valid values are Hours and Units.
start_time	DATE	The start time of the time entry.
stop_time	DATE	The end time of the time entry.
abs_type	TEXT	The absence type time attribute, which Oracle Fusion Absence Management provides.
pay_type	TEXT	The payroll time type attribute, which Oracle Fusion Global Payroll provides.
time_data_type	TEXT	The type of time data, valid values are: MEASURE and RANGE MEASURE: The time entry value is a duration rather than a combination of start and end times. RANGE: The time entry value is composed of start and end times rather than a duration.
zone_type	TEXT	The zone type to use when offsetting start and end dates and times.
start_time_zone_code	TEXT	The zone code to use when offsetting the start date and time.
stop_time_zone_code	TEXT	The zone code to use when offsetting the stop date and time.
start_gmt_offset	NUMBER	The Greenwich Mean Time (GMT) to use when offsetting the start date and time.
stop_gmt_offset	NUMBER	The Greenwich Mean Time (GMT) to use when offsetting the stop date and time.