APPS.AHL_UE_RELATIONSHIPS_PKG dependencies on AHL_UE_RELATIONSHIPS

Line 1: package body AHL_UE_RELATIONSHIPS_PKG as

1: package body AHL_UE_RELATIONSHIPS_PKG as
2: /* $Header: AHLLUERB.pls 115.1 2002/12/04 22:38:15 sracha noship $ */
3:
4: procedure INSERT_ROW (
5: X_UE_RELATIONSHIP_ID IN OUT NOCOPY NUMBER,

Line 34: cursor C is select ROWID from AHL_UE_RELATIONSHIPS

30: X_CREATED_BY IN NUMBER,
31: X_LAST_UPDATE_LOGIN IN NUMBER
32: ) is
33:
34: cursor C is select ROWID from AHL_UE_RELATIONSHIPS
35: where UE_RELATIONSHIP_ID = X_UE_RELATIONSHIP_ID
36: ;
37:
38: l_ROWID ROWID;

Line 41: insert into AHL_UE_RELATIONSHIPS (

37:
38: l_ROWID ROWID;
39:
40: begin
41: insert into AHL_UE_RELATIONSHIPS (
42: UE_RELATIONSHIP_ID,
43: UE_ID,
44: RELATED_UE_ID,
45: RELATIONSHIP_CODE,

Line 70: AHL_UE_RELATIONSHIPS_S.NEXTVAL,

66: CREATION_DATE,
67: CREATED_BY,
68: LAST_UPDATE_LOGIN
69: ) values (
70: AHL_UE_RELATIONSHIPS_S.NEXTVAL,
71: X_UE_ID,
72: X_RELATED_UE_ID,
73: X_RELATIONSHIP_CODE,
74: X_ORIGINATOR_UE_ID,

Line 140: update AHL_UE_RELATIONSHIPS set

136: X_LAST_UPDATE_LOGIN IN NUMBER
137: ) is
138:
139: begin
140: update AHL_UE_RELATIONSHIPS set
141: UE_ID = X_UE_ID,
142: RELATED_UE_ID = X_RELATED_UE_ID,
143: RELATIONSHIP_CODE = X_RELATIONSHIP_CODE,
144: ORIGINATOR_UE_ID = X_ORIGINATOR_UE_ID,

Line 180: delete from AHL_UE_RELATIONSHIPS

176: ) is
177:
178: begin
179:
180: delete from AHL_UE_RELATIONSHIPS
181: where UE_RELATIONSHIP_ID = X_UE_RELATIONSHIP_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 189: END AHL_UE_RELATIONSHIPS_PKG;

185: end if;
186:
187: end DELETE_ROW;
188:
189: END AHL_UE_RELATIONSHIPS_PKG;