[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT disb_vsites.start_date
, disb_vsites.end_date
FROM okl_disb_rule_sty_types disb_sty,
okl_disb_rule_vendor_sites disb_vsites
WHERE disb_sty.stream_type_purpose = p_sty_purpose
AND disb_sty.disb_rule_id = disb_vsites.disb_rule_id
AND disb_vsites.vendor_id = p_vendor_id
AND disb_vsites.vendor_site_id = p_vendor_site_id
AND disb_vsites.disb_rule_vendor_site_id <> NVL (p_disb_rule_vendor_site_id , -1);
SELECT disb_vsites.invoice_seq_start
, disb_vsites.invoice_seq_end
FROM okl_disb_rule_vendor_sites disb_vsites
WHERE disb_vsites.vendor_id = p_vendor_id
AND disb_vsites.vendor_site_id = p_vendor_site_id
AND disb_vsites.disb_rule_vendor_site_id <> NVL (p_disb_rule_vendor_site_id , -1) ;
SELECT disb_rule_vendor_site_id
FROM okl_disb_rule_vendor_sites
WHERE disb_rule_id = p_disb_rule_id;
SELECT disb_rule_vendor_site_id
FROM okl_disb_rule_vendor_sites
WHERE disb_rule_id = p_disb_rule_id
AND vendor_id = NVL(p_vendor_id , vendor_id);
okl_drv_pvt.delete_row( p_api_version => l_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_drv_tbl => l_drv_del_tbl);
SELECT DISB_RULE_ID ,START_DATE ,end_date ,fee_basis ,fee_option ,fee_amount ,
fee_percent ,consolidate_by_due_date ,frequency ,day_of_month ,scheduled_month
FROM OKL_DISB_RULES_B
WHERE DISB_RULE_ID = c_disb_rule_id;
SELECT DISB_RULE_ID ,STREAM_TYPE_PURPOSE ,DISB_RULE_STY_TYPE_ID
FROM OKL_DISB_RULE_STY_TYPES
WHERE DISB_RULE_ID = c_disb_rule_id;
SELECT INVOICE_SEQ_START ,NEXT_INV_SEQ ,INVOICE_SEQ_END
FROM OKL_DISB_RULE_VENDOR_SITES
WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;
SELECT COUNT(DISB_RULE_VENDOR_SITE_ID)
FROM OKL_DISB_RULE_VENDOR_SITES
WHERE DISB_RULE_VENDOR_SITE_ID = c_disb_rule_vendor_site_id;*/
okl_drv_pvt.update_row( p_api_version => l_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_drv_tbl => l_drv_Updt_tbl
, x_drv_tbl => lx_drv_tbl);
okl_drv_pvt.insert_row( p_api_version => l_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_drv_tbl => l_drv_Crt_tbl
, x_drv_tbl => lx_drv_tbl);
SELECT 'Y' FROM OKL_DISB_RULES_B
WHERE RULE_NAME = p_disb_rule_name;
okl_dra_pvt.insert_row( p_api_version => l_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_drav_rec => l_drav_rec
, x_drav_rec => lx_drav_rec);
okl_drs_pvt.insert_row( p_api_version => l_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_drs_tbl => l_drs_tbl
, x_drs_tbl => lx_drs_tbl);
okl_drv_pvt.insert_row( p_api_version => l_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_drv_tbl => l_drv_tbl
, x_drv_tbl => lx_drv_tbl);
PROCEDURE delete_disb_rule_sty_types( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_disb_rule_id IN okl_disb_rules_v.disb_rule_id%type
, p_new_drs_tbl IN drs_tbl_type
)
IS
l_api_name CONSTANT VARCHAR2(40) := 'delete_disb_rule_sty_types';
SELECT disb_rule_sty_type_id
FROM okl_disb_rule_sty_types
WHERE disb_rule_id = p_disb_rule_id;
okl_drs_pvt.delete_row( p_api_version => l_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_drs_tbl => l_drs_del_tbl);
END delete_disb_rule_sty_types;
PROCEDURE update_disbursement_rule( p_api_version IN NUMBER
, p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
, x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_drav_rec IN drav_rec_type
, p_drs_tbl IN drs_tbl_type
, p_drv_tbl IN drv_tbl_type
, x_drav_rec OUT NOCOPY drav_rec_type
)
IS
l_api_name CONSTANT VARCHAR2(40) := 'update_disbursement_rule';
okl_dra_pvt.update_row( p_api_version => l_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_drav_rec => l_drav_rec
, x_drav_rec => lx_drav_rec);
delete_disb_rule_sty_types( p_api_version => l_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_disb_rule_id => p_drav_rec.disb_rule_id
, p_new_drs_tbl => p_drs_tbl);
okl_drs_pvt.insert_row( p_api_version => l_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_drs_tbl => l_drs_ins_tbl
, x_drs_tbl => lx_drs_ins_tbl);
okl_drs_pvt.update_row( p_api_version => l_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_drs_tbl => l_drs_upd_tbl
, x_drs_tbl => lx_drs_upd_tbl);
okl_drv_pvt.insert_row( p_api_version => l_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_drv_tbl => l_drv_ins_tbl
, x_drv_tbl => lx_drv_ins_tbl);
okl_drv_pvt.update_row( p_api_version => l_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_drv_tbl => l_drv_upd_tbl
, x_drv_tbl => lx_drv_upd_tbl);
END update_disbursement_rule;