[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(p_sys_param_all_rec IN
oe_parameters_pkg.sys_param_all_rec_type,
x_row_id OUT NOCOPY VARCHAR2)
IS
CURSOR get_rowid IS
SELECT rowid FROM oe_sys_parameters_all
WHERE nvl(org_id, -99) = nvl(p_sys_param_all_rec.org_Id, -99)
AND parameter_code = p_sys_param_all_rec.parameter_code;
INSERT INTO oe_sys_parameters_all(
org_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
parameter_code,
parameter_value,
context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
)
VALUES (
p_sys_param_all_rec.org_id,
p_sys_param_all_rec.creation_date,
p_sys_param_all_rec.created_by,
p_sys_param_all_rec.last_update_date,
p_sys_param_all_rec.last_updated_by,
p_sys_param_all_rec.last_update_login,
p_sys_param_all_rec.parameter_code,
p_sys_param_all_rec.parameter_value,
p_sys_param_all_rec.Context,
p_sys_param_all_rec.Attribute1,
p_sys_param_all_rec.Attribute2,
p_sys_param_all_rec.Attribute3,
p_sys_param_all_rec.Attribute4,
p_sys_param_all_rec.Attribute5,
p_sys_param_all_rec.Attribute6,
p_sys_param_all_rec.Attribute7,
p_sys_param_all_rec.Attribute8,
p_sys_param_all_rec.Attribute9,
p_sys_param_all_rec.Attribute10,
p_sys_param_all_rec.Attribute11,
p_sys_param_all_rec.Attribute12,
p_sys_param_all_rec.Attribute13,
p_sys_param_all_rec.Attribute14,
p_sys_param_all_rec.Attribute15
);
END Insert_Row;
SELECT org_id,parameter_value,
context,attribute1,
attribute2,attribute3,
attribute4,attribute5,
attribute6,attribute7,
attribute8,attribute9,
attribute10,attribute11,
attribute12,attribute13,
attribute14,attribute15
FROM oe_sys_parameters_all
WHERE rowid = p_row_id
FOR UPDATE OF parameter_value NOWAIT;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(x_row_id IN OUT NOCOPY VARCHAR2,
p_sys_param_all_rec IN
oe_parameters_pkg.sys_param_all_rec_type)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
UPDATE oe_sys_parameters_all
SET
org_id = p_sys_param_all_rec.org_id,
last_update_date = p_sys_param_all_rec.Last_Update_Date,
last_updated_by = p_sys_param_all_rec.Last_Updated_By,
last_update_login = p_sys_param_all_rec.Last_Update_Login,
parameter_value = p_sys_param_all_rec.parameter_value,
context = p_sys_param_all_rec.Context,
attribute1 = p_sys_param_all_rec.Attribute1,
attribute2 = p_sys_param_all_rec.Attribute2,
attribute3 = p_sys_param_all_rec.Attribute3,
attribute4 = p_sys_param_all_rec.Attribute4,
attribute5 = p_sys_param_all_rec.Attribute5,
attribute6 = p_sys_param_all_rec.Attribute6,
attribute7 = p_sys_param_all_rec.Attribute7,
attribute8 = p_sys_param_all_rec.Attribute8,
attribute9 = p_sys_param_all_rec.Attribute9,
attribute10 = p_sys_param_all_rec.Attribute10,
attribute11 = p_sys_param_all_rec.Attribute11,
attribute12 = p_sys_param_all_rec.Attribute12,
attribute13 = p_sys_param_all_rec.Attribute13,
attribute14 = p_sys_param_all_rec.Attribute14,
attribute15 = p_sys_param_all_rec.Attribute15
WHERE rowid = X_Row_id;
Insert_Row(p_sys_param_all_rec,
x_row_id );
ELSE -- New Record Insert it.
Insert_Row(p_sys_param_all_rec,
x_row_id);
END Update_Row;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Organization_Id NUMBER,
X_Last_Update_Date DATE ,
X_Last_Updated_By NUMBER ,
X_Creation_Date DATE ,
X_Created_By NUMBER ,
X_Last_Update_Login NUMBER,
X_Master_Organization_Id NUMBER,
x_customer_relationships_flag varchar2,
X_Audit_trail_Enable_Flag VARCHAR2,
--MRG BGN
X_Compute_Margin_Flag VARCHAR2,
--MRG END
--freight rating begin
X_Freight_Rating_Enabled_Flag VARCHAR2,
--freight rating end
X_Fte_Ship_Method_Enabled_Flag VARCHAR2,
X_Context 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
) IS
-- CURSOR C IS SELECT rowid FROM oe_system_parameters_all
/** WHERE nvl(org_id, -99) = nvl(X_Organization_Id, -99); **/
INSERT INTO oe_system_parameters_all(
org_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
master_organization_id,
customer_relationships_flag,
audit_trail_enable_flag,
--MRG BGN
Compute_Margin_Flag,
--MRG END
--freight rating begin
freight_rating_enabled_flag,
--freight rating end
Fte_Ship_Method_enabled_flag,
context,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
)
VALUES (
X_Organization_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Master_Organization_Id,
x_customer_relationships_flag,
X_Audit_trail_Enable_Flag,
--MRG BGN
X_Compute_Margin_Flag,
--MRG END
--freight rating begin
X_Freight_Rating_Enabled_flag,
--freight rating end
X_Fte_Ship_Method_Enabled_Flag,
X_Context,
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
);
END Insert_Row;
SELECT *
FROM oe_system_parameters_all
WHERE rowid = X_Rowid
FOR UPDATE of Org_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Organization_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Master_Organization_Id NUMBER,
x_customer_relationships_flag varchar2,
X_Audit_trail_Enable_Flag VARCHAR2,
--MRG BGN
X_Compute_Margin_Flag VARCHAR2,
--MRG END
--freight rating begin
X_Freight_Rating_Enabled_Flag VARCHAR2,
--freight rating end
X_Fte_Ship_Method_Enabled_Flag VARCHAR2,
X_Context 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
) IS
BEGIN
/*
UPDATE oe_system_parameters_all
SET
org_id = X_Organization_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
master_organization_id = X_Master_Organization_Id,
customer_relationships_flag = x_customer_relationships_flag,
audit_trail_enable_flag = X_Audit_trail_Enable_Flag,
--MRG BGN
Compute_Margin_Flag = X_Compute_Margin_Flag,
--MRG END
--freight rating begin
freight_rating_enabled_flag = X_Freight_Rating_Enabled_flag,
--freight rating end
Fte_Ship_Method_enabled_flag = X_Fte_Ship_Method_Enabled_flag,
context = X_Context,
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
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
DELETE FROM oe_sys_parameters_all
WHERE rowid = X_Rowid;
DELETE FROM oe_system_parameters_all
WHERE rowid = X_Rowid;
END Delete_Row;