DBA Data[Home] [Help]

APPS.JL_BR_AP_COLLECTION_DOC2_PKG dependencies on JL_BR_AP_COLLECTION_DOCS

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

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

Line 93: debug_info := 'Update JL_BR_AP_COLLECTION_DOCS';

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,

Line 94: UPDATE JL_BR_AP_COLLECTION_DOCS

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,

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

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;

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

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

Line 202: DELETE FROM JL_BR_AP_COLLECTION_DOCS

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;