APPS.OKE_COMM_ACTIONS_PKG dependencies on OKE_COMM_ACTIONS_B

Line 35: cursor C is select ROWID from OKE_COMM_ACTIONS_B

31: , X_ATTRIBUTE13 in VARCHAR2
32: , X_ATTRIBUTE14 in VARCHAR2
33: , X_ATTRIBUTE15 in VARCHAR2
34: ) is
35: cursor C is select ROWID from OKE_COMM_ACTIONS_B
36: where COMM_ACTION_CODE = X_COMM_ACTION_CODE
37: ;
38: begin
39: insert into OKE_COMM_ACTIONS_B (

Line 39: insert into OKE_COMM_ACTIONS_B (

35: cursor C is select ROWID from OKE_COMM_ACTIONS_B
36: where COMM_ACTION_CODE = X_COMM_ACTION_CODE
37: ;
38: begin
39: insert into OKE_COMM_ACTIONS_B (
40: COMM_ACTION_CODE
41: , CREATION_DATE
42: , CREATED_BY
43: , LAST_UPDATE_DATE

Line 187: from OKE_COMM_ACTIONS_B

183: , ATTRIBUTE12
184: , ATTRIBUTE13
185: , ATTRIBUTE14
186: , ATTRIBUTE15
187: from OKE_COMM_ACTIONS_B
188: where COMM_ACTION_CODE = X_COMM_ACTION_CODE
189: for update of COMM_ACTION_CODE nowait;
190: recinfo c%rowtype;
191:

Line 310: update OKE_COMM_ACTIONS_B set

306: , X_ATTRIBUTE14 in VARCHAR2
307: , X_ATTRIBUTE15 in VARCHAR2
308: ) is
309: begin
310: update OKE_COMM_ACTIONS_B set
311: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
312: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
313: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
314: , OWNER_ID = X_OWNER_ID

Line 364: from OKE_COMM_ACTIONS_B B

360: begin
361: delete from OKE_COMM_ACTIONS_TL T
362: where not exists
363: (select NULL
364: from OKE_COMM_ACTIONS_B B
365: where B.COMM_ACTION_CODE = T.COMM_ACTION_CODE
366: );
367:
368: update OKE_COMM_ACTIONS_TL T set (