APPS.ASO_HEADER_RELATIONSHIPS_PKG dependencies on ASO_HEADER_RELATIONSHIPS

Line 1: PACKAGE BODY ASO_HEADER_RELATIONSHIPS_PKG as

1: PACKAGE BODY ASO_HEADER_RELATIONSHIPS_PKG as
2: /* $Header: asothedb.pls 120.1 2005/06/29 12:38:57 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_HEADER_RELATIONSHIPS_PKG
5: -- Purpose :

Line 4: -- Package name : ASO_HEADER_RELATIONSHIPS_PKG

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

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

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

Line 33: CURSOR C2 IS SELECT ASO_HEADER_RELATIONSHIPS_S.nextval FROM sys.dual;

29: p_OBJECT_VERSION_NUMBER NUMBER
30: )
31:
32: IS
33: CURSOR C2 IS SELECT ASO_HEADER_RELATIONSHIPS_S.nextval FROM sys.dual;
34: BEGIN
35: If (px_HEADER_RELATIONSHIP_ID IS NULL) OR (px_HEADER_RELATIONSHIP_ID = FND_API.G_MISS_NUM) then
36: OPEN C2;
37: FETCH C2 INTO px_HEADER_RELATIONSHIP_ID;

Line 40: INSERT INTO ASO_HEADER_RELATIONSHIPS(

36: OPEN C2;
37: FETCH C2 INTO px_HEADER_RELATIONSHIP_ID;
38: CLOSE C2;
39: End If;
40: INSERT INTO ASO_HEADER_RELATIONSHIPS(
41: HEADER_RELATIONSHIP_ID,
42: CREATION_DATE,
43: CREATED_BY,
44: LAST_UPDATE_DATE,

Line 95: Update ASO_HEADER_RELATIONSHIPS

91: )
92:
93: IS
94: BEGIN
95: Update ASO_HEADER_RELATIONSHIPS
96: SET
97: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
98: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
99: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 122: DELETE FROM ASO_HEADER_RELATIONSHIPS

118: PROCEDURE Delete_Row(
119: p_HEADER_RELATIONSHIP_ID NUMBER)
120: IS
121: BEGIN
122: DELETE FROM ASO_HEADER_RELATIONSHIPS
123: WHERE HEADER_RELATIONSHIP_ID = p_HEADER_RELATIONSHIP_ID;
124: If (SQL%NOTFOUND) then
125: RAISE NO_DATA_FOUND;
126: End If;

Line 163: FROM ASO_HEADER_RELATIONSHIPS

159: QUOTE_HEADER_ID,
160: RELATED_HEADER_ID,
161: RELATIONSHIP_TYPE_CODE,
162: RECIPROCAL_FLAG
163: FROM ASO_HEADER_RELATIONSHIPS
164: WHERE HEADER_RELATIONSHIP_ID = p_HEADER_RELATIONSHIP_ID
165: FOR UPDATE of HEADER_RELATIONSHIP_ID NOWAIT;
166: Recinfo C%ROWTYPE;
167: BEGIN

Line 234: End ASO_HEADER_RELATIONSHIPS_PKG;

230: APP_EXCEPTION.RAISE_EXCEPTION;
231: End If;
232: END Lock_Row;
233:
234: End ASO_HEADER_RELATIONSHIPS_PKG;