The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_mode constant varchar2(30) := 'ON-INSERT';
PROCEDURE Update_Interest
( p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
p_identity_salesforce_id IN NUMBER := NULL,
p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
p_interest_use_code IN VARCHAR2,
p_check_access_flag IN VARCHAR2,
p_admin_flag IN VARCHAR2,
p_admin_group_id IN NUMBER,
p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_interest_id OUT NOCOPY NUMBER
) is
l_api_name CONSTANT VARCHAR2(30) := 'Update_Interest';
l_mode constant varchar2(30) := 'ON-UPDATE';
l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Update_Interest';
SAVEPOINT UPDATE_INTEREST_PUB;
l_interest_rec.last_update_date := p_interest_rec.last_update_date;
l_interest_rec.last_updated_by := p_interest_rec.last_updated_by;
l_interest_rec.last_update_login := p_interest_rec.last_update_login;
AS_INTEREST_PVT.Update_Interest ( p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id=> p_identity_salesforce_id,
p_interest_rec => l_interest_rec,
p_interest_use_code => p_interest_use_code,
p_check_access_flag => p_check_access_flag,
p_admin_flag => p_admin_flag,
p_admin_group_id => p_admin_group_id,
p_access_profile_rec => p_access_profile_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_interest_id => l_interest_id
);
END Update_Interest;
SELECT ais.interest_status_code
FROM as_interest_statuses ais, as_lookups lkp
WHERE nls_upper(X_Int_Status) = nls_upper(lkp.meaning)
and product_category_id = X_Product_Category_Id
and product_cat_set_id = X_Product_Cat_Set_Id
and ais.interest_status_code = lkp.lookup_code
and lkp.lookup_type = 'INTEREST_STATUS';
SELECT interest_type_id
FROM as_interest_types_vl
WHERE nls_upper(X_Int_Type) = nls_upper(interest_type)
and (interest_type like nls_upper(substr(X_Int_Type, 1, 1) || '%') or
interest_type like lower(substr(X_Int_Type, 1, 1) || '%'));
SELECT interest_code_id
FROM as_interest_codes_v
WHERE nls_upper(X_Int_Code) = nls_upper(code)
and interest_type_id = X_Int_Type_Id;
SELECT description
FROM as_interest_codes_v
WHERE interest_code_id = p_interest_code_id
and interest_type_id = p_interest_type_id;
SELECT description
FROM as_interest_types_vl
WHERE interest_type_id = p_interest_type_id;
PROCEDURE Delete_Interest
( p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
p_identity_salesforce_id IN NUMBER,
p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
p_interest_use_code IN VARCHAR2,
p_check_access_flag in varchar2,
p_admin_flag in varchar2,
p_admin_group_id in number,
p_access_profile_rec IN AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Interest';
l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Delete_Interest';
SAVEPOINT DELETE_INTEREST_PUB;
'Public API: Calling AS_ACCESS_PVT.delete_interest');
as_interest_pvt.Delete_Interest ( p_api_version_number => 2.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => p_validation_level,
p_identity_salesforce_id=> p_identity_salesforce_id,
p_interest_rec => l_interest_rec,
p_interest_use_code => p_interest_use_code,
p_check_access_flag => p_check_access_flag,
p_admin_flag => p_admin_flag,
p_admin_group_id => p_admin_group_id,
p_access_profile_rec => p_access_profile_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
End delete_interest;