APPS.GMD_SAMPLING_PLANS_PVT dependencies on GMD_SAMPLING_PLANS_TL

Line 165: insert into GMD_SAMPLING_PLANS_TL (

161: X_LAST_UPDATED_BY,
162: X_LAST_UPDATE_LOGIN
163: );
164:
165: insert into GMD_SAMPLING_PLANS_TL (
166: SAMPLING_PLAN_ID,
167: LAST_UPDATE_DATE,
168: LAST_UPDATE_LOGIN,
169: SAMPLING_PLAN_DESC,

Line 189: from GMD_SAMPLING_PLANS_TL T

185: from FND_LANGUAGES L
186: where L.INSTALLED_FLAG in ('I', 'B')
187: and not exists
188: (select NULL
189: from GMD_SAMPLING_PLANS_TL T
190: where T.SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID
191: and T.LANGUAGE = L.LANGUAGE_CODE);
192:
193: open c;

Line 304: from GMD_SAMPLING_PLANS_TL

300:
301: cursor c1 is select
302: SAMPLING_PLAN_DESC,
303: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
304: from GMD_SAMPLING_PLANS_TL
305: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID
306: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
307: for update of SAMPLING_PLAN_ID nowait;
308: begin

Line 530: update GMD_SAMPLING_PLANS_TL set

526: if (sql%notfound) then
527: raise no_data_found;
528: end if;
529:
530: update GMD_SAMPLING_PLANS_TL set
531: SAMPLING_PLAN_DESC = X_SAMPLING_PLAN_DESC,
532: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
533: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
534: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 548: delete from GMD_SAMPLING_PLANS_TL

544: procedure DELETE_ROW (
545: X_SAMPLING_PLAN_ID in NUMBER
546: ) is
547: begin
548: delete from GMD_SAMPLING_PLANS_TL
549: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID;
550:
551: if (sql%notfound) then
552: raise no_data_found;

Line 566: delete from GMD_SAMPLING_PLANS_TL T

562:
563: procedure ADD_LANGUAGE
564: is
565: begin
566: delete from GMD_SAMPLING_PLANS_TL T
567: where not exists
568: (select NULL
569: from GMD_SAMPLING_PLANS_B B
570: where B.SAMPLING_PLAN_ID = T.SAMPLING_PLAN_ID

Line 573: update GMD_SAMPLING_PLANS_TL T set (

569: from GMD_SAMPLING_PLANS_B B
570: where B.SAMPLING_PLAN_ID = T.SAMPLING_PLAN_ID
571: );
572:
573: update GMD_SAMPLING_PLANS_TL T set (
574: SAMPLING_PLAN_DESC
575: ) = (select
576: B.SAMPLING_PLAN_DESC
577: from GMD_SAMPLING_PLANS_TL B

Line 577: from GMD_SAMPLING_PLANS_TL B

573: update GMD_SAMPLING_PLANS_TL T set (
574: SAMPLING_PLAN_DESC
575: ) = (select
576: B.SAMPLING_PLAN_DESC
577: from GMD_SAMPLING_PLANS_TL B
578: where B.SAMPLING_PLAN_ID = T.SAMPLING_PLAN_ID
579: and B.LANGUAGE = T.SOURCE_LANG)
580: where (
581: T.SAMPLING_PLAN_ID,

Line 586: from GMD_SAMPLING_PLANS_TL SUBB, GMD_SAMPLING_PLANS_TL SUBT

582: T.LANGUAGE
583: ) in (select
584: SUBT.SAMPLING_PLAN_ID,
585: SUBT.LANGUAGE
586: from GMD_SAMPLING_PLANS_TL SUBB, GMD_SAMPLING_PLANS_TL SUBT
587: where SUBB.SAMPLING_PLAN_ID = SUBT.SAMPLING_PLAN_ID
588: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
589: and (SUBB.SAMPLING_PLAN_DESC <> SUBT.SAMPLING_PLAN_DESC
590: ));

Line 592: insert into GMD_SAMPLING_PLANS_TL (

588: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
589: and (SUBB.SAMPLING_PLAN_DESC <> SUBT.SAMPLING_PLAN_DESC
590: ));
591:
592: insert into GMD_SAMPLING_PLANS_TL (
593: SAMPLING_PLAN_ID,
594: LAST_UPDATE_DATE,
595: LAST_UPDATE_LOGIN,
596: SAMPLING_PLAN_DESC,

Line 612: from GMD_SAMPLING_PLANS_TL B, FND_LANGUAGES L

608: B.CREATED_BY,
609: B.LAST_UPDATED_BY,
610: L.LANGUAGE_CODE,
611: B.SOURCE_LANG
612: from GMD_SAMPLING_PLANS_TL B, FND_LANGUAGES L
613: where L.INSTALLED_FLAG in ('I', 'B')
614: and B.LANGUAGE = userenv('LANG')
615: and not exists
616: (select NULL

Line 617: from GMD_SAMPLING_PLANS_TL T

613: where L.INSTALLED_FLAG in ('I', 'B')
614: and B.LANGUAGE = userenv('LANG')
615: and not exists
616: (select NULL
617: from GMD_SAMPLING_PLANS_TL T
618: where T.SAMPLING_PLAN_ID = B.SAMPLING_PLAN_ID
619: and T.LANGUAGE = L.LANGUAGE_CODE);
620: end ADD_LANGUAGE;
621: