APPS.GMD_ACTIONS_PVT dependencies on GMD_ACTIONS_TL

Line 135: insert into GMD_ACTIONS_TL (

131: X_LAST_UPDATED_BY,
132: X_LAST_UPDATE_LOGIN
133: );
134:
135: insert into GMD_ACTIONS_TL (
136: ACTION_CODE,
137: ACTION_DESC,
138: CREATION_DATE,
139: CREATED_BY,

Line 159: from GMD_ACTIONS_TL T

155: from FND_LANGUAGES L
156: where L.INSTALLED_FLAG in ('I', 'B')
157: and not exists
158: (select NULL
159: from GMD_ACTIONS_TL T
160: where T.ACTION_CODE = X_ACTION_CODE
161: and T.LANGUAGE = L.LANGUAGE_CODE);
162:
163: open c;

Line 254: from GMD_ACTIONS_TL

250:
251: cursor c1 is select
252: ACTION_DESC,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from GMD_ACTIONS_TL
255: where ACTION_CODE = X_ACTION_CODE
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of ACTION_CODE nowait;
258: begin

Line 440: update GMD_ACTIONS_TL set

436: if (sql%notfound) then
437: raise no_data_found;
438: end if;
439:
440: update GMD_ACTIONS_TL set
441: ACTION_DESC = X_ACTION_DESC,
442: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
443: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
444: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 458: delete from GMD_ACTIONS_TL

454: procedure DELETE_ROW (
455: X_ACTION_CODE in VARCHAR2
456: ) is
457: begin
458: delete from GMD_ACTIONS_TL
459: where ACTION_CODE = X_ACTION_CODE;
460:
461: if (sql%notfound) then
462: raise no_data_found;

Line 476: delete from GMD_ACTIONS_TL T

472:
473: procedure ADD_LANGUAGE
474: is
475: begin
476: delete from GMD_ACTIONS_TL T
477: where not exists
478: (select NULL
479: from GMD_ACTIONS_B B
480: where B.ACTION_CODE = T.ACTION_CODE

Line 483: update GMD_ACTIONS_TL T set (

479: from GMD_ACTIONS_B B
480: where B.ACTION_CODE = T.ACTION_CODE
481: );
482:
483: update GMD_ACTIONS_TL T set (
484: ACTION_DESC
485: ) = (select
486: B.ACTION_DESC
487: from GMD_ACTIONS_TL B

Line 487: from GMD_ACTIONS_TL B

483: update GMD_ACTIONS_TL T set (
484: ACTION_DESC
485: ) = (select
486: B.ACTION_DESC
487: from GMD_ACTIONS_TL B
488: where B.ACTION_CODE = T.ACTION_CODE
489: and B.LANGUAGE = T.SOURCE_LANG)
490: where (
491: T.ACTION_CODE,

Line 496: from GMD_ACTIONS_TL SUBB, GMD_ACTIONS_TL SUBT

492: T.LANGUAGE
493: ) in (select
494: SUBT.ACTION_CODE,
495: SUBT.LANGUAGE
496: from GMD_ACTIONS_TL SUBB, GMD_ACTIONS_TL SUBT
497: where SUBB.ACTION_CODE = SUBT.ACTION_CODE
498: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
499: and (SUBB.ACTION_DESC <> SUBT.ACTION_DESC
500: ));

Line 502: insert into GMD_ACTIONS_TL (

498: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
499: and (SUBB.ACTION_DESC <> SUBT.ACTION_DESC
500: ));
501:
502: insert into GMD_ACTIONS_TL (
503: ACTION_CODE,
504: ACTION_DESC,
505: CREATION_DATE,
506: CREATED_BY,

Line 522: from GMD_ACTIONS_TL B, FND_LANGUAGES L

518: B.LAST_UPDATED_BY,
519: B.LAST_UPDATE_LOGIN,
520: L.LANGUAGE_CODE,
521: B.SOURCE_LANG
522: from GMD_ACTIONS_TL B, FND_LANGUAGES L
523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL

Line 527: from GMD_ACTIONS_TL T

523: where L.INSTALLED_FLAG in ('I', 'B')
524: and B.LANGUAGE = userenv('LANG')
525: and not exists
526: (select NULL
527: from GMD_ACTIONS_TL T
528: where T.ACTION_CODE = B.ACTION_CODE
529: and T.LANGUAGE = L.LANGUAGE_CODE);
530: end ADD_LANGUAGE;
531: