DBA Data[Home] [Help]

APPS.CSP_EXCESS_LISTS_PKG dependencies on CSP_EXCESS_LISTS_PKG

Line 1: PACKAGE BODY CSP_EXCESS_LISTS_PKG as

1: PACKAGE BODY CSP_EXCESS_LISTS_PKG as
2: /* $Header: csptexcb.pls 120.0.12010000.2 2009/05/14 13:13:48 htank ship $ */
3: -- Start of Comments
4: -- Package name : CSP_EXCESS_LISTS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_EXCESS_LISTS_PKG

1: PACKAGE BODY CSP_EXCESS_LISTS_PKG as
2: /* $Header: csptexcb.pls 120.0.12010000.2 2009/05/14 13:13:48 htank ship $ */
3: -- Start of Comments
4: -- Package name : CSP_EXCESS_LISTS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_EXCESS_LISTS_PKG';

5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_EXCESS_LISTS_PKG';
10: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptexcb.pls';
11: PROCEDURE Insert_Row(
12: px_EXCESS_LINE_ID IN OUT NOCOPY NUMBER,
13: p_CREATED_BY NUMBER,

Line 51: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',

47: BEGIN
48:
49: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
50: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
51: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',
52: 'Begin...');
53: end if;
54:
55: If (px_EXCESS_LINE_ID IS NULL) OR (px_EXCESS_LINE_ID = FND_API.G_MISS_NUM) then

Line 63: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',

59: End If;
60:
61: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
62: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
63: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',
64: 'px_EXCESS_LINE_ID = ' || px_EXCESS_LINE_ID);
65: end if;
66:
67: INSERT INTO CSP_EXCESS_LISTS(

Line 140: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',

136: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
137:
138: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
139: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
140: 'csp.plsql.CSP_EXCESS_LISTS_PKG.Insert_Row',
141: 'Record inserted...');
142: end if;
143:
144: End Insert_Row;

Line 367: End CSP_EXCESS_LISTS_PKG;

363: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
364: APP_EXCEPTION.RAISE_EXCEPTION;
365: End If;
366: END Lock_Row;
367: End CSP_EXCESS_LISTS_PKG;