APPS.OKE_APPROVAL_PATHS_PKG dependencies on OKE_APPROVAL_PATHS_TL

Line 65: INSERT INTO OKE_APPROVAL_PATHS_TL

61: , X_LAST_UPDATED_BY
62: , X_LAST_UPDATE_LOGIN
63: );
64:
65: INSERT INTO OKE_APPROVAL_PATHS_TL
66: ( APPROVAL_PATH_ID
67: , CREATION_DATE
68: , CREATED_BY
69: , LAST_UPDATE_DATE

Line 91: FROM OKE_APPROVAL_PATHS_TL T

87: FROM FND_LANGUAGES L
88: WHERE L.INSTALLED_FLAG IN ('I', 'B')
89: AND NOT EXISTS
90: (SELECT NULL
91: FROM OKE_APPROVAL_PATHS_TL T
92: WHERE T.APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
93: AND T.LANGUAGE = L.LANGUAGE_CODE);
94:
95: OPEN c;

Line 183: UPDATE OKE_APPROVAL_PATHS_TL

179: RAISE NO_DATA_FOUND;
180: END IF;
181: CLOSE c;
182:
183: UPDATE OKE_APPROVAL_PATHS_TL
184: SET NAME = X_NAME
185: , DESCRIPTION = X_DESCRIPTION
186: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
187: , LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 205: DELETE FROM OKE_APPROVAL_PATHS_TL

201: ( X_APPROVAL_PATH_ID IN NUMBER
202: ) IS
203: BEGIN
204:
205: DELETE FROM OKE_APPROVAL_PATHS_TL
206: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID;
207:
208: IF (sql%notfound) THEN
209: RAISE NO_DATA_FOUND;

Line 329: FROM OKE_APPROVAL_PATHS_TL

325: BEGIN
326:
327: SELECT LAST_UPDATE_DATE , LAST_UPDATED_BY
328: INTO db_ludate , db_luby
329: FROM OKE_APPROVAL_PATHS_TL
330: WHERE APPROVAL_PATH_ID = X_APPROVAL_PATH_ID
331: AND USERENV('LANG') = LANGUAGE;
332:
333: --

Line 347: UPDATE OKE_APPROVAL_PATHS_TL

343: , db_luby
344: , db_ludate
345: , X_CUSTOM_MODE ) ) THEN
346:
347: UPDATE OKE_APPROVAL_PATHS_TL
348: SET NAME = X_NAME
349: , DESCRIPTION = X_DESCRIPTION
350: , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
351: , LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 365: DELETE FROM OKE_APPROVAL_PATHS_TL T

361: PROCEDURE ADD_LANGUAGE
362: IS
363: BEGIN
364:
365: DELETE FROM OKE_APPROVAL_PATHS_TL T
366: WHERE NOT EXISTS (
367: SELECT NULL
368: FROM OKE_APPROVAL_PATHS B
369: WHERE B.APPROVAL_PATH_ID = T.APPROVAL_PATH_ID

Line 372: UPDATE OKE_APPROVAL_PATHS_TL T SET

368: FROM OKE_APPROVAL_PATHS B
369: WHERE B.APPROVAL_PATH_ID = T.APPROVAL_PATH_ID
370: );
371:
372: UPDATE OKE_APPROVAL_PATHS_TL T SET
373: ( NAME , DESCRIPTION ) = (
374: SELECT B.NAME
375: , B.DESCRIPTION
376: FROM OKE_APPROVAL_PATHS_TL B

Line 376: FROM OKE_APPROVAL_PATHS_TL B

372: UPDATE OKE_APPROVAL_PATHS_TL T SET
373: ( NAME , DESCRIPTION ) = (
374: SELECT B.NAME
375: , B.DESCRIPTION
376: FROM OKE_APPROVAL_PATHS_TL B
377: WHERE B.APPROVAL_PATH_ID = T.APPROVAL_PATH_ID
378: AND B.LANGUAGE = T.SOURCE_LANG)
379: WHERE ( T.APPROVAL_PATH_ID , T.LANGUAGE ) IN (
380: SELECT SUBT.APPROVAL_PATH_ID

Line 382: FROM OKE_APPROVAL_PATHS_TL SUBB

378: AND B.LANGUAGE = T.SOURCE_LANG)
379: WHERE ( T.APPROVAL_PATH_ID , T.LANGUAGE ) IN (
380: SELECT SUBT.APPROVAL_PATH_ID
381: , SUBT.LANGUAGE
382: FROM OKE_APPROVAL_PATHS_TL SUBB
383: , OKE_APPROVAL_PATHS_TL SUBT
384: WHERE SUBB.APPROVAL_PATH_ID = SUBT.APPROVAL_PATH_ID
385: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
386: AND (SUBB.NAME <> SUBT.NAME

Line 383: , OKE_APPROVAL_PATHS_TL SUBT

379: WHERE ( T.APPROVAL_PATH_ID , T.LANGUAGE ) IN (
380: SELECT SUBT.APPROVAL_PATH_ID
381: , SUBT.LANGUAGE
382: FROM OKE_APPROVAL_PATHS_TL SUBB
383: , OKE_APPROVAL_PATHS_TL SUBT
384: WHERE SUBB.APPROVAL_PATH_ID = SUBT.APPROVAL_PATH_ID
385: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
386: AND (SUBB.NAME <> SUBT.NAME
387: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION )

Line 390: INSERT INTO OKE_APPROVAL_PATHS_TL

386: AND (SUBB.NAME <> SUBT.NAME
387: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION )
388: );
389:
390: INSERT INTO OKE_APPROVAL_PATHS_TL
391: ( APPROVAL_PATH_ID
392: , CREATION_DATE
393: , CREATED_BY
394: , LAST_UPDATE_DATE

Line 412: FROM OKE_APPROVAL_PATHS_TL B, FND_LANGUAGES L

408: , B.NAME
409: , B.DESCRIPTION
410: , L.LANGUAGE_CODE
411: , B.SOURCE_LANG
412: FROM OKE_APPROVAL_PATHS_TL B, FND_LANGUAGES L
413: WHERE L.INSTALLED_FLAG IN ('I', 'B')
414: AND B.LANGUAGE = USERENV('LANG')
415: AND NOT EXISTS (
416: SELECT NULL

Line 417: FROM OKE_APPROVAL_PATHS_TL T

413: WHERE L.INSTALLED_FLAG IN ('I', 'B')
414: AND B.LANGUAGE = USERENV('LANG')
415: AND NOT EXISTS (
416: SELECT NULL
417: FROM OKE_APPROVAL_PATHS_TL T
418: WHERE T.APPROVAL_PATH_ID = B.APPROVAL_PATH_ID
419: AND T.LANGUAGE = L.LANGUAGE_CODE
420: );
421: