APPS.CN_SRP_ROLLOVER_QUOTAS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

procedure INSERT_ROW (
   X_ROWID in out NOCOPY VARCHAR2,
   X_SRP_ROLLOVER_QUOTA_ID IN OUT NOCOPY NUMBER,
   X_SRP_QUOTA_ASSIGN_ID IN NUMBER,
   X_ROLLOVER_QUOTA_ID IN NUMBER,
   X_QUOTA_ID IN NUMBER,
   X_SOURCE_QUOTA_ID IN NUMBER,
   X_ROLLOVER IN NUMBER,
   X_ATTRIBUTE_CATEGORY IN VARCHAR2	:= NULL,
   X_ATTRIBUTE1 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE2 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE3 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE4 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE5 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE6 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE7 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE8 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE9 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE10 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE11 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE12 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE13 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE14 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE15 IN VARCHAR2	:= NULL,
   X_CREATED_BY IN NUMBER,
   X_CREATION_DATE IN DATE,
   X_LAST_UPDATE_DATE IN DATE,
   X_LAST_UPDATED_BY IN NUMBER,
   X_LAST_UPDATE_LOGIN IN NUMBER
) is

   l_srp_rollover_quota_id NUMBER;

Line: 52

      SELECT CN_SRP_ROLLOVER_QUOTAS_S.NEXTVAL
	INTO l_srp_rollover_quota_id
	FROM dual;

Line: 60

   SELECT org_id INTO l_org_id
     FROM cn_srp_quota_assigns
    WHERE srp_quota_assign_id = x_srp_quota_assign_id;

Line: 64

  insert into CN_SRP_ROLLOVER_QUOTAS (
    SRP_ROLLOVER_QUOTA_ID,
    SRP_QUOTA_ASSIGN_ID,
    ROLLOVER_QUOTA_ID,
    QUOTA_ID,
    SOURCE_QUOTA_ID,
    ROLLOVER,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    OBJECT_VERSION_NUMBER,
    ORG_ID
    ) VALUES (
    l_srp_rollover_quota_id,
    X_SRP_QUOTA_ASSIGN_ID,
    X_ROLLOVER_QUOTA_ID,
    X_QUOTA_ID,
    X_SOURCE_QUOTA_ID,
    X_ROLLOVER,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    1,
    l_org_id);

Line: 125

end INSERT_ROW;

Line: 129

procedure UPDATE_ROW (
   X_SRP_ROLLOVER_QUOTA_ID IN NUMBER,
   X_SRP_QUOTA_ASSIGN_ID IN NUMBER,
   X_ROLLOVER_QUOTA_ID IN NUMBER,
   X_QUOTA_ID IN NUMBER,
   X_SOURCE_QUOTA_ID IN NUMBER,
   X_ROLLOVER IN NUMBER,
   X_ATTRIBUTE_CATEGORY IN VARCHAR2	:= NULL,
   X_ATTRIBUTE1 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE2 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE3 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE4 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE5 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE6 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE7 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE8 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE9 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE10 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE11 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE12 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE13 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE14 IN VARCHAR2	:= NULL,
   X_ATTRIBUTE15 IN VARCHAR2	:= NULL,
   X_CREATED_BY IN NUMBER,
   X_CREATION_DATE IN DATE,
   X_LAST_UPDATE_DATE IN DATE,
   X_LAST_UPDATED_BY IN NUMBER,
   X_LAST_UPDATE_LOGIN IN NUMBER
) is
begin
  update CN_SRP_ROLLOVER_QUOTAS set
    ROLLOVER = X_ROLLOVER,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
  where SRP_ROLLOVER_QUOTA_ID = X_SRP_ROLLOVER_QUOTA_ID;

Line: 186

end UPDATE_ROW;

Line: 188

procedure DELETE_ROW (
 X_SRP_ROLLOVER_QUOTA_ID IN NUMBER
) is
begin
  delete from CN_SRP_ROLLOVER_QUOTAS
  where SRP_ROLLOVER_QUOTA_ID = X_SRP_ROLLOVER_QUOTA_ID;

Line: 199

end DELETE_ROW;