[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ae_line_id,
CODE_COMBINATION_ID,
AE_HEADER_ID,
CURRENCY_CONVERSION_TYPE,
ORG_ID,
AE_LINE_NUMBER,
AE_LINE_TYPE_CODE,
SOURCE_TABLE,
SOURCE_ID,
OBJECT_VERSION_NUMBER,
CURRENCY_CODE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
DESCRIPTION,
THIRD_PARTY_ID,
THIRD_PARTY_SUB_ID,
STAT_AMOUNT,
USSGL_TRANSACTION_CODE,
SUBLEDGER_DOC_SEQUENCE_ID,
ACCOUNTING_ERROR_CODE,
GL_TRANSFER_ERROR_CODE,
GL_SL_LINK_ID,
TAXABLE_ENTERED_DR,
TAXABLE_ENTERED_CR,
TAXABLE_ACCOUNTED_DR,
TAXABLE_ACCOUNTED_CR,
APPLIED_FROM_TRX_HDR_TABLE,
APPLIED_FROM_TRX_HDR_ID,
APPLIED_TO_TRX_HDR_TABLE,
APPLIED_TO_TRX_HDR_ID,
TAX_LINK_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ACCOUNT_OVERLAY_SOURCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
TAX_CODE_ID
FROM Okl_Ae_Lines
WHERE okl_ae_lines.ae_line_id = p_ae_line_id;
l_ael_rec.PROGRAM_UPDATE_DATE,
l_ael_rec.REQUEST_ID,
l_ael_rec.CREATED_BY,
l_ael_rec.CREATION_DATE,
l_ael_rec.LAST_UPDATED_BY,
l_ael_rec.LAST_UPDATE_DATE,
l_ael_rec.LAST_UPDATE_LOGIN,
l_ael_rec.ACCOUNT_OVERLAY_SOURCE_ID,
l_ael_rec.SUBLEDGER_DOC_SEQUENCE_VALUE,
l_ael_rec.TAX_CODE_ID;
SELECT
ae_line_id,
OBJECT_VERSION_NUMBER,
AE_HEADER_ID,
CURRENCY_CONVERSION_TYPE,
CODE_COMBINATION_ID,
ORG_ID,
AE_LINE_NUMBER,
AE_LINE_TYPE_CODE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR,
SOURCE_TABLE,
SOURCE_ID,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
DESCRIPTION,
THIRD_PARTY_ID,
THIRD_PARTY_SUB_ID,
STAT_AMOUNT,
USSGL_TRANSACTION_CODE,
SUBLEDGER_DOC_SEQUENCE_ID,
ACCOUNTING_ERROR_CODE,
GL_TRANSFER_ERROR_CODE,
GL_SL_LINK_ID,
TAXABLE_ENTERED_DR,
TAXABLE_ENTERED_CR,
TAXABLE_ACCOUNTED_DR,
TAXABLE_ACCOUNTED_CR,
APPLIED_FROM_TRX_HDR_TABLE,
APPLIED_FROM_TRX_HDR_ID,
APPLIED_TO_TRX_HDR_TABLE,
APPLIED_TO_TRX_HDR_ID,
TAX_LINK_ID,
CURRENCY_CODE,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_UPDATE_DATE,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ACCOUNT_OVERLAY_SOURCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
TAX_CODE_ID
FROM OKL_AE_LINES
WHERE OKL_AE_LINES.ae_line_id = p_ae_line_id;
l_aelv_rec.PROGRAM_UPDATE_DATE,
l_aelv_rec.REQUEST_ID,
l_aelv_rec.CREATED_BY,
l_aelv_rec.CREATION_DATE,
l_aelv_rec.LAST_UPDATED_BY,
l_aelv_rec.LAST_UPDATE_DATE,
l_aelv_rec.LAST_UPDATE_LOGIN,
l_aelv_rec.ACCOUNT_OVERLAY_SOURCE_ID,
l_aelv_rec.SUBLEDGER_DOC_SEQUENCE_VALUE,
l_aelv_rec.TAX_CODE_ID;
IF (l_aelv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
l_aelv_rec.program_update_date := NULL;
IF (l_aelv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
l_aelv_rec.last_updated_by := NULL;
IF (l_aelv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
l_aelv_rec.last_update_date := NULL;
IF (l_aelv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
l_aelv_rec.last_update_login := NULL;
SELECT '1'
FROM OKL_AE_HEADERS
WHERE OKL_AE_HEADERS.ae_header_id = p_ae_header_id;
SELECT '1'
FROM OKL_AE_LINES
WHERE AE_HEADER_ID = p_aelv_rec.AE_HEADER_ID
AND AE_LINE_NUMBER = p_aelv_rec.AE_LINE_NUMBER
AND ae_line_id <> p_aelv_rec.ae_line_id;
even when ccid is invalid. In this case, we update the error flag to say that
'ACCOUNT INVALID' but neverthless, we allow an invalid CCID to be present in
the table. Therefore, this check needs to be removed from this place
Validate_Code_Combination_Id(p_aelv_rec, x_return_status);
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 DEFAULT Okc_Api.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_ael_rec IN ael_rec_type,
x_ael_rec OUT NOCOPY ael_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_insert_row';
INSERT INTO OKL_AE_LINES(
ae_line_id,
code_combination_id,
AE_HEADER_ID,
currency_conversion_type,
org_id,
AE_LINE_NUMBER,
AE_LINE_TYPE_CODE,
source_table,
source_id,
object_version_number,
currency_code,
currency_conversion_date,
currency_conversion_rate,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR,
reference1,
reference2,
reference3,
reference4,
reference5,
reference6,
reference7,
reference8,
reference9,
reference10,
description,
third_party_id,
third_party_sub_id,
STAT_AMOUNT,
ussgl_transaction_code,
subledger_doc_sequence_id,
accounting_error_code,
gl_transfer_error_code,
GL_SL_LINK_ID,
taxable_ENTERED_DR,
taxable_ENTERED_CR,
taxable_ACCOUNTED_DR,
taxable_ACCOUNTED_CR,
applied_from_trx_hdr_table,
applied_from_trx_hdr_id,
applied_to_trx_hdr_table,
applied_to_trx_hdr_id,
tax_link_id,
program_id,
program_application_id,
program_update_date,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
LAST_UPDATE_LOGIN,
ACCOUNT_OVERLAY_SOURCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
TAX_CODE_ID)
VALUES (
l_ael_rec.ae_line_id,
l_ael_rec.code_combination_id,
l_ael_rec.AE_HEADER_ID,
l_ael_rec.currency_conversion_type,
l_ael_rec.org_id,
l_ael_rec.AE_LINE_NUMBER,
l_ael_rec.AE_LINE_TYPE_CODE,
l_ael_rec.source_table,
l_ael_rec.source_id,
l_ael_rec.object_version_number,
l_ael_rec.currency_code,
l_ael_rec.currency_conversion_date,
l_ael_rec.currency_conversion_rate,
l_ael_rec.ENTERED_DR,
l_ael_rec.ENTERED_CR,
l_ael_rec.ACCOUNTED_DR,
l_ael_rec.ACCOUNTED_CR,
l_ael_rec.reference1,
l_ael_rec.reference2,
l_ael_rec.reference3,
l_ael_rec.reference4,
l_ael_rec.reference5,
l_ael_rec.reference6,
l_ael_rec.reference7,
l_ael_rec.reference8,
l_ael_rec.reference9,
l_ael_rec.reference10,
l_ael_rec.description,
l_ael_rec.third_party_id,
l_ael_rec.third_party_sub_id,
l_ael_rec.STAT_AMOUNT,
l_ael_rec.ussgl_transaction_code,
l_ael_rec.subledger_doc_sequence_id,
l_ael_rec.accounting_error_code,
l_ael_rec.gl_transfer_error_code,
l_ael_rec.GL_SL_LINK_ID,
l_ael_rec.taxable_ENTERED_DR,
l_ael_rec.taxable_ENTERED_CR,
l_ael_rec.taxable_ACCOUNTED_DR,
l_ael_rec.taxable_ACCOUNTED_CR,
l_ael_rec.applied_from_trx_hdr_table,
l_ael_rec.applied_from_trx_hdr_id,
l_ael_rec.applied_to_trx_hdr_table,
l_ael_rec.applied_to_trx_hdr_id,
l_ael_rec.tax_link_id,
l_ael_rec.PROGRAM_ID,
l_ael_rec.program_application_id,
l_ael_rec.program_update_date,
l_ael_rec.request_id,
l_ael_rec.created_by,
l_ael_rec.creation_date,
l_ael_rec.last_updated_by,
l_ael_rec.last_update_date,
l_ael_rec.LAST_UPDATE_LOGIN,
l_ael_rec.ACCOUNT_OVERLAY_SOURCE_ID,
l_ael_rec.SUBLEDGER_DOC_SEQUENCE_VALUE,
l_ael_rec.TAX_CODE_ID);
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_aelv_rec IN aelv_rec_type,
x_aelv_rec OUT NOCOPY aelv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_aelv_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.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)
INTO x_aelv_rec.REQUEST_ID
,x_aelv_rec.PROGRAM_APPLICATION_ID
,x_aelv_rec.PROGRAM_ID
,x_aelv_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_ael_rec,
lx_ael_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_aelv_tbl IN aelv_tbl_type,
x_aelv_tbl OUT NOCOPY aelv_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_aelv_rec => p_aelv_tbl(i),
x_aelv_rec => x_aelv_tbl(i));
END insert_row;
PROCEDURE insert_row_perf(
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_aelv_tbl IN aelv_tbl_type,
x_aelv_tbl OUT NOCOPY aelv_tbl_type) IS
l_tabsize NUMBER := p_aelv_tbl.COUNT;
program_update_date_tbl program_update_date_typ;
last_updated_by_tbl last_updated_by_typ;
last_update_date_tbl last_update_date_typ;
last_update_login_tbl last_update_login_typ;
program_update_date_tbl(j) := p_aelv_tbl(i).program_update_date;
last_updated_by_tbl(j) := p_aelv_tbl(i).last_updated_by;
last_update_date_tbl(j) := p_aelv_tbl(i).last_update_date;
last_update_login_tbl(j) := p_aelv_tbl(i).last_update_login;
INSERT INTO OKL_AE_LINES(
ae_line_id,
code_combination_id,
ae_header_id,
currency_conversion_type,
org_id,
ae_line_number,
ae_line_type_code,
source_table,
source_id,
object_version_number,
currency_code,
currency_conversion_date,
currency_conversion_rate,
entered_dr,
entered_cr,
accounted_dr,
accounted_cr,
reference1,
reference2,
reference3,
reference4,
reference5,
reference6,
reference7,
reference8,
reference9,
reference10,
description,
third_party_id,
third_party_sub_id,
stat_amount,
ussgl_transaction_code,
subledger_doc_sequence_id,
accounting_error_code,
gl_transfer_error_code,
gl_sl_link_id,
taxable_entered_dr,
taxable_entered_cr,
taxable_accounted_dr,
taxable_accounted_cr,
applied_from_trx_hdr_table,
applied_from_trx_hdr_id,
applied_to_trx_hdr_table,
applied_to_trx_hdr_id,
tax_link_id,
program_id,
program_application_id,
program_update_date,
request_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
account_overlay_source_id,
subledger_doc_sequence_value,
tax_code_id)
VALUES (
ae_line_id_tbl(i),
code_combination_id_tbl(i),
ae_header_id_tbl(i),
currency_conversion_type_tbl(i),
org_id_tbl(i),
ae_line_number_tbl(i),
ae_line_type_code_tbl(i),
source_table_tbl(i),
source_id_tbl(i),
object_version_number_tbl(i),
currency_code_tbl(i),
currency_conversion_date_tbl(i),
currency_conversion_rate_tbl(i),
entered_dr_tbl(i),
entered_cr_tbl(i),
accounted_dr_tbl(i),
accounted_cr_tbl(i),
reference1_tbl(i),
reference2_tbl(i),
reference3_tbl(i),
reference4_tbl(i),
reference5_tbl(i),
reference6_tbl(i),
reference7_tbl(i),
reference8_tbl(i),
reference9_tbl(i),
reference10_tbl(i),
description_tbl(i),
third_party_id_tbl(i),
third_party_sub_id_tbl(i),
stat_amount_tbl(i),
ussgl_transaction_code_tbl(i),
subledger_doc_sequence_id_tbl(i),
accounting_error_code_tbl(i),
gl_transfer_error_code_tbl(i),
gl_sl_link_id_tbl(i),
taxable_entered_dr_tbl(i),
taxable_entered_cr_tbl(i),
taxable_accounted_dr_tbl(i),
taxable_accounted_cr_tbl(i),
applied_from_trx_hdr_tab_tbl(i),
applied_from_trx_hdr_id_tbl(i),
applied_to_trx_hdr_table_tbl(i),
applied_to_trx_hdr_id_tbl(i),
tax_link_id_tbl(i),
program_id_tbl(i),
program_application_id_tbl(i),
program_update_date_tbl(i),
request_id_tbl(i),
created_by_tbl(i),
creation_date_tbl(i),
last_updated_by_tbl(i),
last_update_date_tbl(i),
last_update_login_tbl(i),
account_overlay_source_id_tbl(i),
subledger_doc_seq_value_tbl(i),
tax_code_id_tbl(i));
END insert_row_perf;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_AE_LINES
WHERE ae_line_id = p_ael_rec.ae_line_id
AND OBJECT_VERSION_NUMBER = p_ael_rec.object_version_number
FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
SELECT OBJECT_VERSION_NUMBER
FROM OKL_AE_LINES
WHERE ae_line_id = p_ael_rec.ae_line_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_ael_rec IN ael_rec_type,
x_ael_rec OUT NOCOPY ael_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_update_row';
IF (x_ael_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_ael_rec.program_update_date := l_ael_rec.program_update_date;
IF (x_ael_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_ael_rec.last_updated_by := l_ael_rec.last_updated_by;
IF (x_ael_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_ael_rec.last_update_date := l_ael_rec.last_update_date;
IF (x_ael_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_ael_rec.last_update_login := l_ael_rec.last_update_login;
UPDATE OKL_AE_LINES
SET CODE_COMBINATION_ID = l_def_ael_rec.code_combination_id,
AE_HEADER_ID = l_def_ael_rec.AE_HEADER_ID,
CURRENCY_CONVERSION_TYPE = l_def_ael_rec.currency_conversion_type,
ORG_ID = l_def_ael_rec.org_id,
AE_LINE_NUMBER = l_def_ael_rec.AE_LINE_NUMBER,
AE_LINE_TYPE_CODE = l_def_ael_rec.AE_LINE_TYPE_CODE,
SOURCE_TABLE = l_def_ael_rec.source_table,
SOURCE_ID = l_def_ael_rec.source_id,
OBJECT_VERSION_NUMBER = l_def_ael_rec.object_version_number,
CURRENCY_CODE = l_def_ael_rec.currency_code,
CURRENCY_CONVERSION_DATE = l_def_ael_rec.currency_conversion_date,
CURRENCY_CONVERSION_RATE = l_def_ael_rec.currency_conversion_rate,
ENTERED_DR = l_def_ael_rec.ENTERED_DR,
ENTERED_CR = l_def_ael_rec.ENTERED_CR,
ACCOUNTED_DR = l_def_ael_rec.ACCOUNTED_DR,
ACCOUNTED_CR = l_def_ael_rec.ACCOUNTED_CR,
REFERENCE1 = l_def_ael_rec.reference1,
REFERENCE2 = l_def_ael_rec.reference2,
REFERENCE3 = l_def_ael_rec.reference3,
REFERENCE4 = l_def_ael_rec.reference4,
REFERENCE5 = l_def_ael_rec.reference5,
REFERENCE6 = l_def_ael_rec.reference6,
REFERENCE7 = l_def_ael_rec.reference7,
REFERENCE8 = l_def_ael_rec.reference8,
REFERENCE9 = l_def_ael_rec.reference9,
REFERENCE10 = l_def_ael_rec.reference10,
DESCRIPTION = l_def_ael_rec.description,
THIRD_PARTY_ID = l_def_ael_rec.third_party_id,
THIRD_PARTY_SUB_ID = l_def_ael_rec.third_party_sub_id,
STAT_AMOUNT = l_def_ael_rec.STAT_AMOUNT,
USSGL_TRANSACTION_CODE = l_def_ael_rec.ussgl_transaction_code,
SUBLEDGER_DOC_SEQUENCE_ID = l_def_ael_rec.subledger_doc_sequence_id,
ACCOUNTING_ERROR_CODE = l_def_ael_rec.accounting_error_code,
GL_TRANSFER_ERROR_CODE = l_def_ael_rec.gl_transfer_error_code,
GL_SL_LINK_ID = l_def_ael_rec.GL_SL_LINK_ID,
TAXABLE_ENTERED_DR = l_def_ael_rec.taxable_ENTERED_DR,
TAXABLE_ENTERED_CR = l_def_ael_rec.taxable_ENTERED_CR,
TAXABLE_ACCOUNTED_DR = l_def_ael_rec.taxable_ACCOUNTED_DR,
TAXABLE_ACCOUNTED_CR = l_def_ael_rec.taxable_ACCOUNTED_CR,
APPLIED_FROM_TRX_HDR_TABLE = l_def_ael_rec.applied_from_trx_hdr_table,
APPLIED_FROM_TRX_HDR_ID = l_def_ael_rec.applied_from_trx_hdr_id,
APPLIED_TO_TRX_HDR_TABLE = l_def_ael_rec.applied_to_trx_hdr_table,
APPLIED_TO_TRX_HDR_ID = l_def_ael_rec.applied_to_trx_hdr_id,
TAX_LINK_ID = l_def_ael_rec.tax_link_id,
PROGRAM_ID = l_def_ael_rec.program_id,
PROGRAM_APPLICATION_ID = l_def_ael_rec.program_application_id,
PROGRAM_UPDATE_DATE = l_def_ael_rec.program_update_date,
REQUEST_ID = l_def_ael_rec.request_id,
CREATED_BY = l_def_ael_rec.created_by,
CREATION_DATE = l_def_ael_rec.creation_date,
LAST_UPDATED_BY = l_def_ael_rec.last_updated_by,
LAST_UPDATE_DATE = l_def_ael_rec.last_update_date,
LAST_UPDATE_LOGIN = l_def_ael_rec.last_update_login,
ACCOUNT_OVERLAY_SOURCE_ID = l_def_ael_rec.ACCOUNT_OVERLAY_SOURCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE = l_def_ael_rec.SUBLEDGER_DOC_SEQUENCE_VALUE,
TAX_CODE_ID = l_def_ael_rec.TAX_CODE_ID
WHERE ae_line_id = l_def_ael_rec.ae_line_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_aelv_rec IN aelv_rec_type,
x_aelv_rec OUT NOCOPY aelv_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
IF (x_aelv_rec.program_update_date = Okc_Api.G_MISS_DATE)
THEN
x_aelv_rec.program_update_date := l_aelv_rec.program_update_date;
IF (x_aelv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
THEN
x_aelv_rec.last_updated_by := l_aelv_rec.last_updated_by;
IF (x_aelv_rec.last_update_date = Okc_Api.G_MISS_DATE)
THEN
x_aelv_rec.last_update_date := l_aelv_rec.last_update_date;
IF (x_aelv_rec.last_update_login = Okc_Api.G_MISS_NUM)
THEN
x_aelv_rec.last_update_login := l_aelv_rec.last_update_login;
SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
x_aelv_rec.REQUEST_ID),
NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
x_aelv_rec.PROGRAM_APPLICATION_ID),
NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
x_aelv_rec.PROGRAM_ID),
DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
NULL,x_aelv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
INTO x_aelv_rec.REQUEST_ID
,x_aelv_rec.PROGRAM_APPLICATION_ID
,x_aelv_rec.PROGRAM_ID
,x_aelv_rec.PROGRAM_UPDATE_DATE
FROM DUAL;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_ael_rec,
lx_ael_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_aelv_tbl IN aelv_tbl_type,
x_aelv_tbl OUT NOCOPY aelv_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_aelv_rec => p_aelv_tbl(i),
x_aelv_rec => x_aelv_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_ael_rec IN ael_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_delete_row';
DELETE FROM OKL_AE_LINES
WHERE ae_line_id = l_ael_rec.ae_line_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_aelv_rec IN aelv_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_ael_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_aelv_tbl IN aelv_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_aelv_rec => p_aelv_tbl(i));
END delete_row;