APPS.OKE_CHG_STATUSES_PKG dependencies on OKE_CHG_STATUSES_B

Line 36: cursor C is select ROWID from OKE_CHG_STATUSES_B

32: , X_ATTRIBUTE13 in VARCHAR2
33: , X_ATTRIBUTE14 in VARCHAR2
34: , X_ATTRIBUTE15 in VARCHAR2
35: ) is
36: cursor C is select ROWID from OKE_CHG_STATUSES_B
37: where CHG_STATUS_CODE = X_CHG_STATUS_CODE
38: ;
39: begin
40: insert into OKE_CHG_STATUSES_B (

Line 40: insert into OKE_CHG_STATUSES_B (

36: cursor C is select ROWID from OKE_CHG_STATUSES_B
37: where CHG_STATUS_CODE = X_CHG_STATUS_CODE
38: ;
39: begin
40: insert into OKE_CHG_STATUSES_B (
41: CHG_STATUS_CODE
42: , CREATION_DATE
43: , CREATED_BY
44: , LAST_UPDATE_DATE

Line 192: from OKE_CHG_STATUSES_B

188: , ATTRIBUTE12
189: , ATTRIBUTE13
190: , ATTRIBUTE14
191: , ATTRIBUTE15
192: from OKE_CHG_STATUSES_B
193: where CHG_STATUS_CODE = X_CHG_STATUS_CODE
194: for update of CHG_STATUS_CODE nowait;
195: recinfo c%rowtype;
196:

Line 318: update OKE_CHG_STATUSES_B set

314: , X_ATTRIBUTE14 in VARCHAR2
315: , X_ATTRIBUTE15 in VARCHAR2
316: ) is
317: begin
318: update OKE_CHG_STATUSES_B set
319: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
320: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
321: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
322: , CHG_STATUS_TYPE_CODE = X_CHG_STATUS_TYPE_CODE

Line 373: from OKE_CHG_STATUSES_B B

369: begin
370: delete from OKE_CHG_STATUSES_TL T
371: where not exists
372: (select NULL
373: from OKE_CHG_STATUSES_B B
374: where B.CHG_STATUS_CODE = T.CHG_STATUS_CODE
375: );
376:
377: update OKE_CHG_STATUSES_TL T set (