APPS.GMP_PROCESS_PARAMETERS_PKG dependencies on GMP_PROCESS_PARAMETERS_TL

Line 147: insert into GMP_PROCESS_PARAMETERS_TL (

143: X_LAST_UPDATED_BY,
144: X_LAST_UPDATE_LOGIN
145: );
146:
147: insert into GMP_PROCESS_PARAMETERS_TL (
148: PARAMETER_DESCRIPTION,
149: CREATION_DATE,
150: CREATED_BY,
151: LAST_UPDATE_DATE,

Line 171: from GMP_PROCESS_PARAMETERS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from GMP_PROCESS_PARAMETERS_TL T
172: where T.PARAMETER_ID = X_PARAMETER_ID
173: and T.LANGUAGE = L.LANGUAGE_CODE);
174:
175: open c;

Line 274: from GMP_PROCESS_PARAMETERS_TL

270:
271: cursor c1 is select
272: PARAMETER_DESCRIPTION,
273: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
274: from GMP_PROCESS_PARAMETERS_TL
275: where PARAMETER_ID = X_PARAMETER_ID
276: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
277: for update of PARAMETER_ID nowait;
278: begin

Line 476: update GMP_PROCESS_PARAMETERS_TL set

472: if (sql%notfound) then
473: raise no_data_found;
474: end if;
475:
476: update GMP_PROCESS_PARAMETERS_TL set
477: PARAMETER_DESCRIPTION = X_PARAMETER_DESCRIPTION,
478: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
479: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
480: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 494: delete from GMP_PROCESS_PARAMETERS_TL

490: procedure DELETE_ROW (
491: X_PARAMETER_ID in NUMBER
492: ) is
493: begin
494: delete from GMP_PROCESS_PARAMETERS_TL
495: where PARAMETER_ID = X_PARAMETER_ID;
496:
497: if (sql%notfound) then
498: raise no_data_found;

Line 512: delete from GMP_PROCESS_PARAMETERS_TL T

508:
509: procedure ADD_LANGUAGE
510: is
511: begin
512: delete from GMP_PROCESS_PARAMETERS_TL T
513: where not exists
514: (select NULL
515: from GMP_PROCESS_PARAMETERS_B B
516: where B.PARAMETER_ID = T.PARAMETER_ID

Line 519: update GMP_PROCESS_PARAMETERS_TL T set (

515: from GMP_PROCESS_PARAMETERS_B B
516: where B.PARAMETER_ID = T.PARAMETER_ID
517: );
518:
519: update GMP_PROCESS_PARAMETERS_TL T set (
520: PARAMETER_DESCRIPTION
521: ) = (select
522: B.PARAMETER_DESCRIPTION
523: from GMP_PROCESS_PARAMETERS_TL B

Line 523: from GMP_PROCESS_PARAMETERS_TL B

519: update GMP_PROCESS_PARAMETERS_TL T set (
520: PARAMETER_DESCRIPTION
521: ) = (select
522: B.PARAMETER_DESCRIPTION
523: from GMP_PROCESS_PARAMETERS_TL B
524: where B.PARAMETER_ID = T.PARAMETER_ID
525: and B.LANGUAGE = T.SOURCE_LANG)
526: where (
527: T.PARAMETER_ID,

Line 532: from GMP_PROCESS_PARAMETERS_TL SUBB, GMP_PROCESS_PARAMETERS_TL SUBT

528: T.LANGUAGE
529: ) in (select
530: SUBT.PARAMETER_ID,
531: SUBT.LANGUAGE
532: from GMP_PROCESS_PARAMETERS_TL SUBB, GMP_PROCESS_PARAMETERS_TL SUBT
533: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
534: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
535: and (SUBB.PARAMETER_DESCRIPTION <> SUBT.PARAMETER_DESCRIPTION
536: or (SUBB.PARAMETER_DESCRIPTION is null and SUBT.PARAMETER_DESCRIPTION is not null)

Line 540: insert into GMP_PROCESS_PARAMETERS_TL (

536: or (SUBB.PARAMETER_DESCRIPTION is null and SUBT.PARAMETER_DESCRIPTION is not null)
537: or (SUBB.PARAMETER_DESCRIPTION is not null and SUBT.PARAMETER_DESCRIPTION is null)
538: ));
539:
540: insert into GMP_PROCESS_PARAMETERS_TL (
541: PARAMETER_DESCRIPTION,
542: CREATION_DATE,
543: CREATED_BY,
544: LAST_UPDATE_DATE,

Line 560: from GMP_PROCESS_PARAMETERS_TL B, FND_LANGUAGES L

556: B.LAST_UPDATE_LOGIN,
557: B.PARAMETER_ID,
558: L.LANGUAGE_CODE,
559: B.SOURCE_LANG
560: from GMP_PROCESS_PARAMETERS_TL B, FND_LANGUAGES L
561: where L.INSTALLED_FLAG in ('I', 'B')
562: and B.LANGUAGE = userenv('LANG')
563: and not exists
564: (select NULL

Line 565: from GMP_PROCESS_PARAMETERS_TL T

561: where L.INSTALLED_FLAG in ('I', 'B')
562: and B.LANGUAGE = userenv('LANG')
563: and not exists
564: (select NULL
565: from GMP_PROCESS_PARAMETERS_TL T
566: where T.PARAMETER_ID = B.PARAMETER_ID
567: and T.LANGUAGE = L.LANGUAGE_CODE);
568: end ADD_LANGUAGE;
569: