[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_BANK_COLLECTION_ID NUMBER,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_CREATED_BY NUMBER,
X_CREATION_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_INVOICE_ID NUMBER DEFAULT NULL,
X_PAYMENT_NUM NUMBER DEFAULT NULL,
X_HOLD_FLAG VARCHAR2 DEFAULT NULL,
X_ISSUE_DATE DATE DEFAULT NULL,
X_DOCUMENT_NUMBER VARCHAR2 DEFAULT NULL,
X_DRAWER_GUARANTOR VARCHAR2 DEFAULT NULL,
X_INSTRUCTION_1 VARCHAR2 DEFAULT NULL,
X_INSTRUCTION_2 VARCHAR2 DEFAULT NULL,
X_CURRENCY_CODE VARCHAR2,
X_DUE_DATE DATE DEFAULT NULL,
X_AMOUNT NUMBER DEFAULT NULL,
X_DISCOUNT_DATE DATE DEFAULT NULL,
X_DISCOUNT_AMOUNT NUMBER DEFAULT NULL,
X_ARREARS_DATE DATE DEFAULT NULL,
X_ARREARS_CODE VARCHAR2 DEFAULT NULL,
X_ARREARS_INTEREST NUMBER DEFAULT NULL,
X_ABATE_AMOUNT NUMBER DEFAULT NULL,
X_PAID_AMOUNT NUMBER DEFAULT NULL,
X_PAYMENT_LOCATION VARCHAR2 DEFAULT NULL,
X_DOCUMENT_TYPE VARCHAR2 DEFAULT NULL,
X_ACCEPTANCE VARCHAR2 DEFAULT NULL,
X_PROCESSING_DATE DATE DEFAULT NULL,
X_BANK_USE VARCHAR2 DEFAULT NULL,
X_PORTFOLIO VARCHAR2 DEFAULT NULL,
X_PENALTY_FEE_AMOUNT NUMBER DEFAULT NULL,
X_PENALTY_FEE_DATE DATE DEFAULT NULL,
X_OTHER_ACCRETIONS NUMBER DEFAULT NULL,
X_OUR_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_CODE VARCHAR2 DEFAULT NULL,
X_VENDOR_SITE_ID NUMBER,
X_FILE_CONTROL VARCHAR2 DEFAULT NULL,
X_STATUS_LOOKUP_CODE VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE21 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE22 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE23 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE24 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE25 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE26 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE27 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE28 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE29 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE30 VARCHAR2 DEFAULT NULL,
X_ENTRY_SEQUENTIAL_NUMBER NUMBER DEFAULT NULL,
X_SET_OF_BOOKS_ID NUMBER,
X_VENDOR_ID NUMBER,
X_BANK_BRANCH_ID NUMBER,
X_BANK_PARTY_ID NUMBER,
X_BRANCH_PARTY_ID NUMBER,
X_ORG_ID NUMBER DEFAULT NULL,
X_calling_sequence VARCHAR2,
X_BARCODE VARCHAR2 DEFAULT NULL,
X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
) IS
CURSOR C IS SELECT rowid FROM JL_BR_AP_COLLECTION_DOCS
WHERE bank_collection_id = X_bank_collection_id;
current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into JL_BR_AP_COLLECTION_DOCS';
INSERT INTO JL_BR_AP_COLLECTION_DOCS
(
BANK_COLLECTION_ID,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
INVOICE_ID,
PAYMENT_NUM,
HOLD_FLAG,
ISSUE_DATE,
DOCUMENT_NUMBER,
DRAWER_GUARANTOR,
INSTRUCTION_1,
INSTRUCTION_2,
CURRENCY_CODE,
DUE_DATE,
AMOUNT,
DISCOUNT_DATE,
DISCOUNT_AMOUNT,
ARREARS_DATE,
ARREARS_CODE,
ARREARS_INTEREST,
ABATE_AMOUNT,
PAID_AMOUNT,
PAYMENT_LOCATION,
DOCUMENT_TYPE,
ACCEPTANCE,
PROCESSING_DATE,
BANK_USE,
PORTFOLIO,
PENALTY_FEE_AMOUNT,
PENALTY_FEE_DATE,
OTHER_ACCRETIONS,
OUR_NUMBER,
TRANSFEROR_CODE,
VENDOR_SITE_ID,
FILE_CONTROL,
STATUS_LOOKUP_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
ENTRY_SEQUENTIAL_NUMBER,
SET_OF_BOOKS_ID,
VENDOR_ID,
BANK_BRANCH_ID,
BANK_PARTY_ID,
BRANCH_PARTY_ID,
ORG_ID,
BARCODE,
ELECTRONIC_FORMAT_FLAG
)
VALUES (
X_BANK_COLLECTION_ID,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATE_LOGIN,
X_INVOICE_ID,
X_PAYMENT_NUM,
X_HOLD_FLAG,
X_ISSUE_DATE,
X_DOCUMENT_NUMBER,
X_DRAWER_GUARANTOR,
X_INSTRUCTION_1,
X_INSTRUCTION_2,
X_CURRENCY_CODE,
X_DUE_DATE,
X_AMOUNT,
X_DISCOUNT_DATE,
X_DISCOUNT_AMOUNT,
X_ARREARS_DATE,
X_ARREARS_CODE,
X_ARREARS_INTEREST,
X_ABATE_AMOUNT,
X_PAID_AMOUNT,
X_PAYMENT_LOCATION,
X_DOCUMENT_TYPE,
X_ACCEPTANCE,
X_PROCESSING_DATE,
X_BANK_USE,
X_PORTFOLIO,
X_PENALTY_FEE_AMOUNT,
X_PENALTY_FEE_DATE,
X_OTHER_ACCRETIONS,
X_OUR_NUMBER,
X_TRANSFEROR_CODE,
X_VENDOR_SITE_ID,
X_FILE_CONTROL,
X_STATUS_LOOKUP_CODE,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_ATTRIBUTE16,
X_ATTRIBUTE17,
X_ATTRIBUTE18,
X_ATTRIBUTE19,
X_ATTRIBUTE20,
X_ATTRIBUTE21,
X_ATTRIBUTE22,
X_ATTRIBUTE23,
X_ATTRIBUTE24,
X_ATTRIBUTE25,
X_ATTRIBUTE26,
X_ATTRIBUTE27,
X_ATTRIBUTE28,
X_ATTRIBUTE29,
X_ATTRIBUTE30,
X_ENTRY_SEQUENTIAL_NUMBER,
X_SET_OF_BOOKS_ID,
X_VENDOR_ID,
X_BANK_BRANCH_ID,
X_BANK_PARTY_ID,
X_BRANCH_PARTY_ID,
X_ORG_ID,
X_BARCODE,
X_ELECTRONIC_FORMAT_FLAG
);
END Insert_Row;
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_CREATED_BY NUMBER,
X_CREATION_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_INVOICE_ID NUMBER DEFAULT NULL,
X_PAYMENT_NUM NUMBER DEFAULT NULL,
X_HOLD_FLAG VARCHAR2 DEFAULT NULL,
X_ISSUE_DATE DATE DEFAULT NULL,
X_DOCUMENT_NUMBER VARCHAR2 DEFAULT NULL,
X_DRAWER_GUARANTOR VARCHAR2 DEFAULT NULL,
X_INSTRUCTION_1 VARCHAR2 DEFAULT NULL,
X_INSTRUCTION_2 VARCHAR2 DEFAULT NULL,
X_CURRENCY_CODE VARCHAR2,
X_DUE_DATE DATE DEFAULT NULL,
X_AMOUNT NUMBER DEFAULT NULL,
X_DISCOUNT_DATE DATE DEFAULT NULL,
X_DISCOUNT_AMOUNT NUMBER DEFAULT NULL,
X_ARREARS_DATE DATE DEFAULT NULL,
X_ARREARS_CODE VARCHAR2 DEFAULT NULL,
X_ARREARS_INTEREST NUMBER DEFAULT NULL,
X_ABATE_AMOUNT NUMBER DEFAULT NULL,
X_PAID_AMOUNT NUMBER DEFAULT NULL,
X_PAYMENT_LOCATION VARCHAR2 DEFAULT NULL,
X_DOCUMENT_TYPE VARCHAR2 DEFAULT NULL,
X_ACCEPTANCE VARCHAR2 DEFAULT NULL,
X_PROCESSING_DATE DATE DEFAULT NULL,
X_BANK_USE VARCHAR2 DEFAULT NULL,
X_PORTFOLIO VARCHAR2 DEFAULT NULL,
X_PENALTY_FEE_AMOUNT NUMBER DEFAULT NULL,
X_PENALTY_FEE_DATE DATE DEFAULT NULL,
X_OTHER_ACCRETIONS NUMBER DEFAULT NULL,
X_OUR_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_CODE VARCHAR2 DEFAULT NULL,
X_VENDOR_SITE_ID NUMBER,
X_FILE_CONTROL VARCHAR2 DEFAULT NULL,
X_STATUS_LOOKUP_CODE VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE21 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE22 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE23 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE24 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE25 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE26 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE27 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE28 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE29 VARCHAR2 DEFAULT NULL,
X_ATTRIBUTE30 VARCHAR2 DEFAULT NULL,
X_ENTRY_SEQUENTIAL_NUMBER NUMBER DEFAULT NULL,
X_SET_OF_BOOKS_ID NUMBER,
X_VENDOR_ID NUMBER,
X_BANK_BRANCH_ID NUMBER,
X_BANK_PARTY_ID NUMBER,
X_BRANCH_PARTY_ID NUMBER,
X_calling_sequence VARCHAR2,
X_BARCODE VARCHAR2 DEFAULT NULL,
X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
) IS
CURSOR C IS
SELECT *
FROM JL_BR_AP_COLLECTION_DOCS
WHERE rowid = X_Rowid
FOR UPDATE of bank_collection_id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');