APPS.ASO_SALES_CREDITS_PKG dependencies on ASO_SALES_CREDITS

Line 1: PACKAGE BODY ASO_SALES_CREDITS_PKG as

1: PACKAGE BODY ASO_SALES_CREDITS_PKG as
2: /* $Header: asotqscb.pls 120.0 2005/05/31 12:21:59 appldev noship $ */
3: -- Start of Comments
4: -- Package name : ASO_SALES_CREDITS_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_SALES_CREDITS_PKG

1: PACKAGE BODY ASO_SALES_CREDITS_PKG as
2: /* $Header: asotqscb.pls 120.0 2005/05/31 12:21:59 appldev noship $ */
3: -- Start of Comments
4: -- Package name : ASO_SALES_CREDITS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SALES_CREDITS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotsccb.pls';
13:
14: PROCEDURE Insert_Row(
15: p_CREATION_DATE DATE,

Line 59: CURSOR C2 IS SELECT ASO_SALES_CREDITS_S.nextval FROM sys.dual;

55: p_CREDIT_RULE_ID NUMBER,
56: p_OBJECT_VERSION_NUMBER NUMBER)
57:
58: IS
59: CURSOR C2 IS SELECT ASO_SALES_CREDITS_S.nextval FROM sys.dual;
60: BEGIN
61: If (px_SALES_CREDIT_ID IS NULL) OR (px_SALES_CREDIT_ID = FND_API.G_MISS_NUM) then
62: OPEN C2;
63: FETCH C2 INTO px_SALES_CREDIT_ID;

Line 66: INSERT INTO ASO_SALES_CREDITS(

62: OPEN C2;
63: FETCH C2 INTO px_SALES_CREDIT_ID;
64: CLOSE C2;
65: End If;
66: INSERT INTO ASO_SALES_CREDITS(
67: CREATION_DATE,
68: CREATED_BY,
69: LAST_UPDATED_BY,
70: LAST_UPDATE_DATE,

Line 202: Update ASO_SALES_CREDITS

198: )
199:
200: IS
201: BEGIN
202: Update ASO_SALES_CREDITS
203: SET
204: /* CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
205: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_CHAR, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
206: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 256: DELETE FROM ASO_SALES_CREDITS

252: PROCEDURE Delete_Row(
253: p_SALES_CREDIT_ID NUMBER)
254: IS
255: BEGIN
256: DELETE FROM ASO_SALES_CREDITS
257: WHERE SALES_CREDIT_ID = p_SALES_CREDIT_ID;
258: If (SQL%NOTFOUND) then
259: RAISE NO_DATA_FOUND;
260: End If;

Line 340: FROM ASO_SALES_CREDITS

336: ATTRIBUTE15,
337: --OBJECT_VERSION_NUMBER,
338: SYSTEM_ASSIGNED_FLAG,
339: CREDIT_RULE_ID
340: FROM ASO_SALES_CREDITS
341: WHERE SALES_CREDIT_ID = p_SALES_CREDIT_ID
342: FOR UPDATE of SALES_CREDIT_ID NOWAIT;
343: Recinfo C%ROWTYPE;
344: BEGIN

Line 481: DELETE FROM ASO_SALES_CREDITS

477: PROCEDURE Delete_Row(
478: p_QUOTE_LINE_ID NUMBER)
479: IS
480: BEGIN
481: DELETE FROM ASO_SALES_CREDITS
482: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
483: If (SQL%NOTFOUND) then
484: null;
485: End If;

Line 492: DELETE FROM ASO_SALES_CREDITS

488: PROCEDURE Delete_Row(
489: p_QUOTE_HEADER_ID NUMBER)
490: IS
491: BEGIN
492: DELETE FROM ASO_SALES_CREDITS
493: WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID;
494: If (SQL%NOTFOUND) then
495: null;
496: End If;

Line 503: DELETE FROM ASO_SALES_CREDITS

499: PROCEDURE Delete_Header_Row(
500: p_QUOTE_HEADER_ID NUMBER)
501: IS
502: BEGIN
503: DELETE FROM ASO_SALES_CREDITS
504: WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID
505: AND QUOTE_LINE_ID IS NULL;
506: If (SQL%NOTFOUND) then
507: null;

Line 512: End ASO_SALES_CREDITS_PKG;

508: End If;
509: END;
510:
511:
512: End ASO_SALES_CREDITS_PKG;