APPS.AS_SALES_CREDITS_PKG dependencies on AS_SALES_CREDITS

Line 1: PACKAGE BODY AS_SALES_CREDITS_PKG as

1: PACKAGE BODY AS_SALES_CREDITS_PKG as
2: /* $Header: asxtlscb.pls 120.1 2005/08/29 23:39:44 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_CREDITS_PKG
5: -- Purpose :

Line 4: -- Package name : AS_SALES_CREDITS_PKG

1: PACKAGE BODY AS_SALES_CREDITS_PKG as
2: /* $Header: asxtlscb.pls 120.1 2005/08/29 23:39:44 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_CREDITS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_CREDITS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_CREDITS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtlscb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_SALES_CREDIT_ID IN OUT NOCOPY NUMBER,

Line 67: CURSOR C2 IS SELECT AS_SALES_CREDITS_S.nextval FROM sys.dual;

63: P_DEFAULTED_FROM_OWNER_FLAG VARCHAR2 DEFAULT NULL -- Added for ASNB
64: )
65:
66: IS
67: CURSOR C2 IS SELECT AS_SALES_CREDITS_S.nextval FROM sys.dual;
68: l_OPP_WORST_FORECAST_AMOUNT NUMBER := p_OPP_WORST_FORECAST_AMOUNT;
69: l_OPP_FORECAST_AMOUNT NUMBER := p_OPP_FORECAST_AMOUNT;
70: l_OPP_BEST_FORECAST_AMOUNT NUMBER := p_OPP_BEST_FORECAST_AMOUNT;
71: BEGIN

Line 90: INSERT INTO AS_SALES_CREDITS(

86: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
87: l_OPP_BEST_FORECAST_AMOUNT := 0;
88: END IF;
89:
90: INSERT INTO AS_SALES_CREDITS(
91: SALES_CREDIT_ID,
92: LAST_UPDATE_DATE,
93: LAST_UPDATED_BY,
94: CREATION_DATE,

Line 261: Update AS_SALES_CREDITS

257: IF l_OPP_BEST_FORECAST_AMOUNT = FND_API.G_MISS_NUM THEN
258: l_OPP_BEST_FORECAST_AMOUNT := NULL;
259: END IF;
260:
261: Update AS_SALES_CREDITS
262: SET object_version_number = nvl(object_version_number,0) + 1,
263: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
264: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
265: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 322: DELETE FROM AS_SALES_CREDITS

318: PROCEDURE Delete_Row(
319: p_SALES_CREDIT_ID NUMBER)
320: IS
321: BEGIN
322: DELETE FROM AS_SALES_CREDITS
323: WHERE SALES_CREDIT_ID = p_SALES_CREDIT_ID;
324: If (SQL%NOTFOUND) then
325: RAISE NO_DATA_FOUND;
326: End If;

Line 379: FROM AS_SALES_CREDITS

375:
376: IS
377: CURSOR C IS
378: SELECT *
379: FROM AS_SALES_CREDITS
380: WHERE SALES_CREDIT_ID = p_SALES_CREDIT_ID
381: FOR UPDATE of SALES_CREDIT_ID NOWAIT;
382: Recinfo C%ROWTYPE;
383: BEGIN

Line 534: End AS_SALES_CREDITS_PKG;

530: APP_EXCEPTION.RAISE_EXCEPTION;
531: End If;
532: END Lock_Row;
533:
534: End AS_SALES_CREDITS_PKG;