APPS.AP_BATCHES_PKG dependencies on AP_BATCHES_ALL

Line 60: from ap_batches_all

56:
57: debug_info := 'Count rows with this batch_name';
58: select count(1)
59: into dummy
60: from ap_batches_all
61: where batch_name = X_BATCH_NAME
62: and ((X_ROWID is null) or (rowid <> X_ROWID));
63:
64: if (dummy >= 1) then

Line 127: CURSOR C IS SELECT rowid FROM AP_BATCHES_ALL

123: X_Org_Id NUMBER,
124: X_calling_sequence IN VARCHAR2,
125: X_gl_date DATE -- **1
126: ) IS
127: CURSOR C IS SELECT rowid FROM AP_BATCHES_ALL
128: WHERE batch_id = X_Batch_Id;
129: current_calling_sequence VARCHAR2(2000);
130: debug_info VARCHAR2(100);
131:

Line 144: INSERT INTO AP_BATCHES_ALL(

140: X_BATCH_NAME,
141: X_calling_sequence => current_calling_sequence);
142:
143: debug_info := 'Insert into AP_BATCHES';
144: INSERT INTO AP_BATCHES_ALL(
145: batch_id,
146: batch_name,
147: batch_date,
148: last_update_date,

Line 289: FROM AP_BATCHES_ALL

285: X_gl_date DATE -- **1
286: ) IS
287: CURSOR C IS
288: SELECT *
289: FROM AP_BATCHES_ALL
290: WHERE rowid = X_Rowid
291: FOR UPDATE of Batch_Id NOWAIT;
292: Recinfo C%ROWTYPE;
293: current_calling_sequence VARCHAR2(2000);

Line 489: debug_info := 'Update AP_BATCHES_ALL';

485: ap_batches_pkg.check_unique(X_ROWID,
486: X_BATCH_NAME,
487: X_calling_sequence => current_calling_sequence);
488:
489: debug_info := 'Update AP_BATCHES_ALL';
490: UPDATE AP_BATCHES_ALL
491: SET
492: batch_id = X_Batch_Id,
493: batch_name = X_Batch_Name,

Line 490: UPDATE AP_BATCHES_ALL

486: X_BATCH_NAME,
487: X_calling_sequence => current_calling_sequence);
488:
489: debug_info := 'Update AP_BATCHES_ALL';
490: UPDATE AP_BATCHES_ALL
491: SET
492: batch_id = X_Batch_Id,
493: batch_name = X_Batch_Name,
494: batch_date = X_Batch_Date,

Line 558: DELETE FROM AP_BATCHES_ALL

554: --
555: current_calling_sequence := 'AP_BATCHES_PKG.DELETE_ROW<-' ||
556: X_calling_sequence;
557: debug_info := 'Delete from AP_BATCHES';
558: DELETE FROM AP_BATCHES_ALL
559: WHERE rowid = X_Rowid;
560:
561: if (SQL%NOTFOUND) then
562: Raise NO_DATA_FOUND;