[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row (X_Rowid IN OUT NOCOPY VARCHAR2,
X_FILE_CONTROL VARCHAR2,
X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
X_REGISTRY_CODE VARCHAR2 DEFAULT NULL,
X_RETURN_CODE NUMBER DEFAULT NULL,
X_SERVICE_CODE NUMBER DEFAULT NULL,
X_RECORDING_DATE DATE 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_CNAB_CODE VARCHAR2 DEFAULT NULL,
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_OCCURRENCE VARCHAR2 DEFAULT NULL,
X_OCCURRENCE_DATE DATE DEFAULT NULL,
X_DRAWEE_NAME VARCHAR2 DEFAULT NULL,
X_DRAWEE_BANK_CODE VARCHAR2 DEFAULT NULL,
X_DRAWEE_BANK_NAME VARCHAR2 DEFAULT NULL,
X_DRAWEE_BRANCH_CODE VARCHAR2 DEFAULT NULL,
X_DRAWEE_ACCOUNT_NUMBER VARCHAR2 DEFAULT NULL,
X_DRAWEE_INSCRIPTION_TYPE NUMBER DEFAULT NULL,
X_DRAWEE_INSCRIPTION_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_NAME VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_BANK_CODE VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_BRANCH_CODE VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_ACCOUNT_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_INSCRIPTION_TYPE NUMBER DEFAULT NULL,
X_TRANSFEROR_INSCRIPTION_NUM VARCHAR2 DEFAULT NULL,
X_ACCOUNTING_BALANCING_SEGMENT VARCHAR2 DEFAULT NULL,
X_SET_OF_BOOKS_ID NUMBER DEFAULT NULL,
X_ERROR_CODE VARCHAR2 DEFAULT NULL,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_CREATION_DATE DATE,
X_CREATED_BY NUMBER,
X_LAST_UPDATE_LOGIN NUMBER,
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_calling_sequence VARCHAR2,
X_ORG_ID VARCHAR2 DEFAULT NULL,
X_BARCODE VARCHAR2 DEFAULT NULL,
X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
) IS
CURSOR C IS SELECT rowid FROM JL_BR_AP_INT_COLLECT_EXT
WHERE file_control = X_file_control
AND entry_sequential_number = X_entry_sequential_number;
current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.INSERT_ROW<-' ||
X_calling_sequence;
debug_info := 'Insert into JL_BR_AP_INT_COLLECT_EXT';
INSERT INTO JL_BR_AP_INT_COLLECT_EXT(
FILE_CONTROL,
ENTRY_SEQUENTIAL_NUMBER,
REGISTRY_CODE,
RETURN_CODE,
SERVICE_CODE,
RECORDING_DATE,
ISSUE_DATE,
DOCUMENT_NUMBER,
DRAWER_GUARANTOR,
INSTRUCTION_1,
INSTRUCTION_2,
CNAB_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,
OCCURRENCE,
OCCURRENCE_DATE,
DRAWEE_NAME,
DRAWEE_BANK_CODE,
DRAWEE_BANK_NAME,
DRAWEE_BRANCH_CODE,
DRAWEE_ACCOUNT_NUMBER,
DRAWEE_INSCRIPTION_TYPE,
DRAWEE_INSCRIPTION_NUMBER,
TRANSFEROR_NAME,
TRANSFEROR_BANK_CODE,
TRANSFEROR_BRANCH_CODE,
TRANSFEROR_ACCOUNT_NUMBER,
TRANSFEROR_INSCRIPTION_TYPE,
TRANSFEROR_INSCRIPTION_NUMBER,
ACCOUNTING_BALANCING_SEGMENT,
SET_OF_BOOKS_ID,
ERROR_CODE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ORG_ID,
BARCODE,
ELECTRONIC_FORMAT_FLAG
)
VALUES (
X_FILE_CONTROL,
X_ENTRY_SEQUENTIAL_NUMBER,
X_REGISTRY_CODE,
X_RETURN_CODE,
X_SERVICE_CODE,
X_RECORDING_DATE,
X_ISSUE_DATE,
X_DOCUMENT_NUMBER,
X_DRAWER_GUARANTOR,
X_INSTRUCTION_1,
X_INSTRUCTION_2,
X_CNAB_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_OCCURRENCE,
X_OCCURRENCE_DATE,
X_DRAWEE_NAME,
X_DRAWEE_BANK_CODE,
X_DRAWEE_BANK_NAME,
X_DRAWEE_BRANCH_CODE,
X_DRAWEE_ACCOUNT_NUMBER,
X_DRAWEE_INSCRIPTION_TYPE,
X_DRAWEE_INSCRIPTION_NUMBER,
X_TRANSFEROR_NAME,
X_TRANSFEROR_BANK_CODE,
X_TRANSFEROR_BRANCH_CODE,
X_TRANSFEROR_ACCOUNT_NUMBER,
X_TRANSFEROR_INSCRIPTION_TYPE,
X_TRANSFEROR_INSCRIPTION_NUM,
X_ACCOUNTING_BALANCING_SEGMENT,
X_SET_OF_BOOKS_ID,
X_ERROR_CODE,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_LOGIN,
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_ORG_ID,
X_BARCODE,
X_ELECTRONIC_FORMAT_FLAG
);
END Insert_Row;
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_CREATION_DATE DATE,
X_CREATED_BY NUMBER,
X_LAST_UPDATE_LOGIN NUMBER,
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_calling_sequence VARCHAR2,
X_BARCODE VARCHAR2 DEFAULT NULL,
X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
) IS
CURSOR C IS
SELECT *
FROM JL_BR_AP_INT_COLLECT_EXT
WHERE rowid = X_Rowid
FOR UPDATE OF file_control NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_FILE_CONTROL VARCHAR2,
X_ENTRY_SEQUENTIAL_NUMBER NUMBER,
X_REGISTRY_CODE VARCHAR2 DEFAULT NULL,
X_RETURN_CODE NUMBER DEFAULT NULL,
X_SERVICE_CODE NUMBER DEFAULT NULL,
X_RECORDING_DATE DATE 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_CNAB_CODE VARCHAR2 DEFAULT NULL,
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_OCCURRENCE VARCHAR2 DEFAULT NULL,
X_OCCURRENCE_DATE DATE DEFAULT NULL,
X_DRAWEE_NAME VARCHAR2 DEFAULT NULL,
X_DRAWEE_BANK_CODE VARCHAR2 DEFAULT NULL,
X_DRAWEE_BANK_NAME VARCHAR2 DEFAULT NULL,
X_DRAWEE_BRANCH_CODE VARCHAR2 DEFAULT NULL,
X_DRAWEE_ACCOUNT_NUMBER VARCHAR2 DEFAULT NULL,
X_DRAWEE_INSCRIPTION_TYPE NUMBER DEFAULT NULL,
X_DRAWEE_INSCRIPTION_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_NAME VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_BANK_CODE VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_BRANCH_CODE VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_ACCOUNT_NUMBER VARCHAR2 DEFAULT NULL,
X_TRANSFEROR_INSCRIPTION_TYPE NUMBER DEFAULT NULL,
X_TRANSFEROR_INSCRIPTION_NUM VARCHAR2 DEFAULT NULL,
X_ACCOUNTING_BALANCING_SEGMENT VARCHAR2 DEFAULT NULL,
X_SET_OF_BOOKS_ID NUMBER DEFAULT NULL,
X_ERROR_CODE VARCHAR2 DEFAULT NULL,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATED_BY NUMBER,
X_CREATION_DATE DATE,
X_CREATED_BY NUMBER,
X_LAST_UPDATE_LOGIN NUMBER,
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_calling_sequence VARCHAR2,
X_BARCODE VARCHAR2 DEFAULT NULL,
X_ELECTRONIC_FORMAT_FLAG VARCHAR2 DEFAULT NULL
) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.UPDATE_ROW<-' ||
X_calling_sequence;
debug_info := 'Update JL_BR_AP_INT_COLLECT_EXT';
UPDATE JL_BR_AP_INT_COLLECT_EXT
SET
FILE_CONTROL = X_FILE_CONTROL,
ENTRY_SEQUENTIAL_NUMBER = X_ENTRY_SEQUENTIAL_NUMBER,
REGISTRY_CODE = X_REGISTRY_CODE,
RETURN_CODE = X_RETURN_CODE,
SERVICE_CODE = X_SERVICE_CODE,
RECORDING_DATE = X_RECORDING_DATE,
ISSUE_DATE = X_ISSUE_DATE,
DOCUMENT_NUMBER = X_DOCUMENT_NUMBER,
DRAWER_GUARANTOR = X_DRAWER_GUARANTOR,
INSTRUCTION_1 = X_INSTRUCTION_1,
INSTRUCTION_2 = X_INSTRUCTION_2,
CNAB_CODE = X_CNAB_CODE,
DUE_DATE = X_DUE_DATE,
AMOUNT = X_AMOUNT,
DISCOUNT_DATE = X_DISCOUNT_DATE,
DISCOUNT_AMOUNT = X_DISCOUNT_AMOUNT,
ARREARS_DATE = X_ARREARS_DATE,
ARREARS_CODE = X_ARREARS_CODE,
ARREARS_INTEREST = X_ARREARS_INTEREST,
ABATE_AMOUNT = X_ABATE_AMOUNT,
PAID_AMOUNT = X_PAID_AMOUNT,
PAYMENT_LOCATION = X_PAYMENT_LOCATION,
DOCUMENT_TYPE = X_DOCUMENT_TYPE,
ACCEPTANCE = X_ACCEPTANCE,
PROCESSING_DATE = X_PROCESSING_DATE,
BANK_USE = X_BANK_USE,
PORTFOLIO = X_PORTFOLIO,
PENALTY_FEE_AMOUNT = X_PENALTY_FEE_AMOUNT,
PENALTY_FEE_DATE = X_PENALTY_FEE_DATE,
OTHER_ACCRETIONS = X_OTHER_ACCRETIONS,
OUR_NUMBER = X_OUR_NUMBER,
TRANSFEROR_CODE = X_TRANSFEROR_CODE,
OCCURRENCE = X_OCCURRENCE,
OCCURRENCE_DATE = X_OCCURRENCE_DATE,
DRAWEE_NAME = X_DRAWEE_NAME,
DRAWEE_BANK_CODE = X_DRAWEE_BANK_CODE,
DRAWEE_BANK_NAME = X_DRAWEE_BANK_NAME,
DRAWEE_BRANCH_CODE = X_DRAWEE_BRANCH_CODE,
DRAWEE_ACCOUNT_NUMBER = X_DRAWEE_ACCOUNT_NUMBER,
DRAWEE_INSCRIPTION_TYPE = X_DRAWEE_INSCRIPTION_TYPE,
DRAWEE_INSCRIPTION_NUMBER = X_DRAWEE_INSCRIPTION_NUMBER,
TRANSFEROR_NAME = X_TRANSFEROR_NAME,
TRANSFEROR_BANK_CODE = X_TRANSFEROR_BANK_CODE,
TRANSFEROR_BRANCH_CODE = X_TRANSFEROR_BRANCH_CODE,
TRANSFEROR_ACCOUNT_NUMBER = X_TRANSFEROR_ACCOUNT_NUMBER,
TRANSFEROR_INSCRIPTION_TYPE = X_TRANSFEROR_INSCRIPTION_TYPE,
TRANSFEROR_INSCRIPTION_NUMBER = X_TRANSFEROR_INSCRIPTION_NUM,
ACCOUNTING_BALANCING_SEGMENT = X_ACCOUNTING_BALANCING_SEGMENT,
SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
ERROR_CODE = X_ERROR_CODE,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
CREATION_DATE = X_CREATION_DATE,
CREATED_BY = X_CREATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = X_ATTRIBUTE1,
ATTRIBUTE2 = X_ATTRIBUTE2,
ATTRIBUTE3 = X_ATTRIBUTE3,
ATTRIBUTE4 = X_ATTRIBUTE4,
ATTRIBUTE5 = X_ATTRIBUTE5,
ATTRIBUTE6 = X_ATTRIBUTE6,
ATTRIBUTE7 = X_ATTRIBUTE7,
ATTRIBUTE8 = X_ATTRIBUTE8,
ATTRIBUTE9 = X_ATTRIBUTE9,
ATTRIBUTE10 = X_ATTRIBUTE10,
ATTRIBUTE11 = X_ATTRIBUTE11,
ATTRIBUTE12 = X_ATTRIBUTE12,
ATTRIBUTE13 = X_ATTRIBUTE13,
ATTRIBUTE14 = X_ATTRIBUTE14,
ATTRIBUTE15 = X_ATTRIBUTE15,
BARCODE = X_BARCODE,
ELECTRONIC_FORMAT_FLAG = X_ELECTRONIC_FORMAT_FLAG
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_calling_sequence IN VARCHAR2) IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'JL_BR_AP_INT_COLLECT_EXT_PKG.DELETE_ROW<-' ||
X_calling_sequence;
debug_info := 'Delete from JL_BR_AP_INT_COLLECT_EXT';
DELETE FROM JL_BR_AP_INT_COLLECT_EXT
WHERE rowid = X_Rowid;
END Delete_Row;