APPS.ASO_PARTY_RELATIONSHIPS_PKG dependencies on ASO_PARTY_RELATIONSHIPS

Line 1: PACKAGE BODY ASO_PARTY_RELATIONSHIPS_PKG as

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

Line 4: -- Package name : ASO_PARTY_RELATIONSHIPS_PKG

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

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

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

Line 34: CURSOR C2 IS SELECT ASO_PARTY_RELATIONSHIPS_S.nextval FROM sys.dual;

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

Line 41: INSERT INTO ASO_PARTY_RELATIONSHIPS(

37: OPEN C2;
38: FETCH C2 INTO px_PARTY_RELATIONSHIP_ID;
39: CLOSE C2;
40: End If;
41: INSERT INTO ASO_PARTY_RELATIONSHIPS(
42: PARTY_RELATIONSHIP_ID
43: , CREATION_DATE
44: , CREATED_BY
45: , LAST_UPDATE_DATE

Line 99: Update ASO_PARTY_RELATIONSHIPS

95: )
96:
97: IS
98: BEGIN
99: Update ASO_PARTY_RELATIONSHIPS
100: SET
101: CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
102: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
103: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 127: DELETE FROM ASO_PARTY_RELATIONSHIPS

123: PROCEDURE Delete_Row(
124: p_PARTY_RELATIONSHIP_ID NUMBER)
125: IS
126: BEGIN
127: DELETE FROM ASO_PARTY_RELATIONSHIPS
128: WHERE PARTY_RELATIONSHIP_ID = p_PARTY_RELATIONSHIP_ID;
129: If (SQL%NOTFOUND) then
130: RAISE NO_DATA_FOUND;
131: End If;

Line 170: FROM ASO_PARTY_RELATIONSHIPS

166: QUOTE_LINE_ID,
167: OBJECT_TYPE_CODE,
168: OBJECT_ID,
169: RELATIONSHIP_TYPE_CODE
170: FROM ASO_PARTY_RELATIONSHIPS
171: WHERE PARTY_RELATIONSHIP_ID = p_PARTY_RELATIONSHIP_ID
172: FOR UPDATE of PARTY_RELATIONSHIP_ID NOWAIT;
173: Recinfo C%ROWTYPE;
174: BEGIN

Line 261: End ASO_PARTY_RELATIONSHIPS_PKG;

257: APP_EXCEPTION.RAISE_EXCEPTION;
258: End If;
259: END Lock_Row;
260:
261: End ASO_PARTY_RELATIONSHIPS_PKG;