APPS.OKE_HOLD_STATUSES_PKG dependencies on OKE_HOLD_STATUSES_B

Line 34: cursor C is select ROWID from OKE_HOLD_STATUSES_B

30: , X_ATTRIBUTE13 in VARCHAR2
31: , X_ATTRIBUTE14 in VARCHAR2
32: , X_ATTRIBUTE15 in VARCHAR2
33: ) is
34: cursor C is select ROWID from OKE_HOLD_STATUSES_B
35: where HOLD_STATUS_CODE = X_HOLD_STATUS_CODE
36: ;
37: begin
38: insert into OKE_HOLD_STATUSES_B (

Line 38: insert into OKE_HOLD_STATUSES_B (

34: cursor C is select ROWID from OKE_HOLD_STATUSES_B
35: where HOLD_STATUS_CODE = X_HOLD_STATUS_CODE
36: ;
37: begin
38: insert into OKE_HOLD_STATUSES_B (
39: HOLD_STATUS_CODE
40: , CREATION_DATE
41: , CREATED_BY
42: , LAST_UPDATE_DATE

Line 182: from OKE_HOLD_STATUSES_B

178: , ATTRIBUTE12
179: , ATTRIBUTE13
180: , ATTRIBUTE14
181: , ATTRIBUTE15
182: from OKE_HOLD_STATUSES_B
183: where HOLD_STATUS_CODE = X_HOLD_STATUS_CODE
184: for update of HOLD_STATUS_CODE nowait;
185: recinfo c%rowtype;
186:

Line 302: update OKE_HOLD_STATUSES_B set

298: , X_ATTRIBUTE14 in VARCHAR2
299: , X_ATTRIBUTE15 in VARCHAR2
300: ) is
301: begin
302: update OKE_HOLD_STATUSES_B set
303: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
304: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
305: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
306: , WF_ITEM_TYPE = X_WF_ITEM_TYPE

Line 355: from OKE_HOLD_STATUSES_B B

351: begin
352: delete from OKE_HOLD_STATUSES_TL T
353: where not exists
354: (select NULL
355: from OKE_HOLD_STATUSES_B B
356: where B.HOLD_STATUS_CODE = T.HOLD_STATUS_CODE
357: );
358:
359: update OKE_HOLD_STATUSES_TL T set (