[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM OKS_TEMPLATE_SET
WHERE id = p_template_set_id
AND template_source = p_profile;
PROCEDURE UPDATE_RENEWAL_STATUS (
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
P_CHR_ID IN NUMBER,
P_RENEW_STATUS IN VARCHAR2,
P_CHR_STATUS IN VARCHAR2
) IS
l_api_version CONSTANT NUMBER := 1.0;
oks_contract_hdr_pub.update_header(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khrv_rec => l_khdr_rec_in,
x_khrv_rec => l_khdr_rec_out,
p_validate_yn => 'N'
);
okc_contract_pub.update_contract_header(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_restricted_update => 'F',
p_chrv_rec => l_okc_hdr_rec_in,
x_chrv_rec => l_okc_hdr_rec_out
);
SELECT object1_id1 FROM OKC_K_PARTY_ROLES_V
WHERE dnz_chr_id = p_chr_id
AND cle_id IS NULL
AND jtot_object1_code = 'OKX_PARTY'
AND rle_code = 'CUSTOMER';
SELECT authoring_org_id
FROM OKC_K_HEADERS_V
WHERE id = p_chr_id;
SELECT payment_terms_id1, payment_terms_id2
FROM OKS_K_DEFAULTS_V
WHERE SEGMENT_ID1 = p_id1
AND SEGMENT_ID2 = p_id2
AND JTOT_OBJECT_CODE = p_object_code
AND CDT_TYPE = 'SDT'
AND nvl(p_date, SYSDATE) BETWEEN
nvl(START_DATE, SYSDATE) AND nvl(END_DATE, SYSDATE);
SELECT payment_terms_id1, payment_terms_id2
FROM OKS_K_DEFAULTS_V
WHERE cdt_type = 'MDT'
AND segment_id1 IS NULL
AND segment_id2 IS NULL
AND jtot_object_code IS NULL;
PROCEDURE Can_Update_Contract(
p_chr_id IN NUMBER,
x_can_update_yn OUT NOCOPY VARCHAR2,
x_can_submit_yn OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2
) IS
BEGIN
x_return_status := OKC_API.G_RET_STS_SUCCESS;
x_can_update_yn := 'Y';
END Can_Update_Contract;
SELECT period_type, period_start, price_uom
FROM oks_k_headers_b
WHERE chr_id = p_hdr_id;
SELECT period_type, period_start, price_uom
FROM oks_k_defaults
WHERE cdt_type = 'SDT'
AND segment_id1 = p_org_id;
SELECT period_type, period_start, price_uom
FROM oks_k_defaults
WHERE cdt_type = 'MDT'
AND segment_id1 IS NULL;
SELECT object1_id1 FROM okc_k_party_roles_b
WHERE dnz_chr_id = cp_chr_id
AND cle_id IS NULL
AND jtot_object1_code = 'OKX_PARTY'
AND rle_code IN ('CUSTOMER', 'SUBSCRIBER');
SELECT a.renewal_type_code,
b.renewal_pricing_type, b.renewal_markup_percent, b.renewal_price_list,
b.renewal_po_required,
b.renewal_est_rev_percent, b.renewal_est_rev_duration, b.renewal_est_rev_period,
b.billing_profile_id, b.renewal_grace_duration, b.renewal_grace_period,
a.currency_code, a.approval_type, nvl(a.org_id, a.authoring_org_id)
FROM okc_k_headers_all_b a, oks_k_headers_b b
WHERE a.id = cp_chr_id AND a.id = b.chr_id;
SELECT
cdt_type,
jtot_object_code,
renewal_type,
renewal_pricing_type,
markup_percent,
price_list_id1,
price_list_id2,
pdf_id,
qcl_id,
cgp_new_id,
cgp_renew_id,
po_required_yn,
credit_amount,
rle_code,
revenue_estimated_percent,
revenue_estimated_duration,
revenue_estimated_period,
NULL, --function_name,
NULL, -- salesrep_name
template_set_id,
base_currency, --threshold_currency, col obsolete
threshold_amount,
email_address,
billing_profile_id,
user_id,
threshold_enabled_yn,
grace_period,
grace_duration,
payment_terms_id1,
payment_terms_id2,
base_currency, --evergreen_threshold_curr, col obsolete
evergreen_threshold_amt,
payment_method,
base_currency, --payment_threshold_curr, col obsolete
payment_threshold_amt,
interface_price_break,
base_currency,
approval_type,
evergreen_approval_type,
online_approval_type,
purchase_order_flag,
credit_card_flag,
wire_flag,
commitment_number_flag,
check_flag,
period_type,
period_start,
price_uom,
template_language
FROM oks_k_defaults
WHERE
(cdt_type = 'MDT' AND jtot_object_code IS NULL AND segment_id1 IS NULL AND segment_id2 IS NULL)
OR
(cdt_type = 'SDT' AND jtot_object_code = 'OKX_OPERUNIT' AND segment_id1 = to_char(cp_org_id) AND segment_id2 = '#'
AND trunc(cp_date) BETWEEN start_date AND nvl(end_date, greatest(start_date, trunc(cp_date))))
OR
(cdt_type = 'SDT' AND jtot_object_code = 'OKX_PARTY' AND segment_id1 = to_char(cp_party_id) AND segment_id2 = '#'
AND trunc(cp_date) BETWEEN start_date AND nvl(end_date, greatest(start_date, trunc(cp_date))));
l_rules_tbl_tmp.DELETE;
l_rules_tbl.DELETE;
SELECT b.object1_id1, a.authoring_org_id
FROM okc_k_headers_all_b a LEFT OUTER JOIN okc_k_party_roles_b b
ON a.id = b.dnz_chr_id AND b.cle_id IS NULL AND b.jtot_object1_code = 'OKX_PARTY'
AND b.rle_code IN ('CUSTOMER', 'SUBSCRIBER')
WHERE a.id = cp_chr_id;
SELECT
cdt_type, jtot_object_code, template_set_id, template_language
FROM oks_k_defaults
WHERE
(cdt_type = 'MDT' AND jtot_object_code IS NULL AND segment_id1 IS NULL AND segment_id2 IS NULL)
OR
(cdt_type = 'SDT' AND jtot_object_code = 'OKX_OPERUNIT' AND segment_id1 = to_char(cp_org_id) AND segment_id2 = '#'
AND trunc(cp_date) BETWEEN start_date AND nvl(end_date, greatest(start_date, trunc(cp_date))))
OR
(cdt_type = 'SDT' AND jtot_object_code = 'OKX_PARTY' AND segment_id1 = to_char(cp_party_id) AND segment_id2 = '#'
AND trunc(cp_date) BETWEEN start_date AND nvl(end_date, greatest(start_date, trunc(cp_date))));
l_tset_tbl_tmp.DELETE;
l_tset_tbl.DELETE;
SELECT estimated_amount, currency_code, start_date
FROM okc_k_headers_all_b
WHERE id = cp_chr_id;
SELECT lower(iso_language), iso_territory
FROM fnd_languages
WHERE language_code = p_lang;
SELECT CASE WHEN a.installed_flag = 'D' THEN 'US' ELSE a.language_code END language_code,
CASE WHEN a.installed_flag = 'D' THEN 'en' ELSE b.default_language END default_language,
CASE WHEN a.installed_flag = 'D' THEN '00' ELSE b.default_territory END default_territory
FROM fnd_languages a, xdo_templates_b b
WHERE a.iso_language = upper(b.default_language)
AND b.template_id = p_template_id
AND (a.iso_territory = b.default_territory
OR (b.default_territory = '00' and a.installed_flag IN ('B','I','D')))
ORDER BY a.installed_flag ASC;
x_contract_update_status => l_k_status,
x_return_status => x_return_status,
x_msg_data => x_msg_data,
x_msg_count => x_msg_count
);
' x_contract_update_status ='||l_k_status);