[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_tcnv_rec.last_updated_by := p_header_tbl(1).last_updated_by;
l_tcnv_rec.last_update_date := p_header_tbl(1).last_update_date;
l_tcnv_rec.last_update_login := p_header_tbl(1).last_update_login;
OKL_TAA_PVT.insert_row( p_api_version => l_api_version ,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_taav_tbl => l_taav_tbl,
x_taav_tbl => x_taav_tbl);
l_tcnv_rec.last_updated_by := p_header_tbl(1).last_updated_by;
l_tcnv_rec.last_update_date := p_header_tbl(1).last_update_date;
l_tcnv_rec.last_update_login := p_header_tbl(1).last_update_login;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
OKL_TAA_PVT.update_row( p_api_version => l_api_version ,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_taav_tbl => l_taav_tbl,
x_taav_tbl => x_taav_tbl);
PROCEDURE Update_Requests(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
p_header_tbl IN tcnv_tbl_type,
p_upd_hdr_tbl IN upd_hdr_tbl_type,
p_old_line_tbl IN l_before_trf_tbl,
p_new_line_tbl IN l_after_trf_tbl,
x_header_tbl OUT NOCOPY Okl_Trx_Contracts_Pub.tcnv_tbl_type,
x_taaV_tbl OUT NOCOPY taav_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
AS
l_api_name varchar2(100) := 'Update_Requests';
l_tcnv_rec.last_updated_by := p_header_tbl(1).last_updated_by;
l_tcnv_rec.last_update_date := p_header_tbl(1).last_update_date;
l_tcnv_rec.last_update_login := p_header_tbl(1).last_update_login;
OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => p_api_version,
p_init_msg_list => fnd_api.g_false,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
p_tclv_tbl => l_tclv_tbl,
x_tcnv_rec => lx_tcnv_rec,
x_tclv_tbl => lx_tclv_tbl);
OKL_TAA_PVT.update_row( p_api_version => l_api_version ,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_taav_tbl => l_taav_tbl,
x_taav_tbl => x_taav_tbl);
END Update_Requests;
SELECT *
FROM OKL_TRX_CONTRACTS
WHERE id = p_request_id;
SELECT party_id,
PARTY_NAME
FROM HZ_PARTIES PARTY
WHERE PARTY_ID = p_party_id;
SELECT *
FROM okl_taa_request_details_v
WHERE tcn_id = p_tcn_id;
SELECT id1,
description
FROM okx_cust_site_uses_v
WHERE ID1 = p_site_id;
SELECT id1,
bank_account_num
FROM OKX_RCPT_METHOD_ACCOUNTS_V
WHERE ID1 = p_bank_acct_id;
SELECT cust_account_id,
account_number
FROM hz_cust_accounts
WHERE cust_account_id = p_cust_acct_id;
SELECT id,
name
FROM OKL_INVOICE_FORMATS_V
WHERE ID = p_inv_format_id;
SELECT id1,
name
FROM OKX_RECEIPT_METHODS_V
WHERE id1 = p_pay_mthd_id;
SELECT new_contract_number
FROM okl_taa_request_details_b
WHERE tcn_id = p_request_id;
SELECT id,
contract_number
FROM OKC_K_HEADERS_B
WHERE ID = p_contract_id;
SELECT hzp.party_id,
hzp.party_name contact_name,
hzp.email_address email
FROM hz_parties hzp,
hz_cust_account_roles hzc
WHERE hzc.cust_account_id = p_cust_account_id
AND hzc.status = 'A'
AND hzc.role_type = 'CONTACT'
AND hzc.party_id = hzp.party_id
and hzp.party_id = p_party_id ;
SELECT decode(nvl(phone_country_code,''),(phone_country_code || '-'),'') || phone_area_code || phone_number phone
FROM hz_contact_points
WHERE owner_table_id = p_party_id
AND contact_point_type = 'PHONE';
SELECT *
FROM okl_taa_request_details_v
WHERE id = p_taa_id;
SELECT PARTY_NAME
FROM HZ_PARTIES PARTY
WHERE PARTY_ID = p_party_id;