APPS.AP_HOLDS_PKG dependencies on AP_HOLDS_PKG

Line 1: PACKAGE BODY AP_HOLDS_PKG AS

1: PACKAGE BODY AP_HOLDS_PKG AS
2: /* $Header: apiholdb.pls 120.10.12010000.2 2008/11/12 10:46:14 kpasikan ship $ */
3:
4:
5: /* */

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_HOLDS_PKG';

2: /* $Header: apiholdb.pls 120.10.12010000.2 2008/11/12 10:46:14 kpasikan ship $ */
3:
4:
5: /* */
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_HOLDS_PKG';
7: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
8: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
9: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
10: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_HOLDS_PKG.';

18: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
19: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
20: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
21: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
22: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_HOLDS_PKG.';
23:
24: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
25: x_hold_id in out nocopy number, --5128839
26: X_Invoice_Id NUMBER,

Line 74: current_calling_sequence := 'AP_HOLDS_PKG.INSERT_ROW<-' ||

70: BEGIN
71:
72: -- Update the calling sequence
73: --
74: current_calling_sequence := 'AP_HOLDS_PKG.INSERT_ROW<-' ||
75: X_calling_sequence;
76:
77:
78: select ap_holds_s.nextval

Line 253: current_calling_sequence := 'AP_HOLDS_PKG.LOCK_ROW<-' ||

249:
250: BEGIN
251: -- Update the calling sequence
252: --
253: current_calling_sequence := 'AP_HOLDS_PKG.LOCK_ROW<-' ||
254: X_calling_sequence;
255: debug_info := 'Open cursor C';
256: OPEN C;
257: debug_info := 'Fetch cursor C';

Line 420: current_calling_sequence := 'AP_HOLDS_PKG.UPDATE_ROW<-' ||

416:
417: BEGIN
418: -- Update the calling sequence
419: --
420: current_calling_sequence := 'AP_HOLDS_PKG.UPDATE_ROW<-' ||
421: X_calling_sequence;
422: debug_info := 'Update AP_HOLDS';
423: UPDATE AP_HOLDS
424: SET

Line 570: current_calling_sequence := 'AP_HOLDS_PKG.DELETE_ROW<-' ||

566:
567: BEGIN
568: -- Update the calling sequence
569: --
570: current_calling_sequence := 'AP_HOLDS_PKG.DELETE_ROW<-' ||
571: X_calling_sequence;
572:
573: --Bug 4539462 Need the invoice_id
574: Select invoice_id

Line 636: 'AP_HOLDS_PKG.insert_single_hold<-'||

632:
633: -- Update the calling sequence
634: --
635: current_calling_sequence :=
636: 'AP_HOLDS_PKG.insert_single_hold<-'||
637: X_calling_sequence;
638: l_api_name := 'Insert_Single_Hold';
639:
640: -- If no hold_code was passed to the procedure, abort the call

Line 758: 'AP_HOLDS_PKG.release_single_hold<-'||

754:
755: -- Update the calling sequence
756: --
757: current_calling_sequence :=
758: 'AP_HOLDS_PKG.release_single_hold<-'||
759: X_calling_sequence;
760:
761: debug_info := 'Select from AP_INVOICES';
762:

Line 855: 'AP_HOLDS_PKG.quick_release<-'||

851:
852: -- Update the calling sequence
853: --
854: current_calling_sequence :=
855: 'AP_HOLDS_PKG.quick_release<-'||
856: X_calling_sequence;
857:
858: FOR num IN 1..10 LOOP
859: l_tax_hold_codes(num) := NULL;

Line 1009: END AP_HOLDS_PKG;

1005:
1006:
1007:
1008:
1009: END AP_HOLDS_PKG;
1010: