DBA Data[Home] [Help]

APPS.JL_BR_AP_COLLECTION_DOC2_PKG dependencies on JL_BR_AP_COLLECTION_DOCS

Line 90: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.UPDATE_ROW<-' ||

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

Line 92: debug_info := 'Update JL_BR_AP_COLLECTION_DOCS';

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,

Line 93: UPDATE JL_BR_AP_COLLECTION_DOCS

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,

Line 200: current_calling_sequence := 'JL_BR_AP_COLLECTION_DOCS_PKG.DELETE_ROW<-' ||

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;

Line 202: debug_info := 'Delete from JL_BR_AP_COLLECTION_DOCS';

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

Line 203: DELETE FROM JL_BR_AP_COLLECTION_DOCS

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;