DBA Data[Home] [Help]

APPS.AP_BATCHES_PKG dependencies on AP_BATCHES_PKG

Line 1: PACKAGE BODY AP_BATCHES_PKG as

1: PACKAGE BODY AP_BATCHES_PKG as
2: /* $Header: apibatcb.pls 120.3.12010000.2 2008/12/11 10:58:00 rseeta ship $ */
3:
4:
5: -----------------------------------------------------------------------

Line 56: current_calling_sequence := 'AP_BATCHES_PKG.CHECK_UNIQUE<-' ||

52:
53: begin
54: --Update the calling sequence
55: --
56: current_calling_sequence := 'AP_BATCHES_PKG.CHECK_UNIQUE<-' ||
57: X_calling_sequence;
58:
59: debug_info := 'Count rows with this batch_name';
60: select count(1)

Line 137: current_calling_sequence := 'AP_BATCHES_PKG.INSERT_ROW<-' ||

133:
134: BEGIN
135: --Update the calling sequence
136: --
137: current_calling_sequence := 'AP_BATCHES_PKG.INSERT_ROW<-' ||
138: X_calling_sequence;
139:
140: -- Check uniqueness first
141: ap_batches_pkg.check_unique(X_ROWID,

Line 141: ap_batches_pkg.check_unique(X_ROWID,

137: current_calling_sequence := 'AP_BATCHES_PKG.INSERT_ROW<-' ||
138: X_calling_sequence;
139:
140: -- Check uniqueness first
141: ap_batches_pkg.check_unique(X_ROWID,
142: X_BATCH_NAME,
143: X_calling_sequence => current_calling_sequence);
144:
145: debug_info := 'Insert into AP_BATCHES';

Line 302: current_calling_sequence := 'AP_BATCHES_PKG.LOCK_ROW<-' ||

298:
299: BEGIN
300: -- Update the calling sequence
301: --
302: current_calling_sequence := 'AP_BATCHES_PKG.LOCK_ROW<-' ||
303: X_calling_sequence;
304: debug_info := 'Open cursor C';
305: OPEN C;
306: debug_info := 'Fetch cursor C';

Line 483: current_calling_sequence := 'AP_BATCHES_PKG.UPDATE_ROW<-' ||

479: debug_info VARCHAR2(100);
480: BEGIN
481: --Update the calling sequence
482: --
483: current_calling_sequence := 'AP_BATCHES_PKG.UPDATE_ROW<-' ||
484: X_calling_sequence;
485:
486: -- Check uniqueness first
487: ap_batches_pkg.check_unique(X_ROWID,

Line 487: ap_batches_pkg.check_unique(X_ROWID,

483: current_calling_sequence := 'AP_BATCHES_PKG.UPDATE_ROW<-' ||
484: X_calling_sequence;
485:
486: -- Check uniqueness first
487: ap_batches_pkg.check_unique(X_ROWID,
488: X_BATCH_NAME,
489: X_calling_sequence => current_calling_sequence);
490:
491: debug_info := 'Update AP_BATCHES_ALL';

Line 557: current_calling_sequence := 'AP_BATCHES_PKG.DELETE_ROW<-' ||

553: debug_info VARCHAR2(100);
554: BEGIN
555: -- Update the calling sequence
556: --
557: current_calling_sequence := 'AP_BATCHES_PKG.DELETE_ROW<-' ||
558: X_calling_sequence;
559: debug_info := 'Delete from AP_BATCHES';
560: DELETE FROM AP_BATCHES_ALL
561: WHERE rowid = X_Rowid;

Line 581: END AP_BATCHES_PKG;

577:
578: END Delete_Row;
579:
580:
581: END AP_BATCHES_PKG;