APPS.ASO_QUOTE_LINE_ATTRIBS_EXT_PKG dependencies on ASO_QUOTE_LINE_ATTRIBS_EXT

Line 1: PACKAGE BODY ASO_QUOTE_LINE_ATTRIBS_EXT_PKG as

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

Line 4: -- Package name : ASO_QUOTE_LINE_ATTRIBS_EXT_PKG

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

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

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

Line 40: CURSOR C2 IS SELECT ASO_QUOTE_LINE_ATTRIBS_EXT_S.nextval FROM sys.dual;

36: p_OBJECT_VERSION_NUMBER NUMBER
37: )
38:
39: IS
40: CURSOR C2 IS SELECT ASO_QUOTE_LINE_ATTRIBS_EXT_S.nextval FROM sys.dual;
41: BEGIN
42: If (px_LINE_ATTRIBUTE_ID IS NULL) OR (px_LINE_ATTRIBUTE_ID = FND_API.G_MISS_NUM) then
43: OPEN C2;
44: FETCH C2 INTO px_LINE_ATTRIBUTE_ID;

Line 47: INSERT INTO ASO_QUOTE_LINE_ATTRIBS_EXT(

43: OPEN C2;
44: FETCH C2 INTO px_LINE_ATTRIBUTE_ID;
45: CLOSE C2;
46: End If;
47: INSERT INTO ASO_QUOTE_LINE_ATTRIBS_EXT(
48: LINE_ATTRIBUTE_ID,
49: CREATION_DATE,
50: CREATED_BY,
51: LAST_UPDATE_DATE,

Line 123: Update ASO_QUOTE_LINE_ATTRIBS_EXT

119: )
120:
121: IS
122: BEGIN
123: Update ASO_QUOTE_LINE_ATTRIBS_EXT
124: SET
125: /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
126: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
127: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 158: DELETE FROM ASO_QUOTE_LINE_ATTRIBS_EXT

154: PROCEDURE Delete_Row(
155: p_LINE_ATTRIB_ID NUMBER)
156: IS
157: BEGIN
158: DELETE FROM ASO_QUOTE_LINE_ATTRIBS_EXT
159: WHERE LINE_ATTRIBUTE_ID = p_LINE_ATTRIB_ID;
160: If (SQL%NOTFOUND) then
161: RAISE NO_DATA_FOUND;
162: End If;

Line 171: DELETE FROM ASO_QUOTE_LINE_ATTRIBS_EXT

167: PROCEDURE Delete_Row(
168: p_QUOTE_LINE_ID NUMBER)
169: IS
170: BEGIN
171: DELETE FROM ASO_QUOTE_LINE_ATTRIBS_EXT
172: WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
173: If (SQL%NOTFOUND) then
174: RAISE NO_DATA_FOUND;
175: End If;

Line 227: FROM ASO_QUOTE_LINE_ATTRIBS_EXT

223: VALUE,
224: VALUE_TYPE,
225: START_DATE_ACTIVE,
226: END_DATE_ACTIVE
227: FROM ASO_QUOTE_LINE_ATTRIBS_EXT
228: WHERE LINE_ATTRIBUTE_ID = p_LINE_ATTRIBUTE_ID
229: FOR UPDATE of LINE_ATTRIBUTE_ID NOWAIT;
230: Recinfo C%ROWTYPE;
231: BEGIN

Line 320: End ASO_QUOTE_LINE_ATTRIBS_EXT_PKG;

316: APP_EXCEPTION.RAISE_EXCEPTION;
317: End If;
318: END Lock_Row;
319:
320: End ASO_QUOTE_LINE_ATTRIBS_EXT_PKG;