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