APPS.ASO_LINE_RELATIONSHIPS_PKG dependencies on ASO_LINE_RELATIONSHIPS

Line 1: PACKAGE BODY ASO_LINE_RELATIONSHIPS_PKG as

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

Line 4: -- Package name : ASO_LINE_RELATIONSHIPS_PKG

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

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

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

Line 32: CURSOR C2 IS SELECT ASO_LINE_RELATIONSHIPS_S.nextval FROM sys.dual;

28: p_RELATIONSHIP_TYPE_CODE VARCHAR2,
29: p_OBJECT_VERSION_NUMBER NUMBER)
30:
31: IS
32: CURSOR C2 IS SELECT ASO_LINE_RELATIONSHIPS_S.nextval FROM sys.dual;
33: BEGIN
34: If (px_LINE_RELATIONSHIP_ID IS NULL) OR (px_LINE_RELATIONSHIP_ID = FND_API.G_MISS_NUM) then
35: OPEN C2;
36: FETCH C2 INTO px_LINE_RELATIONSHIP_ID;

Line 39: INSERT INTO ASO_LINE_RELATIONSHIPS(

35: OPEN C2;
36: FETCH C2 INTO px_LINE_RELATIONSHIP_ID;
37: CLOSE C2;
38: End If;
39: INSERT INTO ASO_LINE_RELATIONSHIPS(
40: LINE_RELATIONSHIP_ID,
41: CREATION_DATE,
42: CREATED_BY,
43: LAST_UPDATED_BY,

Line 93: Update ASO_LINE_RELATIONSHIPS

89: p_OBJECT_VERSION_NUMBER NUMBER)
90:
91: IS
92: BEGIN
93: Update ASO_LINE_RELATIONSHIPS
94: SET
95: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
96: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
97: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 120: DELETE FROM ASO_LINE_RELATIONSHIPS

116: PROCEDURE Delete_Row(
117: p_LINE_RELATIONSHIP_ID NUMBER)
118: IS
119: BEGIN
120: DELETE FROM ASO_LINE_RELATIONSHIPS
121: WHERE LINE_RELATIONSHIP_ID = p_LINE_RELATIONSHIP_ID;
122: If (SQL%NOTFOUND) then
123: RAISE NO_DATA_FOUND;
124: End If;

Line 161: FROM ASO_LINE_RELATIONSHIPS

157: QUOTE_LINE_ID,
158: RELATED_QUOTE_LINE_ID,
159: RELATIONSHIP_TYPE_CODE,
160: RECIPROCAL_FLAG
161: FROM ASO_LINE_RELATIONSHIPS
162: WHERE LINE_RELATIONSHIP_ID = p_LINE_RELATIONSHIP_ID
163: FOR UPDATE of LINE_RELATIONSHIP_ID NOWAIT;
164: Recinfo C%ROWTYPE;
165: BEGIN

Line 232: End ASO_LINE_RELATIONSHIPS_PKG;

228: APP_EXCEPTION.RAISE_EXCEPTION;
229: End If;
230: END Lock_Row;
231:
232: End ASO_LINE_RELATIONSHIPS_PKG;