The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row (
x_orig_system IN VARCHAR2,
x_owner_table_name IN VARCHAR2,
x_status IN VARCHAR2,
x_multiple_flag IN VARCHAR2,
--raji
x_multi_osr_flag IN VARCHAR2,
x_object_version_number IN NUMBER,
x_created_by_module IN VARCHAR2,
x_application_id IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2
) IS
BEGIN
INSERT INTO HZ_ORIG_SYS_MAPPING (
orig_system,
owner_table_name,
status,
multiple_flag,
--raji
multi_osr_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
object_version_number,
created_by_module,
application_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
)
VALUES (
DECODE(x_orig_system,
FND_API.G_MISS_CHAR, NULL,
x_orig_system),
DECODE(x_owner_table_name,
FND_API.G_MISS_CHAR, NULL,
x_owner_table_name),
DECODE(x_status,
FND_API.G_MISS_CHAR, 'A',
NULL, 'A',
x_status),
DECODE(x_multiple_flag,
FND_API.G_MISS_CHAR, 'N',NULL, 'N',
x_multiple_flag),
--raji
DECODE(x_multi_osr_flag,
FND_API.G_MISS_CHAR,'Y',NULL,'Y',
x_multi_osr_flag),
hz_utility_v2pub.created_by,
hz_utility_v2pub.creation_date,
hz_utility_v2pub.last_updated_by,
hz_utility_v2pub.last_update_date,
hz_utility_v2pub.last_update_login,
DECODE(x_object_version_number,
FND_API.G_MISS_NUM, NULL,
x_object_version_number),
DECODE(x_created_by_module,
FND_API.G_MISS_CHAR, NULL,
x_created_by_module),
hz_utility_v2pub.application_id,
DECODE(x_attribute_category,
FND_API.G_MISS_CHAR, NULL,
x_attribute_category),
DECODE(x_attribute1,
FND_API.G_MISS_CHAR, NULL,
x_attribute1),
DECODE(x_attribute2,
FND_API.G_MISS_CHAR, NULL,
x_attribute2),
DECODE(x_attribute3,
FND_API.G_MISS_CHAR, NULL,
x_attribute3),
DECODE(x_attribute4,
FND_API.G_MISS_CHAR, NULL,
x_attribute4),
DECODE(x_attribute5,
FND_API.G_MISS_CHAR, NULL,
x_attribute5),
DECODE(x_attribute6,
FND_API.G_MISS_CHAR, NULL,
x_attribute6),
DECODE(x_attribute7,
FND_API.G_MISS_CHAR, NULL,
x_attribute7),
DECODE(x_attribute8,
FND_API.G_MISS_CHAR, NULL,
x_attribute8),
DECODE(x_attribute9,
FND_API.G_MISS_CHAR, NULL,
x_attribute9),
DECODE(x_attribute10,
FND_API.G_MISS_CHAR, NULL,
x_attribute10),
DECODE(x_attribute11,
FND_API.G_MISS_CHAR, NULL,
x_attribute11),
DECODE(x_attribute12,
FND_API.G_MISS_CHAR, NULL,
x_attribute12),
DECODE(x_attribute13,
FND_API.G_MISS_CHAR, NULL,
x_attribute13),
DECODE(x_attribute14,
FND_API.G_MISS_CHAR, NULL,
x_attribute14),
DECODE(x_attribute15,
FND_API.G_MISS_CHAR, NULL,
x_attribute15),
DECODE(x_attribute16,
FND_API.G_MISS_CHAR, NULL,
x_attribute16),
DECODE(x_attribute17,
FND_API.G_MISS_CHAR, NULL,
x_attribute17),
DECODE(x_attribute18,
FND_API.G_MISS_CHAR, NULL,
x_attribute18),
DECODE(x_attribute19,
FND_API.G_MISS_CHAR, NULL,
x_attribute19),
DECODE(x_attribute20,
FND_API.G_MISS_CHAR, NULL,
x_attribute20)
) ;
END Insert_Row;
PROCEDURE Update_Row (
x_orig_system IN VARCHAR2,
x_owner_table_name IN VARCHAR2,
x_status IN VARCHAR2,
x_multiple_flag IN VARCHAR2,
--raji
x_multi_osr_flag IN VARCHAR2,
x_object_version_number IN NUMBER,
x_created_by_module IN VARCHAR2,
x_application_id IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2
) IS
BEGIN
UPDATE HZ_ORIG_SYS_MAPPING
SET
orig_system =
DECODE(x_orig_system,
NULL, orig_system,
FND_API.G_MISS_CHAR, NULL,
x_orig_system),
owner_table_name =
DECODE(x_owner_table_name,
NULL, owner_table_name,
FND_API.G_MISS_CHAR, NULL,
x_owner_table_name),
status =
DECODE(x_status,
NULL, status,
FND_API.G_MISS_CHAR, NULL,
x_status),
multiple_flag =
DECODE(x_multiple_flag,
NULL, multiple_flag,
FND_API.G_MISS_CHAR, NULL,
x_multiple_flag),
--raji
multi_osr_flag =
DECODE(x_multi_osr_flag,
NULL,multi_osr_flag,
FND_API.G_MISS_CHAR,'Y',
x_multi_osr_flag),
created_by = created_by,
creation_date = creation_date,
last_updated_by = hz_utility_v2pub.last_updated_by,
last_update_date = hz_utility_v2pub.last_update_date,
last_update_login = hz_utility_v2pub.last_update_login,
object_version_number =
DECODE(x_object_version_number,
NULL, object_version_number,
FND_API.G_MISS_NUM, NULL,
x_object_version_number),
created_by_module =
DECODE(x_created_by_module,
NULL, created_by_module,
FND_API.G_MISS_CHAR, NULL,
x_created_by_module),
application_id = hz_utility_v2pub.application_id,
attribute_category =
DECODE(x_attribute_category,
NULL, attribute_category,
FND_API.G_MISS_CHAR, NULL,
x_attribute_category),
attribute1 =
DECODE(x_attribute1,
NULL, attribute1,
FND_API.G_MISS_CHAR, NULL,
x_attribute1),
attribute2 =
DECODE(x_attribute2,
NULL, attribute2,
FND_API.G_MISS_CHAR, NULL,
x_attribute2),
attribute3 =
DECODE(x_attribute3,
NULL, attribute3,
FND_API.G_MISS_CHAR, NULL,
x_attribute3),
attribute4 =
DECODE(x_attribute4,
NULL, attribute4,
FND_API.G_MISS_CHAR, NULL,
x_attribute4),
attribute5 =
DECODE(x_attribute5,
NULL, attribute5,
FND_API.G_MISS_CHAR, NULL,
x_attribute5),
attribute6 =
DECODE(x_attribute6,
NULL, attribute6,
FND_API.G_MISS_CHAR, NULL,
x_attribute6),
attribute7 =
DECODE(x_attribute7,
NULL, attribute7,
FND_API.G_MISS_CHAR, NULL,
x_attribute7),
attribute8 =
DECODE(x_attribute8,
NULL, attribute8,
FND_API.G_MISS_CHAR, NULL,
x_attribute8),
attribute9 =
DECODE(x_attribute9,
NULL, attribute9,
FND_API.G_MISS_CHAR, NULL,
x_attribute9),
attribute10 =
DECODE(x_attribute10,
NULL, attribute10,
FND_API.G_MISS_CHAR, NULL,
x_attribute10),
attribute11 =
DECODE(x_attribute11,
NULL, attribute11,
FND_API.G_MISS_CHAR, NULL,
x_attribute11),
attribute12 =
DECODE(x_attribute12,
NULL, attribute12,
FND_API.G_MISS_CHAR, NULL,
x_attribute12),
attribute13 =
DECODE(x_attribute13,
NULL, attribute13,
FND_API.G_MISS_CHAR, NULL,
x_attribute13),
attribute14 =
DECODE(x_attribute14,
NULL, attribute14,
FND_API.G_MISS_CHAR, NULL,
x_attribute14),
attribute15 =
DECODE(x_attribute15,
NULL, attribute15,
FND_API.G_MISS_CHAR, NULL,
x_attribute15),
attribute16 =
DECODE(x_attribute16,
NULL, attribute16,
FND_API.G_MISS_CHAR, NULL,
x_attribute16),
attribute17 =
DECODE(x_attribute17,
NULL, attribute17,
FND_API.G_MISS_CHAR, NULL,
x_attribute17),
attribute18 =
DECODE(x_attribute18,
NULL, attribute18,
FND_API.G_MISS_CHAR, NULL,
x_attribute18),
attribute19 =
DECODE(x_attribute19,
NULL, attribute19,
FND_API.G_MISS_CHAR, NULL,
x_attribute19),
attribute20 =
DECODE(x_attribute20,
NULL, attribute20,
FND_API.G_MISS_CHAR, NULL,
x_attribute20)
WHERE ORIG_SYSTEM = X_ORIG_SYSTEM
AND OWNER_TABLE_NAME = X_OWNER_TABLE_NAME;
END Update_Row;
x_last_updated_by IN NUMBER,
x_last_update_date IN DATE,
x_last_update_login IN NUMBER,
x_object_version_number IN NUMBER,
x_created_by_module IN VARCHAR2,
x_application_id IN NUMBER,
x_attribute_category IN VARCHAR2,
x_attribute1 IN VARCHAR2,
x_attribute2 IN VARCHAR2,
x_attribute3 IN VARCHAR2,
x_attribute4 IN VARCHAR2,
x_attribute5 IN VARCHAR2,
x_attribute6 IN VARCHAR2,
x_attribute7 IN VARCHAR2,
x_attribute8 IN VARCHAR2,
x_attribute9 IN VARCHAR2,
x_attribute10 IN VARCHAR2,
x_attribute11 IN VARCHAR2,
x_attribute12 IN VARCHAR2,
x_attribute13 IN VARCHAR2,
x_attribute14 IN VARCHAR2,
x_attribute15 IN VARCHAR2,
x_attribute16 IN VARCHAR2,
x_attribute17 IN VARCHAR2,
x_attribute18 IN VARCHAR2,
x_attribute19 IN VARCHAR2,
x_attribute20 IN VARCHAR2
) IS
CURSOR c IS
SELECT * FROM HZ_ORIG_SYS_MAPPING
WHERE rowid = x_rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.last_updated_by = x_last_updated_by )
OR ( ( Recinfo.last_updated_by IS NULL )
AND ( x_last_updated_by IS NULL ) ) )
AND ( ( Recinfo.last_update_date = x_last_update_date )
OR ( ( Recinfo.last_update_date IS NULL )
AND ( x_last_update_date IS NULL ) ) )
AND ( ( Recinfo.last_update_login = x_last_update_login )
OR ( ( Recinfo.last_update_login IS NULL )
AND ( x_last_update_login IS NULL ) ) )
AND ( ( Recinfo.object_version_number = x_object_version_number )
OR ( ( Recinfo.object_version_number IS NULL )
AND ( x_object_version_number IS NULL ) ) )
AND ( ( Recinfo.created_by_module = x_created_by_module )
OR ( ( Recinfo.created_by_module IS NULL )
AND ( x_created_by_module IS NULL ) ) )
AND ( ( Recinfo.application_id = x_application_id )
OR ( ( Recinfo.application_id IS NULL )
AND ( x_application_id IS NULL ) ) )
AND ( ( Recinfo.attribute_category = x_attribute_category )
OR ( ( Recinfo.attribute_category IS NULL )
AND ( x_attribute_category IS NULL ) ) )
AND ( ( Recinfo.attribute1 = x_attribute1 )
OR ( ( Recinfo.attribute1 IS NULL )
AND ( x_attribute1 IS NULL ) ) )
AND ( ( Recinfo.attribute2 = x_attribute2 )
OR ( ( Recinfo.attribute2 IS NULL )
AND ( x_attribute2 IS NULL ) ) )
AND ( ( Recinfo.attribute3 = x_attribute3 )
OR ( ( Recinfo.attribute3 IS NULL )
AND ( x_attribute3 IS NULL ) ) )
AND ( ( Recinfo.attribute4 = x_attribute4 )
OR ( ( Recinfo.attribute4 IS NULL )
AND ( x_attribute4 IS NULL ) ) )
AND ( ( Recinfo.attribute5 = x_attribute5 )
OR ( ( Recinfo.attribute5 IS NULL )
AND ( x_attribute5 IS NULL ) ) )
AND ( ( Recinfo.attribute6 = x_attribute6 )
OR ( ( Recinfo.attribute6 IS NULL )
AND ( x_attribute6 IS NULL ) ) )
AND ( ( Recinfo.attribute7 = x_attribute7 )
OR ( ( Recinfo.attribute7 IS NULL )
AND ( x_attribute7 IS NULL ) ) )
AND ( ( Recinfo.attribute8 = x_attribute8 )
OR ( ( Recinfo.attribute8 IS NULL )
AND ( x_attribute8 IS NULL ) ) )
AND ( ( Recinfo.attribute9 = x_attribute9 )
OR ( ( Recinfo.attribute9 IS NULL )
AND ( x_attribute9 IS NULL ) ) )
AND ( ( Recinfo.attribute10 = x_attribute10 )
OR ( ( Recinfo.attribute10 IS NULL )
AND ( x_attribute10 IS NULL ) ) )
AND ( ( Recinfo.attribute11 = x_attribute11 )
OR ( ( Recinfo.attribute11 IS NULL )
AND ( x_attribute11 IS NULL ) ) )
AND ( ( Recinfo.attribute12 = x_attribute12 )
OR ( ( Recinfo.attribute12 IS NULL )
AND ( x_attribute12 IS NULL ) ) )
AND ( ( Recinfo.attribute13 = x_attribute13 )
OR ( ( Recinfo.attribute13 IS NULL )
AND ( x_attribute13 IS NULL ) ) )
AND ( ( Recinfo.attribute14 = x_attribute14 )
OR ( ( Recinfo.attribute14 IS NULL )
AND ( x_attribute14 IS NULL ) ) )
AND ( ( Recinfo.attribute15 = x_attribute15 )
OR ( ( Recinfo.attribute15 IS NULL )
AND ( x_attribute15 IS NULL ) ) )
AND ( ( Recinfo.attribute16 = x_attribute16 )
OR ( ( Recinfo.attribute16 IS NULL )
AND ( x_attribute16 IS NULL ) ) )
AND ( ( Recinfo.attribute17 = x_attribute17 )
OR ( ( Recinfo.attribute17 IS NULL )
AND ( x_attribute17 IS NULL ) ) )
AND ( ( Recinfo.attribute18 = x_attribute18 )
OR ( ( Recinfo.attribute18 IS NULL )
AND ( x_attribute18 IS NULL ) ) )
AND ( ( Recinfo.attribute19 = x_attribute19 )
OR ( ( Recinfo.attribute19 IS NULL )
AND ( x_attribute19 IS NULL ) ) )
AND ( ( Recinfo.attribute20 = x_attribute20 )
OR ( ( Recinfo.attribute20 IS NULL )
AND ( x_attribute20 IS NULL ) ) )
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Select_Row (
x_orig_system IN OUT NOCOPY VARCHAR2,
x_owner_table_name IN OUT NOCOPY VARCHAR2,
x_status OUT NOCOPY VARCHAR2,
x_multiple_flag OUT NOCOPY VARCHAR2,
--raji
x_multi_osr_flag OUT NOCOPY VARCHAR2,
x_object_version_number OUT NOCOPY NUMBER,
x_created_by_module OUT NOCOPY VARCHAR2,
x_application_id OUT NOCOPY NUMBER,
x_attribute_category OUT NOCOPY VARCHAR2,
x_attribute1 OUT NOCOPY VARCHAR2,
x_attribute2 OUT NOCOPY VARCHAR2,
x_attribute3 OUT NOCOPY VARCHAR2,
x_attribute4 OUT NOCOPY VARCHAR2,
x_attribute5 OUT NOCOPY VARCHAR2,
x_attribute6 OUT NOCOPY VARCHAR2,
x_attribute7 OUT NOCOPY VARCHAR2,
x_attribute8 OUT NOCOPY VARCHAR2,
x_attribute9 OUT NOCOPY VARCHAR2,
x_attribute10 OUT NOCOPY VARCHAR2,
x_attribute11 OUT NOCOPY VARCHAR2,
x_attribute12 OUT NOCOPY VARCHAR2,
x_attribute13 OUT NOCOPY VARCHAR2,
x_attribute14 OUT NOCOPY VARCHAR2,
x_attribute15 OUT NOCOPY VARCHAR2,
x_attribute16 OUT NOCOPY VARCHAR2,
x_attribute17 OUT NOCOPY VARCHAR2,
x_attribute18 OUT NOCOPY VARCHAR2,
x_attribute19 OUT NOCOPY VARCHAR2,
x_attribute20 OUT NOCOPY VARCHAR2
) IS
BEGIN
SELECT
NVL(orig_system, FND_API.G_MISS_CHAR),
NVL(owner_table_name, FND_API.G_MISS_CHAR),
NVL(status, FND_API.G_MISS_CHAR),
NVL(multiple_flag, FND_API.G_MISS_CHAR),
--raji
NVL(multi_osr_flag,FND_API.G_MISS_CHAR),
NVL(created_by_module, FND_API.G_MISS_CHAR),
NVL(application_id, FND_API.G_MISS_NUM),
NVL(attribute_category, FND_API.G_MISS_CHAR),
NVL(attribute1, FND_API.G_MISS_CHAR),
NVL(attribute2, FND_API.G_MISS_CHAR),
NVL(attribute3, FND_API.G_MISS_CHAR),
NVL(attribute4, FND_API.G_MISS_CHAR),
NVL(attribute5, FND_API.G_MISS_CHAR),
NVL(attribute6, FND_API.G_MISS_CHAR),
NVL(attribute7, FND_API.G_MISS_CHAR),
NVL(attribute8, FND_API.G_MISS_CHAR),
NVL(attribute9, FND_API.G_MISS_CHAR),
NVL(attribute10, FND_API.G_MISS_CHAR),
NVL(attribute11, FND_API.G_MISS_CHAR),
NVL(attribute12, FND_API.G_MISS_CHAR),
NVL(attribute13, FND_API.G_MISS_CHAR),
NVL(attribute14, FND_API.G_MISS_CHAR),
NVL(attribute15, FND_API.G_MISS_CHAR),
NVL(attribute16, FND_API.G_MISS_CHAR),
NVL(attribute17, FND_API.G_MISS_CHAR),
NVL(attribute18, FND_API.G_MISS_CHAR),
NVL(attribute19, FND_API.G_MISS_CHAR),
NVL(attribute20, FND_API.G_MISS_CHAR)
INTO
x_orig_system,
x_owner_table_name,
x_status,
x_multiple_flag,
--raji
x_multi_osr_flag,
x_created_by_module,
x_application_id,
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_attribute16,
x_attribute17,
x_attribute18,
x_attribute19,
x_attribute20
FROM HZ_ORIG_SYS_MAPPING
WHERE ORIG_SYSTEM = X_ORIG_SYSTEM
AND OWNER_TABLE_NAME = X_OWNER_TABLE_NAME;
END Select_Row;