APPS.AP_HOLD_CODES_PKG dependencies on AP_HOLD_CODES

Line 1: PACKAGE BODY AP_HOLD_CODES_PKG as

1: PACKAGE BODY AP_HOLD_CODES_PKG as
2: /* $Header: apihdcob.pls 120.5 2006/05/05 00:18:10 bghose noship $ */
3:
4:
5:

Line 17: current_calling_sequence := 'AP_HOLD_CODES_PKG.CHECK_UNIQUE<-' ||

13: debug_info VARCHAR2(100);
14: BEGIN
15: -- Update the calling sequence
16: --
17: current_calling_sequence := 'AP_HOLD_CODES_PKG.CHECK_UNIQUE<-' ||
18: X_calling_sequence;
19:
20: -- Check if hold_lookup_code is unique
21: --

Line 26: FROM ap_hold_codes

22: debug_info := 'Checking hold_lookup_code uniqueness';
23:
24: SELECT count(1)
25: INTO Dummy
26: FROM ap_hold_codes
27: WHERE upper(hold_lookup_code) = upper(X_Hold_Lookup_Code)
28: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
29:
30: IF (Dummy >= 1) then

Line 71: CURSOR C IS SELECT rowid FROM ap_hold_codes

67: X_Reminder_Days NUMBER DEFAULT NULL,
68: X_Hold_Instruction VARCHAR2 DEFAULT NULL,
69: X_calling_sequence IN VARCHAR2
70: ) IS
71: CURSOR C IS SELECT rowid FROM ap_hold_codes
72: WHERE hold_lookup_code = X_Hold_Lookup_Code;
73: current_calling_sequence VARCHAR2(2000);
74: debug_info VARCHAR2(100);
75: BEGIN

Line 79: current_calling_sequence := 'AP_HOLD_CODES_PKG.INSERT_ROW<-' ||

75: BEGIN
76:
77: -- Update the calling sequence
78: --
79: current_calling_sequence := 'AP_HOLD_CODES_PKG.INSERT_ROW<-' ||
80: X_calling_sequence;
81:
82: -- Check if unique values
83: AP_HOLD_CODES_PKG.check_unique(X_Rowid, X_Hold_Lookup_Code, current_calling_sequence);

Line 83: AP_HOLD_CODES_PKG.check_unique(X_Rowid, X_Hold_Lookup_Code, current_calling_sequence);

79: current_calling_sequence := 'AP_HOLD_CODES_PKG.INSERT_ROW<-' ||
80: X_calling_sequence;
81:
82: -- Check if unique values
83: AP_HOLD_CODES_PKG.check_unique(X_Rowid, X_Hold_Lookup_Code, current_calling_sequence);
84:
85: -- Insert values into ap_hold_codes
86: --
87: debug_info := 'Inserting in ap_hold_codes';

Line 85: -- Insert values into ap_hold_codes

81:
82: -- Check if unique values
83: AP_HOLD_CODES_PKG.check_unique(X_Rowid, X_Hold_Lookup_Code, current_calling_sequence);
84:
85: -- Insert values into ap_hold_codes
86: --
87: debug_info := 'Inserting in ap_hold_codes';
88:
89: INSERT INTO ap_hold_codes(

Line 87: debug_info := 'Inserting in ap_hold_codes';

83: AP_HOLD_CODES_PKG.check_unique(X_Rowid, X_Hold_Lookup_Code, current_calling_sequence);
84:
85: -- Insert values into ap_hold_codes
86: --
87: debug_info := 'Inserting in ap_hold_codes';
88:
89: INSERT INTO ap_hold_codes(
90: hold_type,
91: hold_lookup_code,

Line 89: INSERT INTO ap_hold_codes(

85: -- Insert values into ap_hold_codes
86: --
87: debug_info := 'Inserting in ap_hold_codes';
88:
89: INSERT INTO ap_hold_codes(
90: hold_type,
91: hold_lookup_code,
92: description,
93: last_update_date,

Line 205: -- Open cursor to check existence of hold_lookup_code in ap_hold_codes

201: and FLV.lookup_code = X_Hold_Lookup_Code
202: and FLV.language = L.LANGUAGE_CODE);
203:
204:
205: -- Open cursor to check existence of hold_lookup_code in ap_hold_codes
206: --
207: debug_info := 'Open cursor C on ap_hold_codes';
208:
209: OPEN C;

Line 207: debug_info := 'Open cursor C on ap_hold_codes';

203:
204:
205: -- Open cursor to check existence of hold_lookup_code in ap_hold_codes
206: --
207: debug_info := 'Open cursor C on ap_hold_codes';
208:
209: OPEN C;
210:
211: debug_info := 'Fetch cursor C';

Line 254: FROM ap_hold_codes

250: X_calling_sequence IN VARCHAR2
251: ) IS
252: CURSOR C IS
253: SELECT *
254: FROM ap_hold_codes
255: WHERE rowid = X_Rowid
256: FOR UPDATE of hold_lookup_code NOWAIT;
257: Recinfo C%ROWTYPE;
258: current_calling_sequence VARCHAR2(2000);

Line 264: current_calling_sequence := 'AP_HOLD_CODES_PKG.LOCK_ROW<-' ||

260:
261: BEGIN
262: -- Update the calling sequence
263: --
264: current_calling_sequence := 'AP_HOLD_CODES_PKG.LOCK_ROW<-' ||
265: X_calling_sequence;
266:
267: -- Open cursor on ap_hold_codes
268: --

Line 267: -- Open cursor on ap_hold_codes

263: --
264: current_calling_sequence := 'AP_HOLD_CODES_PKG.LOCK_ROW<-' ||
265: X_calling_sequence;
266:
267: -- Open cursor on ap_hold_codes
268: --
269: debug_info := 'Open cursor C on ap_hold_codes';
270:
271: OPEN C;

Line 269: debug_info := 'Open cursor C on ap_hold_codes';

265: X_calling_sequence;
266:
267: -- Open cursor on ap_hold_codes
268: --
269: debug_info := 'Open cursor C on ap_hold_codes';
270:
271: OPEN C;
272:
273: debug_info := 'Fetch cursor C';

Line 369: current_calling_sequence := 'AP_HOLD_CODES_PKG.UPDATE_ROW<-' ||

365:
366: BEGIN
367: -- Update the calling sequence
368: --
369: current_calling_sequence := 'AP_HOLD_CODES_PKG.UPDATE_ROW<-' ||
370: X_calling_sequence;
371:
372: -- Updating ap_hold_codes
373: --

Line 372: -- Updating ap_hold_codes

368: --
369: current_calling_sequence := 'AP_HOLD_CODES_PKG.UPDATE_ROW<-' ||
370: X_calling_sequence;
371:
372: -- Updating ap_hold_codes
373: --
374: debug_info := 'Updating ap_hold_codes';
375:
376: UPDATE ap_hold_codes

Line 374: debug_info := 'Updating ap_hold_codes';

370: X_calling_sequence;
371:
372: -- Updating ap_hold_codes
373: --
374: debug_info := 'Updating ap_hold_codes';
375:
376: UPDATE ap_hold_codes
377: SET
378: hold_type = X_Hold_Type,

Line 376: UPDATE ap_hold_codes

372: -- Updating ap_hold_codes
373: --
374: debug_info := 'Updating ap_hold_codes';
375:
376: UPDATE ap_hold_codes
377: SET
378: hold_type = X_Hold_Type,
379: hold_lookup_code = X_Hold_Lookup_Code,
380: description = X_Description,

Line 436: DELETE FROM ap_hold_codes

432:
433: /*
434: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
435: BEGIN
436: DELETE FROM ap_hold_codes
437: WHERE rowid = X_Rowid;
438:
439: if (SQL%NOTFOUND) then
440: Raise NO_DATA_FOUND;

Line 445: END AP_HOLD_CODES_PKG;

441: end if;
442: END Delete_Row;
443: */
444:
445: END AP_HOLD_CODES_PKG;