APPS.GMD_OPERATIONS_PKG dependencies on GMD_OPERATIONS_TL

Line 162: insert into GMD_OPERATIONS_TL (

158: X_LAST_UPDATED_BY,
159: X_LAST_UPDATE_LOGIN
160: );
161:
162: insert into GMD_OPERATIONS_TL (
163: LAST_UPDATE_LOGIN,
164: LAST_UPDATE_DATE,
165: LAST_UPDATED_BY,
166: OPRN_ID,

Line 186: from GMD_OPERATIONS_TL T

182: from FND_LANGUAGES L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: and not exists
185: (select NULL
186: from GMD_OPERATIONS_TL T
187: where T.OPRN_ID = X_OPRN_ID
188: and T.LANGUAGE = L.LANGUAGE_CODE);
189:
190: open c;

Line 300: from GMD_OPERATIONS_TL

296:
297: cursor c1 is select
298: OPRN_DESC,
299: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
300: from GMD_OPERATIONS_TL
301: where OPRN_ID = X_OPRN_ID
302: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
303: for update of OPRN_ID nowait;
304: begin

Line 518: update GMD_OPERATIONS_TL set

514: if (sql%notfound) then
515: raise no_data_found;
516: end if;
517:
518: update GMD_OPERATIONS_TL set
519: OPRN_DESC = X_OPRN_DESC,
520: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
521: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
522: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 537: /* delete from GMD_OPERATIONS_TL

533: procedure DELETE_ROW (
534: X_OPRN_ID in NUMBER
535: ) is
536: begin
537: /* delete from GMD_OPERATIONS_TL
538: where OPRN_ID = X_OPRN_ID;
539:
540: if (sql%notfound) then
541: raise no_data_found;

Line 558: delete from GMD_OPERATIONS_TL T

554:
555: procedure ADD_LANGUAGE
556: is
557: begin
558: delete from GMD_OPERATIONS_TL T
559: where not exists
560: (select NULL
561: from GMD_OPERATIONS_B B
562: where B.OPRN_ID = T.OPRN_ID

Line 565: update GMD_OPERATIONS_TL T set (

561: from GMD_OPERATIONS_B B
562: where B.OPRN_ID = T.OPRN_ID
563: );
564:
565: update GMD_OPERATIONS_TL T set (
566: OPRN_DESC
567: ) = (select
568: B.OPRN_DESC
569: from GMD_OPERATIONS_TL B

Line 569: from GMD_OPERATIONS_TL B

565: update GMD_OPERATIONS_TL T set (
566: OPRN_DESC
567: ) = (select
568: B.OPRN_DESC
569: from GMD_OPERATIONS_TL B
570: where B.OPRN_ID = T.OPRN_ID
571: and B.LANGUAGE = T.SOURCE_LANG)
572: where (
573: T.OPRN_ID,

Line 578: from GMD_OPERATIONS_TL SUBB, GMD_OPERATIONS_TL SUBT

574: T.LANGUAGE
575: ) in (select
576: SUBT.OPRN_ID,
577: SUBT.LANGUAGE
578: from GMD_OPERATIONS_TL SUBB, GMD_OPERATIONS_TL SUBT
579: where SUBB.OPRN_ID = SUBT.OPRN_ID
580: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
581: and (SUBB.OPRN_DESC <> SUBT.OPRN_DESC
582: ));

Line 584: insert into GMD_OPERATIONS_TL (

580: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
581: and (SUBB.OPRN_DESC <> SUBT.OPRN_DESC
582: ));
583:
584: insert into GMD_OPERATIONS_TL (
585: LAST_UPDATE_LOGIN,
586: LAST_UPDATE_DATE,
587: LAST_UPDATED_BY,
588: OPRN_ID,

Line 604: from GMD_OPERATIONS_TL B, FND_LANGUAGES L

600: B.CREATION_DATE,
601: B.CREATED_BY,
602: L.LANGUAGE_CODE,
603: B.SOURCE_LANG
604: from GMD_OPERATIONS_TL B, FND_LANGUAGES L
605: where L.INSTALLED_FLAG in ('I', 'B')
606: and B.LANGUAGE = userenv('LANG')
607: and not exists
608: (select NULL

Line 609: from GMD_OPERATIONS_TL T

605: where L.INSTALLED_FLAG in ('I', 'B')
606: and B.LANGUAGE = userenv('LANG')
607: and not exists
608: (select NULL
609: from GMD_OPERATIONS_TL T
610: where T.OPRN_ID = B.OPRN_ID
611: and T.LANGUAGE = L.LANGUAGE_CODE);
612: end ADD_LANGUAGE;
613: