87: debug_info VARCHAR2(100);
88: BEGIN
89: -- Update the calling sequence
90: --
91: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
92: X_calling_sequence;
93: debug_info := 'Update JL_BR_AP_COLLECTION_DOCS';
94: UPDATE JL_BR_AP_COLLECTION_DOCS
95: SET
89: -- Update the calling sequence
90: --
91: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
92: X_calling_sequence;
93: debug_info := 'Update JL_BR_AP_COLLECTION_DOCS';
94: UPDATE JL_BR_AP_COLLECTION_DOCS
95: SET
96: BANK_COLLECTION_ID = X_BANK_COLLECTION_ID,
97: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
90: --
91: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||
92: X_calling_sequence;
93: debug_info := 'Update JL_BR_AP_COLLECTION_DOCS';
94: UPDATE JL_BR_AP_COLLECTION_DOCS
95: SET
96: BANK_COLLECTION_ID = X_BANK_COLLECTION_ID,
97: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
98: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
195: debug_info VARCHAR2(100);
196: BEGIN
197: -- Update the calling sequence
198: --
199: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.DELETE_ROW<-' ||
200: X_calling_sequence;
201: debug_info := 'Delete from JL_BR_AP_COLLECTION_DOCS';
202: DELETE FROM JL_BR_AP_COLLECTION_DOCS
203: WHERE rowid = X_Rowid;
197: -- Update the calling sequence
198: --
199: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.DELETE_ROW<-' ||
200: X_calling_sequence;
201: debug_info := 'Delete from JL_BR_AP_COLLECTION_DOCS';
202: DELETE FROM JL_BR_AP_COLLECTION_DOCS
203: WHERE rowid = X_Rowid;
204:
205: if (SQL%NOTFOUND) then
198: --
199: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.DELETE_ROW<-' ||
200: X_calling_sequence;
201: debug_info := 'Delete from JL_BR_AP_COLLECTION_DOCS';
202: DELETE FROM JL_BR_AP_COLLECTION_DOCS
203: WHERE rowid = X_Rowid;
204:
205: if (SQL%NOTFOUND) then
206: Raise NO_DATA_FOUND;