[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF pv_action = jai_constants.INSERTING THEN --1
INSERT INTO JAI_RCV_SUBLED_ENTRIES(SUBLED_ENTRY_ID,LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
RCV_TRANSACTION_ID,
CURRENCY_CODE,
ACTUAL_FLAG,
JE_SOURCE_NAME,
JE_CATEGORY_NAME,
SET_OF_BOOKS_ID,
ACCOUNTING_DATE,
CODE_COMBINATION_ID,
ACCOUNTED_DR,
ACCOUNTED_CR,
ENCUMBRANCE_TYPE_ID,
ENTERED_DR,
ENTERED_CR,
BUDGET_VERSION_ID,
CURRENCY_CONVERSION_DATE,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
TRANSACTION_DATE,
PERIOD_NAME,
CHART_OF_ACCOUNTS_ID,
FUNCTIONAL_CURRENCY_CODE,
DATE_CREATED_IN_GL,
JE_BATCH_NAME,
JE_BATCH_DESCRIPTION,
JE_HEADER_NAME,
JE_LINE_DESCRIPTION,
REVERSE_JOURNAL_FLAG,
REVERSAL_PERIOD_NAME,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
--SUBLEDGER_DOC_SEQUENCE_ID,
--SUBLEDGER_DOC_SEQUENCE_VALUE,
USSGL_TRANSACTION_CODE,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
SOURCE_DOC_QUANTITY,
FROM_TYPE
)
VALUES( JAI_RCV_SUBLED_ENTRIES_S.nextval,
pr_new.LAST_UPDATE_DATE,
pr_new.LAST_UPDATED_BY,
pr_new.CREATION_DATE,
pr_new.CREATED_BY,
pr_new.LAST_UPDATE_LOGIN,
pr_new.RCV_TRANSACTION_ID,
pr_new.CURRENCY_CODE,
pr_new.ACTUAL_FLAG,
pr_new.JE_SOURCE_NAME,
pr_new.JE_CATEGORY_NAME,
pr_new.SET_OF_BOOKS_ID,
pr_new.ACCOUNTING_DATE,
pr_new.CODE_COMBINATION_ID,
pr_new.ACCOUNTED_DR,
pr_new.ACCOUNTED_CR,
pr_new.ENCUMBRANCE_TYPE_ID,
pr_new.ENTERED_DR,
pr_new.ENTERED_CR,
pr_new.BUDGET_VERSION_ID,
pr_new.CURRENCY_CONVERSION_DATE,
pr_new.USER_CURRENCY_CONVERSION_TYPE,
pr_new.CURRENCY_CONVERSION_RATE,
pr_new.TRANSACTION_DATE,
pr_new.PERIOD_NAME,
pr_new.CHART_OF_ACCOUNTS_ID,
pr_new.FUNCTIONAL_CURRENCY_CODE,
pr_new.DATE_CREATED_IN_GL,
pr_new.JE_BATCH_NAME,
pr_new.JE_BATCH_DESCRIPTION,
pr_new.JE_HEADER_NAME,
pr_new.JE_LINE_DESCRIPTION,
pr_new.REVERSE_JOURNAL_FLAG,
pr_new.REVERSAL_PERIOD_NAME,
pr_new.ATTRIBUTE_CATEGORY,
pr_new.ATTRIBUTE1,
pr_new.ATTRIBUTE2,
pr_new.ATTRIBUTE3,
pr_new.ATTRIBUTE4,
pr_new.ATTRIBUTE5,
pr_new.ATTRIBUTE6,
pr_new.ATTRIBUTE7,
pr_new.ATTRIBUTE8,
pr_new.ATTRIBUTE9,
pr_new.ATTRIBUTE10,
pr_new.ATTRIBUTE11,
pr_new.ATTRIBUTE12,
pr_new.ATTRIBUTE13,
pr_new.ATTRIBUTE14,
pr_new.ATTRIBUTE15,
pr_new.REQUEST_ID,
pr_new.PROGRAM_APPLICATION_ID,
pr_new.PROGRAM_ID,
pr_new.PROGRAM_UPDATE_DATE,
--pr_new.SUBLEDGER_DOC_SEQUENCE_ID,
--pr_new.SUBLEDGER_DOC_SEQUENCE_VALUE,
pr_new.USSGL_TRANSACTION_CODE,
pr_new.REFERENCE1,
pr_new.REFERENCE2,
pr_new.REFERENCE3,
pr_new.REFERENCE4,
pr_new.REFERENCE5,
pr_new.REFERENCE6,
pr_new.REFERENCE7,
pr_new.REFERENCE8,
pr_new.REFERENCE9,
pr_new.REFERENCE10,
pr_new.SOURCE_DOC_QUANTITY,
'A'
);
UPDATE JAI_RCV_SUBLED_ENTRIES
SET LAST_UPDATE_DATE = pr_new.LAST_UPDATE_DATE,
LAST_UPDATED_BY = pr_new.LAST_UPDATED_BY,
CREATION_DATE = pr_new.CREATION_DATE,
CREATED_BY = pr_new.CREATED_BY,
LAST_UPDATE_LOGIN = pr_new.LAST_UPDATE_LOGIN,
RCV_TRANSACTION_ID = pr_new.RCV_TRANSACTION_ID,
CURRENCY_CODE = pr_new.CURRENCY_CODE,
ACTUAL_FLAG = pr_new.ACTUAL_FLAG,
JE_SOURCE_NAME = pr_new.JE_SOURCE_NAME,
JE_CATEGORY_NAME = pr_new.JE_CATEGORY_NAME,
SET_OF_BOOKS_ID = pr_new.SET_OF_BOOKS_ID,
ACCOUNTING_DATE = pr_new.ACCOUNTING_DATE,
CODE_COMBINATION_ID = pr_new.CODE_COMBINATION_ID,
ACCOUNTED_DR = pr_new.ACCOUNTED_DR,
ACCOUNTED_CR = pr_new.ACCOUNTED_CR,
ENCUMBRANCE_TYPE_ID = pr_new.ENCUMBRANCE_TYPE_ID,
ENTERED_DR = pr_new.ENTERED_DR,
ENTERED_CR = pr_new.ENTERED_CR,
BUDGET_VERSION_ID = pr_new.BUDGET_VERSION_ID,
CURRENCY_CONVERSION_DATE = pr_new.CURRENCY_CONVERSION_DATE,
USER_CURRENCY_CONVERSION_TYPE = pr_new.USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE = pr_new.CURRENCY_CONVERSION_RATE,
TRANSACTION_DATE = pr_new.TRANSACTION_DATE,
PERIOD_NAME = pr_new.PERIOD_NAME,
CHART_OF_ACCOUNTS_ID = pr_new.CHART_OF_ACCOUNTS_ID,
FUNCTIONAL_CURRENCY_CODE = pr_new.FUNCTIONAL_CURRENCY_CODE,
DATE_CREATED_IN_GL = pr_new.DATE_CREATED_IN_GL,
JE_BATCH_NAME = pr_new.JE_BATCH_NAME,
JE_BATCH_DESCRIPTION = pr_new.JE_BATCH_DESCRIPTION,
JE_HEADER_NAME = pr_new.JE_HEADER_NAME,
JE_LINE_DESCRIPTION = pr_new.JE_LINE_DESCRIPTION,
REVERSE_JOURNAL_FLAG = pr_new.REVERSE_JOURNAL_FLAG,
REVERSAL_PERIOD_NAME = pr_new.REVERSAL_PERIOD_NAME,
ATTRIBUTE_CATEGORY = pr_new.ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = pr_new.ATTRIBUTE1,
ATTRIBUTE2 = pr_new.ATTRIBUTE2,
ATTRIBUTE3 = pr_new.ATTRIBUTE3,
ATTRIBUTE4 = pr_new.ATTRIBUTE4,
ATTRIBUTE5 = pr_new.ATTRIBUTE5,
ATTRIBUTE6 = pr_new.ATTRIBUTE6,
ATTRIBUTE7 = pr_new.ATTRIBUTE7,
ATTRIBUTE8 = pr_new.ATTRIBUTE8,
ATTRIBUTE9 = pr_new.ATTRIBUTE9,
ATTRIBUTE10 = pr_new.ATTRIBUTE10,
ATTRIBUTE11 = pr_new.ATTRIBUTE11,
ATTRIBUTE12 = pr_new.ATTRIBUTE12,
ATTRIBUTE13 = pr_new.ATTRIBUTE13,
ATTRIBUTE14 = pr_new.ATTRIBUTE14,
ATTRIBUTE15 = pr_new.ATTRIBUTE15,
REQUEST_ID = pr_new.REQUEST_ID,
PROGRAM_APPLICATION_ID = pr_new.PROGRAM_APPLICATION_ID,
PROGRAM_ID = pr_new.PROGRAM_ID,
PROGRAM_UPDATE_DATE = pr_new.PROGRAM_UPDATE_DATE,
--SUBLEDGER_DOC_SEQUENCE_ID = pr_new.SUBLEDGER_DOC_SEQUENCE_ID,
--SUBLEDGER_DOC_SEQUENCE_VALUE = pr_new.SUBLEDGER_DOC_SEQUENCE_VALUE,
USSGL_TRANSACTION_CODE = pr_new.USSGL_TRANSACTION_CODE,
REFERENCE1 = pr_new.REFERENCE1,
REFERENCE2 = pr_new.REFERENCE2,
REFERENCE3 = pr_new.REFERENCE3,
REFERENCE4 = pr_new.REFERENCE4,
REFERENCE5 = pr_new.REFERENCE5,
REFERENCE6 = pr_new.REFERENCE6,
REFERENCE7 = pr_new.REFERENCE7,
REFERENCE8 = pr_new.REFERENCE8,
REFERENCE9 = pr_new.REFERENCE9,
REFERENCE10 = pr_new.REFERENCE10,
SOURCE_DOC_QUANTITY = pr_new.SOURCE_DOC_QUANTITY
WHERE from_type = 'A'
AND rcv_transaction_id = pr_old.rcv_transaction_id
AND ((entered_dr IS NULL AND entered_cr = pr_old.entered_cr) OR
(entered_cr IS NULL AND entered_dr = pr_old.entered_dr));