The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT '1'
FROM OKL_CNSLD_AR_LINES_V
WHERE id = p_llnv_rec.lln_id_parent;
SELECT '1'
FROM OKC_K_LINES_B
WHERE id = p_llnv_rec.kle_id;
SELECT '1'
FROM OKL_K_HEADERS_V
WHERE id = p_llnv_rec.khr_id;
SELECT '1'
FROM OKL_CNSLD_AR_HDRS_V
WHERE id = p_llnv_rec.cnr_id;
SELECT '1'
FROM OKL_INVC_LINE_TYPES_V
WHERE id = p_llnv_rec.ilt_id;
SELECT '1'
FROM fnd_currencies_vl
WHERE currency_code = p_llnv_rec.currency_code;
DELETE FROM OKL_CNSLD_AR_LINES_TL T
WHERE NOT EXISTS (
SELECT NULL
FROM OKL_CNSLD_AR_LINES_B B
WHERE B.ID = T.ID
AND T.LANGUAGE = USERENV('LANG')
);
UPDATE statement is not complete.
Please comment out WHERE condition if
UPDATE statement is not present
If new release has some columns in the table,
this modification is not needed
WHERE (
T.ID,
T.LANGUAGE)
IN (SELECT
SUBT.ID,
SUBT.LANGUAGE
FROM OKL_CNSLD_AR_LINES_TL SUBB, OKL_CNSLD_AR_LINES_TL SUBT
WHERE SUBB.ID = SUBT.ID
AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
*/
INSERT INTO OKL_CNSLD_AR_LINES_TL (
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN)
SELECT
B.ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG,
B.SFWT_FLAG,
B.CREATED_BY,
B.CREATION_DATE,
B.LAST_UPDATED_BY,
B.LAST_UPDATE_DATE,
B.LAST_UPDATE_LOGIN
FROM OKL_CNSLD_AR_LINES_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('I', 'B')
AND B.LANGUAGE = USERENV('LANG')
AND NOT EXISTS(
SELECT NULL
FROM OKL_CNSLD_AR_LINES_TL T
WHERE T.ID = B.ID
AND T.LANGUAGE = L.LANGUAGE_CODE
);
SELECT
ID,
SEQUENCE_NUMBER,
LLN_ID_PARENT,
KLE_ID,
KHR_ID,
CNR_ID,
ILT_ID,
LINE_TYPE,
AMOUNT,
OBJECT_VERSION_NUMBER,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
ORG_ID,
TAX_AMOUNT,
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
FROM Okl_Cnsld_Ar_Lines_B
WHERE okl_cnsld_ar_lines_b.id = p_id;
l_lln_rec.PROGRAM_UPDATE_DATE,
l_lln_rec.ORG_ID,
l_lln_rec.TAX_AMOUNT,
l_lln_rec.ATTRIBUTE_CATEGORY,
l_lln_rec.ATTRIBUTE1,
l_lln_rec.ATTRIBUTE2,
l_lln_rec.ATTRIBUTE3,
l_lln_rec.ATTRIBUTE4,
l_lln_rec.ATTRIBUTE5,
l_lln_rec.ATTRIBUTE6,
l_lln_rec.ATTRIBUTE7,
l_lln_rec.ATTRIBUTE8,
l_lln_rec.ATTRIBUTE9,
l_lln_rec.ATTRIBUTE10,
l_lln_rec.ATTRIBUTE11,
l_lln_rec.ATTRIBUTE12,
l_lln_rec.ATTRIBUTE13,
l_lln_rec.ATTRIBUTE14,
l_lln_rec.ATTRIBUTE15,
l_lln_rec.CREATED_BY,
l_lln_rec.CREATION_DATE,
l_lln_rec.LAST_UPDATED_BY,
l_lln_rec.LAST_UPDATE_DATE,
l_lln_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Cnsld_Ar_Lines_Tl
WHERE okl_cnsld_ar_lines_tl.id = p_id
AND okl_cnsld_ar_lines_tl.LANGUAGE = p_language;
l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATED_BY,
l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_DATE,
l_okl_cnsld_ar_lines_tl_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
KHR_ID,
CNR_ID,
KLE_ID,
LLN_ID_PARENT,
ILT_ID,
SEQUENCE_NUMBER,
AMOUNT,
TAX_AMOUNT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LINE_TYPE,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
ORG_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Cnsld_Ar_Lines_V
WHERE okl_cnsld_ar_lines_v.id = p_id;
l_llnv_rec.PROGRAM_UPDATE_DATE,
l_llnv_rec.ORG_ID,
l_llnv_rec.CREATED_BY,
l_llnv_rec.CREATION_DATE,
l_llnv_rec.LAST_UPDATED_BY,
l_llnv_rec.LAST_UPDATE_DATE,
l_llnv_rec.LAST_UPDATE_LOGIN;
IF (l_llnv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
l_llnv_rec.program_update_date := NULL;
IF (l_llnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
l_llnv_rec.last_updated_by := NULL;
IF (l_llnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
l_llnv_rec.last_update_date := NULL;
IF (l_llnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
l_llnv_rec.last_update_login := NULL;
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;
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_lln_rec IN lln_rec_type,
x_lln_rec OUT NOCOPY lln_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
INSERT INTO OKL_CNSLD_AR_LINES_B(
id,
sequence_number,
lln_id_parent,
kle_id,
khr_id,
cnr_id,
ilt_id,
line_type,
amount,
object_version_number,
request_id,
program_application_id,
program_id,
program_update_date,
org_id,
tax_amount,
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)
VALUES (
l_lln_rec.id,
l_lln_rec.sequence_number,
l_lln_rec.lln_id_parent,
l_lln_rec.kle_id,
l_lln_rec.khr_id,
l_lln_rec.cnr_id,
l_lln_rec.ilt_id,
l_lln_rec.line_type,
l_lln_rec.amount,
l_lln_rec.object_version_number,
l_lln_rec.request_id,
l_lln_rec.program_application_id,
l_lln_rec.program_id,
l_lln_rec.program_update_date,
l_lln_rec.org_id,
l_lln_rec.tax_amount,
l_lln_rec.attribute_category,
l_lln_rec.attribute1,
l_lln_rec.attribute2,
l_lln_rec.attribute3,
l_lln_rec.attribute4,
l_lln_rec.attribute5,
l_lln_rec.attribute6,
l_lln_rec.attribute7,
l_lln_rec.attribute8,
l_lln_rec.attribute9,
l_lln_rec.attribute10,
l_lln_rec.attribute11,
l_lln_rec.attribute12,
l_lln_rec.attribute13,
l_lln_rec.attribute14,
l_lln_rec.attribute15,
l_lln_rec.created_by,
l_lln_rec.creation_date,
l_lln_rec.last_updated_by,
l_lln_rec.last_update_date,
l_lln_rec.last_update_login);
END insert_row;
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_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
SELECT *
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('I', 'B');
INSERT INTO OKL_CNSLD_AR_LINES_TL(
id,
LANGUAGE,
source_lang,
sfwt_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (
l_okl_cnsld_ar_lines_tl_rec.id,
l_okl_cnsld_ar_lines_tl_rec.LANGUAGE,
l_okl_cnsld_ar_lines_tl_rec.source_lang,
l_okl_cnsld_ar_lines_tl_rec.sfwt_flag,
l_okl_cnsld_ar_lines_tl_rec.created_by,
l_okl_cnsld_ar_lines_tl_rec.creation_date,
l_okl_cnsld_ar_lines_tl_rec.last_updated_by,
l_okl_cnsld_ar_lines_tl_rec.last_update_date,
l_okl_cnsld_ar_lines_tl_rec.last_update_login);
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_llnv_rec IN llnv_rec_type,
x_llnv_rec OUT NOCOPY llnv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
SELECT
DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
INTO
x_llnv_rec.request_id,
x_llnv_rec.program_application_id,
x_llnv_rec.program_id,
x_llnv_rec.program_update_date
FROM dual;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lln_rec,
lx_lln_rec
);
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_okl_cnsld_ar_lines_tl_rec,
lx_okl_cnsld_ar_lines_tl_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_llnv_tbl IN llnv_tbl_type,
x_llnv_tbl OUT NOCOPY llnv_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_llnv_rec => p_llnv_tbl(i),
x_llnv_rec => x_llnv_tbl(i));
END insert_row;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_CNSLD_AR_LINES_B
WHERE ID = p_lln_rec.id
AND OBJECT_VERSION_NUMBER = p_lln_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_CNSLD_AR_LINES_B
WHERE ID = p_lln_rec.id;
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
SELECT *
FROM OKL_CNSLD_AR_LINES_TL
WHERE ID = p_okl_cnsld_ar_lines_tl_rec.id
FOR UPDATE NOWAIT;
Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_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_lln_rec IN lln_rec_type,
x_lln_rec OUT NOCOPY lln_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
IF (x_lln_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_lln_rec.program_update_date := l_lln_rec.program_update_date;
IF (x_lln_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_lln_rec.last_updated_by := l_lln_rec.last_updated_by;
IF (x_lln_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_lln_rec.last_update_date := l_lln_rec.last_update_date;
IF (x_lln_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_lln_rec.last_update_login := l_lln_rec.last_update_login;
UPDATE OKL_CNSLD_AR_LINES_B
SET SEQUENCE_NUMBER = l_def_lln_rec.sequence_number,
LLN_ID_PARENT = l_def_lln_rec.lln_id_parent,
KLE_ID = l_def_lln_rec.kle_id,
KHR_ID = l_def_lln_rec.khr_id,
CNR_ID = l_def_lln_rec.cnr_id,
ILT_ID = l_def_lln_rec.ilt_id,
LINE_TYPE = l_def_lln_rec.line_type,
AMOUNT = l_def_lln_rec.amount,
OBJECT_VERSION_NUMBER = l_def_lln_rec.object_version_number,
REQUEST_ID = l_def_lln_rec.request_id,
PROGRAM_APPLICATION_ID = l_def_lln_rec.program_application_id,
PROGRAM_ID = l_def_lln_rec.program_id,
PROGRAM_UPDATE_DATE = l_def_lln_rec.program_update_date,
ORG_ID = l_def_lln_rec.org_id,
TAX_AMOUNT = l_def_lln_rec.tax_amount,
ATTRIBUTE_CATEGORY = l_def_lln_rec.attribute_category,
ATTRIBUTE1 = l_def_lln_rec.attribute1,
ATTRIBUTE2 = l_def_lln_rec.attribute2,
ATTRIBUTE3 = l_def_lln_rec.attribute3,
ATTRIBUTE4 = l_def_lln_rec.attribute4,
ATTRIBUTE5 = l_def_lln_rec.attribute5,
ATTRIBUTE6 = l_def_lln_rec.attribute6,
ATTRIBUTE7 = l_def_lln_rec.attribute7,
ATTRIBUTE8 = l_def_lln_rec.attribute8,
ATTRIBUTE9 = l_def_lln_rec.attribute9,
ATTRIBUTE10 = l_def_lln_rec.attribute10,
ATTRIBUTE11 = l_def_lln_rec.attribute11,
ATTRIBUTE12 = l_def_lln_rec.attribute12,
ATTRIBUTE13 = l_def_lln_rec.attribute13,
ATTRIBUTE14 = l_def_lln_rec.attribute14,
ATTRIBUTE15 = l_def_lln_rec.attribute15,
CREATED_BY = l_def_lln_rec.created_by,
CREATION_DATE = l_def_lln_rec.creation_date,
LAST_UPDATED_BY = l_def_lln_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_lln_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_lln_rec.last_update_login
WHERE ID = l_def_lln_rec.id;
END update_row;
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_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type,
x_okl_cnsld_ar_lines_tl_rec OUT NOCOPY okl_cnsld_ar_lines_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
IF (x_okl_cnsld_ar_lines_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_okl_cnsld_ar_lines_tl_rec.last_updated_by := l_okl_cnsld_ar_lines_tl_rec.last_updated_by;
IF (x_okl_cnsld_ar_lines_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_okl_cnsld_ar_lines_tl_rec.last_update_date := l_okl_cnsld_ar_lines_tl_rec.last_update_date;
IF (x_okl_cnsld_ar_lines_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_okl_cnsld_ar_lines_tl_rec.last_update_login := l_okl_cnsld_ar_lines_tl_rec.last_update_login;
UPDATE OKL_CNSLD_AR_LINES_TL
SET CREATED_BY = ldefoklcnsldarlinestlrec.created_by,
CREATION_DATE = ldefoklcnsldarlinestlrec.creation_date,
LAST_UPDATED_BY = ldefoklcnsldarlinestlrec.last_updated_by,
LAST_UPDATE_DATE = ldefoklcnsldarlinestlrec.last_update_date,
LAST_UPDATE_LOGIN = ldefoklcnsldarlinestlrec.last_update_login
WHERE ID = ldefoklcnsldarlinestlrec.id
--AND SOURCE_LANG = USERENV('LANG');
UPDATE OKL_CNSLD_AR_LINES_TL
SET SFWT_FLAG = 'Y'
WHERE ID = ldefoklcnsldarlinestlrec.id
AND SOURCE_LANG <> USERENV('LANG');
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_llnv_rec IN llnv_rec_type,
x_llnv_rec OUT NOCOPY llnv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_llnv_rec.LAST_UPDATE_DATE := SYSDATE;
l_llnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_llnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_llnv_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_llnv_rec.program_update_date := l_llnv_rec.program_update_date;
IF (x_llnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_llnv_rec.last_updated_by := l_llnv_rec.last_updated_by;
IF (x_llnv_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_llnv_rec.last_update_date := l_llnv_rec.last_update_date;
IF (x_llnv_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_llnv_rec.last_update_login := l_llnv_rec.last_update_login;
SELECT
NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
x_llnv_rec.request_id),
NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
x_llnv_rec.program_application_id),
NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
x_llnv_rec.program_id),
DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
NULL,x_llnv_rec.program_update_date,SYSDATE)
INTO
x_llnv_rec.request_id,
x_llnv_rec.program_application_id,
x_llnv_rec.program_id,
x_llnv_rec.program_update_date
FROM dual;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_okl_cnsld_ar_lines_tl_rec,
lx_okl_cnsld_ar_lines_tl_rec
);
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lln_rec,
lx_lln_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_llnv_tbl IN llnv_tbl_type,
x_llnv_tbl OUT NOCOPY llnv_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_llnv_rec => p_llnv_tbl(i),
x_llnv_rec => x_llnv_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_lln_rec IN lln_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
DELETE FROM OKL_CNSLD_AR_LINES_B
WHERE ID = l_lln_rec.id;
END delete_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_okl_cnsld_ar_lines_tl_rec IN okl_cnsld_ar_lines_tl_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
DELETE FROM OKL_CNSLD_AR_LINES_TL
WHERE ID = l_okl_cnsld_ar_lines_tl_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_llnv_rec IN llnv_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_okl_cnsld_ar_lines_tl_rec
);
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_lln_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_llnv_tbl IN llnv_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_llnv_rec => p_llnv_tbl(i));
END delete_row;