APPS.AP_DUPLICATE_VENDORS_PKG dependencies on AP_DUPLICATE_VENDORS

Line 1: PACKAGE BODY AP_DUPLICATE_VENDORS_PKG as

1: PACKAGE BODY AP_DUPLICATE_VENDORS_PKG as
2: /* $Header: apiduveb.pls 120.3 2004/10/28 00:01:41 pjena noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 28: CURSOR C IS SELECT rowid FROM AP_DUPLICATE_VENDORS

24: X_Created_By NUMBER DEFAULT NULL,
25: X_Org_Id NUMBER,
26: X_calling_sequence IN VARCHAR2
27: ) IS
28: CURSOR C IS SELECT rowid FROM AP_DUPLICATE_VENDORS
29: WHERE ( (entry_id = X_Entry_Id)
30: or (entry_id is NULL and X_Entry_Id is NULL));
31:
32: current_calling_sequence VARCHAR2(2000);

Line 38: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.INSERT_ROW<-' ||

34: BEGIN
35:
36: -- Update the calling sequence
37: --
38: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.INSERT_ROW<-' ||
39: X_calling_sequence;
40:
41: debug_info := 'Insert into AP_DUPLICATE_VENDORS';
42: INSERT INTO AP_DUPLICATE_VENDORS(

Line 41: debug_info := 'Insert into AP_DUPLICATE_VENDORS';

37: --
38: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.INSERT_ROW<-' ||
39: X_calling_sequence;
40:
41: debug_info := 'Insert into AP_DUPLICATE_VENDORS';
42: INSERT INTO AP_DUPLICATE_VENDORS(
43:
44: entry_id,
45: vendor_id,

Line 42: INSERT INTO AP_DUPLICATE_VENDORS(

38: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.INSERT_ROW<-' ||
39: X_calling_sequence;
40:
41: debug_info := 'Insert into AP_DUPLICATE_VENDORS';
42: INSERT INTO AP_DUPLICATE_VENDORS(
43:
44: entry_id,
45: vendor_id,
46: duplicate_vendor_id,

Line 136: FROM AP_DUPLICATE_VENDORS

132: X_calling_sequence IN VARCHAR2
133: ) IS
134: CURSOR C IS
135: SELECT *
136: FROM AP_DUPLICATE_VENDORS
137: WHERE rowid = X_Rowid
138: FOR UPDATE of Entry_Id NOWAIT;
139: Recinfo C%ROWTYPE;
140:

Line 147: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.LOCK_ROW<-' ||

143:
144: BEGIN
145: -- Update the calling sequence
146: --
147: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.LOCK_ROW<-' ||
148: X_calling_sequence;
149:
150: debug_info := 'Open cursor C';
151: OPEN C;

Line 268: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.UPDATE_ROW<-' ||

264: BEGIN
265:
266: -- Update the calling sequence
267: --
268: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.UPDATE_ROW<-' ||
269: X_calling_sequence;
270:
271: debug_info := 'Update AP_DUPLICATE_VENDORS';
272:

Line 271: debug_info := 'Update AP_DUPLICATE_VENDORS';

267: --
268: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.UPDATE_ROW<-' ||
269: X_calling_sequence;
270:
271: debug_info := 'Update AP_DUPLICATE_VENDORS';
272:
273: UPDATE AP_DUPLICATE_VENDORS
274: SET
275: entry_id = X_Entry_Id,

Line 273: UPDATE AP_DUPLICATE_VENDORS

269: X_calling_sequence;
270:
271: debug_info := 'Update AP_DUPLICATE_VENDORS';
272:
273: UPDATE AP_DUPLICATE_VENDORS
274: SET
275: entry_id = X_Entry_Id,
276: vendor_id = X_Vendor_Id,
277: duplicate_vendor_id = X_Duplicate_Vendor_Id,

Line 324: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.DELETE_ROW<-' ||

320: BEGIN
321:
322: -- Update the calling sequence
323: --
324: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.DELETE_ROW<-' ||
325: X_calling_sequence;
326:
327: debug_info := 'Delete from AP_DUPLICATE_VENDORS';
328: DELETE FROM AP_DUPLICATE_VENDORS

Line 327: debug_info := 'Delete from AP_DUPLICATE_VENDORS';

323: --
324: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.DELETE_ROW<-' ||
325: X_calling_sequence;
326:
327: debug_info := 'Delete from AP_DUPLICATE_VENDORS';
328: DELETE FROM AP_DUPLICATE_VENDORS
329: WHERE rowid = X_Rowid;
330:
331: if (SQL%NOTFOUND) then

Line 328: DELETE FROM AP_DUPLICATE_VENDORS

324: current_calling_sequence := 'AP_DUPLICATE_VENDORS_PKG.DELETE_ROW<-' ||
325: X_calling_sequence;
326:
327: debug_info := 'Delete from AP_DUPLICATE_VENDORS';
328: DELETE FROM AP_DUPLICATE_VENDORS
329: WHERE rowid = X_Rowid;
330:
331: if (SQL%NOTFOUND) then
332: Raise NO_DATA_FOUND;

Line 349: END AP_DUPLICATE_VENDORS_PKG;

345:
346: END Delete_Row;
347:
348:
349: END AP_DUPLICATE_VENDORS_PKG;