The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF (p_mode = G_INSERT_MODE) THEN
-- column is required:
IF (p_ppydv_rec.vendor_id IS NULL) OR
(p_ppydv_rec.vendor_id = OKL_API.G_MISS_NUM)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Pay As Vendor');
ELSIF (p_mode = G_UPDATE_MODE) THEN
-- column is required:
IF (p_ppydv_rec.vendor_id IS NULL)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Pay As Vendor');
IF (p_mode = G_INSERT_MODE) THEN
-- column is required:
IF (p_ppydv_rec.pay_site_id IS NULL) OR
(p_ppydv_rec.pay_site_id = OKL_API.G_MISS_NUM)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Pay Site');
ELSIF (p_mode = G_UPDATE_MODE) THEN
-- column is required:
IF (p_ppydv_rec.pay_site_id IS NULL)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Pay Site');
IF (p_mode = G_INSERT_MODE) THEN
-- column is required:
IF (p_ppydv_rec.payment_term_id IS NULL) OR
(p_ppydv_rec.payment_term_id = OKL_API.G_MISS_NUM)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Payment Term');
ELSIF (p_mode = G_UPDATE_MODE) THEN
-- column is required:
IF (p_ppydv_rec.payment_term_id IS NULL)
THEN
OKL_API.Set_Message(p_app_name => G_APP_NAME,
p_msg_name => G_REQUIRED_VALUE,
p_token1 => G_COL_NAME_TOKEN,
p_token1_value => 'Payment Term');
select kpr.id
from okc_k_party_roles_b kpr
where kpr.rle_code = 'LESSEE'
and kpr.dnz_chr_id = p_chr_id
;
l_return_status := validate_header_attributes(lp_ppydv_rec, G_INSERT_MODE);
okl_pyd_pvt.insert_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ppydv_rec => lp_ppydv_rec,
x_ppydv_rec => x_ppydv_rec);
PROCEDURE update_lessee_as_vendor(
p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,p_ppydv_rec IN ppydv_rec_type
,x_ppydv_rec OUT NOCOPY ppydv_rec_type
)
is
l_api_name CONSTANT VARCHAR2(30) := 'update_lessee_as_vendor';
SAVEPOINT update_lessee_as_vendor;
l_return_status := validate_header_attributes(lp_ppydv_rec, G_UPDATE_MODE);
okl_pyd_pvt.update_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_ppydv_rec => lp_ppydv_rec,
x_ppydv_rec => x_ppydv_rec);
ROLLBACK TO update_lessee_as_vendor;
ROLLBACK TO update_lessee_as_vendor;
ROLLBACK TO update_lessee_as_vendor;
end update_lessee_as_vendor;