APPS.ASO_PRICE_ATTRIBUTES_PKG dependencies on ASO_PRICE_ATTRIBUTES

Line 1: PACKAGE BODY ASO_PRICE_ATTRIBUTES_PKG as

1: PACKAGE BODY ASO_PRICE_ATTRIBUTES_PKG as
2: /* $Header: asotpatb.pls 120.1 2005/06/29 12:39:52 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICE_ATTRIBUTES_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_PRICE_ATTRIBUTES_PKG

1: PACKAGE BODY ASO_PRICE_ATTRIBUTES_PKG as
2: /* $Header: asotpatb.pls 120.1 2005/06/29 12:39:52 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICE_ATTRIBUTES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICE_ATTRIBUTES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotpatb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_PRICE_ATTRIBUTE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 154: CURSOR C2 IS SELECT ASO_PRICE_ATTRIBUTES_S.nextval FROM sys.dual;

150: p_OBJECT_VERSION_NUMBER NUMBER
151: )
152:
153: IS
154: CURSOR C2 IS SELECT ASO_PRICE_ATTRIBUTES_S.nextval FROM sys.dual;
155: BEGIN
156: If (px_PRICE_ATTRIBUTE_ID IS NULL) OR (px_PRICE_ATTRIBUTE_ID = FND_API.G_MISS_NUM) then
157: OPEN C2;
158: FETCH C2 INTO px_PRICE_ATTRIBUTE_ID;

Line 161: INSERT INTO ASO_PRICE_ATTRIBUTES(

157: OPEN C2;
158: FETCH C2 INTO px_PRICE_ATTRIBUTE_ID;
159: CLOSE C2;
160: End If;
161: INSERT INTO ASO_PRICE_ATTRIBUTES(
162: PRICE_ATTRIBUTE_ID,
163: CREATION_DATE,
164: CREATED_BY,
165: LAST_UPDATE_DATE,

Line 579: Update ASO_PRICE_ATTRIBUTES

575: )
576:
577: IS
578: BEGIN
579: Update ASO_PRICE_ATTRIBUTES
580: SET
581: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
582: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
583: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 727: DELETE FROM ASO_PRICE_ATTRIBUTES

723: PROCEDURE Delete_Row(
724: p_PRICE_ATTRIBUTE_ID NUMBER)
725: IS
726: BEGIN
727: DELETE FROM ASO_PRICE_ATTRIBUTES
728: WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID;
729: If (SQL%NOTFOUND) then
730: RAISE NO_DATA_FOUND;
731: End If;

Line 739: DELETE FROM ASO_PRICE_ATTRIBUTES

735: PROCEDURE Delete_Row(
736: p_QUOTE_LINE_ID NUMBER)
737: IS
738: BEGIN
739: DELETE FROM ASO_PRICE_ATTRIBUTES
740: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
741: If (SQL%NOTFOUND) then
742: RAISE NO_DATA_FOUND;
743: End If;

Line 1012: FROM ASO_PRICE_ATTRIBUTES

1008: PRICING_ATTRIBUTE22,
1009: PRICING_ATTRIBUTE23,
1010: PRICING_ATTRIBUTE24,
1011: PRICING_ATTRIBUTE25
1012: FROM ASO_PRICE_ATTRIBUTES
1013: WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID
1014: FOR UPDATE of PRICE_ATTRIBUTE_ID NOWAIT;
1015: Recinfo C%ROWTYPE;
1016: BEGIN

Line 1431: End ASO_PRICE_ATTRIBUTES_PKG;

1427: APP_EXCEPTION.RAISE_EXCEPTION;
1428: End If;
1429: END Lock_Row;
1430:
1431: End ASO_PRICE_ATTRIBUTES_PKG;