APPS.OKE_PRIORITY_CODES_PKG dependencies on OKE_PRIORITY_CODES_B

Line 33: cursor C is select ROWID from OKE_PRIORITY_CODES_B

29: , X_ATTRIBUTE13 in VARCHAR2
30: , X_ATTRIBUTE14 in VARCHAR2
31: , X_ATTRIBUTE15 in VARCHAR2
32: ) is
33: cursor C is select ROWID from OKE_PRIORITY_CODES_B
34: where PRIORITY_CODE = X_PRIORITY_CODE
35: ;
36: begin
37: insert into OKE_PRIORITY_CODES_B (

Line 37: insert into OKE_PRIORITY_CODES_B (

33: cursor C is select ROWID from OKE_PRIORITY_CODES_B
34: where PRIORITY_CODE = X_PRIORITY_CODE
35: ;
36: begin
37: insert into OKE_PRIORITY_CODES_B (
38: PRIORITY_CODE
39: , CREATION_DATE
40: , CREATED_BY
41: , LAST_UPDATE_DATE

Line 177: from OKE_PRIORITY_CODES_B

173: , ATTRIBUTE12
174: , ATTRIBUTE13
175: , ATTRIBUTE14
176: , ATTRIBUTE15
177: from OKE_PRIORITY_CODES_B
178: where PRIORITY_CODE = X_PRIORITY_CODE
179: for update of PRIORITY_CODE nowait;
180: recinfo c%rowtype;
181:

Line 294: update OKE_PRIORITY_CODES_B set

290: , X_ATTRIBUTE14 in VARCHAR2
291: , X_ATTRIBUTE15 in VARCHAR2
292: ) is
293: begin
294: update OKE_PRIORITY_CODES_B set
295: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
296: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
297: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
298: , PRIORITY_TYPE_CODE = X_PRIORITY_TYPE_CODE

Line 346: from OKE_PRIORITY_CODES_B B

342: begin
343: delete from OKE_PRIORITY_CODES_TL T
344: where not exists
345: (select NULL
346: from OKE_PRIORITY_CODES_B B
347: where B.PRIORITY_CODE = T.PRIORITY_CODE
348: );
349:
350: update OKE_PRIORITY_CODES_TL T set (