APPS.PRP_TOKENS_PKG dependencies on PRP_TOKENS_TL

Line 113: insert into PRP_TOKENS_TL (

109: X_LAST_UPDATED_BY,
110: X_LAST_UPDATE_LOGIN
111: );
112:
113: insert into PRP_TOKENS_TL (
114: TOKEN_NAME,
115: TOKEN_PROMPT,
116: TOKEN_DESC,
117: CREATED_BY,

Line 141: from PRP_TOKENS_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from PRP_TOKENS_TL T
142: where T.TOKEN_ID = X_TOKEN_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: open c;

Line 224: from PRP_TOKENS_TL

220: TOKEN_NAME,
221: TOKEN_PROMPT,
222: TOKEN_DESC,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from PRP_TOKENS_TL
225: where TOKEN_ID = X_TOKEN_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of TOKEN_ID nowait;
228: begin

Line 382: update PRP_TOKENS_TL set

378: if (sql%notfound) then
379: raise no_data_found;
380: end if;
381:
382: update PRP_TOKENS_TL set
383: TOKEN_NAME = X_TOKEN_NAME,
384: TOKEN_PROMPT = X_TOKEN_PROMPT,
385: TOKEN_DESC = X_TOKEN_DESC,
386: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 402: delete from PRP_TOKENS_TL

398: procedure DELETE_ROW (
399: X_TOKEN_ID in NUMBER
400: ) is
401: begin
402: delete from PRP_TOKENS_TL
403: where TOKEN_ID = X_TOKEN_ID;
404:
405: if (sql%notfound) then
406: raise no_data_found;

Line 420: delete from PRP_TOKENS_TL T

416:
417: procedure ADD_LANGUAGE
418: is
419: begin
420: delete from PRP_TOKENS_TL T
421: where not exists
422: (select NULL
423: from PRP_TOKENS_B B
424: where B.TOKEN_ID = T.TOKEN_ID

Line 427: update PRP_TOKENS_TL T set (

423: from PRP_TOKENS_B B
424: where B.TOKEN_ID = T.TOKEN_ID
425: );
426:
427: update PRP_TOKENS_TL T set (
428: TOKEN_NAME,
429: TOKEN_PROMPT,
430: TOKEN_DESC
431: ) = (select

Line 435: from PRP_TOKENS_TL B

431: ) = (select
432: B.TOKEN_NAME,
433: B.TOKEN_PROMPT,
434: B.TOKEN_DESC
435: from PRP_TOKENS_TL B
436: where B.TOKEN_ID = T.TOKEN_ID
437: and B.LANGUAGE = T.SOURCE_LANG)
438: where (
439: T.TOKEN_ID,

Line 444: from PRP_TOKENS_TL SUBB, PRP_TOKENS_TL SUBT

440: T.LANGUAGE
441: ) in (select
442: SUBT.TOKEN_ID,
443: SUBT.LANGUAGE
444: from PRP_TOKENS_TL SUBB, PRP_TOKENS_TL SUBT
445: where SUBB.TOKEN_ID = SUBT.TOKEN_ID
446: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
447: and (SUBB.TOKEN_NAME <> SUBT.TOKEN_NAME
448: or SUBB.TOKEN_PROMPT <> SUBT.TOKEN_PROMPT

Line 454: insert into PRP_TOKENS_TL (

450: or (SUBB.TOKEN_DESC is null and SUBT.TOKEN_DESC is not null)
451: or (SUBB.TOKEN_DESC is not null and SUBT.TOKEN_DESC is null)
452: ));
453:
454: insert into PRP_TOKENS_TL (
455: TOKEN_NAME,
456: TOKEN_PROMPT,
457: TOKEN_DESC,
458: CREATED_BY,

Line 478: from PRP_TOKENS_TL B, FND_LANGUAGES L

474: B.LAST_UPDATE_LOGIN,
475: B.TOKEN_ID,
476: L.LANGUAGE_CODE,
477: B.SOURCE_LANG
478: from PRP_TOKENS_TL B, FND_LANGUAGES L
479: where L.INSTALLED_FLAG in ('I', 'B')
480: and B.LANGUAGE = userenv('LANG')
481: and not exists
482: (select NULL

Line 483: from PRP_TOKENS_TL T

479: where L.INSTALLED_FLAG in ('I', 'B')
480: and B.LANGUAGE = userenv('LANG')
481: and not exists
482: (select NULL
483: from PRP_TOKENS_TL T
484: where T.TOKEN_ID = B.TOKEN_ID
485: and T.LANGUAGE = L.LANGUAGE_CODE);
486: end ADD_LANGUAGE;
487:

Line 632: UPDATE prp_tokens_tl

628: IS
629: l_login_id NUMBER := 0;
630: BEGIN
631:
632: UPDATE prp_tokens_tl
633: SET token_name = p_token_name,
634: token_prompt = p_token_prompt,
635: token_desc = p_token_desc,
636: last_update_date = sysdate,