APPS.PO_PALT_ASSIGNMENTS dependencies on PO_CLM_ASSIGNMENT_SEQUENCE

Line 37: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;

33: FROM PO_CLM_ASSIGNMENTS
34: WHERE ASSIGNMENT_NUMBER = l_Assignment_Number;
35:
36: IF (l_Assignment_count > 0) THEN
37: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;
38: END IF;
39: ELSE
40: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;
41: END IF;

Line 40: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;

36: IF (l_Assignment_count > 0) THEN
37: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;
38: END IF;
39: ELSE
40: l_Assignment_Number := PO_CLM_ASSIGNMENT_SEQUENCE.CURRVAL;
41: END IF;
42:
43: return l_Assignment_Number;
44:

Line 510: l_assignment_number := PO_CLM_ASSIGNMENT_SEQUENCE.NEXTVAL;

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:
512: INSERT INTO po_clm_assignments (assignment_id,
513: assignment_number,
514: created_by,