APPS.ASO_PRICE_ADJ_ATTRIBS_PKG dependencies on ASO_PRICE_ADJ_ATTRIBS

Line 1: PACKAGE BODY ASO_PRICE_ADJ_ATTRIBS_PKG as

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

Line 4: -- Package name : ASO_PRICE_ADJ_ATTRIBS_PKG

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

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

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

Line 36: CURSOR C2 IS SELECT ASO_PRICE_ADJ_ATTRIBS_S.nextval FROM sys.dual;

32: p_OBJECT_VERSION_NUMBER NUMBER
33: )
34:
35: IS
36: CURSOR C2 IS SELECT ASO_PRICE_ADJ_ATTRIBS_S.nextval FROM sys.dual;
37: BEGIN
38: If (px_PRICE_ADJ_ATTRIB_ID IS NULL) OR (px_PRICE_ADJ_ATTRIB_ID = FND_API.G_MISS_NUM) then
39: OPEN C2;
40: FETCH C2 INTO px_PRICE_ADJ_ATTRIB_ID;

Line 43: INSERT INTO ASO_PRICE_ADJ_ATTRIBS(

39: OPEN C2;
40: FETCH C2 INTO px_PRICE_ADJ_ATTRIB_ID;
41: CLOSE C2;
42: End If;
43: INSERT INTO ASO_PRICE_ADJ_ATTRIBS(
44: PRICE_ADJ_ATTRIB_ID,
45: CREATION_DATE,
46: CREATED_BY,
47: LAST_UPDATE_DATE,

Line 107: Update ASO_PRICE_ADJ_ATTRIBS

103: )
104:
105: IS
106: BEGIN
107: Update ASO_PRICE_ADJ_ATTRIBS
108: SET
109: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
110: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
111: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 137: DELETE FROM ASO_PRICE_ADJ_ATTRIBS

133: PROCEDURE Delete_Row(
134: p_PRICE_ADJ_ATTRIB_ID NUMBER)
135: IS
136: BEGIN
137: DELETE FROM ASO_PRICE_ADJ_ATTRIBS
138: WHERE PRICE_ADJ_ATTRIB_ID = p_PRICE_ADJ_ATTRIB_ID;
139: If (SQL%NOTFOUND) then
140: RAISE NO_DATA_FOUND;
141: End If;

Line 184: FROM ASO_PRICE_ADJ_ATTRIBS

180: PRICING_ATTR_VALUE_FROM,
181: PRICING_ATTR_VALUE_TO,
182: COMPARISON_OPERATOR,
183: FLEX_TITLE
184: FROM ASO_PRICE_ADJ_ATTRIBS
185: WHERE PRICE_ADJ_ATTRIB_ID = p_PRICE_ADJ_ATTRIB_ID
186: FOR UPDATE of PRICE_ADJ_ATTRIB_ID NOWAIT;
187: Recinfo C%ROWTYPE;
188: BEGIN

Line 264: End ASO_PRICE_ADJ_ATTRIBS_PKG;

260: APP_EXCEPTION.RAISE_EXCEPTION;
261: End If;
262: END Lock_Row;
263:
264: End ASO_PRICE_ADJ_ATTRIBS_PKG;