APPS.ASO_QUOTE_RELATED_OBJECTS_PKG dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 1: PACKAGE BODY ASO_QUOTE_RELATED_OBJECTS_PKG as

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

Line 4: -- Package name : ASO_QUOTE_RELATED_OBJECTS_PKG

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

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

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

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

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

Line 43: INSERT INTO ASO_QUOTE_RELATED_OBJECTS(

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

Line 105: Update ASO_QUOTE_RELATED_OBJECTS

101: -- p_QUOTE_OBJECT_CODE NUMBER)
102:
103: IS
104: BEGIN
105: Update ASO_QUOTE_RELATED_OBJECTS
106: SET
107: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
108: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
109: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 134: DELETE FROM ASO_QUOTE_RELATED_OBJECTS

130: PROCEDURE Delete_Row(
131: p_RELATED_OBJECT_ID NUMBER)
132: IS
133: BEGIN
134: DELETE FROM ASO_QUOTE_RELATED_OBJECTS
135: WHERE RELATED_OBJECT_ID = p_RELATED_OBJECT_ID;
136: If (SQL%NOTFOUND) then
137: RAISE NO_DATA_FOUND;
138: End If;

Line 180: FROM ASO_QUOTE_RELATED_OBJECTS

176: OBJECT_TYPE_CODE,
177: OBJECT_ID,
178: RELATIONSHIP_TYPE_CODE,
179: RECIPROCAL_FLAG
180: FROM ASO_QUOTE_RELATED_OBJECTS
181: WHERE RELATED_OBJECT_ID = p_RELATED_OBJECT_ID
182: FOR UPDATE of RELATED_OBJECT_ID NOWAIT;
183: Recinfo C%ROWTYPE;
184: BEGIN

Line 260: End ASO_QUOTE_RELATED_OBJECTS_PKG;

256: APP_EXCEPTION.RAISE_EXCEPTION;
257: End If;
258: END Lock_Row;
259:
260: End ASO_QUOTE_RELATED_OBJECTS_PKG;