DBA Data[Home] [Help]

APPS.CN_ROLLOVER_QUOTAS_PKG dependencies on CN_ROLLOVER_QUOTAS_S

Line 50: SELECT CN_ROLLOVER_QUOTAS_S.NEXTVAL

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;

Line 152: update CN_ROLLOVER_QUOTAS set

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,