APPS.ASO_TAX_DETAILS_PKG dependencies on ASO_TAX_DETAILS

Line 1: PACKAGE BODY ASO_TAX_DETAILS_PKG as

1: PACKAGE BODY ASO_TAX_DETAILS_PKG as
2: /* $Header: asottaxb.pls 120.2 2005/08/30 04:58:06 anrajan ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_DETAILS_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_TAX_DETAILS_PKG

1: PACKAGE BODY ASO_TAX_DETAILS_PKG as
2: /* $Header: asottaxb.pls 120.2 2005/08/30 04:58:06 anrajan ship $ */
3: -- Start of Comments
4: -- Package name : ASO_TAX_DETAILS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_TAX_DETAILS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asottaxb.pls';
13:
14: --Added the TAX_RATE_ID column in INSERT_ROW,UPDATE_ROW and LOCK_ROW procedures
15: --by Anoop Rajan on 30 August 2005.

Line 65: CURSOR C2 IS SELECT ASO_TAX_DETAILS_S.nextval FROM sys.dual;

61: p_TAX_RATE_ID NUMBER
62: )
63:
64: IS
65: CURSOR C2 IS SELECT ASO_TAX_DETAILS_S.nextval FROM sys.dual;
66: BEGIN
67: If (px_TAX_DETAIL_ID IS NULL) OR (px_TAX_DETAIL_ID = FND_API.G_MISS_NUM) then
68: OPEN C2;
69: FETCH C2 INTO px_TAX_DETAIL_ID;

Line 72: INSERT INTO ASO_TAX_DETAILS(

68: OPEN C2;
69: FETCH C2 INTO px_TAX_DETAIL_ID;
70: CLOSE C2;
71: End If;
72: INSERT INTO ASO_TAX_DETAILS(
73: TAX_DETAIL_ID,
74: CREATION_DATE,
75: CREATED_BY,
76: LAST_UPDATE_DATE,

Line 217: Update ASO_TAX_DETAILS

213: )
214:
215: IS
216: BEGIN
217: Update ASO_TAX_DETAILS
218: SET
219: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
220: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
221: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 274: DELETE FROM ASO_TAX_DETAILS

270: PROCEDURE Delete_Row(
271: p_TAX_DETAIL_ID NUMBER)
272: IS
273: BEGIN
274: DELETE FROM ASO_TAX_DETAILS
275: WHERE TAX_DETAIL_ID = p_TAX_DETAIL_ID;
276: If (SQL%NOTFOUND) then
277: RAISE NO_DATA_FOUND;
278: End If;

Line 286: DELETE FROM ASO_TAX_DETAILS

282: PROCEDURE Delete_Row(
283: p_QUOTE_LINE_ID NUMBER)
284: IS
285: BEGIN
286: DELETE FROM ASO_TAX_DETAILS
287: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
288: If (SQL%NOTFOUND) then
289: RAISE NO_DATA_FOUND;
290: End If;

Line 376: FROM ASO_TAX_DETAILS

372: TAX_RATE,
373: TAX_DATE,
374: TAX_AMOUNT,
375: TAX_RATE_ID
376: FROM ASO_TAX_DETAILS
377: WHERE TAX_DETAIL_ID = p_TAX_DETAIL_ID
378: FOR UPDATE of TAX_DETAIL_ID NOWAIT;
379: Recinfo C%ROWTYPE;
380: BEGIN

Line 517: End ASO_TAX_DETAILS_PKG;

513: APP_EXCEPTION.RAISE_EXCEPTION;
514: End If;
515: END Lock_Row;
516:
517: End ASO_TAX_DETAILS_PKG;