hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)
An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data model behind this report isTimeApprovalNotificationBulkDM
The dataset I am interested in is SQL :
timecard_totals
The SQL is shown below:
SELECT
tm_rec_grp_id,
label_total,
reported_total, --*****
calculated_total, --*****
is_valid_record,
error_message
FROM
TABLE ( hwm_timecard_report.timecard_totals(
:bindtmrecgrpid1,
:bindtmrecgrpid2,
:bindtmrecgrpid3,
:bindtmrecgrpid4,
:bindtmrecgrpid5,
:bindaprvtmrecgrpid,
:bindTmCardMode,
:bindTmCardFlow,
:bindLoggedInUser ) )
)
The columns populated as show with ***** please can someone confirm what value type is returned from
this procedure (function) and its format. ie. → hwm_timecard_report.timecard_totals.