DBA Data[Home] [Help]

APPS.OKE_K_TYPES_PKG dependencies on OKE_K_TYPES_B

Line 35: cursor C is select ROWID from OKE_K_TYPES_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_K_TYPES_B
36: where K_TYPE_CODE = X_K_TYPE_CODE
37: ;
38:
39: Number_Option_ROWID ROWID;

Line 42: insert into OKE_K_TYPES_B (

38:
39: Number_Option_ROWID ROWID;
40:
41: begin
42: insert into OKE_K_TYPES_B (
43: K_TYPE_CODE
44: , CREATION_DATE
45: , CREATED_BY
46: , LAST_UPDATE_DATE

Line 290: from OKE_K_TYPES_B

286: , ATTRIBUTE12
287: , ATTRIBUTE13
288: , ATTRIBUTE14
289: , ATTRIBUTE15
290: from OKE_K_TYPES_B
291: where K_TYPE_CODE = X_K_TYPE_CODE
292: for update of K_TYPE_CODE nowait;
293: recinfo c%rowtype;
294:

Line 415: update OKE_K_TYPES_B set

411: , X_ATTRIBUTE14 in VARCHAR2
412: , X_ATTRIBUTE15 in VARCHAR2
413: ) is
414: begin
415: update OKE_K_TYPES_B set
416: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
417: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
418: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
419: , TYPE_CLASS_CODE = X_TYPE_CLASS_CODE

Line 687: from OKE_K_TYPES_B B

683: begin
684: delete from OKE_K_TYPES_TL T
685: where not exists
686: (select NULL
687: from OKE_K_TYPES_B B
688: where B.K_TYPE_CODE = T.K_TYPE_CODE
689: );
690:
691: update OKE_K_TYPES_TL T set (