46: l_rollover_quota_id NUMBER;
47: BEGIN
48:
49: IF (X_ROLLOVER_QUOTA_ID IS NULL) THEN
50: SELECT CN_ROLLOVER_QUOTAS_S.NEXTVAL
51: INTO l_rollover_quota_id
52: FROM dual;
53: ELSE
54: l_rollover_quota_id := x_rollover_quota_id;
148: X_LAST_UPDATED_BY IN NUMBER,
149: X_LAST_UPDATE_LOGIN IN NUMBER
150: ) is
151: begin
152: update CN_ROLLOVER_QUOTAS set
153: SOURCE_QUOTA_ID = X_SOURCE_QUOTA_ID,
154: ROLLOVER = X_ROLLOVER,
155: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
156: ATTRIBUTE1 = X_ATTRIBUTE1,