[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pr.id cpl_id,
pr.jtot_object1_code object1_code,
pr.object1_id1 object1_id1,
pr.object1_id2 object1_id2
FROM okc_k_party_roles_b pr
WHERE pr.rle_code = cp_role_code
AND pr.cle_id IS NULL
AND pr.chr_id = cp_contract_id
AND pr.dnz_chr_id = cp_contract_id
AND rownum = 1; -- Only return 1st party
SELECT kh.buy_or_sell k_buy_or_sell,
lq.meaning qp_party_role,
pr.rle_code kp_role_code,
lk.meaning kp_party_role
FROM okc_k_party_roles_b pr,
okc_k_headers_b kh,
fnd_lookups lq,
fnd_lookups lk
WHERE pr.id = cp_cpl_id
AND kh.id = cp_khr_id
AND kh.id = pr.chr_id
AND lq.lookup_code = cp_qpt_code
AND lq.lookup_type = 'OKL_QUOTE_PARTY_TYPE'
AND lk.lookup_code = pr.rle_code
AND lk.lookup_type = 'OKC_ROLE';
SELECT kh.buy_or_sell k_buy_or_sell,
lq.meaning qp_party_role
FROM okc_k_headers_v kh,
fnd_lookups lq
WHERE kh.id = cp_khr_id
AND lq.lookup_code = cp_qpt_code
AND lq.lookup_type = 'OKL_QUOTE_PARTY_TYPE';
SELECT khr.id khr_id,
par.id par_id,
kpr.id kpr_id,
kpr.jtot_object1_code object1_code,
kpr.object1_id1 object1_id1,
kpr.object1_id2 object1_id2
FROM okl_k_headers khr,
okc_k_headers_all_b par,
okc_k_party_roles_b kpr
WHERE khr.id = cp_chr_id
AND par.id (+) = khr.khr_id
AND par.scs_code (+) = 'PROGRAM'
AND kpr.dnz_chr_id (+) = par.id
AND kpr.rle_code (+) = 'OKL_VENDOR';
okl_quote_parties_pub.insert_quote_parties (
p_api_version => l_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_qpyv_tbl => lp_qpyv_tbl,
x_qpyv_tbl => lx_qpyv_tbl);
'after call to okl_quote_parties_pub.insert_quote_parties :'||l_return_status);
SELECT kpr.rle_code rle_code,
kpr.jtot_object1_code object1_code,
kpr.object1_id1 object1_id1,
kpr.object1_id2 object1_id2
FROM okc_k_party_roles_b kpr
WHERE kpr.id = cp_cpl_id
AND kpr.chr_id = cp_khr_id
AND kpr.dnz_chr_id = cp_khr_id;
okl_quote_parties_pub.insert_quote_parties (
p_api_version => l_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_qpyv_tbl => lp_qpyv_tbl,
x_qpyv_tbl => lx_qpyv_tbl);
'after call to okl_quote_parties_pub.insert_quote_parties :'||l_return_status);
SELECT qp.id qp_party_id,
qp.qpt_code qp_role_code,
qp.CREATED_BY qp_created_by,
qp.CREATION_DATE qp_creation_date,
qp.LAST_UPDATED_BY qp_last_updated_by,
qp.LAST_UPDATE_DATE qp_last_update_date,
qp.LAST_UPDATE_LOGIN qp_last_update_login,
qp.PARTY_JTOT_OBJECT1_CODE qp_party_object,
qp.PARTY_OBJECT1_ID1 qp_party_id1,
qp.PARTY_OBJECT1_ID2 qp_party_id2,
qp.CONTACT_JTOT_OBJECT1_CODE qp_contact_object,
qp.CONTACT_OBJECT1_ID1 qp_contact_id1,
qp.CONTACT_OBJECT1_ID2 qp_contact_id2,
qp.EMAIL_ADDRESS qp_email_address,
lq.meaning qp_party_role,
qp.date_sent qp_date_sent,
pr.id kp_party_id,
pr.rle_code kp_role_code,
lk.meaning kp_party_role,
pr.jtot_object1_code po_party_object,
pr.object1_id1 po_party_id1,
pr.object1_id2 po_party_id2,
kh.id contract_id,
kh.buy_or_sell k_buy_or_sell
FROM okl_quote_parties qp,
okc_k_party_roles_b pr,
okl_trx_quotes_b tq,
okc_k_headers_all_b kh,
fnd_lookups lq,
fnd_lookups lk
WHERE qp.qte_id = cp_qte_id
AND qp.qpt_code = NVL (cp_qpt_code, qp.qpt_code)
AND pr.id (+) = qp.cpl_id
AND tq.id = qp.qte_id
AND tq.id = cp_qte_id
AND kh.id = tq.khr_id
AND lq.lookup_code = qp.qpt_code
AND lq.lookup_type = 'OKL_QUOTE_PARTY_TYPE'
AND lk.lookup_code (+) = pr.rle_code
AND lk.lookup_type (+) = 'OKC_ROLE'
AND qp.id = nvl(cp_party_id, qp.id);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_updated_by : '||p_q_party_uv_rec.qp_last_updated_by );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_date : '||p_q_party_uv_rec.qp_last_update_date );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_login : '||p_q_party_uv_rec.qp_last_update_login );
l_q_party_tbl(l_cnt).qp_last_updated_by := l_q_role_rec.qp_last_updated_by;
l_q_party_tbl(l_cnt).qp_last_update_date := l_q_role_rec.qp_last_update_date;
l_q_party_tbl(l_cnt).qp_last_update_login := l_q_role_rec.qp_last_update_login;
l_q_party_tbl(l_cnt).qp_last_updated_by := l_q_role_rec.qp_last_updated_by;
l_q_party_tbl(l_cnt).qp_last_update_date := l_q_role_rec.qp_last_update_date;
l_q_party_tbl(l_cnt).qp_last_update_login := l_q_role_rec.qp_last_update_login;
l_other_cols okl_am_util_pvt.select_tbl_type;
SELECT count(*)
FROM okc_contact_sources cs
WHERE cs.rle_code = cp_rle_code
AND cs.start_date <= SYSDATE
AND NVL (cs.end_date, SYSDATE) >= SYSDATE
AND cs.buy_or_sell = cp_buy_or_sell;
SELECT cn.jtot_object1_code,
cn.object1_id1,
cn.object1_id2
FROM okc_contacts cn,
okc_contact_sources cs
WHERE cn.cpl_id = cp_k_party_id
AND cn.dnz_chr_id = cp_contract_id
AND cn.cro_code = cs.cro_code
AND cn.jtot_object1_code = cs.jtot_object_code
AND cs.start_date <= SYSDATE
AND NVL (cs.end_date, SYSDATE) >= SYSDATE
AND cs.rle_code = cp_rle_code
AND cs.buy_or_sell = cp_buy_or_sell;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_updated_by : '||p_q_party_uv_rec.qp_last_updated_by );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_date : '||p_q_party_uv_rec.qp_last_update_date );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_login : '||p_q_party_uv_rec.qp_last_update_login );
l_object_tbl.delete;
p_other_select => l_other_cols,
x_object_tbl => l_object_tbl,
x_return_status => l_return_status);
p_other_select => l_other_cols,
p_object_id1 => l_cntct_rec.object1_id1,
p_object_id2 => l_cntct_rec.object1_id2,
x_object_tbl => l_t_object_tbl,
x_return_status => l_return_status);
p_other_select => l_other_cols,
p_other_where => l_where_cond,
p_check_status => 'Y',
x_object_tbl => l_object_tbl,
x_return_status => l_return_status);
SELECT Initcap (
Decode (c.contact_point_type,
'PHONE', Decode (c.phone_line_type,
'GEN', c.contact_point_type,
c.phone_line_type),
'EMAIL', c.contact_point_type))
contact_point_type,
Decode (c.contact_point_type,
'PHONE', LTrim (RTrim (
Decode (c.telephone_type, NULL, NULL,
c.telephone_type || ' ') ||
Decode (c.phone_country_code, NULL, NULL,
c.phone_country_code || ' ') ||
Decode (c.phone_area_code, NULL, NULL,
c.phone_area_code || ' ') ||
Decode (c.phone_number, NULL, NULL,
c.phone_number || ' ') ||
Decode (c.phone_extension, NULL, NULL,
'Ext. ' || c.phone_extension))),
'EMAIL', c.email_address)
contact_point_details,
c.contact_point_id contact_point_id,
c.email_address email_address,
c.primary_flag primary_flag
FROM okx_contact_points_v c
WHERE c.owner_table_name = cp_owner_table_name
AND c.owner_table_id = cp_owner_table_id
AND c.status = 'A'
AND c.contact_point_type IN ('EMAIL','PHONE');
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_updated_by : '||p_q_party_uv_rec.qp_last_updated_by );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_date : '||p_q_party_uv_rec.qp_last_update_date );
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,'p_q_party_uv_rec.qp_last_update_login : '||p_q_party_uv_rec.qp_last_update_login );
l_other_cols okl_am_util_pvt.select_tbl_type;
SELECT c.contact_point_id,
c.email_address,
c.primary_flag
FROM okx_contact_points_v c
WHERE c.contact_point_type = 'EMAIL'
AND c.owner_table_name = 'HZ_PARTIES'
AND c.status = 'A'
AND c.owner_table_id = cp_object_id;
SELECT cn.jtot_object1_code,
cn.object1_id1,
cn.object1_id2
FROM okc_contacts cn
WHERE cn.cpl_id = cp_k_party_id
AND NVL (cn.start_date, SYSDATE) <= SYSDATE
AND NVL (cn.end_date, SYSDATE) >= SYSDATE;
p_other_select => l_other_cols,
x_object_tbl => l_obj1,
x_return_status => l_return_status);
p_other_select => l_other_cols,
x_object_tbl => l_obj1,
x_return_status => l_return_status);
p_other_select => l_other_cols,
p_other_where => l_where_cond,
p_check_status => 'Y',
x_object_tbl => l_obj2,
x_return_status => l_return_status);
p_other_select => l_other_cols,
x_object_tbl => l_obj1,
x_return_status => l_return_status);
p_other_select => l_other_cols,
p_other_where => l_where_cond,
p_check_status => 'Y',
x_object_tbl => l_obj2,
x_return_status => l_return_status);
p_other_select => l_other_cols,
p_other_where => l_where_cond,
p_check_status => 'Y',
x_object_tbl => l_obj3,
x_return_status => l_return_status);