The following lines contain the word 'select', 'insert', 'update' or 'delete':
L_LAST_UPDATE_DATE DATE := sysdate;
L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
SELECT count(*) into l_count from cn_sca_rule_attributes where
TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
and ORG_ID = p_org_id -- MOAC Change
and ( SRC_COLUMN_NAME = l_credit_rule_attr_rec.destination_column OR upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name)));
SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
CN_SCA_CRRULEATTR_PKG.INSERT_ROW(
x_Rowid => L_ROWID,
x_org_id => p_org_id, -- MOAC Change
x_sca_rule_attribute_id => l_sca_rule_attribute_id,
X_TRANSACTION_SOURCE => l_credit_rule_attr_rec.transaction_source,
X_SRC_COLUMN_NAME => l_credit_rule_attr_rec.destination_column,
X_DATATYPE => l_credit_rule_attr_rec.data_type,
X_VALUE_SET_ID => l_value_set_id,
X_TRX_SRC_COLUMN_NAME => l_credit_rule_attr_rec.source_column,
X_ENABLED_FLAG => l_credit_rule_attr_rec.enable_flag,
x_attribute_category => l_credit_rule_attr_rec.attribute_category,
x_attribute1 => l_credit_rule_attr_rec.attribute1,
x_attribute2 => l_credit_rule_attr_rec.attribute2,
x_attribute3 => l_credit_rule_attr_rec.attribute3,
x_attribute4 => l_credit_rule_attr_rec.attribute4,
x_attribute5 => l_credit_rule_attr_rec.attribute5,
x_attribute6 => l_credit_rule_attr_rec.attribute6,
x_attribute7 => l_credit_rule_attr_rec.attribute7,
x_attribute8 => l_credit_rule_attr_rec.attribute8,
x_attribute9 => l_credit_rule_attr_rec.attribute9,
x_attribute10 => l_credit_rule_attr_rec.attribute10,
x_attribute11 => l_credit_rule_attr_rec.attribute11,
x_attribute12 => l_credit_rule_attr_rec.attribute12,
x_attribute13 => l_credit_rule_attr_rec.attribute13,
x_attribute14 => l_credit_rule_attr_rec.attribute14,
x_attribute15 => l_credit_rule_attr_rec.attribute15,
X_OBJECT_VERSION_NUMBER => l_credit_rule_attr_rec.Object_Version_Number,
X_SECURITY_GROUP_ID => L_SECURITY_GROUP_ID,
X_USER_COLUMN_NAME => l_credit_rule_attr_rec.user_name,
x_Creation_Date => l_creation_date,
x_Created_By => l_created_by,
x_Last_Update_Date => l_last_update_date,
x_Last_Updated_By => l_last_updated_by,
x_Last_Update_Login => l_last_update_login
);
UPDATE cn_repositories
SET sca_mapping_status = 'UNSYNC'
WHERE org_id = p_org_id; -- MOAC Change
PROCEDURE Update_Credit_RuleAttr (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2,
p_valdiation_level IN VARCHAR2,
p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
p_credit_rule_attr_rec IN credit_rule_attr_rec,
-- p_old_credit_rule_attr_rec IN credit_rule_attr_rec,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SCA_CRRULEATTR_PVT';
L_LAST_UPDATE_DATE DATE := sysdate;
L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Credit_RuleAttr';
SAVEPOINT Update_Credit_RuleAttr;
SELECT object_version_number -- ,sca_rule_attribute_id
INTO l_old_ovn -- ,l_sca_rule_attribute_id
FROM cn_sca_rule_attributes
WHERE SCA_RULE_ATTRIBUTE_ID = l_credit_rule_attr_rec.sca_rule_attribute_id
AND ORG_ID = p_org_id; -- MOAC Change
SELECT count(1) into l_count2
FROM CN_SCA_CONDITIONS
WHERE SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
AND ORG_ID = p_org_id; -- MOAC Change
CN_SCA_CRRULEATTR_PKG.DELETE_ROW(
X_ORG_ID => p_org_id, -- MOAC Change
X_SCA_RULE_ATTRIBUTE_ID => l_credit_rule_attr_rec.sca_rule_attribute_id) ;
update cn_repositories
set sca_mapping_status = 'UNSYNC'
where org_id = p_org_id; -- MOAC Change
SELECT count(sca_rule_attribute_id) into l_count from cn_sca_rule_attributes where
TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
and org_id = p_org_id -- MOAC Change
and upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name));
SELECT count(1) into l_count2 FROM CN_SCA_CONDITIONS WHERE
SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
and org_id = p_org_id; -- MOAC Change
select trx_src_column_name
into l_trx_source_column
from cn_sca_rule_attributes
where sca_rule_attribute_id = l_credit_rule_attr_rec.sca_rule_attribute_id
and org_id = p_org_id; -- MOAC Change
CN_SCA_CRRULEATTR_PKG.UPDATE_ROW(
x_org_id => p_org_id, -- MOAC Change
x_sca_rule_attribute_id => l_credit_rule_attr_rec.sca_rule_attribute_id,
X_TRANSACTION_SOURCE => l_credit_rule_attr_rec.transaction_source,
X_SRC_COLUMN_NAME => l_credit_rule_attr_rec.destination_column,
X_DATATYPE => l_credit_rule_attr_rec.data_type,
X_VALUE_SET_ID => l_value_set_id,
X_TRX_SRC_COLUMN_NAME => l_credit_rule_attr_rec.source_column,
X_ENABLED_FLAG => l_credit_rule_attr_rec.enable_flag,
x_attribute_category => l_credit_rule_attr_rec.attribute_category,
x_attribute1 => l_credit_rule_attr_rec.attribute1,
x_attribute2 => l_credit_rule_attr_rec.attribute2,
x_attribute3 => l_credit_rule_attr_rec.attribute3,
x_attribute4 => l_credit_rule_attr_rec.attribute4,
x_attribute5 => l_credit_rule_attr_rec.attribute5,
x_attribute6 => l_credit_rule_attr_rec.attribute6,
x_attribute7 => l_credit_rule_attr_rec.attribute7,
x_attribute8 => l_credit_rule_attr_rec.attribute8,
x_attribute9 => l_credit_rule_attr_rec.attribute9,
x_attribute10 => l_credit_rule_attr_rec.attribute10,
x_attribute11 => l_credit_rule_attr_rec.attribute11,
x_attribute12 => l_credit_rule_attr_rec.attribute12,
x_attribute13 => l_credit_rule_attr_rec.attribute13,
x_attribute14 => l_credit_rule_attr_rec.attribute14,
x_attribute15 => l_credit_rule_attr_rec.attribute15,
X_OBJECT_VERSION_NUMBER => l_credit_rule_attr_rec.Object_Version_Number,
X_SECURITY_GROUP_ID => L_SECURITY_GROUP_ID ,
X_USER_COLUMN_NAME => l_credit_rule_attr_rec.user_name,
x_Last_Update_Date => l_last_update_date,
x_Last_Updated_By => l_last_updated_by,
x_Last_Update_Login => l_last_update_login
);
update cn_repositories
set sca_mapping_status = 'UNSYNC'
where org_id = p_org_id;
ROLLBACK TO Update_Credit_RuleAttr;
ROLLBACK TO Update_Credit_RuleAttr;
ROLLBACK TO Update_Credit_RuleAttr;
END Update_Credit_RuleAttr;
L_LAST_UPDATE_DATE DATE := sysdate;
L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
L_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
SELECT count(*) into l_count
FROM CN_SCA_RULE_ATTRIBUTES
WHERE TRANSACTION_SOURCE='CN'
AND ORG_ID = p_org_id; -- MOAC Change
update cn_repositories
set sca_mapping_status='GENERATED'
WHERE org_id = p_org_id; -- MOAC Change