APPS.OKE_TERMS_PKG dependencies on OKE_TERMS_B

Line 21: select ROWID from OKE_TERMS_B

17: , X_LAST_UPDATE_LOGIN IN NUMBER
18: ) IS
19:
20: cursor C is
21: select ROWID from OKE_TERMS_B
22: where TERM_CODE = X_TERM_CODE;
23:
24: BEGIN
25:

Line 26: INSERT INTO OKE_TERMS_B

22: where TERM_CODE = X_TERM_CODE;
23:
24: BEGIN
25:
26: INSERT INTO OKE_TERMS_B
27: ( TERM_CODE
28: , TERM_TYPE_CODE
29: , CREATION_DATE
30: , CREATED_BY

Line 108: FROM OKE_TERMS_B

104: SELECT TERM_TYPE_CODE
105: , USER_DEFINED_FLAG
106: , VIEW_APPLICATION_ID
107: , LOOKUP_TYPE
108: FROM OKE_TERMS_B
109: WHERE TERM_CODE = X_TERM_CODE
110: FOR UPDATE OF TERM_CODE NOWAIT;
111: RecInfo c%rowtype;
112:

Line 185: UPDATE OKE_TERMS_B

181: ) IS
182:
183: BEGIN
184:
185: UPDATE OKE_TERMS_B
186: SET TERM_TYPE_CODE = X_TERM_TYPE_CODE
187: , USER_DEFINED_FLAG = X_USER_DEFINED_FLAG
188: , VIEW_APPLICATION_ID = X_VIEW_APPL_ID
189: , LOOKUP_TYPE = X_LOOKUP_TYPE

Line 228: DELETE FROM OKE_TERMS_B

224: IF (sql%notfound) THEN
225: RAISE no_data_found;
226: END IF;
227:
228: DELETE FROM OKE_TERMS_B
229: WHERE TERM_CODE = X_TERM_CODE;
230:
231: IF (sql%notfound) THEN
232: RAISE no_data_found;

Line 245: FROM OKE_TERMS_B B

241:
242: DELETE FROM OKE_TERMS_TL T
243: WHERE NOT EXISTS (
244: SELECT NULL
245: FROM OKE_TERMS_B B
246: WHERE B.TERM_CODE = T.TERM_CODE
247: );
248:
249: UPDATE OKE_TERMS_TL T

Line 335: UPDATE OKE_TERMS_B

331:
332: --
333: -- Load the record
334: --
335: UPDATE OKE_TERMS_B
336: SET TERM_TYPE_CODE = NVL(X_TERM_TYPE_CODE , TERM_TYPE_CODE)
337: , USER_DEFINED_FLAG = X_USER_DEFINED_FLAG
338: , VIEW_APPLICATION_ID = X_VIEW_APPL_ID
339: , LOOKUP_TYPE = X_LOOKUP_TYPE