[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ID,
SOURCE_TABLE,
SOURCE_ID,
PDT_ID,
TRY_ID,
STY_ID,
MEMO_YN,
FACTOR_INVESTOR_FLAG,
FACTOR_INVESTOR_CODE,
AMOUNT,
FORMULA_USED,
ENTERED_DATE,
ACCOUNTING_DATE,
GL_REVERSAL_FLAG,
POST_TO_GL,
CURRENCY_CODE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
KHR_ID,
KLE_ID,
PAY_VENDOR_SITES_PK,
REC_SITE_USES_PK,
ASSET_CATEGORY_ID_PK1,
ASSET_BOOK_PK2,
PAY_FINANCIAL_OPTIONS_PK,
JTF_SALES_REPS_PK,
INVENTORY_ITEM_ID_PK1,
INVENTORY_ORG_ID_PK2,
REC_TRX_TYPES_PK,
AVL_ID,
LOCAL_PRODUCT_YN,
INTERNAL_STATUS,
CUSTOM_STATUS,
SOURCE_INDICATOR_FLAG,
ORG_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
PROGRAM_UPDATE_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_ACCT_SOURCES
WHERE OKL_ACCT_SOURCES.id = p_id;
l_asev_rec.program_update_date,
l_asev_rec.created_by,
l_asev_rec.creation_date,
l_asev_rec.last_updated_by,
l_asev_rec.last_update_date,
l_asev_rec.last_update_login;
SELECT
ID,
SOURCE_TABLE,
SOURCE_ID,
PDT_ID,
TRY_ID,
STY_ID,
MEMO_YN,
FACTOR_INVESTOR_FLAG,
FACTOR_INVESTOR_CODE,
AMOUNT,
FORMULA_USED,
ENTERED_DATE,
ACCOUNTING_DATE,
GL_REVERSAL_FLAG,
POST_TO_GL,
CURRENCY_CODE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
KHR_ID,
KLE_ID,
PAY_VENDOR_SITES_PK,
REC_SITE_USES_PK,
ASSET_CATEGORY_ID_PK1,
ASSET_BOOK_PK2,
PAY_FINANCIAL_OPTIONS_PK,
JTF_SALES_REPS_PK,
INVENTORY_ITEM_ID_PK1,
INVENTORY_ORG_ID_PK2,
REC_TRX_TYPES_PK,
AVL_ID,
LOCAL_PRODUCT_YN,
INTERNAL_STATUS,
CUSTOM_STATUS,
SOURCE_INDICATOR_FLAG,
ORG_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
REQUEST_ID,
PROGRAM_UPDATE_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM OKL_ACCT_SOURCES
WHERE OKL_ACCT_SOURCES.id = p_id;
l_ase_rec.program_update_date,
l_ase_rec.created_by,
l_ase_rec.creation_date,
l_ase_rec.last_updated_by,
l_ase_rec.last_update_date,
l_ase_rec.last_update_login;
IF (l_asev_rec.program_update_date = Okc_Api.G_MISS_DATE ) THEN
l_asev_rec.program_update_date := NULL;
IF (l_asev_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN
l_asev_rec.last_updated_by := NULL;
IF (l_asev_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN
l_asev_rec.last_update_date := NULL;
IF (l_asev_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN
l_asev_rec.last_update_login := NULL;
SELECT '1'
FROM OKL_PRODUCTS_V
WHERE ID = v_pdt_id;
SELECT '1'
FROM OKL_TRX_TYPES_V
WHERE ID = v_try_id;
SELECT '1'
FROM Okl_Strm_Type_V
WHERE okl_strm_type_v.id = p_id;
SELECT '1'
FROM Okl_K_Headers_V
WHERE okl_k_headers_v.id = p_id;
SELECT '1'
FROM OKL_AE_TEMPLATES
WHERE id = v_template_id;
p_to.program_update_date := p_from.program_update_date;
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.program_update_date := p_from.program_update_date;
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,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ase_rec IN ase_rec_type,
x_ase_rec OUT NOCOPY ase_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
INSERT INTO OKL_ACCT_SOURCES(
id,
source_table,
source_id,
pdt_id,
try_id,
sty_id,
memo_yn,
factor_investor_flag,
factor_investor_code,
amount,
formula_used,
entered_date,
accounting_date,
gl_reversal_flag,
post_to_gl,
currency_code,
currency_conversion_type,
currency_conversion_date,
currency_conversion_rate,
khr_id,
kle_id,
pay_vendor_sites_pk,
rec_site_uses_pk,
asset_category_id_pk1,
asset_book_pk2,
pay_financial_options_pk,
jtf_sales_reps_pk,
inventory_item_id_pk1,
inventory_org_id_pk2,
rec_trx_types_pk,
avl_id,
local_product_yn,
internal_status,
custom_status,
source_indicator_flag,
org_id,
program_id,
program_application_id,
request_id,
program_update_date,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (
l_ase_rec.id,
l_ase_rec.source_table,
l_ase_rec.source_id,
l_ase_rec.pdt_id,
l_ase_rec.try_id,
l_ase_rec.sty_id,
l_ase_rec.memo_yn,
l_ase_rec.factor_investor_flag,
l_ase_rec.factor_investor_code,
l_ase_rec.amount,
l_ase_rec.formula_used,
l_ase_rec.entered_date,
l_ase_rec.accounting_date,
l_ase_rec.gl_reversal_flag,
l_ase_rec.post_to_gl,
l_ase_rec.currency_code,
l_ase_rec.currency_conversion_type,
l_ase_rec.currency_conversion_date,
l_ase_rec.currency_conversion_rate,
l_ase_rec.khr_id,
l_ase_rec.kle_id,
l_ase_rec.pay_vendor_sites_pk,
l_ase_rec.rec_site_uses_pk,
l_ase_rec.asset_category_id_pk1,
l_ase_rec.asset_book_pk2,
l_ase_rec.pay_financial_options_pk,
l_ase_rec.jtf_sales_reps_pk,
l_ase_rec.inventory_item_id_pk1,
l_ase_rec.inventory_org_id_pk2,
l_ase_rec.rec_trx_types_pk,
l_ase_rec.avl_id,
l_ase_rec.local_product_yn,
l_ase_rec.internal_status,
l_ase_rec.custom_status,
l_ase_rec.source_indicator_flag,
l_ase_rec.org_id,
l_ase_rec.program_id,
l_ase_rec.program_application_id,
l_ase_rec.request_id,
l_ase_rec.program_update_date,
l_ase_rec.created_by,
l_ase_rec.creation_date,
l_ase_rec.last_updated_by,
l_ase_rec.last_update_date,
l_ase_rec.last_update_login);
END insert_row;
PROCEDURE insert_row(
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_asev_rec IN asev_rec_type,
x_asev_rec OUT NOCOPY asev_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_asev_rec.LAST_UPDATE_DATE := l_asev_rec.CREATION_DATE;
l_asev_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_asev_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
SELECT DECODE(l_request_id, -1, NULL, l_request_id),
DECODE(l_prog_app_id, -1, NULL, l_prog_app_id),
DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
DECODE(l_request_id, -1, NULL, SYSDATE)
INTO x_asev_rec.REQUEST_ID
,x_asev_rec.PROGRAM_APPLICATION_ID
,x_asev_rec.PROGRAM_ID
,x_asev_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
insert_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_ase_rec,
lx_ase_rec
);
END insert_row;
PROCEDURE insert_row_bulk(
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_asev_tbl IN asev_tbl_type,
x_asev_tbl OUT NOCOPY asev_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row_bulk';
in_program_update_date Okl_Streams_Util.DateTabTyp;
in_last_updated_by Okl_Streams_Util.NumberTabTyp;
in_last_update_date Okl_Streams_Util.DateTabTyp;
in_last_update_login Okl_Streams_Util.NumberTabTyp;
l_last_updated_by NUMBER;
l_last_update_date DATE;
l_last_update_login NUMBER;
l_prog_update_date DATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_date := SYSDATE;
l_last_update_login := FND_GLOBAL.LOGIN_ID;
SELECT DECODE(l_request_id, -1, NULL, l_request_id),
DECODE(l_prog_app_id, -1, NULL, l_prog_app_id),
DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
DECODE(l_request_id, -1, NULL, SYSDATE)
INTO l_request_id
,l_prog_app_id
,l_program_id
,l_prog_update_date
FROM DUAL;
in_program_update_date(j) := l_prog_update_date;
in_last_updated_by(j) := l_last_updated_by;
in_last_update_date(j) := l_last_update_date;
in_last_update_login(j) := l_last_update_login;
INSERT INTO okl_acct_sources(id
,source_table
,source_id
,pdt_id
,try_id
,sty_id
,memo_yn
,factor_investor_flag
,factor_investor_code
,amount
,formula_used
,entered_date
,accounting_date
,gl_reversal_flag
,post_to_gl
,currency_code
,currency_conversion_type
,currency_conversion_date
,currency_conversion_rate
,khr_id
,kle_id
,pay_vendor_sites_pk
,rec_site_uses_pk
,asset_category_id_pk1
,asset_book_pk2
,pay_financial_options_pk
,jtf_sales_reps_pk
,inventory_item_id_pk1
,inventory_org_id_pk2
,rec_trx_types_pk
,avl_id
,local_product_yn
,internal_status
,custom_status
,source_indicator_flag
,org_id
,program_id
,program_application_id
,request_id
,program_update_date
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES(in_id(i)
,in_source_table(i)
,in_source_id(i)
,in_pdt_id(i)
,in_try_id(i)
,in_sty_id(i)
,in_memo_yn(i)
,in_factor_investor_flag(i)
,in_factor_investor_code(i)
,in_amount(i)
,in_formula_used(i)
,in_entered_date(i)
,in_accounting_date(i)
,in_gl_reversal_flag(i)
,in_post_to_gl(i)
,in_currency_code(i)
,in_currency_conversion_type(i)
,in_currency_conversion_date(i)
,in_currency_conversion_rate(i)
,in_khr_id(i)
,in_kle_id(i)
,in_pay_vendor_sites_pk(i)
,in_rec_site_uses_pk(i)
,in_asset_category_id_pk1(i)
,in_asset_book_pk2(i)
,in_pay_financial_options_pk(i)
,in_jtf_sales_reps_pk(i)
,in_inventory_item_id_pk1(i)
,in_inventory_org_id_pk2(i)
,in_rec_trx_types_pk(i)
,in_avl_id(i)
,in_local_product_yn(i)
,in_internal_status(i)
,in_custom_status(i)
,in_source_indicator_flag(i)
,in_org_id(i)
,in_program_id(i)
,in_program_application_id(i)
,in_request_id(i)
,in_program_update_date(i)
,in_created_by(i)
,in_creation_date(i)
,in_last_updated_by(i)
,in_last_update_date(i)
,in_last_update_login(i));
END insert_row_bulk;
PROCEDURE insert_row(
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_asev_tbl IN asev_tbl_type,
x_asev_tbl OUT NOCOPY asev_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_asev_rec => p_asev_tbl(i),
x_asev_rec => x_asev_tbl(i));
END insert_row;
SELECT *
FROM OKL_ACCT_SOURCES
WHERE ID = p_ase_rec.id
FOR UPDATE NOWAIT;
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
IF (l_lock_var.program_update_date <> p_ase_rec.program_update_date) THEN
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
IF (l_lock_var.last_updated_by <> p_ase_rec.last_updated_by) THEN
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
IF (l_lock_var.last_update_date <> p_ase_rec.last_update_date) THEN
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
IF (l_lock_var.last_update_login <> p_ase_rec.last_update_login) THEN
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
PROCEDURE update_row(
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_ase_rec IN ase_rec_type,
x_ase_rec OUT NOCOPY ase_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
IF (x_ase_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_ase_rec.program_update_date := l_ase_rec.program_update_date;
IF (x_ase_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_ase_rec.last_updated_by := l_ase_rec.last_updated_by;
IF (x_ase_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_ase_rec.last_update_date := l_ase_rec.last_update_date;
IF (x_ase_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_ase_rec.last_update_login := l_ase_rec.last_update_login;
UPDATE OKL_ACCT_SOURCES
SET SOURCE_TABLE = l_def_ase_rec.source_table,
SOURCE_ID = l_def_ase_rec.source_id,
PDT_ID = l_def_ase_rec.pdt_id,
TRY_ID = l_def_ase_rec.try_id,
STY_ID = l_def_ase_rec.sty_id,
MEMO_YN = l_def_ase_rec.memo_yn,
FACTOR_INVESTOR_FLAG = l_def_ase_rec.factor_investor_flag,
FACTOR_INVESTOR_CODE = l_def_ase_rec.factor_investor_code,
AMOUNT = l_def_ase_rec.amount,
FORMULA_USED = l_def_ase_rec.formula_used,
ENTERED_DATE = l_def_ase_rec.entered_date,
ACCOUNTING_DATE = l_def_ase_rec.accounting_date,
GL_REVERSAL_FLAG = l_def_ase_rec.gl_reversal_flag,
POST_TO_GL = l_def_ase_rec.post_to_gl,
CURRENCY_CODE = l_def_ase_rec.currency_code,
CURRENCY_CONVERSION_TYPE = l_def_ase_rec.currency_conversion_type,
CURRENCY_CONVERSION_DATE = l_def_ase_rec.currency_conversion_date,
CURRENCY_CONVERSION_RATE = l_def_ase_rec.currency_conversion_rate,
KHR_ID = l_def_ase_rec.khr_id,
KLE_ID = l_def_ase_rec.kle_id,
PAY_VENDOR_SITES_PK = l_def_ase_rec.pay_vendor_sites_pk,
REC_SITE_USES_PK = l_def_ase_rec.rec_site_uses_pk,
ASSET_CATEGORY_ID_PK1 = l_def_ase_rec.asset_category_id_pk1,
ASSET_BOOK_PK2 = l_def_ase_rec.asset_book_pk2,
PAY_FINANCIAL_OPTIONS_PK = l_def_ase_rec.pay_financial_options_pk,
JTF_SALES_REPS_PK = l_def_ase_rec.jtf_sales_reps_pk,
INVENTORY_ITEM_ID_PK1 = l_def_ase_rec.inventory_item_id_pk1,
INVENTORY_ORG_ID_PK2 = l_def_ase_rec.inventory_org_id_pk2,
REC_TRX_TYPES_PK = l_def_ase_rec.rec_trx_types_pk,
AVL_ID = l_def_ase_rec.avl_id,
LOCAL_PRODUCT_YN = l_def_ase_rec.local_product_yn,
INTERNAL_STATUS = l_def_ase_rec.internal_status,
CUSTOM_STATUS = l_def_ase_rec.custom_status,
SOURCE_INDICATOR_FLAG = l_def_ase_rec.source_indicator_flag,
ORG_ID = l_def_ase_rec.org_id,
PROGRAM_ID = l_def_ase_rec.program_id,
PROGRAM_APPLICATION_ID = l_def_ase_rec.program_application_id,
REQUEST_ID = l_def_ase_rec.request_id,
PROGRAM_UPDATE_DATE = l_def_ase_rec.program_update_date,
CREATED_BY = l_def_ase_rec.created_by,
CREATION_DATE = l_def_ase_rec.creation_date,
LAST_UPDATED_BY = l_def_ase_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_ase_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_ase_rec.last_update_login
WHERE ID = l_def_ase_rec.id;
END update_row;
PROCEDURE update_row(
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_asev_rec IN asev_rec_type,
x_asev_rec OUT NOCOPY asev_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_asev_rec.LAST_UPDATE_DATE := SYSDATE;
l_asev_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_asev_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_asev_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_asev_rec.program_update_date := l_db_asev_rec.program_update_date;
IF (x_asev_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_asev_rec.last_updated_by := l_db_asev_rec.last_updated_by;
IF (x_asev_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_asev_rec.last_update_date := l_db_asev_rec.last_update_date;
IF (x_asev_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_asev_rec.last_update_login := l_db_asev_rec.last_update_login;
SELECT NVL(DECODE(l_request_id, -1, NULL, l_request_id) ,p_asev_rec.REQUEST_ID)
,NVL(DECODE(l_prog_app_id, -1, NULL, l_prog_app_id) ,p_asev_rec.PROGRAM_APPLICATION_ID)
,NVL(DECODE(l_program_id, -1, NULL, l_program_id) ,p_asev_rec.PROGRAM_ID)
,DECODE(DECODE(l_request_id, -1, NULL, SYSDATE) ,NULL, p_asev_rec.PROGRAM_UPDATE_DATE,SYSDATE)
INTO x_asev_rec.REQUEST_ID
,x_asev_rec.PROGRAM_APPLICATION_ID
,x_asev_rec.PROGRAM_ID
,x_asev_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
update_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_ase_rec,
lx_ase_rec
);
END update_row;
PROCEDURE update_row(
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_asev_tbl IN asev_tbl_type,
x_asev_tbl OUT NOCOPY asev_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_asev_rec => p_asev_tbl(i),
x_asev_rec => x_asev_tbl(i));
END update_row;
PROCEDURE delete_row(
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_ase_rec IN ase_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
DELETE FROM OKL_ACCT_SOURCES
WHERE ID = p_ase_rec.id;
END delete_row;
PROCEDURE delete_row(
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_asev_rec IN asev_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list,
l_return_status,
x_msg_count,
x_msg_data,
l_ase_rec
);
END delete_row;
PROCEDURE delete_row(
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_asev_tbl IN asev_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_asev_rec => p_asev_tbl(i));
END delete_row;