[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure insert_recorded_request( p_process in varchar2,
p_recorded_date in date,
p_attribute1 in varchar2 ,
p_attribute2 in varchar2 ,
p_attribute3 in varchar2 ,
p_attribute4 in varchar2 ,
p_attribute5 in varchar2 ,
p_attribute6 in varchar2 ,
p_attribute7 in varchar2 ,
p_attribute8 in varchar2 ,
p_attribute9 in varchar2 ,
p_attribute10 in varchar2 ,
p_attribute11 in varchar2 ,
p_attribute12 in varchar2 ,
p_attribute13 in varchar2 ,
p_attribute14 in varchar2 ,
p_attribute15 in varchar2 ,
p_attribute16 in varchar2 ,
p_attribute17 in varchar2 ,
p_attribute18 in varchar2 ,
p_attribute19 in varchar2 ,
p_attribute20 in varchar2 )
as
l_proc varchar2(72) := g_package||'insert_recorded_request';
INSERT INTO pay_recorded_requests(recorded_request_id,
recorded_date,
attribute_category,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20 )
VALUES (pay_recorded_requests_s.NEXTVAL,
p_recorded_date,
p_process,
p_attribute1 ,
p_attribute2 ,
p_attribute3 ,
p_attribute4 ,
p_attribute5 ,
p_attribute6 ,
p_attribute7 ,
p_attribute8 ,
p_attribute9 ,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19,
p_attribute20 );
END insert_recorded_request;
SELECT recorded_date
FROM pay_recorded_requests
WHERE attribute_category = p_process
and attribute1 = p_attribute1
and nvl(attribute2,'X') = nvl(p_attribute2,'X')
and nvl(attribute3,'X') = nvl(p_attribute3,'X')
and nvl(attribute4,'X') = nvl(p_attribute4,'X')
and nvl(attribute5,'X') = nvl(p_attribute5,'X')
and nvl(attribute6,'X') = nvl(p_attribute6,'X')
and nvl(attribute7,'X') = nvl(p_attribute7,'X')
and nvl(attribute8,'X') = nvl(p_attribute8,'X')
and nvl(attribute9,'X') = nvl(p_attribute9,'X')
and nvl(attribute10,'X') = nvl(p_attribute10,'X')
and nvl(attribute11,'X') = nvl(p_attribute11,'X')
and nvl(attribute12,'X') = nvl(p_attribute12,'X')
and nvl(attribute13,'X') = nvl(p_attribute13,'X')
and nvl(attribute14,'X') = nvl(p_attribute14,'X')
and nvl(attribute15,'X') = nvl(p_attribute15,'X')
and nvl(attribute16,'X') = nvl(p_attribute16,'X')
and nvl(attribute17,'X') = nvl(p_attribute17,'X')
and nvl(attribute18,'X') = nvl(p_attribute18,'X')
and nvl(attribute19,'X') = nvl(p_attribute19,'X')
and nvl(attribute20,'X') = nvl(p_attribute20,'X');
insert_recorded_request( p_process ,
l_recorded_date,
p_attribute1,
p_attribute2,
p_attribute3,
p_attribute4,
p_attribute5,
p_attribute6,
p_attribute7,
p_attribute8,
p_attribute9,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19 ,
p_attribute20);
SELECT recorded_date
FROM pay_recorded_requests
WHERE attribute_category = p_process
and attribute1 = p_attribute1
and nvl(attribute2,'X') = nvl(p_attribute2,'X')
and nvl(attribute3,'X') = nvl(p_attribute3,'X')
and nvl(attribute4,'X') = nvl(p_attribute4,'X')
and nvl(attribute5,'X') = nvl(p_attribute5,'X')
and nvl(attribute6,'X') = nvl(p_attribute6,'X')
and nvl(attribute7,'X') = nvl(p_attribute7,'X')
and nvl(attribute8,'X') = nvl(p_attribute8,'X')
and nvl(attribute9,'X') = nvl(p_attribute9,'X')
and nvl(attribute10,'X') = nvl(p_attribute10,'X')
and nvl(attribute11,'X') = nvl(p_attribute11,'X')
and nvl(attribute12,'X') = nvl(p_attribute12,'X')
and nvl(attribute13,'X') = nvl(p_attribute13,'X')
and nvl(attribute14,'X') = nvl(p_attribute14,'X')
and nvl(attribute15,'X') = nvl(p_attribute15,'X')
and nvl(attribute16,'X') = nvl(p_attribute16,'X')
and nvl(attribute17,'X') = nvl(p_attribute17,'X')
and nvl(attribute18,'X') = nvl(p_attribute18,'X')
and nvl(attribute19,'X') = nvl(p_attribute19,'X')
and nvl(attribute20,'X') = nvl(p_attribute20,'X');
SELECT recorded_date
FROM pay_recorded_requests
WHERE attribute_category = p_process
and attribute1 = p_attribute1
and nvl(attribute2,'X') = nvl(p_attribute2,'X')
and nvl(attribute3,'X') = nvl(p_attribute3,'X')
and nvl(attribute4,'X') = nvl(p_attribute4,'X')
and nvl(attribute5,'X') = nvl(p_attribute5,'X')
and nvl(attribute6,'X') = nvl(p_attribute6,'X')
and nvl(attribute7,'X') = nvl(p_attribute7,'X')
and nvl(attribute8,'X') = nvl(p_attribute8,'X')
and nvl(attribute9,'X') = nvl(p_attribute9,'X')
and nvl(attribute10,'X') = nvl(p_attribute10,'X')
and nvl(attribute11,'X') = nvl(p_attribute11,'X')
and nvl(attribute12,'X') = nvl(p_attribute12,'X')
and nvl(attribute13,'X') = nvl(p_attribute13,'X')
and nvl(attribute14,'X') = nvl(p_attribute14,'X')
and nvl(attribute15,'X') = nvl(p_attribute15,'X')
and nvl(attribute16,'X') = nvl(p_attribute16,'X')
and nvl(attribute17,'X') = nvl(p_attribute17,'X')
and nvl(attribute18,'X') = nvl(p_attribute18,'X')
and nvl(attribute19,'X') = nvl(p_attribute19,'X')
and nvl(attribute20,'X') = nvl(p_attribute20,'X')
for update of recorded_date;
insert_recorded_request(
p_process,
p_recorded_date,
p_attribute1 ,
p_attribute2 ,
p_attribute3 ,
p_attribute4 ,
p_attribute5 ,
p_attribute6 ,
p_attribute7 ,
p_attribute8 ,
p_attribute9 ,
p_attribute10,
p_attribute11,
p_attribute12,
p_attribute13,
p_attribute14,
p_attribute15,
p_attribute16,
p_attribute17,
p_attribute18,
p_attribute19,
p_attribute20 );
UPDATE pay_recorded_requests
SET recorded_date = p_recorded_date
WHERE attribute_category = p_process
and attribute1 = p_attribute1
and nvl(attribute2,'X') = nvl(p_attribute2,'X')
and nvl(attribute3,'X') = nvl(p_attribute3,'X')
and nvl(attribute4,'X') = nvl(p_attribute4,'X')
and nvl(attribute5,'X') = nvl(p_attribute5,'X')
and nvl(attribute6,'X') = nvl(p_attribute6,'X')
and nvl(attribute7,'X') = nvl(p_attribute7,'X')
and nvl(attribute8,'X') = nvl(p_attribute8,'X')
and nvl(attribute9,'X') = nvl(p_attribute9,'X')
and nvl(attribute10,'X') = nvl(p_attribute10,'X')
and nvl(attribute11,'X') = nvl(p_attribute11,'X')
and nvl(attribute12,'X') = nvl(p_attribute12,'X')
and nvl(attribute13,'X') = nvl(p_attribute13,'X')
and nvl(attribute14,'X') = nvl(p_attribute14,'X')
and nvl(attribute15,'X') = nvl(p_attribute15,'X')
and nvl(attribute16,'X') = nvl(p_attribute16,'X')
and nvl(attribute17,'X') = nvl(p_attribute17,'X')
and nvl(attribute18,'X') = nvl(p_attribute18,'X')
and nvl(attribute19,'X') = nvl(p_attribute19,'X')
and nvl(attribute20,'X') = nvl(p_attribute20,'X');