DBA Data[Home] [Help]

APPS.CN_SRP_ROLLOVER_QUOTAS_PKG dependencies on CN_SRP_ROLLOVER_QUOTAS_S

Line 52: SELECT CN_SRP_ROLLOVER_QUOTAS_S.NEXTVAL

48: l_srp_rollover_quota_id NUMBER;
49: l_org_id NUMBER;
50: BEGIN
51: IF (X_SRP_ROLLOVER_QUOTA_ID IS NULL) THEN
52: SELECT CN_SRP_ROLLOVER_QUOTAS_S.NEXTVAL
53: INTO l_srp_rollover_quota_id
54: FROM dual;
55: ELSE
56: l_srp_rollover_quota_id := x_srp_rollover_quota_id;

Line 159: update CN_SRP_ROLLOVER_QUOTAS set

155: X_LAST_UPDATED_BY IN NUMBER,
156: X_LAST_UPDATE_LOGIN IN NUMBER
157: ) is
158: begin
159: update CN_SRP_ROLLOVER_QUOTAS set
160: ROLLOVER = X_ROLLOVER,
161: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
162: ATTRIBUTE1 = X_ATTRIBUTE1,
163: ATTRIBUTE2 = X_ATTRIBUTE2,