DBA Data[Home] [Help]

APPS.AP_PBATCH_SET_HEADER_PKG dependencies on AP_PBATCH_SET_HEADER_PKG

Line 1: PACKAGE BODY AP_PBATCH_SET_HEADER_PKG as

1: PACKAGE BODY AP_PBATCH_SET_HEADER_PKG as
2: /* $Header: apbsethb.pls 120.2 2004/10/27 01:28:34 pjena noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Batch_Set_Name VARCHAR2,

Line 25: 'AP_PBATCH_SET_HEADER_PKG.INSERT_ROW<-'||X_Calling_Sequence;

21: BEGIN
22: -- Update the calling sequence
23: --
24: current_calling_sequence :=
25: 'AP_PBATCH_SET_HEADER_PKG.INSERT_ROW<-'||X_Calling_Sequence;
26:
27: debug_info := 'Get next Batch set Id';
28:
29: select ap_pbatch_sets_s.nextval

Line 100: 'AP_PBATCH_SET_HEADER_PKG.LOCK_ROW<-'||X_Calling_Sequence;

96: BEGIN
97: -- Update the calling sequence
98: --
99: current_calling_sequence :=
100: 'AP_PBATCH_SET_HEADER_PKG.LOCK_ROW<-'||X_Calling_Sequence;
101:
102: debug_info := 'Open cursor C';
103: OPEN C;
104: debug_info := 'Fetch cursor C';

Line 161: 'AP_PBATCH_SET_HEADER_PKG.UPDATE_ROW<-'||X_Calling_Sequence;

157: BEGIN
158: -- Update the calling sequence
159: --
160: current_calling_sequence :=
161: 'AP_PBATCH_SET_HEADER_PKG.UPDATE_ROW<-'||X_Calling_Sequence;
162:
163: debug_info := 'Update ap_pbatch_sets';
164: UPDATE ap_pbatch_sets
165: SET

Line 202: 'AP_PBATCH_SET_HEADER_PKG.DELETE_ROW<-'||X_Calling_Sequence;

198: BEGIN
199: -- Update the calling sequence
200: --
201: current_calling_sequence :=
202: 'AP_PBATCH_SET_HEADER_PKG.DELETE_ROW<-'||X_Calling_Sequence;
203:
204: debug_info := 'Delete from ap_pbatch_sets';
205: DELETE FROM ap_pbatch_sets
206: WHERE rowid = X_Rowid;

Line 225: END AP_PBATCH_SET_HEADER_PKG;

221: APP_EXCEPTION.RAISE_EXCEPTION;
222: END Delete_Row;
223: */
224:
225: END AP_PBATCH_SET_HEADER_PKG;