CSF_DEBRIEF_PUB.CREATE_DEBRIEF_LINES - How to Get the Debrief Line ID API Created?
I am successfully calling the CSF_DEBRIEF_PUB.CREATE_DEBRIEF_LINES to create debrief lines. I am passing the debrief header ID that I already have and letting the API determine the debrief line ID to use.
What I have not determined is how to get the DEBRIEF_LINE_ID that was created each time I call the API.
If I call the API as such:
l_debrief_line_tbl_type := CSF_DEBRIEF_PUB.G_MISS_DEBRIEF_LINE_TBL;
l_debrief_line_tbl_type(1).DEBRIEF_HEADER_ID := R3.DEBRIEF_HEADER_ID;
l_debrief_line_tbl_type(1).SERVICE_DATE := SYSDATE;
l_debrief_line_tbl_type(1).BUSINESS_PROCESS_ID := R3.BUSINESS_PROCESS_ID;