The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
CC_REP_CURRENCY_CODE,
CODE_COMBINATION_ID,
AEL_REP_CURRENCY_CODE,
SET_OF_BOOKS_ID,
OBJECT_VERSION_NUMBER,
REC_CCID,
REALIZED_GAIN_CCID,
REALIZED_LOSS_CCID,
TAX_CCID,
CROSS_CURRENCY_CCID,
ROUNDING_CCID,
AR_CLEARING_CCID,
PAYABLES_CCID,
LIABLITY_CCID,
PRE_PAYMENT_CCID,
FUT_DATE_PAY_CCID,
CC_ROUNDING_RULE,
CC_PRECISION,
CC_MIN_ACCT_UNIT,
DIS_TAKEN_CCID,
AP_CLEARING_CCID,
AEL_ROUNDING_RULE,
AEL_PRECISION,
AEL_MIN_ACCT_UNIT,
ORG_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
/* Changed Made by Kanti on 06/21/2001. The following two fields are available in Table
but were missing here. Changes Start here */
CC_APPLY_ROUNDING_DIFFERENCE,
AEL_APPLY_ROUNDING_DIFFERENCE,
ACCRUAL_REVERSAL_DAYS,
/*Changes End Here */
-- Added a new field for the bug 2331564 Santonyr
LKE_HOLD_DAYS,
/*Changes made by Keerthi 10-Sep-2003 for Rounding Amounts in Streams */
STM_APPLY_ROUNDING_DIFFERENCE,
STM_ROUNDING_RULE
/*Added new field for bug 4884618(H) */
,VALIDATE_KHR_START_DATE
,ACCOUNT_DERIVATION
,ISG_ARREARS_PAY_DATES_OPTION
,PAY_DIST_SET_ID
,SECONDARY_REP_METHOD --Bug#7225249
--Bug# 8370699
,amort_inc_adj_rev_dt_yn
FROM Okl_Sys_Acct_Opts
WHERE okl_sys_acct_opts.id = p_id;
l_sao_rec.LAST_UPDATED_BY,
l_sao_rec.LAST_UPDATE_DATE,
l_sao_rec.LAST_UPDATE_LOGIN,
/* Changed made by Kanti on 06/21/2001. The following two fields are available in table
but were missing from here. Changes starts here */
l_sao_rec.CC_APPLY_ROUNDING_DIFFERENCE,
l_sao_rec.AEL_APPLY_ROUNDING_DIFFERENCE,
l_sao_rec.ACCRUAL_REVERSAL_DAYS,
/* Changes End Here */
-- Added a new field for the bug 2331564 Santonyr
l_sao_rec.LKE_HOLD_DAYS,
/*Changes made by Keerthi 10-Sep-2003 for Rounding Amounts in Streams */
l_sao_rec.STM_APPLY_ROUNDING_DIFFERENCE,
l_sao_rec.STM_ROUNDING_RULE
/*Added new field for bug 4746246 */
,l_sao_rec.VALIDATE_KHR_START_DATE
,l_sao_rec.ACCOUNT_DERIVATION -- R12 SLA Uptake
,l_sao_rec.ISG_ARREARS_PAY_DATES_OPTION
,l_sao_rec.PAY_DIST_SET_ID
,l_sao_rec.SECONDARY_REP_METHOD --Bug#7225249
--Bug# 8370699
,l_sao_rec.AMORT_INC_ADJ_REV_DT_YN;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SET_OF_BOOKS_ID,
CODE_COMBINATION_ID,
CC_REP_CURRENCY_CODE,
AEL_REP_CURRENCY_CODE,
REC_CCID,
REALIZED_GAIN_CCID,
REALIZED_LOSS_CCID,
TAX_CCID,
CROSS_CURRENCY_CCID,
ROUNDING_CCID,
AR_CLEARING_CCID,
PAYABLES_CCID,
LIABLITY_CCID,
PRE_PAYMENT_CCID,
FUT_DATE_PAY_CCID,
DIS_TAKEN_CCID,
AP_CLEARING_CCID,
AEL_ROUNDING_RULE,
AEL_PRECISION,
AEL_MIN_ACCT_UNIT,
CC_ROUNDING_RULE,
CC_PRECISION,
CC_MIN_ACCT_UNIT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
/* Changed Made by Kanti on 06/21/2001. The following two fields are available in Table
but were missing here. Changes Start here */
CC_APPLY_ROUNDING_DIFFERENCE,
AEL_APPLY_ROUNDING_DIFFERENCE,
ACCRUAL_REVERSAL_DAYS,
-- Added new field lke_hold_days for the bug 2331564 by Santonyr
LKE_HOLD_DAYS,
/*Changes made by Keerthi 10-Sep-2003 for Rounding Amounts in Streams */
STM_APPLY_ROUNDING_DIFFERENCE,
STM_ROUNDING_RULE
/*Changes End Here */
/*Added new field for bug 4746246 */
,VALIDATE_KHR_START_DATE
,ACCOUNT_DERIVATION -- R12 SLA Uptake
,ISG_ARREARS_PAY_DATES_OPTION
,PAY_DIST_SET_ID
,SECONDARY_REP_METHOD --Bug#7225249
--Bug# 8370699
,AMORT_INC_ADJ_REV_DT_YN
FROM OKL_SYS_ACCT_OPTS
WHERE OKL_SYS_ACCT_OPTS.id = p_id;
l_saov_rec.LAST_UPDATED_BY,
l_saov_rec.LAST_UPDATE_DATE,
l_saov_rec.LAST_UPDATE_LOGIN,
/* Changed made by Kanti on 06/21/2001. The following two fields are available in table
but were missing from here. Changes starts here */
l_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE,
l_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE,
l_saov_rec.ACCRUAL_REVERSAL_DAYS,
-- Added new field lke_hold_days for the bug 2331564 by Santonyr
l_saov_rec.LKE_HOLD_DAYS,
/*Changes made by Keerthi 10-Sep-2003 for Rounding Amounts in Streams */
l_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE,
l_saov_rec.STM_ROUNDING_RULE
/* Changes End Here */
/*Added new field for bug 4746246 */
,l_saov_rec.VALIDATE_KHR_START_DATE
,l_saov_rec.ACCOUNT_DERIVATION -- R12 SLA Uptake;
IF (l_saov_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
l_saov_rec.last_updated_by := NULL;
IF (l_saov_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
l_saov_rec.last_update_date := NULL;
IF (l_saov_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
l_saov_rec.last_update_login := NULL;
select 1 from AP_DISTRIBUTION_SETS where DISTRIBUTION_SET_ID = distsetid ;
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;
PROCEDURE insert_row(
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sao_rec IN sao_rec_type,
x_sao_rec OUT NOCOPY sao_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_insert_row';
INSERT INTO OKL_SYS_ACCT_OPTS(
id,
cc_rep_currency_code,
code_combination_id,
ael_rep_currency_code,
set_of_books_id,
object_version_number,
rec_ccid,
realized_gain_ccid,
realized_loss_ccid,
tax_ccid,
cross_currency_ccid,
rounding_ccid,
ar_clearing_ccid,
payables_ccid,
liablity_ccid,
pre_payment_ccid,
fut_date_pay_ccid,
cc_rounding_rule,
cc_precision,
cc_min_acct_unit,
dis_taken_ccid,
ap_clearing_ccid,
ael_rounding_rule,
ael_precision,
ael_min_acct_unit,
org_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
/*changes made by Kanti on 06/21/2001 to make it consistent with database*/
cc_apply_rounding_difference,
ael_apply_rounding_difference,
/*changes end here*/
accrual_reversal_days ,
-- Added new field lke_hold_days for the bug 2331564 by Santonyr
lke_hold_days,
--Added by Keerthi 10-Sep-2003 for Rounding of Amounts in Streams
stm_apply_rounding_difference,
stm_rounding_rule
/*Added new field for bug 4884618(H) */
,validate_khr_start_date
,account_derivation -- R12 SLA Uptake
,isg_arrears_pay_dates_option
,PAY_DIST_SET_ID
,SECONDARY_REP_METHOD --Bug#7225249
--Bug# 8370699
,amort_inc_adj_rev_dt_yn
)
VALUES (
l_sao_rec.id,
l_sao_rec.cc_rep_currency_code,
l_sao_rec.code_combination_id,
l_sao_rec.ael_rep_currency_code,
l_sao_rec.set_of_books_id,
l_sao_rec.object_version_number,
l_sao_rec.rec_ccid,
l_sao_rec.realized_gain_ccid,
l_sao_rec.realized_loss_ccid,
l_sao_rec.tax_ccid,
l_sao_rec.cross_currency_ccid,
l_sao_rec.rounding_ccid,
l_sao_rec.ar_clearing_ccid,
l_sao_rec.payables_ccid,
l_sao_rec.liablity_ccid,
l_sao_rec.pre_payment_ccid,
l_sao_rec.fut_date_pay_ccid,
l_sao_rec.cc_rounding_rule,
l_sao_rec.cc_precision,
l_sao_rec.cc_min_acct_unit,
l_sao_rec.dis_taken_ccid,
l_sao_rec.ap_clearing_ccid,
l_sao_rec.ael_rounding_rule,
l_sao_rec.ael_precision,
l_sao_rec.ael_min_acct_unit,
l_sao_rec.org_id,
l_sao_rec.attribute_category,
l_sao_rec.attribute1,
l_sao_rec.attribute2,
l_sao_rec.attribute3,
l_sao_rec.attribute4,
l_sao_rec.attribute5,
l_sao_rec.attribute6,
l_sao_rec.attribute7,
l_sao_rec.attribute8,
l_sao_rec.attribute9,
l_sao_rec.attribute10,
l_sao_rec.attribute11,
l_sao_rec.attribute12,
l_sao_rec.attribute13,
l_sao_rec.attribute14,
l_sao_rec.attribute15,
l_sao_rec.created_by,
l_sao_rec.creation_date,
l_sao_rec.last_updated_by,
l_sao_rec.last_update_date,
l_sao_rec.last_update_login,
/* CHange done by Kanti on 06.21.2001 to make it consistent with table */
l_sao_rec.cc_apply_rounding_difference,
l_sao_rec.ael_apply_rounding_difference,
/*changes end here */
l_sao_rec.accrual_reversal_days,
-- Added new field lke_hold_days for the bug 2331564 by Santonyr
l_sao_rec.lke_hold_days,
--Added by Keerthi 10-Sep-2003 for Rounding of Amounts in Streams
l_sao_rec.stm_apply_rounding_difference,
l_sao_rec.stm_rounding_rule
--Added new field for bug 4884618(H)
,l_sao_rec.validate_khr_start_date
-- R12 SLA Uptake
,l_sao_rec.account_derivation
,l_sao_rec.isg_arrears_pay_dates_option
,l_sao_rec.PAY_DIST_SET_ID
,l_sao_rec.SECONDARY_REP_METHOD --Bug#7225249
-- Bug# 8370699
,l_sao_rec.amort_inc_adj_rev_dt_yn
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_rec IN saov_rec_type,
x_saov_rec OUT NOCOPY saov_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_saov_rec.LAST_UPDATE_DATE := SYSDATE;
l_saov_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_saov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_sao_rec,
lx_sao_rec
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_tbl IN saov_tbl_type,
x_saov_tbl OUT NOCOPY saov_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saov_rec => p_saov_tbl(i),
x_saov_rec => x_saov_tbl(i));
END insert_row;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_SYS_ACCT_OPTS
WHERE ID = p_sao_rec.id
AND OBJECT_VERSION_NUMBER = p_sao_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_SYS_ACCT_OPTS
WHERE ID = p_sao_rec.id;
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
PROCEDURE update_row(
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sao_rec IN sao_rec_type,
x_sao_rec OUT NOCOPY sao_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_update_row';
IF (x_sao_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_sao_rec.last_updated_by := l_sao_rec.last_updated_by;
IF (x_sao_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_sao_rec.last_update_date := l_sao_rec.last_update_date;
IF (x_sao_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_sao_rec.last_update_login := l_sao_rec.last_update_login;
UPDATE OKL_SYS_ACCT_OPTS
SET CC_REP_CURRENCY_CODE = l_def_sao_rec.cc_rep_currency_code,
CODE_COMBINATION_ID = l_def_sao_rec.code_combination_id,
AEL_REP_CURRENCY_CODE = l_def_sao_rec.ael_rep_currency_code,
SET_OF_BOOKS_ID = l_def_sao_rec.set_of_books_id,
OBJECT_VERSION_NUMBER = l_def_sao_rec.object_version_number,
REC_CCID = l_def_sao_rec.rec_ccid,
REALIZED_GAIN_CCID = l_def_sao_rec.realized_gain_ccid,
REALIZED_LOSS_CCID = l_def_sao_rec.realized_loss_ccid,
TAX_CCID = l_def_sao_rec.tax_ccid,
CROSS_CURRENCY_CCID = l_def_sao_rec.cross_currency_ccid,
ROUNDING_CCID = l_def_sao_rec.rounding_ccid,
AR_CLEARING_CCID = l_def_sao_rec.ar_clearing_ccid,
PAYABLES_CCID = l_def_sao_rec.payables_ccid,
LIABLITY_CCID = l_def_sao_rec.liablity_ccid,
PRE_PAYMENT_CCID = l_def_sao_rec.pre_payment_ccid,
FUT_DATE_PAY_CCID = l_def_sao_rec.fut_date_pay_ccid,
CC_ROUNDING_RULE = l_def_sao_rec.cc_rounding_rule,
CC_PRECISION = l_def_sao_rec.cc_precision,
CC_MIN_ACCT_UNIT = l_def_sao_rec.cc_min_acct_unit,
DIS_TAKEN_CCID = l_def_sao_rec.dis_taken_ccid,
AP_CLEARING_CCID = l_def_sao_rec.ap_clearing_ccid,
AEL_ROUNDING_RULE = l_def_sao_rec.ael_rounding_rule,
AEL_PRECISION = l_def_sao_rec.ael_precision,
AEL_MIN_ACCT_UNIT = l_def_sao_rec.ael_min_acct_unit,
ORG_ID = l_def_sao_rec.org_id,
ATTRIBUTE_CATEGORY = l_def_sao_rec.attribute_category,
ATTRIBUTE1 = l_def_sao_rec.attribute1,
ATTRIBUTE2 = l_def_sao_rec.attribute2,
ATTRIBUTE3 = l_def_sao_rec.attribute3,
ATTRIBUTE4 = l_def_sao_rec.attribute4,
ATTRIBUTE5 = l_def_sao_rec.attribute5,
ATTRIBUTE6 = l_def_sao_rec.attribute6,
ATTRIBUTE7 = l_def_sao_rec.attribute7,
ATTRIBUTE8 = l_def_sao_rec.attribute8,
ATTRIBUTE9 = l_def_sao_rec.attribute9,
ATTRIBUTE10 = l_def_sao_rec.attribute10,
ATTRIBUTE11 = l_def_sao_rec.attribute11,
ATTRIBUTE12 = l_def_sao_rec.attribute12,
ATTRIBUTE13 = l_def_sao_rec.attribute13,
ATTRIBUTE14 = l_def_sao_rec.attribute14,
ATTRIBUTE15 = l_def_sao_rec.attribute15,
CREATED_BY = l_def_sao_rec.created_by,
CREATION_DATE = l_def_sao_rec.creation_date,
LAST_UPDATED_BY = l_def_sao_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_sao_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_sao_rec.last_update_login,
/* Changes made by Kanti on 06/21/2001. Two new fields are present in the table but were
not present here
Changes Start here */
CC_APPLY_ROUNDING_DIFFERENCE = l_def_sao_rec.cc_apply_rounding_difference,
AEL_APPLY_ROUNDING_DIFFERENCE = l_def_sao_rec.ael_apply_rounding_difference,
ACCRUAL_REVERSAL_DAYS = l_def_sao_rec.ACCRUAL_REVERSAL_DAYS,
-- Added new field lke_hold_days for the bug 2331564 by Santonyr
LKE_HOLD_DAYS = l_def_sao_rec.LKE_HOLD_DAYS,
/* Changes end here */
--Added by Keerthi 10-Sep-2003 for Rounding of Amounts in Streams
STM_APPLY_ROUNDING_DIFFERENCE = l_def_sao_rec.stm_apply_rounding_difference,
STM_ROUNDING_RULE = l_def_sao_rec.stm_rounding_rule
--Added new field for bug 4746246
, VALIDATE_KHR_START_DATE=l_def_sao_rec.validate_khr_start_date
-- R12 SLA Uptake
,ACCOUNT_DERIVATION = l_def_sao_rec.account_derivation
,ISG_ARREARS_PAY_DATES_OPTION = l_def_sao_rec.isg_arrears_pay_dates_option
,PAY_DIST_SET_ID = l_def_sao_rec.PAY_DIST_SET_ID
,SECONDARY_REP_METHOD = l_def_sao_rec.SECONDARY_REP_METHOD
--Bug# 8370699
,AMORT_INC_ADJ_REV_DT_YN = l_def_sao_rec.amort_inc_adj_rev_dt_yn
WHERE ID = l_def_sao_rec.id;
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_rec IN saov_rec_type,
x_saov_rec OUT NOCOPY saov_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_saov_rec.LAST_UPDATE_DATE := SYSDATE;
l_saov_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_saov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_saov_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_saov_rec.last_updated_by := l_saov_rec.last_updated_by;
IF (x_saov_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_saov_rec.last_update_date := l_saov_rec.last_update_date;
IF (x_saov_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_saov_rec.last_update_login := l_saov_rec.last_update_login;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_sao_rec,
lx_sao_rec
);
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_tbl IN saov_tbl_type,
x_saov_tbl OUT NOCOPY saov_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saov_rec => p_saov_tbl(i),
x_saov_rec => x_saov_tbl(i));
END update_row;
PROCEDURE delete_row(
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sao_rec IN sao_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'OPTS_delete_row';
DELETE FROM OKL_SYS_ACCT_OPTS
WHERE ID = l_sao_rec.id;
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_rec IN saov_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_sao_rec
);
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saov_tbl IN saov_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => Okc_Api.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saov_rec => p_saov_tbl(i));
END delete_row;