25: EXIT WHEN ReqlinesCur%NOTFOUND;
26: END LOOP;
27: CLOSE ReqlinesCur;
28:
29: l_Assignment_Number := po_palt_assignments_hook.AssignmentNumberCustHook(l_Requisition_Details);
30: IF (l_Assignment_Number is not NULL) THEN
31: SELECT count(*)
32: INTO l_Assignment_count
33: FROM PO_CLM_ASSIGNMENTS
503: EXIT WHEN ReqlinesCur%NOTFOUND;
504: END LOOP;
505: CLOSE ReqlinesCur;
506:
507: l_assignment_number := PO_PALT_ASSIGNMENTS_HOOK.AssignmentNumberCustHook(l_Requisition_Details);
508: -- If assignment number from hook is null, then create new assignment
509: IF l_assignment_number IS NULL THEN
510: l_assignment_number := PO_CLM_ASSIGNMENT_SEQUENCE.NEXTVAL;
511: