Individual RQ Line updates in ProcessFlow

Hi aathum - I don't have any experience with this particular module/screen, so I'm just guessing, but could you use a SQL query or table query to select the records for review, and then pass the keys to RQ10 to update the specific lines that you identify that need to be updated?

Hey Kelly:
RQ10 only allows relatively small number of lines to edit. 5 at a time. I'm not sure how I can get one at a time to go through. What would the procedure be for this?I know setting up a dme query (or sql but our sql jdbc drivers are currently hosed) I can loop through the detail requision lines one at a time and do my line type check. The part I am wrestling with is how do I update a single line at a time through a TRANS activity (AGS)? I am sure the process would be identical on AP20 or PO20 or similar line based form.

Does anyone know how to do this?

The Line Number field on RQ10 acts like a Position To field. I've only tried updating one line at a time but you might be okay to update several lines as long as they're in sequence. I usually put my AGS call within my DME so as I'm looping through my records in the query I send an update to the line via the AGS call.

David:
Thanks. I will give this a try. I have the DME loop on the lines. I just wasn't sure of the "key" to do the update on this form. I am assuming the AGS change function will do an auto inquire first?

Yes. The key fields for a requisition on RQ10 are requester and requisition number. You will want to include line number and the details of what you're changing. You do realize you can't change a requisition once it has been released (excluding adding comments)? Is your flow going to unrelease the requisition first?

Yes I have a trans that executes RQ13.1 to do this and it works fine.
I am also assuming that I position to the record by using the RLN-LINE-NBRr0 field correct? First line of the requisition screen setting the associated LINE-FCr0 for a change "C" and the rest as you mentioned?

the Setting the RLN-LINE-NBRr0 didn't work. Error stating line number cant be changed for this function

Yes, that should work.

I apologize - I'm sure that used to work. I just double checked my previous samples and there is a field for position to for RQ10 - PT-RLN-LINE-NBR. Use that instead of the line number field.

David:
That did the trick! Thank you for your assistance. For the benefit of others who may follow the thread:

For Line level updates in RQ10:
Supply values to

PT-RLN-COMPANY
PT-RLN-LINE-NBR - this comes from the SQL or DME line loop for REQLINE table

Your changes go into Row 0
LINE-FCr0=C
Select Line items to change where the variable ends in r0.
Such as RLN-FROM-LOCATIONr0 which would be located on the MISC Line tab in RQ10 and corresponding to the first displayable line.

Ahhhhh. I spoke too soon.
What the PT-RLN-LINE-NBR will do is get reset to the next block of 5 lines. For example: Try changing line 2 and PT-RLN-LINE-NBR gets set to 6. The r0 only changes the first line. So its not positioning directly on the line that we want to change.Back to drawing board. I am only getting the first line to change.

Finally!
OK The position field for individual line updates in RQ10 is the first (and only the first) RLN-LINE-NBRr0 field. I found this when I brought the form up in LID and confirmed by looking at the screen def RQ10.scr.
LID showed the field to be an input field and all the other RLN-LINE-NBRr1 through RLN-LINE-NBRr4 as output. Portal shows them all as input so it was confusing. To see how that works in Portal, enter the line number you want to position to in the first line number field and hit inquiry. The form will move that line to that position and display of  its line detail becomes available.
PT-RLN-LINE-NBR will then show the relative positionof the next group of lines

Thanks again David for pointing me in the right direction!