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.15 2011/07/18 13:52:44 pgayen ship $ */
3:
4:
5: /* */

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

2: /* $Header: apiholdb.pls 120.15 2011/07/18 13:52:44 pgayen 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 421: current_calling_sequence := 'AP_HOLDS_PKG.UPDATE_ROW<-' ||

417: l_hold_id AP_HOLDS_ALL.HOLD_ID%TYPE ; -- Bug 8266290
418: BEGIN
419: -- Update the calling sequence
420: --
421: current_calling_sequence := 'AP_HOLDS_PKG.UPDATE_ROW<-' ||
422: X_calling_sequence;
423:
424: -- Bug 8266290 : Start
425: SELECT wf_status,

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

586:
587: BEGIN
588: -- Update the calling sequence
589: --
590: current_calling_sequence := 'AP_HOLDS_PKG.DELETE_ROW<-' ||
591: X_calling_sequence;
592:
593: --Bug 4539462 Need the invoice_id
594: Select invoice_id

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

659:
660: -- Update the calling sequence
661: --
662: current_calling_sequence :=
663: 'AP_HOLDS_PKG.insert_single_hold<-'||
664: X_calling_sequence;
665: l_api_name := 'Insert_Single_Hold';
666:
667: -- If no hold_code was passed to the procedure, abort the call

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

821:
822: -- Update the calling sequence
823: --
824: current_calling_sequence :=
825: 'AP_HOLDS_PKG.release_single_hold<-'||
826: X_calling_sequence;
827:
828: debug_info := 'Select from AP_INVOICES';
829:

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

932:
933: -- Update the calling sequence
934: --
935: current_calling_sequence :=
936: 'AP_HOLDS_PKG.quick_release<-'||
937: X_calling_sequence;
938:
939: /*Bug 12747896: commented below initialization as it is not needed for associative arrays*/
940: /*FOR num IN 1..10 LOOP

Line 1117: END AP_HOLDS_PKG;

1113:
1114:
1115:
1116:
1117: END AP_HOLDS_PKG;
1118: