[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_pending_int(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
p_contract_id IN NUMBER,
x_oinv_rec OUT NOCOPY oinv_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) AS
l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'insert_pending_int';
SELECT id
FROM okl_open_int
WHERE khr_id = cp_contract_id;
okl_open_int_pub.update_open_int(p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_oinv_rec => l_oinv_rec
,x_oinv_rec => lx_oinv_rec);
okl_open_int_pub.insert_open_int(p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_oinv_rec => l_oinv_rec
,x_oinv_rec => lx_oinv_rec);
END insert_pending_int;
SELECT id
FROM okl_open_int_prty
WHERE khr_id = cp_khr_id
AND party_id = cp_party_id;
okl_open_int_pub.update_open_int(p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_oinv_rec => l_oinv_rec
,x_oinv_rec => lx_oinv_rec);
okl_open_int_prty_pub.update_open_int_prty( p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_oipv_rec => l_oipv_rec
,x_oipv_rec => lx_oipv_rec);
okl_open_int_prty_pub.insert_open_int_prty( p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_oipv_rec => l_oipv_rec
,x_oipv_rec => lx_oipv_rec);
SELECT id
FROM okl_open_int_asst
WHERE khr_id = cp_khr_id
AND instance_number = cp_instance_number;
lx_oiav_tbl.delete;
okl_open_int_asst_pub.update_open_int_asst (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiav_rec => l_oiav_rec,
x_oiav_rec => lx_oiav_rec);
okl_open_int_asst_pub.insert_open_int_asst (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_oiav_rec => l_oiav_rec,
x_oiav_rec => lx_oiav_rec);
SELECT id
FROM okc_k_headers_v
WHERE authoring_org_id = cp_organization_id
AND scs_code = 'LEASE';
iex_open_interface_pub.insert_pending(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
p_object1_id1 => l_oinv_rec.khr_id,
p_object1_id2 => '#',
p_jtot_object1_code => 'OKX_LEASE',
p_action => IEX_OPI_PVT.ACTION_REPORT_CB,
p_status => IEX_OPI_PVT.STATUS_PENDING_ALL,
p_comments => OKC_API.G_MISS_CHAR,
p_ext_agncy_id => NULL,
p_transfer_days => NULL,
p_extend_days => NULL,
x_return_status => l_return_status,
x_msg_count => lx_msg_count,
x_msg_data => lx_msg_data);
SELECT hp.party_name
,hp.party_type
FROM hz_parties hp
WHERE hp.party_id = cp_party_id;
SELECT hpp.date_of_birth
,hpp.place_of_birth
,hpp.person_identifier
,hpp.person_iden_type
FROM hz_person_profiles hpp
WHERE hpp.party_id = cp_party_id;
SELECT hzl.address1
,hzl.address2
,hzl.address3
,hzl.address4
,hzl.country
,hzl.city
,hzl.postal_code
,hzl.state
,hzl.province
,hzl.county
,hzl.po_box_number
,hzl.house_number
,hzl.street_suffix
,hzl.apartment_number
,hzl.street
,hzl.rural_route_number
,hzl.street_number
,hzl.building
,hzl.floor
,hzl.suite
,hzl.room
,hzl.postal_plus4_code
FROM hz_locations hzl
WHERE hzl.location_id = cp_bill_to_address_id;
SELECT hp.party_id
,hp.party_name
,hl.address1
,hl.address2
,hl.address3
,hl.address4
,hl.country
,hl.city
,hl.postal_code
,hl.state
,hl.province
,hl.county
,hl.po_box_number
,hl.house_number
,hl.street_suffix
,hl.apartment_number
,hl.street
,hl.rural_route_number
,hl.street_number
,hl.building
,hl.floor
,hl.suite
,hl.room
,hl.postal_plus4_code
FROM okc_k_party_roles_b opr
,hz_parties hp
,hz_party_sites hps
,hz_locations hl
,hz_party_site_uses hpsu
WHERE opr.dnz_chr_id = cp_contract_id
AND opr.rle_code = 'GUARANTOR'
AND opr.object1_id1 = hp.party_id
AND hp.party_id = hps.party_id
AND hps.party_site_id = hpsu.party_site_id
AND hpsu.site_use_type = 'BILL_TO'
AND hpsu.primary_per_type = 'Y'
AND hps.location_id = hl.location_id
ORDER BY hp.party_id;
SELECT phone_country_code
,phone_area_code
,phone_number
,phone_extension
FROM hz_contact_points
WHERE owner_table_name = 'HZ_PARTIES'
AND owner_table_id = cp_party_id
AND contact_point_type = 'PHONE'
AND primary_flag = 'Y'
AND status = 'A';
SELECT ico.cas_id
,ica.case_number
FROM iex_case_objects ico
,iex_cases_all_b ica
WHERE ico.object_id = cp_contract_id
AND ico.cas_id = ica.cas_id
AND ica.active_flag = 'Y';
SELECT okhv.contract_number
,okhv.scs_code
,okhv.sts_code
,okhv.start_date
,nvl(okhv.date_terminated, okhv.end_date) close_date
,okh.term_duration
,okhv.authoring_org_id
FROM okc_k_headers_v okhv
,okl_k_headers okh
WHERE okhv.id = cp_contract_id
AND okhv.id = okh.id;
SELECT sum(nvl(aps.amount_due_remaining, 0)) past_due_amount
FROM okl_cnsld_ar_strms_b ocas
,ar_payment_schedules_all aps
WHERE ocas.khr_id = cp_contract_id
AND ocas.receivables_invoice_id = aps.customer_trx_id
AND aps.class = 'INV'
AND aps.due_date < sysdate
AND nvl(aps.amount_due_remaining, 0) > 0;
SELECT min(aps.due_date) due_date
FROM okl_cnsld_ar_strms_b ocas
,ar_payment_schedules_all aps
WHERE ocas.khr_id = cp_contract_id
AND ocas.receivables_invoice_id = aps.customer_trx_id
AND aps.class = 'INV'
AND aps.due_date < sysdate
AND nvl(aps.amount_due_remaining, 0) > 0;
SELECT min(ara.apply_date) apply_date
FROM okl_cnsld_ar_strms_b ocas
,ar_payment_schedules_all aps
,ar_receivable_applications_all ara
WHERE ocas.khr_id = cp_contract_id
AND ocas.receivables_invoice_id = aps.customer_trx_id
AND aps.class = 'INV'
AND aps.payment_schedule_id = ara.payment_schedule_id
AND ara.status = 'APP';
SELECT ica.owner_resource_id
,jre.source_name
,jre.source_phone
,jre.source_email
FROM iex_cases_all_b ica
,jtf_rs_resource_extns jre
WHERE ica.cas_id = cp_cas_id
AND ica.owner_resource_id = jre.resource_id;
SELECT ols.lty_code
,okl.id
FROM okc_k_lines_v okl
,okc_line_styles_b ols
WHERE okl.dnz_chr_id = cp_contract_id
AND okl.lse_id = ols.id
AND ols.lty_code = 'FREE_FORM1';
SELECT name
,description
,asset_id
,asset_number
,original_cost
,tag_number
,manufacturer_name
,model_number
,asset_type
FROM okx_assets_v oka
,(select oki.object1_id1
,oki.object1_id2
FROM okc_k_items_v oki
,(SELECT ols.lty_code, okl.id
FROM okc_k_lines_v okl
,okc_line_styles_b ols
WHERE okl.cle_id = cp_top_line_id
AND okl.lse_id = ols.id
AND ols.lty_code = 'FIXED_ASSET') fa
WHERE oki.cle_id = fa.id) oi
WHERE oka.id1 = TO_NUMBER(oi.object1_id1)
AND oka.id2 = oi.object1_id2;
SELECT oii.instance_number
,oii.serial_number
,oii.quantity
,oii.install_location_id
FROM okx_install_items_v oii
,(SELECT oki.object1_id1
,oki.object1_id2
FROM okc_k_items_v oki
,(SELECT ols.lty_code
,okl.id
FROM okc_k_lines_v okl
,okc_line_styles_b ols
,(SELECT ols.lty_code, okl.id
FROM okc_k_lines_v okl
,okc_line_styles_b ols
WHERE okl.cle_id = cp_top_line_id
AND okl.lse_id = ols.id
AND ols.lty_code = 'FREE_FORM2') ff2
WHERE okl.cle_id = ff2.id
AND okl.lse_id = ols.id
AND ols.lty_code = 'INST_ITEM') ii
WHERE oki.cle_id = ii.id) oi
WHERE id1 = TO_NUMBER(oi.object1_id1)
AND id2 = oi.object1_id2;
SELECT hl.country
,hl.address1
,hl.address2
,hl.address3
,hl.address4
,hl.city
,hl.postal_code
,hl.state
,hl.province
,hl.county
,hl.po_box_number
,hl.house_number
,hl.street_suffix
,hl.apartment_number
,hl.street
,hl.rural_route_number
,hl.street_number
,hl.building
,hl.floor
,hl.suite
,hl.room
,hl.postal_plus4_code
FROM hz_locations hl
,(SELECT location_id
FROM hz_party_sites
WHERE party_site_id = cp_location_id) hps
WHERE hl.location_id = hps.location_id;
x_oiav_tbl.delete;
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE OKL_OPEN_INT opi
SET opi.party_ID = p_to_fk_id
,opi.object_version_number = opi.object_version_number + 1
,opi.last_update_date = SYSDATE
,opi.last_updated_by = arp_standard.profile.user_id
,opi.last_update_login = arp_standard.profile.last_update_login
WHERE opi.party_ID = p_from_fk_id ;
arp_message.set_name('AR','AR_ROWS_UPDATED');