[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE select_row( recinfo IN OUT NOCOPY gl_daily_conversion_types%ROWTYPE) IS
BEGIN
SELECT *
INTO recinfo
FROM gl_daily_conversion_types
WHERE conversion_type = recinfo.conversion_type;
END SELECT_ROW;
PROCEDURE select_columns(
x_conversion_type VARCHAR2,
x_user_conversion_type IN OUT NOCOPY VARCHAR2) IS
recinfo gl_daily_conversion_types%ROWTYPE;
select_row(recinfo);
END select_columns;
SELECT 1
FROM GL_DAILY_CONVERSION_TYPES dct
WHERE dct.user_conversion_type =
check_unique_user_type.user_conversion_type
AND ( x_rowid is NULL
OR dct.rowid <> x_rowid );
SELECT 1
FROM GL_DAILY_CONVERSION_TYPES dct
WHERE dct.conversion_type =
check_unique_type.conversion_type
AND ( x_rowid is NULL
OR dct.rowid <> x_rowid );
select GL_DAILY_CONVERSION_TYPES_S.NEXTVAL
into next_val
from dual;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Conversion_Type VARCHAR2,
X_User_Conversion_Type VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER,
X_Description VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Context VARCHAR2,
X_Security_Flag VARCHAR2) IS
CURSOR C IS SELECT rowid
FROM GL_DAILY_CONVERSION_TYPES
WHERE conversion_type = X_Conversion_Type
AND user_conversion_type = X_User_Conversion_Type;
INSERT INTO GL_DAILY_CONVERSION_TYPES(
conversion_type,
user_conversion_type,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
description,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
context,
security_flag)
VALUES(
X_Conversion_Type,
X_User_Conversion_Type,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Description,
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_Context,
X_Security_Flag );
'GL_DAILY_CONV_TYPES_PKG.Insert_Row');
END Insert_Row;
CURSOR C IS SELECT
conversion_type,
user_conversion_type,
description,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
context,
security_flag
FROM GL_DAILY_CONVERSION_TYPES
WHERE ROWID = X_Rowid
FOR UPDATE OF conversion_type NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Conversion_Type VARCHAR2,
X_User_Conversion_Type VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Description VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Context VARCHAR2,
X_Security_Flag VARCHAR2) IS
BEGIN
UPDATE gl_daily_conversion_types
SET
user_conversion_type = X_User_Conversion_Type,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
description = X_Description,
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,
context = X_Context,
security_flag = X_Security_Flag
WHERE conversion_type = X_Conversion_Type;
'GL_DAILY_CONV_TYPES_PKG.Update_Row');
END Update_Row;
/* Modified calls to Insert_Row and Update_Row to include Security_Flag
(for Definition Access Sets Project) */
PROCEDURE Load_Row(
V_Conversion_Type VARCHAR2,
V_User_Conversion_Type VARCHAR2,
V_Description VARCHAR2,
V_Attribute1 VARCHAR2,
V_Attribute2 VARCHAR2,
V_Attribute3 VARCHAR2,
V_Attribute4 VARCHAR2,
V_Attribute5 VARCHAR2,
V_Attribute6 VARCHAR2,
V_Attribute7 VARCHAR2,
V_Attribute8 VARCHAR2,
V_Attribute9 VARCHAR2,
V_Attribute10 VARCHAR2,
V_Attribute11 VARCHAR2,
V_Attribute12 VARCHAR2,
V_Attribute13 VARCHAR2,
V_Attribute14 VARCHAR2,
V_Attribute15 VARCHAR2,
V_Context VARCHAR2,
V_Owner VARCHAR2,
V_Force_Edits VARCHAR2) IS
user_id NUMBER := 0;
the creation date for update_row. */
-- Added security_flag for DAS project
select creation_date, security_flag
into x_creation_date, x_security_flag
from gl_daily_conversion_types
where conversion_type = V_Conversion_Type;
/* Update only if Force_Edits is 'Y' or user_id = 1 */
IF ( Force_Edits = 'Y' OR user_id = 1 ) THEN
-- update row if present
GL_DAILY_CONV_TYPES_PKG.Update_Row(
X_Conversion_Type => V_Conversion_Type,
X_User_Conversion_Type => V_User_Conversion_Type,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Last_Update_Login => 0,
X_Description => V_Description,
X_Attribute1 => V_Attribute1,
X_Attribute2 => V_Attribute2,
X_Attribute3 => V_Attribute3,
X_Attribute4 => V_Attribute4,
X_Attribute5 => V_Attribute5,
X_Attribute6 => V_Attribute6,
X_Attribute7 => V_Attribute7,
X_Attribute8 => V_Attribute8,
X_Attribute9 => V_Attribute9,
X_Attribute10 => V_Attribute10,
X_Attribute11 => V_Attribute11,
X_Attribute12 => V_Attribute12,
X_Attribute13 => V_Attribute13,
X_Attribute14 => V_Attribute14,
X_Attribute15 => V_Attribute15,
X_Context => V_Context,
X_Security_Flag => x_security_flag);
GL_DAILY_CONV_TYPES_PKG.Insert_Row(
X_Rowid => V_Rowid,
X_Conversion_Type => V_Conversion_Type,
X_User_Conversion_Type => V_User_Conversion_Type,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => user_id,
X_Creation_Date => x_creation_date,
X_Created_By => user_id,
X_Last_Update_Login => 0,
X_Description => V_Description,
X_Attribute1 => V_Attribute1,
X_Attribute2 => V_Attribute2,
X_Attribute3 => V_Attribute3,
X_Attribute4 => V_Attribute4,
X_Attribute5 => V_Attribute5,
X_Attribute6 => V_Attribute6,
X_Attribute7 => V_Attribute7,
X_Attribute8 => V_Attribute8,
X_Attribute9 => V_Attribute9,
X_Attribute10 => V_Attribute10,
X_Attribute11 => V_Attribute11,
X_Attribute12 => V_Attribute12,
X_Attribute13 => V_Attribute13,
X_Attribute14 => V_Attribute14,
X_Attribute15 => V_Attribute15,
X_Context => V_Context,
X_Security_Flag => 'N');
/* Update only if Force_Edits is 'Y' or user_id = 1 */
IF ( Force_Edits = 'Y' OR user_id = 1 ) THEN
UPDATE GL_DAILY_CONVERSION_TYPES
SET
user_conversion_type = V_User_Conversion_Type,
description = V_Description,
last_update_date = sysdate,
last_updated_by = user_id,
last_update_login = 0
WHERE conversion_type = V_Conversion_Type
AND userenv('LANG') =
( SELECT language_code
FROM FND_LANGUAGES
WHERE installed_flag = 'B');