The following lines contain the word 'select', 'insert', 'update' or 'delete':
oks_khr_pvt.insert_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_rec => p_khrv_rec,
x_khrv_rec => x_khrv_rec
);
oks_khr_pvt.insert_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl,
x_khrv_tbl => x_khrv_tbl,
px_error_tbl => px_error_tbl
);
oks_khr_pvt.insert_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl,
x_khrv_tbl => x_khrv_tbl
);
PROCEDURE update_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_rec IN khrv_rec_type,
x_khrv_rec OUT NOCOPY khrv_rec_type,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_khr_pvt.update_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_rec => p_khrv_rec,
x_khrv_rec => x_khrv_rec
);
END update_header;
PROCEDURE update_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_tbl IN khrv_tbl_type,
x_khrv_tbl OUT NOCOPY khrv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_khr_pvt.update_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl,
x_khrv_tbl => x_khrv_tbl,
px_error_tbl => px_error_tbl
);
END update_header;
PROCEDURE update_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_tbl IN khrv_tbl_type,
x_khrv_tbl OUT NOCOPY khrv_tbl_type,
p_validate_yn IN VARCHAR2) IS
BEGIN
x_return_status := G_RET_STS_SUCCESS;
oks_khr_pvt.update_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl,
x_khrv_tbl => x_khrv_tbl
);
END update_header;
PROCEDURE delete_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_rec IN khrv_rec_type) IS
BEGIN
oks_khr_pvt.delete_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_rec => p_khrv_rec
);
END delete_header;
PROCEDURE delete_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_tbl IN khrv_tbl_type,
px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
BEGIN
oks_khr_pvt.delete_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl,
px_error_tbl => px_error_tbl
);
END delete_header;
PROCEDURE delete_header(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_khrv_tbl IN khrv_tbl_type) IS
BEGIN
oks_khr_pvt.delete_row
(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_khrv_tbl => p_khrv_tbl
);
END delete_header;
INSERT INTO oks_k_headers_bh
(major_version,
id,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED,
renewal_comment,
cc_email_address) /*Added for ER 13869562*/
SELECT
p_major_version,
id,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED,
renewal_comment,
cc_email_address /*Added for ER 13869562*/
FROM oks_k_headers_b
WHERE chr_id = p_chr_id;
INSERT INTO oks_k_lines_bh
(major_version,
id,
cle_id,
dnz_chr_id,
discount_list,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
locked_price_list_id,
usage_est_yn,
usage_est_method,
usage_est_start_date,
termn_method,
ubt_amount,
credit_amount,
suppressed_credit,
override_amount,
cust_po_number_req_yn,
cust_po_number,
grace_duration,
grace_period,
inv_print_flag,
-- price_uom ,
tax_amount,
tax_inclusive_yn,
tax_status,
tax_code,
tax_exemption_id,
ib_trans_type,
ib_trans_date,
prod_price,
service_price,
clvl_list_price,
clvl_quantity,
clvl_extended_amt,
clvl_uom_code,
toplvl_operand_code,
toplvl_operand_val,
toplvl_quantity,
toplvl_uom_code,
toplvl_adj_price,
toplvl_price_qty,
averaging_interval,
settlement_interval,
minimum_quantity,
default_quantity,
amcv_flag,
fixed_quantity,
usage_duration,
usage_period,
level_yn,
usage_type,
uom_quantified,
base_reading,
billing_schedule_type,
full_credit,
locked_price_list_line_id,
break_uom,
prorate,
coverage_type,
exception_cov_id,
limit_uom_quantified,
discount_amount,
discount_percent,
offset_duration,
offset_period,
incident_severity_id,
pdf_id,
work_thru_yn,
react_active_yn,
transfer_option,
prod_upgrade_yn,
inheritance_type,
pm_program_id,
pm_conf_req_yn,
pm_sch_exists_yn,
allow_bt_discount,
apply_default_timezone,
sync_date_install,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
/*** R12 Data Model Changes 27072005 Start ***/
TRXN_EXTENSION_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
COVERAGE_ID,
STANDARD_COV_YN,
/*** R12 Data Model Changes 27072005 End ***/
/* skuchima VRM Er Changes */
revenue_impact_date,
counter_value_id
)
SELECT
p_major_version,
id,
cle_id,
dnz_chr_id,
discount_list,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
locked_price_list_id,
usage_est_yn,
usage_est_method,
usage_est_start_date,
termn_method,
ubt_amount,
credit_amount,
suppressed_credit,
override_amount,
cust_po_number_req_yn,
cust_po_number,
grace_duration,
grace_period,
inv_print_flag,
-- price_uom ,
tax_amount,
tax_inclusive_yn,
tax_status,
tax_code,
tax_exemption_id,
ib_trans_type,
ib_trans_date,
prod_price,
service_price,
clvl_list_price,
clvl_quantity,
clvl_extended_amt,
clvl_uom_code,
toplvl_operand_code,
toplvl_operand_val,
toplvl_quantity,
toplvl_uom_code,
toplvl_adj_price,
toplvl_price_qty,
averaging_interval,
settlement_interval,
minimum_quantity,
default_quantity,
amcv_flag,
fixed_quantity,
usage_duration,
usage_period,
level_yn,
usage_type,
uom_quantified,
base_reading,
billing_schedule_type,
full_credit,
locked_price_list_line_id,
break_uom,
prorate,
coverage_type,
exception_cov_id,
limit_uom_quantified,
discount_amount,
discount_percent,
offset_duration,
offset_period,
incident_severity_id,
pdf_id,
work_thru_yn,
react_active_yn,
transfer_option,
prod_upgrade_yn,
inheritance_type,
pm_program_id,
pm_conf_req_yn,
pm_sch_exists_yn,
allow_bt_discount,
apply_default_timezone,
sync_date_install,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
/*** R12 Data Model Changes 27072005 Start ***/
TRXN_EXTENSION_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
COVERAGE_ID,
STANDARD_COV_YN ,
/*** R12 Data Model Changes 27072005 End ***/
/* skuchima VRM Er Changes */
revenue_impact_date,
counter_value_id
FROM oks_k_lines_b
WHERE dnz_chr_id = p_chr_id;
INSERT INTO oks_k_lines_tlh
(major_version,
id,
language,
source_lang,
sfwt_flag,
invoice_text,
ib_trx_details,
status_text,
react_time_name,
security_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
SELECT
p_major_version,
a.id,
a.language,
a.source_lang,
a.sfwt_flag,
a.invoice_text,
a.ib_trx_details,
a.status_text,
a.react_time_name,
a.security_group_id,
a.created_by,
a.creation_date,
a.last_updated_by,
a.last_update_date,
a.last_update_login
FROM oks_k_lines_tl a,
oks_k_lines_b b
WHERE a.id = b.id
AND b.dnz_chr_id = p_chr_id;
SELECT major_version
FROM okc_k_vers_numbers
WHERE chr_id = p_chr_id;
PROCEDURE delete_saved_version(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN NUMBER) IS
BEGIN
OKC_API.init_msg_list(p_init_msg_list);
DELETE oks_k_lines_tlh
WHERE id IN
(SELECT id FROM oks_k_lines_bh
WHERE dnz_chr_id = p_chr_id )
AND major_version = - 1;
DELETE oks_k_lines_bh
WHERE dnz_chr_id = p_chr_id
AND major_version = - 1;
DELETE oks_k_headers_bh
WHERE chr_id = p_chr_id
AND major_version = - 1;
oks_coverages_pub.delete_saved_version
(
p_api_version => p_api_version,
p_init_msg_list => 'F',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => p_chr_id
);
END delete_saved_version;
PROCEDURE delete_saved_version(
p_chr_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2) IS
l_api_version NUMBER := 1.0;
delete_saved_version
(p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_chr_id => p_chr_id
);
END delete_saved_version;
DELETE oks_k_lines_tl
WHERE id IN
(SELECT id FROM oks_k_lines_b
WHERE dnz_chr_id = p_chr_id );
DELETE oks_k_lines_b
WHERE dnz_chr_id = p_chr_id;
DELETE oks_k_headers_b
WHERE chr_id = p_chr_id;
INSERT INTO oks_k_headers_b
(id,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED,
renewal_comment,
cc_email_address /*Added for ER 13869562*/
)
SELECT
id,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED,
renewal_comment,
cc_email_address /*Added for ER 13869562*/
FROM oks_k_headers_bh
WHERE chr_id = p_chr_id
AND major_version = - 1;
INSERT INTO oks_k_lines_b
(id,
cle_id,
dnz_chr_id,
discount_list,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
locked_price_list_id,
usage_est_yn,
usage_est_method,
usage_est_start_date,
termn_method,
ubt_amount,
credit_amount,
suppressed_credit,
override_amount,
cust_po_number_req_yn,
cust_po_number,
grace_duration,
grace_period,
inv_print_flag,
-- price_uom ,
tax_amount,
tax_inclusive_yn,
tax_status,
tax_code,
tax_exemption_id,
ib_trans_type,
ib_trans_date,
prod_price,
service_price,
clvl_list_price,
clvl_quantity,
clvl_extended_amt,
clvl_uom_code,
toplvl_operand_code,
toplvl_operand_val,
toplvl_quantity,
toplvl_uom_code,
toplvl_adj_price,
toplvl_price_qty,
averaging_interval,
settlement_interval,
minimum_quantity,
default_quantity,
amcv_flag,
fixed_quantity,
usage_duration,
usage_period,
level_yn,
usage_type,
uom_quantified,
base_reading,
billing_schedule_type,
full_credit,
locked_price_list_line_id,
break_uom,
prorate,
coverage_type,
exception_cov_id,
limit_uom_quantified,
discount_amount,
discount_percent,
offset_duration,
offset_period,
incident_severity_id,
pdf_id,
work_thru_yn,
react_active_yn,
transfer_option,
prod_upgrade_yn,
inheritance_type,
pm_program_id,
pm_conf_req_yn,
pm_sch_exists_yn,
allow_bt_discount,
apply_default_timezone,
sync_date_install,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
/*** R12 Data Model Changes 27072005 Start ***/
TRXN_EXTENSION_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
COVERAGE_ID,
STANDARD_COV_YN ,
/*** R12 Data Model Changes 27072005 End ***/
--skuchima VRM ER
revenue_impact_date,
counter_value_id
)
SELECT
id,
cle_id,
dnz_chr_id,
discount_list,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
locked_price_list_id,
usage_est_yn,
usage_est_method,
usage_est_start_date,
termn_method,
ubt_amount,
credit_amount,
suppressed_credit,
override_amount,
cust_po_number_req_yn,
cust_po_number,
grace_duration,
grace_period,
inv_print_flag,
-- price_uom ,
tax_amount,
tax_inclusive_yn,
tax_status,
tax_code,
tax_exemption_id,
ib_trans_type,
ib_trans_date,
prod_price,
service_price,
clvl_list_price,
clvl_quantity,
clvl_extended_amt,
clvl_uom_code,
toplvl_operand_code,
toplvl_operand_val,
toplvl_quantity,
toplvl_uom_code,
toplvl_adj_price,
toplvl_price_qty,
averaging_interval,
settlement_interval,
minimum_quantity,
default_quantity,
amcv_flag,
fixed_quantity,
usage_duration,
usage_period,
level_yn,
usage_type,
uom_quantified,
base_reading,
billing_schedule_type,
full_credit,
locked_price_list_line_id,
break_uom,
prorate,
coverage_type,
exception_cov_id,
limit_uom_quantified,
discount_amount,
discount_percent,
offset_duration,
offset_period,
incident_severity_id,
pdf_id,
work_thru_yn,
react_active_yn,
transfer_option,
prod_upgrade_yn,
inheritance_type,
pm_program_id,
pm_conf_req_yn,
pm_sch_exists_yn,
allow_bt_discount,
apply_default_timezone,
sync_date_install,
object_version_number,
security_group_id,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
/*** R12 Data Model Changes 27072005 Start ***/
TRXN_EXTENSION_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
COVERAGE_ID,
STANDARD_COV_YN,
/*** R12 Data Model Changes 27072005 End ***/
--skuchima VRM ER
revenue_impact_date,
counter_value_id
FROM oks_k_lines_bh
WHERE dnz_chr_id = p_chr_id
AND major_version = - 1;
INSERT INTO oks_k_lines_tl
(id,
language,
source_lang,
sfwt_flag,
invoice_text,
ib_trx_details,
status_text,
react_time_name,
security_group_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
)
SELECT
a.id,
a.language,
a.source_lang,
a.sfwt_flag,
a.invoice_text,
a.ib_trx_details,
a.status_text,
a.react_time_name,
a.security_group_id,
a.created_by,
a.creation_date,
a.last_updated_by,
a.last_update_date,
a.last_update_login
FROM oks_k_lines_tlh a,
oks_k_lines_b b
WHERE a.id = b.id
AND b.dnz_chr_id = p_chr_id
AND a.major_version = - 1;
PROCEDURE delete_history(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN NUMBER) IS
BEGIN
OKC_API.init_msg_list(p_init_msg_list);
DELETE oks_k_lines_tlh
WHERE id IN
(SELECT id FROM oks_k_lines_bh
WHERE dnz_chr_id = p_chr_id );
DELETE oks_k_lines_bh
WHERE dnz_chr_id = p_chr_id;
DELETE oks_k_headers_bh
WHERE chr_id = p_chr_id;
oks_coverages_pub.delete_history
(
p_api_version => p_api_version,
p_init_msg_list => 'F',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => p_chr_id
);
END delete_history;
PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,
p_khrv_tbl IN khrv_tbl_type) IS
l_tabsize NUMBER := p_khrv_tbl.COUNT;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by(j) := p_khrv_tbl(i).last_updated_by;
in_last_update_date(j) := p_khrv_tbl(i).last_update_date;
in_last_update_login(j) := p_khrv_tbl(i).last_update_login;
INSERT
INTO OKS_K_HEADERS_B
(
id,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED
)
VALUES (
in_id(i),
in_chr_id(i),
in_acct_rule_id(i),
in_payment_type(i),
in_cc_no(i),
in_cc_expiry_date(i),
in_cc_bank_acct_id(i),
in_cc_auth_code(i),
in_commitment_id(i),
in_grace_duration(i),
in_grace_period(i),
in_est_rev_percent(i),
in_est_rev_date(i),
in_tax_amount(i),
in_tax_status(i),
in_tax_code(i),
in_tax_exemption_id(i),
in_billing_profile_id(i),
in_renewal_status(i),
in_electronic_renewal_flag(i),
in_quote_to_contact_id(i),
in_quote_to_site_id(i),
in_quote_to_email_id(i),
in_quote_to_phone_id(i),
in_quote_to_fax_id(i),
in_renewal_po_required(i),
in_renewal_po_number(i),
in_renewal_price_list(i),
in_renewal_pricing_type(i),
in_renewal_markup_percent(i),
in_renewal_grace_duration(i),
in_renewal_grace_period(i),
in_renewal_est_rev_percent(i),
in_renewal_est_rev_duration(i),
in_renewal_est_rev_period(i),
in_renewal_price_list_used(i),
in_renewal_type_used(i),
in_renewal_notification_to(i),
in_renewal_po_used(i),
in_renewal_pricing_type_used(i),
in_renewal_markup_percent_used(i),
in_rev_est_percent_used(i),
in_rev_est_duration_used(i),
in_rev_est_period_used(i),
in_billing_profile_used(i),
in_ern_flag_used_yn(i),
in_evn_threshold_amt(i),
in_evn_threshold_cur(i),
in_ern_threshold_amt(i),
in_ern_threshold_cur(i),
in_renewal_grace_duration_used(i),
in_renewal_grace_period_used(i),
in_inv_trx_type(i),
in_inv_print_profile(i),
in_ar_interface_yn(i),
in_hold_billing(i),
in_summary_trx_yn(i),
in_service_po_number(i),
in_service_po_required(i),
in_billing_schedule_type(i),
in_object_version_number(i),
in_request_id(i),
in_created_by(i),
in_creation_date(i),
in_last_updated_by(i),
in_last_update_date(i),
in_last_update_login(i),
in_period_type(i),
in_period_start(i),
in_price_uom(i),
in_follow_up_action(i),
in_follow_up_date(i),
in_trxn_extension_id(i),
in_date_accepted(i),
in_accepted_by(i),
in_rmndr_suppress_flag(i),
in_rmndr_sent_flag(i),
in_quote_sent_flag(i),
in_process_request_id(i),
in_wf_item_key(i),
in_person_party_id(i),
in_tax_classification_code(i),
in_exempt_certificate_number(i),
in_exempt_reason_code(i),
in_approval_type_used(i)
);
END INSERT_ROW_UPG;
in_last_updated_by OKC_DATATYPES.NumberTabTyp;
in_last_update_date OKC_DATATYPES.DateTabTyp;
in_last_update_login OKC_DATATYPES.NumberTabTyp;
in_last_updated_by(j) := p_khrhv_tbl(i).last_updated_by;
in_last_update_date(j) := p_khrhv_tbl(i).last_update_date;
in_last_update_login(j) := p_khrhv_tbl(i).last_update_login;
INSERT INTO OKS_K_HEADERS_BH
(
id,
major_version,
chr_id,
acct_rule_id,
payment_type,
cc_no,
cc_expiry_date,
cc_bank_acct_id,
cc_auth_code,
commitment_id,
grace_duration,
grace_period,
est_rev_percent,
est_rev_date,
tax_amount,
tax_status,
tax_code,
tax_exemption_id,
billing_profile_id,
renewal_status,
electronic_renewal_flag,
quote_to_contact_id,
quote_to_site_id,
quote_to_email_id,
quote_to_phone_id,
quote_to_fax_id,
renewal_po_required,
renewal_po_number,
renewal_price_list,
renewal_pricing_type,
renewal_markup_percent,
renewal_grace_duration,
renewal_grace_period,
renewal_est_rev_percent,
renewal_est_rev_duration,
renewal_est_rev_period,
renewal_price_list_used,
renewal_type_used,
renewal_notification_to,
renewal_po_used,
renewal_pricing_type_used,
renewal_markup_percent_used,
rev_est_percent_used,
rev_est_duration_used,
rev_est_period_used,
billing_profile_used,
ern_flag_used_yn,
evn_threshold_amt,
evn_threshold_cur,
ern_threshold_amt,
ern_threshold_cur,
renewal_grace_duration_used,
renewal_grace_period_used,
inv_trx_type,
inv_print_profile,
ar_interface_yn,
hold_billing,
summary_trx_yn,
service_po_number,
service_po_required,
billing_schedule_type,
object_version_number,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
PERIOD_TYPE,
PERIOD_START,
PRICE_UOM,
FOLLOW_UP_ACTION,
FOLLOW_UP_DATE,
TRXN_EXTENSION_ID,
DATE_ACCEPTED,
ACCEPTED_BY,
RMNDR_SUPPRESS_FLAG,
RMNDR_SENT_FLAG,
QUOTE_SENT_FLAG,
PROCESS_REQUEST_ID,
WF_ITEM_KEY,
PERSON_PARTY_ID,
TAX_CLASSIFICATION_CODE,
EXEMPT_CERTIFICATE_NUMBER,
EXEMPT_REASON_CODE,
APPROVAL_TYPE_USED
)
VALUES (
in_id(i),
in_major_version(i),
in_chr_id(i),
in_acct_rule_id(i),
in_payment_type(i),
in_cc_no(i),
in_cc_expiry_date(i),
in_cc_bank_acct_id(i),
in_cc_auth_code(i),
in_commitment_id(i),
in_grace_duration(i),
in_grace_period(i),
in_est_rev_percent(i),
in_est_rev_date(i),
in_tax_amount(i),
in_tax_status(i),
in_tax_code(i),
in_tax_exemption_id(i),
in_billing_profile_id(i),
in_renewal_status(i),
in_electronic_renewal_flag(i),
in_quote_to_contact_id(i),
in_quote_to_site_id(i),
in_quote_to_email_id(i),
in_quote_to_phone_id(i),
in_quote_to_fax_id(i),
in_renewal_po_required(i),
in_renewal_po_number(i),
in_renewal_price_list(i),
in_renewal_pricing_type(i),
in_renewal_markup_percent(i),
in_renewal_grace_duration(i),
in_renewal_grace_period(i),
in_renewal_est_rev_percent(i),
in_renewal_est_rev_duration(i),
in_renewal_est_rev_period(i),
in_renewal_price_list_used(i),
in_renewal_type_used(i),
in_renewal_notification_to(i),
in_renewal_po_used(i),
in_renewal_pricing_type_used(i),
in_renewal_markup_percent_used(i),
in_rev_est_percent_used(i),
in_rev_est_duration_used(i),
in_rev_est_period_used(i),
in_billing_profile_used(i),
in_ern_flag_used_yn(i),
in_evn_threshold_amt(i),
in_evn_threshold_cur(i),
in_ern_threshold_amt(i),
in_ern_threshold_cur(i),
in_renewal_grace_duration_used(i),
in_renewal_grace_period_used(i),
in_inv_trx_type(i),
in_inv_print_profile(i),
in_ar_interface_yn(i),
in_hold_billing(i),
in_summary_trx_yn(i),
in_service_po_number(i),
in_service_po_required(i),
in_billing_schedule_type(i),
in_object_version_number(i),
in_request_id(i),
in_created_by(i),
in_creation_date(i),
in_last_updated_by(i),
in_last_update_date(i),
in_last_update_login(i),
in_period_type(i),
in_period_start(i),
in_price_uom(i),
in_follow_up_action(i),
in_follow_up_date(i),
in_trxn_extension_id(i),
in_date_accepted(i),
in_accepted_by(i),
in_rmndr_suppress_flag(i),
in_rmndr_sent_flag(i),
in_quote_sent_flag(i),
in_process_request_id(i),
in_wf_item_key(i),
in_person_party_id(i),
in_tax_classification_code(i),
in_exempt_certificate_number(i),
in_exempt_reason_code(i),
in_approval_type_used(i)
);