APPS.GMD_STORAGE_PLANS_PKG dependencies on GMD_STORAGE_PLANS_TL

Line 138: insert into GMD_STORAGE_PLANS_TL (

134: X_LAST_UPDATED_BY,
135: X_LAST_UPDATE_LOGIN
136: );
137:
138: insert into GMD_STORAGE_PLANS_TL (
139: STORAGE_PLAN_ID,
140: DESCRIPTION,
141: CREATION_DATE,
142: CREATED_BY,

Line 162: from GMD_STORAGE_PLANS_TL T

158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from GMD_STORAGE_PLANS_TL T
163: where T.STORAGE_PLAN_ID = X_STORAGE_PLAN_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165:
166: open c;

Line 259: from GMD_STORAGE_PLANS_TL

255:
256: cursor c1 is select
257: DESCRIPTION,
258: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
259: from GMD_STORAGE_PLANS_TL
260: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID
261: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
262: for update of STORAGE_PLAN_ID nowait;
263: begin

Line 448: update GMD_STORAGE_PLANS_TL set

444: if (sql%notfound) then
445: raise no_data_found;
446: end if;
447:
448: update GMD_STORAGE_PLANS_TL set
449: DESCRIPTION = X_DESCRIPTION,
450: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
451: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
452: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 466: delete from GMD_STORAGE_PLANS_TL

462: procedure DELETE_ROW (
463: X_STORAGE_PLAN_ID in NUMBER
464: ) is
465: begin
466: delete from GMD_STORAGE_PLANS_TL
467: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID;
468:
469: if (sql%notfound) then
470: raise no_data_found;

Line 484: delete from GMD_STORAGE_PLANS_TL T

480:
481: procedure ADD_LANGUAGE
482: is
483: begin
484: delete from GMD_STORAGE_PLANS_TL T
485: where not exists
486: (select NULL
487: from GMD_STORAGE_PLANS_B B
488: where B.STORAGE_PLAN_ID = T.STORAGE_PLAN_ID

Line 491: update GMD_STORAGE_PLANS_TL T set (

487: from GMD_STORAGE_PLANS_B B
488: where B.STORAGE_PLAN_ID = T.STORAGE_PLAN_ID
489: );
490:
491: update GMD_STORAGE_PLANS_TL T set (
492: DESCRIPTION
493: ) = (select
494: B.DESCRIPTION
495: from GMD_STORAGE_PLANS_TL B

Line 495: from GMD_STORAGE_PLANS_TL B

491: update GMD_STORAGE_PLANS_TL T set (
492: DESCRIPTION
493: ) = (select
494: B.DESCRIPTION
495: from GMD_STORAGE_PLANS_TL B
496: where B.STORAGE_PLAN_ID = T.STORAGE_PLAN_ID
497: and B.LANGUAGE = T.SOURCE_LANG)
498: where (
499: T.STORAGE_PLAN_ID,

Line 504: from GMD_STORAGE_PLANS_TL SUBB, GMD_STORAGE_PLANS_TL SUBT

500: T.LANGUAGE
501: ) in (select
502: SUBT.STORAGE_PLAN_ID,
503: SUBT.LANGUAGE
504: from GMD_STORAGE_PLANS_TL SUBB, GMD_STORAGE_PLANS_TL SUBT
505: where SUBB.STORAGE_PLAN_ID = SUBT.STORAGE_PLAN_ID
506: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
507: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
508: ));

Line 510: insert into GMD_STORAGE_PLANS_TL (

506: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
507: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
508: ));
509:
510: insert into GMD_STORAGE_PLANS_TL (
511: STORAGE_PLAN_ID,
512: DESCRIPTION,
513: CREATION_DATE,
514: CREATED_BY,

Line 530: from GMD_STORAGE_PLANS_TL B, FND_LANGUAGES L

526: B.LAST_UPDATE_DATE,
527: B.LAST_UPDATE_LOGIN,
528: L.LANGUAGE_CODE,
529: B.SOURCE_LANG
530: from GMD_STORAGE_PLANS_TL B, FND_LANGUAGES L
531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL

Line 535: from GMD_STORAGE_PLANS_TL T

531: where L.INSTALLED_FLAG in ('I', 'B')
532: and B.LANGUAGE = userenv('LANG')
533: and not exists
534: (select NULL
535: from GMD_STORAGE_PLANS_TL T
536: where T.STORAGE_PLAN_ID = B.STORAGE_PLAN_ID
537: and T.LANGUAGE = L.LANGUAGE_CODE);
538: end ADD_LANGUAGE;
539: