APPS.OKC_REP_RELATIONSHIPS_PKG dependencies on OKC_REP_RELATIONSHIPS_B

Line 19: cursor C is select ROWID from OKC_REP_RELATIONSHIPS_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from OKC_REP_RELATIONSHIPS_B
20: where RELATIONSHIP_ROLE1_ID = X_RELATIONSHIP_ROLE1_ID
21: ;
22: begin
23: insert into OKC_REP_RELATIONSHIPS_B (

Line 23: insert into OKC_REP_RELATIONSHIPS_B (

19: cursor C is select ROWID from OKC_REP_RELATIONSHIPS_B
20: where RELATIONSHIP_ROLE1_ID = X_RELATIONSHIP_ROLE1_ID
21: ;
22: begin
23: insert into OKC_REP_RELATIONSHIPS_B (
24: DIRECTION,
25: OBJECT_VERSION_NUMBER,
26: RELATIONSHIP_ROLE1_ID,
27: RELATIONSHIP_ROLE2_ID,

Line 104: from OKC_REP_RELATIONSHIPS_B

100: DIRECTION,
101: OBJECT_VERSION_NUMBER,
102: RELATIONSHIP_ROLE2_ID,
103: DISABLED_FLAG
104: from OKC_REP_RELATIONSHIPS_B
105: where RELATIONSHIP_ROLE1_ID = X_RELATIONSHIP_ROLE1_ID
106: for update of RELATIONSHIP_ROLE1_ID nowait;
107: recinfo c%rowtype;
108:

Line 169: update OKC_REP_RELATIONSHIPS_B set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update OKC_REP_RELATIONSHIPS_B set
170: DIRECTION = X_DIRECTION,
171: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
172: RELATIONSHIP_ROLE2_ID = X_RELATIONSHIP_ROLE2_ID,
173: DISABLED_FLAG = X_DISABLED_FLAG,

Line 210: delete from OKC_REP_RELATIONSHIPS_B

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: delete from OKC_REP_RELATIONSHIPS_B
211: where RELATIONSHIP_ROLE1_ID = X_RELATIONSHIP_ROLE1_ID;
212:
213: if (sql%notfound) then
214: raise no_data_found;

Line 224: from OKC_REP_RELATIONSHIPS_B B

220: begin
221: delete from OKC_REP_RELATIONSHIPS_TL T
222: where not exists
223: (select NULL
224: from OKC_REP_RELATIONSHIPS_B B
225: where B.RELATIONSHIP_ROLE1_ID = T.RELATIONSHIP_ROLE1_ID
226: );
227:
228: update OKC_REP_RELATIONSHIPS_TL T set (