The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
decode(pdf.pdf_type,'PPS',
pdf.package_name||'.'||pdf.procedure_name,NULL) proc_name
FROM okc_process_defs_v pdf
-- bug 2112814 ,okc_process_def_parameters_v pdp
WHERE pdf.id = l_pdf_id;
SELECT pdp.name param_name
FROM okc_process_defs_v pdf,
okc_process_def_parameters_v pdp
WHERE pdf.id = l_pdf_id
AND pdf.id = pdp.pdf_id;
SELECT template_yn
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT '1'
FROM okc_k_headers_b
WHERE template_yn = 'Y'
AND nvl(end_date, sysdate+1) >= trunc(sysdate)
AND id = p_chr_id;
SELECT '1'
FROM okc_k_headers_b
WHERE id = p_chr_id
AND date_terminated IS NOT NULL
AND date_terminated <= SYSDATE;
SELECT '1'
FROM okc_k_headers_b hdr, okc_statuses_b status
WHERE hdr.id = p_chr_id
AND hdr.sts_code = status.code
AND status.ste_code = 'CANCELLED';
SELECT sts_code,template_yn,scs_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT ste_code
FROM okc_statuses_b
WHERE code = p_code;
SELECT cls_code
FROM okc_subclasses_b
WHERE code = p_scs_code;
FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN IS
l_in_process_yn VARCHAR2(1) := '?';
SELECT cps.user_id,
upper(substr(cps.in_process_yn,1,1)) in_process_yn
FROM okc_k_processes_v cps,
okc_change_requests_b crt
WHERE crt.id = cps.crt_id
AND crt.chr_id = p_chr_id;
-- No update allowed if process is active for the contract
If (OKC_CONTRACT_PVT.Is_Process_Active(p_chr_id) = 'Y') Then
RETURN(FALSE);
IF OKC_ASSENT_PUB.HEADER_OPERATION_ALLOWED(p_chr_id,'UPDATE') = 'T' THEN
OPEN c_locked_user(p_chr_id);
END update_target_contract;
SELECT lty_code,recursive_yn
FROM okc_line_styles_b
WHERE id = p_old_lse_id;
SELECT lse.id
FROM okc_subclass_top_line_v stl,
okc_line_styles_b lse
WHERE stl.lse_id = lse.id
AND lse.lty_code = p_lty_code
AND stl.scs_code = p_new_subclass;
SELECT lse.id
FROM okc_subclass_top_line_v stl,
okc_line_styles_b lse
WHERE stl.lse_id = lse.id
AND lse.id = p_old_lse_id -- added
AND lse.lty_code = p_lty_code
AND stl.scs_code = p_new_subclass
AND sysdate BETWEEN stl.start_date and nvl(stl.end_date,sysdate); -- added
SELECT lse.id
FROM okc_line_styles_b lse
WHERE lse.lty_code = p_lty_code
AND lse.lse_parent_id = p_new_parent_lse;
SELECT jtot_object_code
FROM okc_line_style_sources_v
WHERE lse_id = p_lse_id
AND sysdate BETWEEN start_date and nvl(end_date,sysdate);
SELECT scn_id
FROM okc_section_contents_v
WHERE id = p_scc_id;
SELECT id,level
FROM okc_sections_b
CONNECT BY PRIOR scn_id = id
START WITH id = p_scn_id;
SELECT tve_id
FROM okc_cover_times_v
WHERE RUL_ID = p_from_rul_id;
SELECT tve_id,
uom_code,
duration
FROM okc_react_intervals_v
WHERE RUL_ID = p_from_rul_id;
SELECT id
FROM okc_k_accesses_v
WHERE chr_id = p_from_chr_id;
SELECT id
FROM okc_k_processes_v
WHERE chr_id = p_from_chr_id;
SELECT cgcv.id
FROM okc_k_grpings_v cgcv,
okc_k_groups_b cgpv
WHERE cgcv.included_chr_id = p_from_chr_id
AND cgcv.cgp_parent_id = cgpv.id
AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);
SELECT id
FROM okc_governances_v
WHERE dnz_chr_id = p_from_chr_id
AND cle_id is null;
SELECT
DNZ_CHR_ID,
ISA_AGREEMENT_ID,
CHR_ID,
CLE_ID,
CHR_ID_REFERRED,
CLE_ID_REFERRED,
COPIED_ONLY_YN
FROM OKC_GOVERNANCES
WHERE ID = p_gve_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT id
FROM okc_article_trans_v
WHERE cat_id = p_id;
SELECT id
FROM okc_section_contents_v
WHERE cat_id = p_cat_id;
SELECT sav_sae_id
FROM okc_k_articles_b
WHERE id = p_cat_id;
SELECT sav_release
FROM okc_std_art_versions_v
WHERE sae_id = p_sae_id
AND creation_date = (SELECT max(creation_date)
FROM okc_std_art_versions_v
WHERE sae_id = p_sae_id)
AND date_active <= sysdate;
SELECT id
FROM okc_price_adj_attribs_v
WHERE pat_id = p_pat_id;
SELECT
--ID,
DNZ_CHR_ID,
PERCENT,
CHR_ID,
CLE_ID,
SALESREP_ID1,
SALESREP_ID2,
SALES_CREDIT_TYPE_ID1,
SALES_CREDIT_TYPE_ID2,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE
FROM OKC_K_SALES_CREDITS_V
WHERE ID = p_scrv_id;
x_scrv_rec.LAST_UPDATED_BY,
x_scrv_rec.LAST_UPDATE_DATE;
OKC_SALES_credit_PUB.insert_Sales_credit(
p_api_version => p_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_scrv_rec => l_scrv_rec,
x_scrv_rec => x_scrv_rec);
SELECT
--ID
CLE_ID,
VALUE_FROM,
VALUE_TO,
PRICING_TYPE,
VALUE,
START_DATE,
END_DATE,
INTEGRATED_WITH_QP,
QP_REFERENCE_ID,
SHIP_TO_ORGANIZATION_ID,
SHIP_TO_LOCATION_ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE
FROM OKC_PH_LINE_BREAKS_V
WHERE ID = p_okc_ph_line_breaks_v_id;
x_okc_ph_line_breaks_v_rec.LAST_UPDATED_BY,
x_okc_ph_line_breaks_v_rec.LAST_UPDATE_DATE;
SELECT
DNZ_CHR_ID,
ISA_AGREEMENT_ID,
CHR_ID,
CLE_ID,
CHR_ID_REFERRED,
CLE_ID_REFERRED,
COPIED_ONLY_YN
FROM OKC_GOVERNANCES
WHERE ID = p_gve_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT id
FROM okc_contacts_v
WHERE cpl_id = p_cpl_id;
SELECT id
FROM okc_condition_lines_b
WHERE cnh_id = p_cnh_id;
SELECT id
FROM okc_outcomes_b
WHERE cnh_id = p_cnh_id;
SELECT id
FROM okc_outcome_arguments_v
WHERE oce_id = p_oce_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT rul.id,rule_information_category
FROM okc_rules_b rul, okc_rule_groups_b rgp ,okc_rg_def_rules rgdef
WHERE rul.rgp_id = p_rgp_id
and rul.rgp_id=rgp.id
and rgp.rgd_code=rgdef.rgd_code
and rul.rule_information_category=rgdef.rdf_code;
SELECT rrd_id,cpl_id
FROM okc_rg_party_roles_v
WHERE rgp_id = p_rgp_id;
SELECT cpl_id
FROM okc_rg_party_roles_v rgp, okc_rg_role_defs rrd
WHERE rrd.id = rgp.rrd_id
and rgp.dnz_chr_id = (select dnz_chr_id
from okc_rule_groups_b
where id = p_rgp_id)
and rgp.rgp_id = p_rgp_id
and rrd.subject_object_flag = 'O';
SELECT 'x'
FROM FND_LOOKUP_VALUES rgdv,
okc_rule_groups_b rgp,
OKC_SUBCLASS_RG_DEFS srdv,
OKC_K_HEADERS_B chrv
WHERE rgp.id = p_rgp_id
AND rgdv.LOOKUP_CODE = rgp.rgd_code
AND rgdv.lookup_type = 'OKC_RULE_GROUP_DEF'
AND srdv.RGD_CODE = rgp.rgd_code
AND srdv.SCS_CODE = chrv.SCS_CODE
AND chrv.ID = p_dnz_chr_id;
SELECT dnz_chr_id,price_level_ind
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT id
FROM okc_k_items_v
WHERE cle_id = p_from_cle_id;
SELECT nvl(orig_system_id1,-001) into l_a FROM okc_k_lines_b
WHERE id = l_cimv_rec.cle_id;
SELECT nvl(object1_id1,-002) into l_b FROM okc_k_items
WHERE cle_id = l_a;
SELECT nvl(id,-003) into l_c FROM okc_k_lines_b
WHERE orig_system_id1 = l_b
AND dnz_chr_id = l_cimv_rec.dnz_chr_id;
DELETE FROM okc_k_lines_b
WHERE id = l_cimv_rec.cle_id;
DELETE FROM okc_k_lines_tl
WHERE id = l_cimv_rec.cle_id;
DELETE FROM okc_k_lines_b
WHERE id = l_cimv_rec.cle_id;
DELETE FROM okc_k_lines_tl
WHERE id = l_cimv_rec.cle_id;
DELETE FROM okc_k_lines_b
WHERE id = l_cimv_rec.cle_id;
DELETE FROM okc_k_lines_tl
WHERE id = l_cimv_rec.cle_id;
SELECT application_id
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT to_char(major_version)
FROM okc_k_vers_numbers
WHERE chr_id = p_chr_id;
-- topline during update service
IS
l_clev_rec clev_rec_type;
select sts_code, date_cancelled, trn_code, term_cancel_source, cancelled_amount
from okc_k_lines_b
where id= p_from_cle_id;
SELECT pdf_id
FROM okc_class_operations
WHERE opn_code = 'COPY'
AND cls_code = 'SERVICE';
SELECT osb.cls_code
FROM okc_subclasses_b osb,okc_k_headers_b okb
WHERE okb.id = p_from_chr_id
AND okb.scs_code = osb.code ;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT id
FROM okc_rule_groups_b
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_k_articles_b
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_price_att_values_v
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_price_adjustments_v
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_price_adj_assocs_v
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_price_adj_attribs_v
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_k_sales_credits_v
WHERE cle_id = p_from_cle_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_k_sales_credits_hv
WHERE cle_id = p_from_cle_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_governances_v
WHERE cle_id = p_from_cle_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_governances_hv
WHERE cle_id = p_from_cle_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_ph_line_breaks_v
WHERE cle_id = p_from_cle_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_ph_line_breaks_hv
WHERE cle_id = p_from_cle_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_k_party_roles_b
WHERE cle_id = p_from_cle_id
AND rle_code <> 'LICENCEE_ACCT'
and dnz_chr_id = p_from_chr_id;
SELECT lty_code,
priced_yn
FROM okc_line_styles_b
WHERE id = p_id;
SELECT id
FROM okc_k_items_v
WHERE cle_id = p_cle_id
AND priced_item_yn = 'Y';
SELECT object1_id1
FROM okc_k_items_v
WHERE cle_id = p_old_cle_id;
Select Counter_Group_id
From OKX_CTR_ASSOCIATIONS_V
Where Source_Object_Id = p_id;
SELECT coverage_template_id
FROM okx_system_items_v
WHERE id1 = p_item_id;
SELECT start_date,end_date
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT start_date,end_date
FROM okc_k_headers_b
WHERE id = p_to_chr_id;
SELECT id
FROM okc_operation_instances
WHERE target_chr_id = p_to_chr_id;
SELECT nvl(chr_id , cle_id)
FROM okc_k_lines_b
WHERE id = p_cle_id;
l_olev_rec.SELECT_YN := NULL;
g_price_adjustments.DELETE;
IF (p_change_status ='N') THEN --status of sublines to retained after update service
Open get_line_status_csr (p_from_cle_id);
-- of the topline during update service
IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
SELECT level,
id,
chr_id,
cle_id,
dnz_chr_id,
lse_id
FROM okc_k_lines_b
CONNECT BY PRIOR id = cle_id
START WITH id = p_from_cle_id;
SELECT chr.application_id
FROM okc_k_headers_b chr,
okc_k_lines_b cle
WHERE chr.id = cle.dnz_chr_id
AND cle.id = p_from_cle_id;
-- of the topline during update service
x_cle_id := l_cle_id_out; -- only the 1st level line id generated is passed out.
-- of the topline during update service
END IF;
SELECT id
FROM okc_class_operations
WHERE cls_code = ( SELECT cls_code
FROM okc_subclasses_b
WHERE code = p_chrv_rec.scs_code )
AND opn_code = 'RENEWAL';
l_olev_rec.SELECT_YN := NULL;
SELECT id
FROM okc_price_att_values_V
WHERE chr_id = p_from_chr_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_price_att_values_HV
WHERE chr_id = p_from_chr_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_price_adjustments_V
WHERE chr_id = p_from_chr_id
AND cle_id IS NULL -- Added for Bug 2027165
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_price_adjustments_HV
WHERE chr_id = p_from_chr_id
AND cle_id IS NULL -- Added for Bug 2027165
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_price_adj_assocs_v
WHERE
pat_id_from IN
( SELECT id
FROM OKC_PRICE_ADJUSTMENTS
WHERE chr_id = p_from_chr_id)
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_price_adj_assocs_HV
WHERE
pat_id_from IN
( SELECT id
FROM OKC_PRICE_ADJUSTMENTS
WHERE chr_id = p_from_chr_id)
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_price_adj_attribs_v
WHERE
pat_id IN
( SELECT pat_id
FROM OKC_PRICE_ADJUSTMENTS
WHERE
chr_id = p_from_chr_id);
SELECT id
FROM okc_k_sales_credits_v
WHERE dnz_chr_id = p_from_chr_id
AND cle_id IS NULL
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_k_sales_credits_hv
WHERE dnz_chr_id = p_from_chr_id
AND cle_id IS NULL
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_governances_v
WHERE dnz_chr_id = p_from_chr_id
AND cle_id is null
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT id
FROM okc_governances_hv
WHERE dnz_chr_id = p_from_chr_id
AND cle_id is null
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_k_history_b
WHERE TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS') =
(SELECT MAX(TO_CHAR(CREATION_DATE, 'DD-MON-YYYY HH:MI:SS'))
FROM OKC_K_HISTORY_B
WHERE CHR_ID = p_chr_id)
AND CHR_ID = p_chr_id;
select CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_DATE
into g_conversion_type, g_conversion_rate, g_conversion_date
from okc_conversion_attribs_v
where DNZ_CHR_ID = l_chrv_rec.id
and chr_id = l_chrv_rec.id;
select CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_rate_DATE
into g_conversion_type, g_conversion_rate, g_conversion_date
from okc_k_headers_b
where id = l_chrv_rec.id;
l_chrv_rec.deleted_yn := 'N';
g_price_adjustments.DELETE;
UPDATE okc_k_history_b
SET reason_code = 'RENEW'
WHERE id = l_history_id;
select id
from okc_sections_b
where chr_id = p_chr_id
and scn_id IS NULL;
select id, level
from okc_sections_b
CONNECT BY PRIOR id = scn_id
START WITH id = p_id;
SELECT pdf_id
FROM okc_class_operations
WHERE opn_code = 'COPY'
AND cls_code = 'SERVICE';
SELECT osb.cls_code
FROM okc_subclasses_b osb,okc_k_headers_b okb
WHERE okb.id = p_chr_id
AND okb.scs_code = osb.code ;
SELECT cle.id,lse.lty_code
FROM okc_k_lines_b cle,
okc_line_styles_b lse
WHERE chr_id = p_chr_id
AND cle.lse_id= lse.id
AND g_copy_history_yn = 'N'
UNION ALL
SELECT cle.id,lse.lty_code
FROM okc_k_lines_bh cle,
okc_line_styles_b lse
WHERE chr_id = p_chr_id
AND cle.lse_id= lse.id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_rule_groups_b
WHERE dnz_chr_id = p_chr_id
AND cle_id is null
AND g_copy_history_yn = 'N'
UNION ALL
SELECT id
FROM okc_rule_groups_bH
WHERE dnz_chr_id = p_chr_id and cle_id is null
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_k_articles_b
WHERE dnz_chr_id = p_chr_id
AND cle_id is null
AND g_copy_history_yn = 'N'
UNION ALL
SELECT id
FROM okc_k_articles_bH
WHERE dnz_chr_id = p_chr_id and cle_id is null
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT article_effective_date
FROM okc_template_usages_v
WHERE document_type=p_doc_type AND document_id=p_doc_id;
SELECT id
FROM okc_k_party_roles_b
WHERE dnz_chr_id = p_chr_id
and cle_id is NULL
AND g_copy_history_yn = 'N'
UNION ALL
SELECT id
FROM okc_k_party_roles_bH
WHERE dnz_chr_id = p_chr_id and cle_id is NULL
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT id
FROM okc_condition_headers_b
WHERE dnz_chr_id = p_chr_id
AND g_copy_history_yn = 'N'
UNION ALL
SELECT id
FROM okc_condition_headers_bH
WHERE dnz_chr_id = p_chr_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
g_events.DELETE;
g_ruls.DELETE;
g_sections.DELETE;
g_price_adjustments.DELETE;
g_timevalues.DELETE;
g_party.DELETE;
g_op_lines.DELETE;
SELECT ID,
CAT_ID,
CLE_ID,
RUL_ID,
DNZ_CHR_ID
FROM OKC_ARTICLE_TRANS_V
WHERE ID = p_atn_id
AND g_copy_history_yn = 'N'
UNION ALL
SELECT ID,
CAT_ID,
CLE_ID,
RUL_ID,
DNZ_CHR_ID
FROM OKC_ARTICLE_TRANS_HV
WHERE ID = p_atn_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
CLE_ID,
CHR_ID,
CLE_ID_FOR,
DNZ_CHR_ID,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
UOM_CODE,
EXCEPTION_YN,
NUMBER_OF_ITEMS,
PRICED_ITEM_YN
FROM OKC_K_ITEMS_V
WHERE ID = p_cim_id;
SELECT ID,
GROUP_ID,
CHR_ID,
RESOURCE_ID,
ACCESS_LEVEL
FROM OKC_K_ACCESSES_V
WHERE ID = p_cac_id;
SELECT ID,
SFWT_FLAG,
CHR_ID,
CLE_ID,
RLE_CODE,
DNZ_CHR_ID,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
COGNOMEN,
CODE,
FACILITY,
MINORITY_GROUP_LOOKUP_CODE,
SMALL_BUSINESS_FLAG,
WOMEN_OWNED_FLAG,
ALIAS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRIMARY_YN, -- Bug 2374325
--- new columns to replace rules
CUST_ACCT_ID,
BILL_TO_SITE_USE_ID
FROM OKC_K_PARTY_ROLES_V
WHERE ID = p_cpl_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
CHR_ID,
CLE_ID,
RLE_CODE,
DNZ_CHR_ID,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
COGNOMEN,
CODE,
FACILITY,
MINORITY_GROUP_LOOKUP_CODE,
SMALL_BUSINESS_FLAG,
WOMEN_OWNED_FLAG,
ALIAS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRIMARY_YN, -- Bug 2374325
--- new columns to replace rules
CUST_ACCT_ID,
BILL_TO_SITE_USE_ID
FROM OKC_K_PARTY_ROLES_HV
WHERE ID = p_cpl_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
PDF_ID,
CHR_ID,
USER_ID,
CRT_ID,
PROCESS_ID,
IN_PROCESS_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_K_PROCESSES_V
WHERE ID = p_cps_id;
SELECT ID,
CGP_PARENT_ID,
INCLUDED_CHR_ID,
INCLUDED_CGP_ID
FROM OKC_K_GRPINGS_V
WHERE ID = p_cgc_id;
SELECT ID,
SFWT_FLAG,
ACN_ID,
COUNTER_GROUP_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
ONE_TIME_YN,
NAME,
CONDITION_VALID_YN,
BEFORE_AFTER,
TRACKED_YN,
CNH_VARIANCE,
DNZ_CHR_ID,
TEMPLATE_YN,
DATE_ACTIVE,
OBJECT_ID,
DATE_INACTIVE,
JTOT_OBJECT_CODE,
TASK_OWNER_ID,
CNH_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_HEADERS_V
WHERE ID = p_cnh_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
ACN_ID,
COUNTER_GROUP_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
ONE_TIME_YN,
NAME,
CONDITION_VALID_YN,
BEFORE_AFTER,
TRACKED_YN,
CNH_VARIANCE,
DNZ_CHR_ID,
TEMPLATE_YN,
DATE_ACTIVE,
OBJECT_ID,
DATE_INACTIVE,
JTOT_OBJECT_CODE,
TASK_OWNER_ID,
CNH_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_HEADERS_HV
WHERE ID = p_cnh_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
SFWT_FLAG,
START_AT,
CNH_ID,
PDF_ID,
AAE_ID,
LEFT_CTR_MASTER_ID,
RIGHT_CTR_MASTER_ID,
LEFT_COUNTER_ID,
RIGHT_COUNTER_ID,
DNZ_CHR_ID,
SORTSEQ,
CNL_TYPE,
DESCRIPTION,
LEFT_PARENTHESIS,
RELATIONAL_OPERATOR,
RIGHT_PARENTHESIS,
LOGICAL_OPERATOR,
TOLERANCE,
RIGHT_OPERAND,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_LINES_V
WHERE ID = p_cnl_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
START_AT,
CNH_ID,
PDF_ID,
AAE_ID,
LEFT_CTR_MASTER_ID,
RIGHT_CTR_MASTER_ID,
LEFT_COUNTER_ID,
RIGHT_COUNTER_ID,
DNZ_CHR_ID,
SORTSEQ,
CNL_TYPE,
DESCRIPTION,
LEFT_PARENTHESIS,
RELATIONAL_OPERATOR,
RIGHT_PARENTHESIS,
LOGICAL_OPERATOR,
TOLERANCE,
RIGHT_OPERAND,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_LINES_HV
WHERE ID = p_cnl_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
CPL_ID,
CRO_CODE,
DNZ_CHR_ID,
CONTACT_SEQUENCE,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
RESOURCE_CLASS,--Bug#3038104
SALES_GROUP_ID, --Bug#2882737
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
START_DATE,
END_DATE,
PRIMARY_YN -- Bug 2374325
FROM OKC_CONTACTS_V
WHERE ID = p_ctc_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
CPL_ID,
CRO_CODE,
DNZ_CHR_ID,
CONTACT_SEQUENCE,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
RESOURCE_CLASS,--Bug#3038104
SALES_GROUP_ID, --Bug#2882737
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
START_DATE,
END_DATE,
PRIMARY_YN -- Bug 2374325
FROM OKC_CONTACTS_HV
WHERE ID = p_ctc_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
SFWT_FLAG,
RGP_TYPE,
RGD_CODE,
CLE_ID,
CHR_ID,
DNZ_CHR_ID,
PARENT_RGP_ID,
SAT_CODE,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_RULE_GROUPS_V
WHERE ID = p_rgp_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
RGP_TYPE,
RGD_CODE,
CLE_ID,
CHR_ID,
DNZ_CHR_ID,
PARENT_RGP_ID,
SAT_CODE,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_RULE_GROUPS_HV
WHERE ID = p_rgp_id
AND G_COPY_HISTORY_YN = 'Y'
AND major_version = G_FROM_VERSION_NUMBER;
SELECT ID,
SFWT_FLAG,
SPN_ID,
TVE_ID_OFFSET,
UOM_CODE,
TVE_ID_GENERATED_BY,
TVE_ID_STARTED,
TVE_ID_ENDED,
TVE_ID_LIMITED,
CNH_ID,
DNZ_CHR_ID,
TZE_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
DURATION,
OPERATOR,
BEFORE_AFTER,
DATETIME,
MONTH,
DAY,
DAY_OF_WEEK,
HOUR,
MINUTE,
SECOND,
NAME,
INTERVAL_YN,
NTH,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
TVE_TYPE
FROM OKC_TIMEVALUES_V
WHERE ID = p_tve_id;
SELECT ID,
--Bug 3055393 SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
--Bug 3055393 TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15
FROM OKC_RULES_V
WHERE ID = p_rul_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
-- Bug 3055393 SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
--Bug 3055393 TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15
FROM OKC_RULES_HV
WHERE ID = p_rul_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
SFWT_FLAG,
CHR_ID,
CLE_ID,
decode(p_renew_ref_yn, 'Y', LINE_NUMBER,''), -- Modified for bugfix 2307197
LSE_ID,
STS_CODE,
DISPLAY_SEQUENCE,
TRN_CODE,
COMMENTS,
ITEM_DESCRIPTION,
OKE_BOE_DESCRIPTION,
COGNOMEN,
HIDDEN_IND,
PRICE_UNIT,
PRICE_UNIT_PERCENT,
PRICE_NEGOTIATED,
PRICE_LEVEL_IND,
INVOICE_LINE_LEVEL_IND,
DPAS_RATING,
BLOCK23TEXT,
EXCEPTION_YN,
TEMPLATE_USED,
DATE_TERMINATED,
NAME,
START_DATE,
END_DATE,
DATE_RENEWED,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
PRICE_LIST_ID,
PRICING_DATE,
PRICE_LIST_LINE_ID,
LINE_LIST_PRICE,
ITEM_TO_PRICE_YN,
PRICE_BASIS_YN,
CONFIG_HEADER_ID,
CONFIG_REVISION_NUMBER,
CONFIG_COMPLETE_YN,
CONFIG_VALID_YN,
CONFIG_TOP_MODEL_LINE_ID,
CONFIG_ITEM_TYPE,
---Bug.No.-1942374
CONFIG_ITEM_ID,
---Bug.No.-1942374
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRICE_TYPE,
CURRENCY_CODE,
SERVICE_ITEM_YN,
-- new columns for price hold
PH_PRICING_TYPE,
PH_ADJUSTMENT,
PH_PRICE_BREAK_BASIS,
PH_MIN_QTY,
PH_MIN_AMT,
PH_QP_REFERENCE_ID,
PH_VALUE,
PH_ENFORCE_PRICE_LIST_YN,
PH_INTEGRATED_WITH_QP,
-- new colums to replace rules
CUST_ACCT_ID,
BILL_TO_SITE_USE_ID,
INV_RULE_ID,
LINE_RENEWAL_TYPE_CODE,
SHIP_TO_SITE_USE_ID,
PAYMENT_TERM_ID,
ANNUALIZED_FACTOR, --Bug 4722452: Added these two column to support Update_Service
PAYMENT_INSTRUCTION_TYPE --in R12
FROM OKC_K_LINES_V
WHERE id = p_cle_id;
x_clev_rec.PROGRAM_UPDATE_DATE,
x_clev_rec.PRICE_LIST_ID,
x_clev_rec.PRICING_DATE,
x_clev_rec.PRICE_LIST_LINE_ID,
x_clev_rec.LINE_LIST_PRICE,
x_clev_rec.ITEM_TO_PRICE_YN,
x_clev_rec.PRICE_BASIS_YN,
x_clev_rec.CONFIG_HEADER_ID,
x_clev_rec.CONFIG_REVISION_NUMBER,
x_clev_rec.CONFIG_COMPLETE_YN,
x_clev_rec.CONFIG_VALID_YN,
x_clev_rec.CONFIG_TOP_MODEL_LINE_ID,
x_clev_rec.CONFIG_ITEM_TYPE,
---Bug.No.-1942374
x_clev_rec.CONFIG_ITEM_ID,
---Bug.No.-1942374
x_clev_rec.ATTRIBUTE_CATEGORY,
x_clev_rec.ATTRIBUTE1,
x_clev_rec.ATTRIBUTE2,
x_clev_rec.ATTRIBUTE3,
x_clev_rec.ATTRIBUTE4,
x_clev_rec.ATTRIBUTE5,
x_clev_rec.ATTRIBUTE6,
x_clev_rec.ATTRIBUTE7,
x_clev_rec.ATTRIBUTE8,
x_clev_rec.ATTRIBUTE9,
x_clev_rec.ATTRIBUTE10,
x_clev_rec.ATTRIBUTE11,
x_clev_rec.ATTRIBUTE12,
x_clev_rec.ATTRIBUTE13,
x_clev_rec.ATTRIBUTE14,
x_clev_rec.ATTRIBUTE15,
x_clev_rec.PRICE_TYPE,
x_clev_rec.CURRENCY_CODE,
x_clev_rec.SERVICE_ITEM_YN,
--new columns for price hold
x_clev_rec.PH_PRICING_TYPE,
x_clev_rec.PH_ADJUSTMENT,
x_clev_rec.PH_PRICE_BREAK_BASIS,
x_clev_rec.PH_MIN_QTY,
x_clev_rec.PH_MIN_AMT,
x_clev_rec.PH_QP_REFERENCE_ID,
x_clev_rec.PH_VALUE,
x_clev_rec.PH_ENFORCE_PRICE_LIST_YN,
x_clev_rec.PH_INTEGRATED_WITH_QP,
-- new colums to replace rules
x_clev_rec.CUST_ACCT_ID,
x_clev_rec.BILL_TO_SITE_USE_ID,
x_clev_rec.INV_RULE_ID,
x_clev_rec.LINE_RENEWAL_TYPE_CODE,
x_clev_rec.SHIP_TO_SITE_USE_ID,
x_clev_rec.PAYMENT_TERM_ID,
x_clev_rec.ANNUALIZED_FACTOR, --Fix for bug 4722452
x_clev_rec.PAYMENT_INSTRUCTION_TYPE; --
SELECT ID,
SFWT_FLAG,
CHR_ID_RESPONSE,
CHR_ID_AWARD,
INV_ORGANIZATION_ID,
to_char(APPLICATION_ID),
STS_CODE,
QCL_ID,
SCS_CODE,
CONTRACT_NUMBER,
CURRENCY_CODE,
CONTRACT_NUMBER_MODIFIER,
ARCHIVED_YN,
DELETED_YN,
CUST_PO_NUMBER_REQ_YN,
PRE_PAY_REQ_YN,
CUST_PO_NUMBER,
SHORT_DESCRIPTION,
COMMENTS,
DESCRIPTION,
DPAS_RATING,
COGNOMEN,
TEMPLATE_YN,
TEMPLATE_USED,
DATE_APPROVED,
DATETIME_CANCELLED,
AUTO_RENEW_DAYS,
DATE_ISSUED,
DATETIME_RESPONDED,
NON_RESPONSE_REASON,
NON_RESPONSE_EXPLAIN,
RFP_TYPE,
CHR_TYPE,
KEEP_ON_MAIL_LIST,
SET_ASIDE_REASON,
SET_ASIDE_PERCENT,
RESPONSE_COPIES_REQ,
DATE_CLOSE_PROJECTED,
DATETIME_PROPOSED,
DATE_SIGNED,
DATE_TERMINATED,
DATE_RENEWED,
TRN_CODE,
START_DATE,
END_DATE,
AUTHORING_ORG_ID,
BUY_OR_SELL,
ISSUE_OR_RECEIVE,
ESTIMATED_AMOUNT,
PROGRAM_ID,
REQUEST_ID,
PRICE_LIST_ID,
PRICING_DATE,
SIGN_BY_DATE,
PROGRAM_UPDATE_DATE,
TOTAL_LINE_LIST_PRICE,
PROGRAM_APPLICATION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GOVERNING_CONTRACT_YN,
-- new colums to replace rules
CONVERSION_TYPE,
CONVERSION_RATE,
CONVERSION_RATE_DATE,
CONVERSION_EURO_RATE,
CUST_ACCT_ID,
BILL_TO_SITE_USE_ID,
INV_RULE_ID,
RENEWAL_TYPE_CODE,
RENEWAL_NOTIFY_TO,
RENEWAL_END_DATE,
SHIP_TO_SITE_USE_ID,
PAYMENT_TERM_ID
FROM OKC_K_HEADERS_V
WHERE id = p_chr_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
CHR_ID_RESPONSE,
CHR_ID_AWARD,
INV_ORGANIZATION_ID,
APPLICATION_ID,
STS_CODE,
QCL_ID,
SCS_CODE,
CONTRACT_NUMBER,
CURRENCY_CODE,
CONTRACT_NUMBER_MODIFIER,
ARCHIVED_YN,
DELETED_YN,
CUST_PO_NUMBER_REQ_YN,
PRE_PAY_REQ_YN,
CUST_PO_NUMBER,
SHORT_DESCRIPTION,
COMMENTS,
DESCRIPTION,
DPAS_RATING,
COGNOMEN,
TEMPLATE_YN,
TEMPLATE_USED,
DATE_APPROVED,
DATETIME_CANCELLED,
AUTO_RENEW_DAYS,
DATE_ISSUED,
DATETIME_RESPONDED,
NON_RESPONSE_REASON,
NON_RESPONSE_EXPLAIN,
RFP_TYPE,
CHR_TYPE,
KEEP_ON_MAIL_LIST,
SET_ASIDE_REASON,
SET_ASIDE_PERCENT,
RESPONSE_COPIES_REQ,
DATE_CLOSE_PROJECTED,
DATETIME_PROPOSED,
DATE_SIGNED,
DATE_TERMINATED,
DATE_RENEWED,
TRN_CODE,
START_DATE,
END_DATE,
AUTHORING_ORG_ID,
BUY_OR_SELL,
ISSUE_OR_RECEIVE,
ESTIMATED_AMOUNT,
PROGRAM_ID,
REQUEST_ID,
PRICE_LIST_ID,
PRICING_DATE,
SIGN_BY_DATE,
PROGRAM_UPDATE_DATE,
TOTAL_LINE_LIST_PRICE,
PROGRAM_APPLICATION_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
GOVERNING_CONTRACT_YN,
-- new colums to replace rules
CONVERSION_TYPE,
CONVERSION_RATE,
CONVERSION_RATE_DATE,
CONVERSION_EURO_RATE,
CUST_ACCT_ID,
BILL_TO_SITE_USE_ID,
INV_RULE_ID,
RENEWAL_TYPE_CODE,
RENEWAL_NOTIFY_TO,
RENEWAL_END_DATE,
SHIP_TO_SITE_USE_ID,
PAYMENT_TERM_ID
FROM OKC_K_HEADERS_HV
WHERE id = p_chr_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
x_chrv_rec.DELETED_YN,
x_chrv_rec.CUST_PO_NUMBER_REQ_YN,
x_chrv_rec.PRE_PAY_REQ_YN,
x_chrv_rec.CUST_PO_NUMBER,
x_chrv_rec.SHORT_DESCRIPTION,
x_chrv_rec.COMMENTS,
x_chrv_rec.DESCRIPTION,
x_chrv_rec.DPAS_RATING,
x_chrv_rec.COGNOMEN,
x_chrv_rec.TEMPLATE_YN,
x_chrv_rec.TEMPLATE_USED,
x_chrv_rec.DATE_APPROVED,
x_chrv_rec.DATETIME_CANCELLED,
x_chrv_rec.AUTO_RENEW_DAYS,
x_chrv_rec.DATE_ISSUED,
x_chrv_rec.DATETIME_RESPONDED,
x_chrv_rec.NON_RESPONSE_REASON,
x_chrv_rec.NON_RESPONSE_EXPLAIN,
x_chrv_rec.RFP_TYPE,
x_chrv_rec.CHR_TYPE,
x_chrv_rec.KEEP_ON_MAIL_LIST,
x_chrv_rec.SET_ASIDE_REASON,
x_chrv_rec.SET_ASIDE_PERCENT,
x_chrv_rec.RESPONSE_COPIES_REQ,
x_chrv_rec.DATE_CLOSE_PROJECTED,
x_chrv_rec.DATETIME_PROPOSED,
x_chrv_rec.DATE_SIGNED,
x_chrv_rec.DATE_TERMINATED,
x_chrv_rec.DATE_RENEWED,
x_chrv_rec.TRN_CODE,
x_chrv_rec.START_DATE,
x_chrv_rec.END_DATE,
x_chrv_rec.AUTHORING_ORG_ID,
x_chrv_rec.BUY_OR_SELL,
x_chrv_rec.ISSUE_OR_RECEIVE,
x_chrv_rec.ESTIMATED_AMOUNT,
x_chrv_rec.PROGRAM_ID,
x_chrv_rec.REQUEST_ID,
x_chrv_rec.PRICE_LIST_ID,
x_chrv_rec.PRICING_DATE,
x_chrv_rec.SIGN_BY_DATE,
x_chrv_rec.PROGRAM_UPDATE_DATE,
x_chrv_rec.TOTAL_LINE_LIST_PRICE,
x_chrv_rec.PROGRAM_APPLICATION_ID,
x_chrv_rec.ATTRIBUTE_CATEGORY,
x_chrv_rec.ATTRIBUTE1,
x_chrv_rec.ATTRIBUTE2,
x_chrv_rec.ATTRIBUTE3,
x_chrv_rec.ATTRIBUTE4,
x_chrv_rec.ATTRIBUTE5,
x_chrv_rec.ATTRIBUTE6,
x_chrv_rec.ATTRIBUTE7,
x_chrv_rec.ATTRIBUTE8,
x_chrv_rec.ATTRIBUTE9,
x_chrv_rec.ATTRIBUTE10,
x_chrv_rec.ATTRIBUTE11,
x_chrv_rec.ATTRIBUTE12,
x_chrv_rec.ATTRIBUTE13,
x_chrv_rec.ATTRIBUTE14,
x_chrv_rec.ATTRIBUTE15,
x_chrv_rec.GOVERNING_CONTRACT_YN,
-- new colums to replace rules
x_chrv_rec.CONVERSION_TYPE,
x_chrv_rec.CONVERSION_RATE,
x_chrv_rec.CONVERSION_RATE_DATE,
x_chrv_rec.CONVERSION_EURO_RATE,
x_chrv_rec.CUST_ACCT_ID,
x_chrv_rec.BILL_TO_SITE_USE_ID,
x_chrv_rec.INV_RULE_ID,
x_chrv_rec.RENEWAL_TYPE_CODE,
x_chrv_rec.RENEWAL_NOTIFY_TO,
x_chrv_rec.RENEWAL_END_DATE,
x_chrv_rec.SHIP_TO_SITE_USE_ID,
x_chrv_rec.PAYMENT_TERM_ID;
SELECT ID,
SFWT_FLAG,
PDF_ID,
CNH_ID,
DNZ_CHR_ID,
ENABLED_YN,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_OUTCOMES_V
WHERE ID = p_oce_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
SFWT_FLAG,
PDF_ID,
CNH_ID,
DNZ_CHR_ID,
ENABLED_YN,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_OUTCOMES_HV
WHERE ID = p_oce_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
PDP_ID,
OCE_ID,
AAE_ID,
DNZ_CHR_ID,
VALUE
FROM OKC_OUTCOME_ARGUMENTS_V
WHERE ID = p_oat_id
AND G_COPY_HISTORY_YN = 'N'
UNION ALL
SELECT ID,
PDP_ID,
OCE_ID,
AAE_ID,
DNZ_CHR_ID,
VALUE
FROM OKC_OUTCOME_ARGUMENTS_HV
WHERE ID = p_oat_id
AND major_version = G_FROM_VERSION_NUMBER
AND G_COPY_HISTORY_YN = 'Y';
SELECT ID,
SCN_TYPE,
CHR_ID,
SAT_CODE,
SECTION_SEQUENCE,
LABEL,
HEADING,
SCN_ID,
SFWT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_SECTIONS_V
WHERE ID = p_scn_id;
SELECT ID,
SCN_ID,
LABEL,
CAT_ID,
CLE_ID,
SAE_ID,
CONTENT_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_SECTION_CONTENTS_V
WHERE ID = p_scc_id;
SELECT
--ID,
PAT_ID,
CHR_ID,
CLE_ID,
BSL_ID,
BCL_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
MODIFIED_FROM,
MODIFIED_TO,
MODIFIER_MECHANISM_TYPE_CODE,
OPERAND,
ARITHMETIC_OPERATOR,
AUTOMATIC_FLAG,
UPDATE_ALLOWED,
UPDATED_FLAG,
APPLIED_FLAG,
ON_INVOICE_FLAG,
PRICING_PHASE_ID,
CONTEXT,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
LIST_HEADER_ID,
LIST_LINE_ID,
LIST_LINE_TYPE_CODE,
CHANGE_REASON_CODE,
CHANGE_REASON_TEXT,
ESTIMATED_FLAG,
ADJUSTED_AMOUNT,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
RANGE_BREAK_QUANTITY,
ACCRUAL_CONVERSION_RATE,
PRICING_GROUP_SEQUENCE,
ACCRUAL_FLAG,
LIST_LINE_NO,
SOURCE_SYSTEM_CODE,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
EXPIRATION_DATE,
MODIFIER_LEVEL_CODE,
PRICE_BREAK_TYPE_CODE,
SUBSTITUTION_ATTRIBUTE,
PRORATION_TYPE_CODE,
INCLUDE_ON_RETURNS_FLAG,
OBJECT_VERSION_NUMBER,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LAST_UPDATE_LOGIN,
REBATE_TRANSACTION_TYPE_CODE
FROM OKC_PRICE_ADJUSTMENTS_V
WHERE ID = p_pat_id;
x_patv_rec.LAST_UPDATED_BY,
x_patv_rec.LAST_UPDATE_DATE,
x_patv_rec.MODIFIED_FROM,
x_patv_rec.MODIFIED_TO,
x_patv_rec.MODIFIER_MECHANISM_TYPE_CODE,
x_patv_rec.OPERAND,
x_patv_rec.ARITHMETIC_OPERATOR,
x_patv_rec.AUTOMATIC_FLAG,
x_patv_rec.UPDATE_ALLOWED,
x_patv_rec.UPDATED_FLAG,
x_patv_rec.APPLIED_FLAG,
x_patv_rec.ON_INVOICE_FLAG,
x_patv_rec.PRICING_PHASE_ID,
x_patv_rec.CONTEXT,
x_patv_rec.PROGRAM_APPLICATION_ID,
x_patv_rec.PROGRAM_ID,
x_patv_rec.PROGRAM_UPDATE_DATE,
x_patv_rec.REQUEST_ID,
x_patv_rec.LIST_HEADER_ID,
x_patv_rec.LIST_LINE_ID,
x_patv_rec.LIST_LINE_TYPE_CODE,
x_patv_rec.CHANGE_REASON_CODE,
x_patv_rec.CHANGE_REASON_TEXT,
x_patv_rec.ESTIMATED_FLAG,
x_patv_rec.ADJUSTED_AMOUNT,
x_patv_rec.CHARGE_TYPE_CODE,
x_patv_rec.CHARGE_SUBTYPE_CODE,
x_patv_rec.RANGE_BREAK_QUANTITY,
x_patv_rec.ACCRUAL_CONVERSION_RATE,
x_patv_rec.PRICING_GROUP_SEQUENCE,
x_patv_rec.ACCRUAL_FLAG,
x_patv_rec.LIST_LINE_NO,
x_patv_rec.SOURCE_SYSTEM_CODE,
x_patv_rec.BENEFIT_QTY,
x_patv_rec.BENEFIT_UOM_CODE,
x_patv_rec.EXPIRATION_DATE,
x_patv_rec.MODIFIER_LEVEL_CODE,
x_patv_rec.PRICE_BREAK_TYPE_CODE,
x_patv_rec.SUBSTITUTION_ATTRIBUTE,
x_patv_rec.PRORATION_TYPE_CODE,
x_patv_rec.INCLUDE_ON_RETURNS_FLAG,
x_patv_rec.OBJECT_VERSION_NUMBER,
x_patv_rec.ATTRIBUTE1,
x_patv_rec.ATTRIBUTE2,
x_patv_rec.ATTRIBUTE3,
x_patv_rec.ATTRIBUTE4,
x_patv_rec.ATTRIBUTE5,
x_patv_rec.ATTRIBUTE6,
x_patv_rec.ATTRIBUTE7,
x_patv_rec.ATTRIBUTE8,
x_patv_rec.ATTRIBUTE9,
x_patv_rec.ATTRIBUTE10,
x_patv_rec.ATTRIBUTE11,
x_patv_rec.ATTRIBUTE12,
x_patv_rec.ATTRIBUTE13,
x_patv_rec.ATTRIBUTE14,
x_patv_rec.ATTRIBUTE15,
x_patv_rec.LAST_UPDATE_LOGIN,
x_patv_rec.REBATE_TRANSACTION_TYPE_CODE;
SELECT
ID,
PAT_ID,
PAT_ID_FROM,
BSL_ID,
CLE_ID,
BCL_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
OBJECT_VERSION_NUMBER
FROM OKC_PRICE_ADJ_ASSOCS_V
WHERE ID = p_pac_id;
x_pacv_rec.LAST_UPDATED_BY,
x_pacv_rec.LAST_UPDATE_DATE,
x_pacv_rec.LAST_UPDATE_LOGIN,
x_pacv_rec.PROGRAM_APPLICATION_ID,
x_pacv_rec.PROGRAM_ID,
x_pacv_rec.PROGRAM_UPDATE_DATE,
x_pacv_rec.REQUEST_ID,
x_pacv_rec.OBJECT_VERSION_NUMBER;
SELECT
ID,
PAT_ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
PRICING_ATTR_VALUE_FROM,
PRICING_ATTR_VALUE_TO,
COMPARISON_OPERATOR,
LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
OBJECT_VERSION_NUMBER
FROM OKC_PRICE_ADJ_ATTRIBS_V
WHERE ID = p_paa_id;
x_paav_rec.LAST_UPDATED_BY,
x_paav_rec.LAST_UPDATE_DATE,
x_paav_rec.PRICING_ATTR_VALUE_FROM,
x_paav_rec.PRICING_ATTR_VALUE_TO,
x_paav_rec.COMPARISON_OPERATOR,
x_paav_rec.LAST_UPDATE_LOGIN,
x_paav_rec.PROGRAM_APPLICATION_ID,
x_paav_rec.PROGRAM_ID,
x_paav_rec.PROGRAM_UPDATE_DATE,
x_paav_rec.REQUEST_ID,
x_paav_rec.OBJECT_VERSION_NUMBER;
SELECT ID,
CHR_ID,
CLE_ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
QUALIFIER_CONTEXT,
QUALIFIER_ATTRIBUTE1,
QUALIFIER_ATTRIBUTE2,
QUALIFIER_ATTRIBUTE3,
QUALIFIER_ATTRIBUTE4,
QUALIFIER_ATTRIBUTE5,
QUALIFIER_ATTRIBUTE6,
QUALIFIER_ATTRIBUTE7,
QUALIFIER_ATTRIBUTE8,
QUALIFIER_ATTRIBUTE9,
QUALIFIER_ATTRIBUTE10,
QUALIFIER_ATTRIBUTE11,
QUALIFIER_ATTRIBUTE12,
QUALIFIER_ATTRIBUTE13,
QUALIFIER_ATTRIBUTE14,
QUALIFIER_ATTRIBUTE15,
QUALIFIER_ATTRIBUTE16,
QUALIFIER_ATTRIBUTE17,
QUALIFIER_ATTRIBUTE18,
QUALIFIER_ATTRIBUTE19,
QUALIFIER_ATTRIBUTE20,
QUALIFIER_ATTRIBUTE21,
QUALIFIER_ATTRIBUTE22,
QUALIFIER_ATTRIBUTE23,
QUALIFIER_ATTRIBUTE24,
QUALIFIER_ATTRIBUTE25,
QUALIFIER_ATTRIBUTE26,
QUALIFIER_ATTRIBUTE27,
QUALIFIER_ATTRIBUTE28,
QUALIFIER_ATTRIBUTE29,
QUALIFIER_ATTRIBUTE30,
QUALIFIER_ATTRIBUTE31,
QUALIFIER_ATTRIBUTE32,
QUALIFIER_ATTRIBUTE33,
QUALIFIER_ATTRIBUTE34,
QUALIFIER_ATTRIBUTE35,
QUALIFIER_ATTRIBUTE36,
QUALIFIER_ATTRIBUTE37,
QUALIFIER_ATTRIBUTE38,
QUALIFIER_ATTRIBUTE39,
QUALIFIER_ATTRIBUTE40,
QUALIFIER_ATTRIBUTE41,
QUALIFIER_ATTRIBUTE42,
QUALIFIER_ATTRIBUTE43,
QUALIFIER_ATTRIBUTE44,
QUALIFIER_ATTRIBUTE45,
QUALIFIER_ATTRIBUTE46,
QUALIFIER_ATTRIBUTE47,
QUALIFIER_ATTRIBUTE48,
QUALIFIER_ATTRIBUTE49,
QUALIFIER_ATTRIBUTE50,
QUALIFIER_ATTRIBUTE51,
QUALIFIER_ATTRIBUTE52,
QUALIFIER_ATTRIBUTE53,
QUALIFIER_ATTRIBUTE54,
QUALIFIER_ATTRIBUTE55,
QUALIFIER_ATTRIBUTE56,
QUALIFIER_ATTRIBUTE57,
QUALIFIER_ATTRIBUTE58,
QUALIFIER_ATTRIBUTE59,
QUALIFIER_ATTRIBUTE60,
QUALIFIER_ATTRIBUTE61,
QUALIFIER_ATTRIBUTE62,
QUALIFIER_ATTRIBUTE63,
QUALIFIER_ATTRIBUTE64,
QUALIFIER_ATTRIBUTE65,
QUALIFIER_ATTRIBUTE66,
QUALIFIER_ATTRIBUTE67,
QUALIFIER_ATTRIBUTE68,
QUALIFIER_ATTRIBUTE69,
QUALIFIER_ATTRIBUTE70,
QUALIFIER_ATTRIBUTE71,
QUALIFIER_ATTRIBUTE72,
QUALIFIER_ATTRIBUTE73,
QUALIFIER_ATTRIBUTE74,
QUALIFIER_ATTRIBUTE75,
QUALIFIER_ATTRIBUTE76,
QUALIFIER_ATTRIBUTE77,
QUALIFIER_ATTRIBUTE78,
QUALIFIER_ATTRIBUTE79,
QUALIFIER_ATTRIBUTE80,
QUALIFIER_ATTRIBUTE81,
QUALIFIER_ATTRIBUTE82,
QUALIFIER_ATTRIBUTE83,
QUALIFIER_ATTRIBUTE84,
QUALIFIER_ATTRIBUTE85,
QUALIFIER_ATTRIBUTE86,
QUALIFIER_ATTRIBUTE87,
QUALIFIER_ATTRIBUTE88,
QUALIFIER_ATTRIBUTE89,
QUALIFIER_ATTRIBUTE90,
QUALIFIER_ATTRIBUTE91,
QUALIFIER_ATTRIBUTE92,
QUALIFIER_ATTRIBUTE93,
QUALIFIER_ATTRIBUTE94,
QUALIFIER_ATTRIBUTE95,
QUALIFIER_ATTRIBUTE96,
QUALIFIER_ATTRIBUTE97,
QUALIFIER_ATTRIBUTE98,
QUALIFIER_ATTRIBUTE99,
QUALIFIER_ATTRIBUTE100
FROM OKC_PRICE_ATT_VALUES_V
WHERE ID = p_pav_id;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
SELECT start_date,end_date
FROM okc_time_ia_startend_val_v
WHERE id = p_id;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
SELECT START_MONTH,
START_NTH,
START_DAY_OF_WEEK,
START_DAY,
START_HOUR,
START_MINUTE,
START_SECOND,
END_MONTH,
END_NTH,
END_DAY_OF_WEEK,
END_DAY,
END_HOUR,
END_MINUTE,
END_SECOND
FROM okc_time_ig_startend_val_v
WHERE id = p_id;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
SELECT start_date,end_date
FROM okc_time_ia_startend_val_v
WHERE id = p_id;
SELECT uom_code,duration,active_yn
FROM okc_time_cycle_span_v
WHERE id = p_id;
p_to.last_updated_by := p_from.last_updated_by;
p_to.last_update_date := p_from.last_update_date;
p_to.last_update_login := p_from.last_update_login;
SELECT tve_type,cnh_id
FROM okc_timevalues
WHERE id = p_id;
SELECT dnz_chr_id,
template_yn
FROM okc_condition_headers_b
WHERE id = p_id;
SELECT START_PARENT_DATE,
END_DATE,
ID,
TZE_ID,
START_UOM_CODE,
START_DURATION,
START_TVE_ID_OFFSET,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
TVE_ID_STARTED,
TVE_ID_ENDED,
TVE_ID_LIMITED,
DNZ_CHR_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
OPERATOR,
DURATION,
UOM_CODE,
BEFORE_AFTER,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_TIME_IA_STARTEND_REL_V
WHERE ID = p_id;
SELECT START_DATE,
END_DATE,
ID,
OBJECT_VERSION_NUMBER,
TZE_ID,
SFWT_FLAG,
TVE_ID_STARTED,
TVE_ID_ENDED,
TVE_ID_LIMITED,
DNZ_CHR_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
OPERATOR,
DURATION,
UOM_CODE,
BEFORE_AFTER,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_TIME_IA_STARTEND_VAL_V
WHERE ID = p_id;
SELECT article_effective_date
FROM okc_template_usages_v
WHERE document_type=p_doc_type AND document_id=p_doc_id;
SELECT id,
dnz_chr_id
FROM okc_k_lines_b
where lse_id=20
CONNECT BY PRIOR id = cle_id
START WITH id =p;
SELECT pdf_id
FROM okc_class_operations
WHERE opn_code = 'COPY'
AND cls_code = 'SERVICE';
SELECT lse_id
FROM OKC_K_LINES_b
WHERE id = p_id;
SELECT osb.cls_code
FROM okc_subclasses_b osb,okc_k_headers_b okb
WHERE okb.id = p_from_chr_id
AND okb.scs_code = osb.code ;
g_events.DELETE;
g_ruls.DELETE;
g_sections.DELETE;
g_timevalues.DELETE;
g_party.DELETE;
SELECT okc_conc_requests_s.nextval into l_id from dual;
INSERT INTO OKC_CONC_REQUESTS(
ID,
SOURCE_ID,
TARGET_CHR_ID,
COMPONENT_TYPE,
ATTRIBUTE1,
PROCESS_NAME,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID)
VALUES
(l_id,
p_components_tbl(i).id,
p_components_tbl(i).to_k,
p_components_tbl(i).component_type,
p_components_tbl(i).attribute1,
'OKCCPCON',
FND_PROFILE.VALUE('ORG_ID'),
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
SYSDATE,
decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
);
INSERT INTO OKC_CONC_REQUESTS(ID,
SOURCE_ID,
TARGET_CLE_ID,
LSE_ID,
LINE_EXISTS_YN,
LINE_EXP_YN, --bug 3990643
PROCESS_NAME,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID)
VALUES ( l_id,
p_lines_tbl(j).id,
p_lines_tbl(j).to_line,
p_lines_tbl(j).lse_id,
p_lines_tbl(j).line_exists_yn,
p_lines_tbl(j).line_exp_yn, --bug 3990643
'OKCCPCON',
FND_PROFILE.VALUE('ORG_ID'),
FND_GLOBAL.USER_ID,
SYSDATE,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
SYSDATE,
decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID)
);
select okc_conc_requests_s.currval into l_id from dual;
CURSOR cur_select_records IS SELECT
SOURCE_ID ID,
TARGET_CHR_ID TO_K,
COMPONENT_TYPE,
ATTRIBUTE1,
TARGET_CLE_ID to_line,
LSE_ID,
LINE_EXISTS_YN,
LINE_EXP_YN --mmadhavi bug 3990643
FROM OKC_CONC_REQUESTS
WHERE ID = p_id;
SELECT
contract_number ||' '|| contract_number_modifier
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT COUNT(date_cancelled), COUNT(date_terminated)
FROM okc_k_lines_b okcb, oks_k_lines_b oksb
WHERE okcb.id = oksb.cle_id
AND okcb.dnz_chr_id = p_chr_id;
FOR p_cur_select_records IN cur_select_records LOOP
l_comp_tbl(i).id := p_cur_select_records.id;
l_comp_tbl(i).to_k := p_cur_select_records.to_k;
IF p_cur_select_records.component_type is not null then
l_comp_tbl(i).component_type := p_cur_select_records.component_type;
l_comp_tbl(i).attribute1 := p_cur_select_records.attribute1;
l_lines_tbl(i).id := p_cur_select_records.id;
l_lines_tbl(i).to_line := p_cur_select_records.to_line;
l_lines_tbl(i).lse_id := p_cur_select_records.lse_id;
l_lines_tbl(i).line_exists_yn := p_cur_select_records.line_exists_yn;
l_lines_tbl(i).line_exp_yn := p_cur_select_records.line_exp_yn; --bug 3990643
PROCEDURE UPDATE_TEMPLATE_CONTRACT (p_api_version IN NUMBER,
p_chr_id IN NUMBER,
p_start_date IN DATE,
p_end_date IN DATE,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
l_msg_count NUMBER;
select orig_system_id1
from
okc_k_headers_b
where id = P_To_Chr_ID;
SELECT id
FROM okc_k_accesses
WHERE chr_id = p_chr_id;
SELECT id,start_date,end_date,lse_id
FROM OKC_K_LINES_B
WHERE lse_id in (1,7,8,9,10,11,12,13,14,19,18,25,35,46)
CONNECT BY cle_id = PRIOR id
START WITH CHR_ID = p_chr_id;
SELECT start_date,end_date
FROM OKC_K_HEADERS_B
WHERE id = p_chr_id;
SELECT id, dnz_chr_id
, start_date, end_date,lse_id,inv_rule_id
--npalepu added new column on 18-may-2006 for bug # 5211482
,ORIG_SYSTEM_ID1
--end npalepu
FROM OKC_K_LINES_B
WHERE dnz_chr_id = p_chr_id
AND cle_id IS NULL;
SELECT SEQUENCE_NO
,UOM_CODE
,START_DATE
,END_DATE
,LEVEL_PERIODS
,UOM_PER_PERIOD
,ADVANCE_PERIODS
,LEVEL_AMOUNT
,INVOICE_OFFSET_DAYS
,INTERFACE_OFFSET_DAYS
,COMMENTS
,DUE_ARR_YN
,AMOUNT
,LINES_DETAILED_YN
FROM OKS_STREAM_LEVELS_B
WHERE CLE_ID = P_From_Cle_ID
AND dnz_chr_id = P_FROM_CHR_ID
ORDER BY SEQUENCE_NO;
SELECT acct_rule_id
FROM OKS_K_HEADERS_B
WHERE chr_id = p_chr_id;
SELECT billing_schedule_type
FROM OKS_K_LINES_B
WHERE cle_id = p_cle_id
and dnz_chr_id = p_chr_id;
SELECT id,acct_rule_id, object_version_number
FROM OKS_K_LINES_B
WHERE cle_id = p_cle_id
and dnz_chr_id = p_chr_id;
SELECT id, object_version_number, est_rev_date
FROM OKS_K_HEADERS_B
WHERE chr_id = p_chr_id;
SELECT SUM(nvl(tax_amount, 0)) amount
FROM okc_k_lines_b cle, oks_k_lines_b kln
WHERE cle.cle_id = p_cle_id
AND cle.id = kln.cle_id
AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25)
AND cle.date_cancelled IS NULL;
SELECT id, object_version_number, dnz_chr_id
FROM oks_k_lines_b
WHERE cle_id = p_cle_id ;
SELECT SUM(kln.tax_amount) amount
FROM okc_k_lines_b cle, oks_k_lines_b kln
WHERE cle.dnz_chr_id = p_chr_id
AND cle.id = kln.cle_id
AND cle.lse_id IN (7, 8, 9, 10, 11, 13, 35, 25, 46)
AND cle.date_cancelled IS NULL;
SELECT id, object_version_number
FROM OKS_K_HEADERS_B
WHERE chr_id = p_chr_id ;
PROCEDURE UPDATE_LINE_DETAILS(p_cle_id NUMBER,
p_start_date DATE,
p_end_date DATE,
p_lse_id NUMBER,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2) IS
l_api_version NUMBER := 1.0;
SELECT '1'
FROM OKS_PM_SCHEDULES
WHERE dnz_chr_id = p_chr_id
--npalepu modified on 5/12/2006 for bug # 5211447
--changing because from R12 onwards the PM schedules will be directly
--attached to the TOP line but not to the coverage line
/* AND cle_id in ( SELECT id
FROM OKC_K_LINES_B
WHERE cle_id = p_cle_id); */
SELECT end_date,inv_rule_id
FROM okc_k_headers_b
WHERE id= p_chr_id;
SELECT end_date,inv_rule_id
FROM okc_k_lines_b
WHERE id IN (SELECT b.cle_id
FROM OKC_K_LINES_B b
WHERE b.id = p_cle_id);
SELECT id
FROM OKC_K_LINES_V
WHERE cle_id = p_cle_id
AND lse_id in (2,13,15,20);
okc_debug.log('1130: Inside Update Lines');
okc_debug.log('1140: Before calling OKC_CONTRACT_PUB.update_contract_line '|| p_cle_id);
OKC_CONTRACT_PUB.update_contract_line(p_api_version => l_api_version,
x_return_status => l_return_status ,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_clev_rec => l_clev_rec ,
x_clev_rec => x_clev_rec);
okc_debug.log('1150: Before Update Coverage');
OKS_COVERAGES_PVT.Update_COVERAGE_Effectivity(
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_service_Line_Id => p_cle_id,
p_New_Start_Date => p_start_date,
p_New_End_Date => l_end_date );
okc_debug.log('1150: After Update Coverage ' || l_return_status);
END UPDATE_LINE_DETAILS;
l_p_tavv_tbl(1).last_updated_by := NULL;
l_p_tavv_tbl(1).last_update_date := NULL;
l_p_tavv_tbl(1).last_update_login := NULL;
okc_debug.Set_Indentation('UPDATE_TEMPLATE_CONTRACT ');
okc_debug.log('1000: Entering Update Template Contract' || to_char(sysdate,'HH:MI:SS'));
OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_chrv_rec => l_chrv_rec,
x_chrv_rec => x_chrv_rec);
okc_debug.log('1020: After OKC_CONTRACT_PUB.update_contract_header call ' || l_return_status);
-- Delete Header billing schedule bug# 4188236
DELETE FROM OKS_LEVEL_ELEMENTS
WHERE RUL_ID IN
(SELECT SLL.ID
FROM OKS_STREAM_LEVELS_B SLL
WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);
DELETE FROM OKS_STREAM_LEVELS_B
WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
OKS_CONTRACT_HDR_PUB.update_header
(
p_api_version => 1,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khrv_tbl => l_khrv_tbl_in,
x_khrv_tbl => l_khrv_tbl_out,
p_validate_yn => 'N');
l_khrv_tbl_in.delete;
OKC_CONTRACT_PUB.delete_contract_access(p_api_version => l_api_version,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_cacv_rec => cacv_rec);
UPDATE_LINE_DETAILS(p_cle_id => l_line_rec.id,
p_start_date => p_start_date,
p_end_date => p_end_date,
p_lse_id => l_line_rec.lse_id,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_return_status => l_return_status );
okc_debug.log('1040: Completed Line Updates');
OKC_CONTRACT_PUB.update_contract_header(p_api_version => l_api_version,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_chrv_rec => l_chrv_rec,
x_chrv_rec => x_chrv_rec);
okc_debug.log('1070: Completed header update ' || l_return_status );
-- Delete Header billing schedule bug# 4188236
DELETE FROM OKS_LEVEL_ELEMENTS
WHERE RUL_ID IN
(SELECT SLL.ID
FROM OKS_STREAM_LEVELS_B SLL
WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);
DELETE FROM OKS_STREAM_LEVELS_B
WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
OKS_CONTRACT_HDR_PUB.update_header
(
p_api_version => 1,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_khrv_tbl => l_khrv_tbl_in,
x_khrv_tbl => l_khrv_tbl_out,
p_validate_yn => 'N');
l_khrv_tbl_in.delete;
OKC_CONTRACT_PUB.delete_contract_access(p_api_version => l_api_version,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_cacv_rec => cacv_rec);
okc_debug.log('1080: After contract access delete');
okc_debug.log('1090: After contract access delete');
UPDATE_LINE_DETAILS(p_cle_id => line_rec.id,
p_start_date => l_start_date,
p_end_date => l_end_date,
p_lse_id => line_rec.lse_id,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
x_return_status => l_return_status );
okc_debug.log('1120: Completed Line update');
oks_contract_line_pub.update_line
(
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_klnv_tbl => l_klnv_tax_tbl_in,
x_klnv_tbl => l_klnv_tax_tbl_out,
p_validate_yn => 'N'
);
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_tbl => l_khrv_tax_tbl_in,
x_khrv_tbl => l_khrv_tax_tbl_out,
p_validate_yn => 'N');
l_LineStreams_tbl.DELETE;
oks_contract_line_pub.update_line
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_klnv_tbl => l_klnv_tbl_in,
x_klnv_tbl => l_klnv_tbl_out,
p_validate_yn => 'N'
);
okc_debug.log('1220: Exiting UPDATE_TEMPLATE_CONTRACT' || to_char(sysdate,'HH:MI:SS'));
END UPDATE_TEMPLATE_CONTRACT ;