APPS.GMD_STATUS_MLS dependencies on GMD_STATUS_TL

Line 149: insert into GMD_STATUS_TL (

145: END IF;
146: Close c;
147: -- END BUG#3131047
148:
149: insert into GMD_STATUS_TL (
150: MEANING,
151: STATUS_CODE,
152: DESCRIPTION,
153: LAST_UPDATE_DATE,

Line 175: from GMD_STATUS_TL T

171: from FND_LANGUAGES L
172: where L.INSTALLED_FLAG in ('I', 'B')
173: and not exists
174: (select NULL
175: from GMD_STATUS_TL T
176: where T.STATUS_CODE = X_STATUS_CODE
177: and T.LANGUAGE = L.LANGUAGE_CODE);
178:
179: open c;

Line 274: from GMD_STATUS_TL

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

Line 466: update GMD_STATUS_TL set

462: if (sql%notfound) then
463: raise no_data_found;
464: end if;
465:
466: update GMD_STATUS_TL set
467: DESCRIPTION = X_DESCRIPTION,
468: MEANING = X_MEANING,
469: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
470: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 485: delete from GMD_STATUS_TL

481: procedure DELETE_ROW (
482: X_STATUS_CODE in VARCHAR2
483: ) is
484: begin
485: delete from GMD_STATUS_TL
486: where STATUS_CODE = X_STATUS_CODE;
487:
488: if (sql%notfound) then
489: raise no_data_found;

Line 503: delete from GMD_STATUS_TL T

499:
500: procedure ADD_LANGUAGE
501: is
502: begin
503: delete from GMD_STATUS_TL T
504: where not exists
505: (select NULL
506: from GMD_STATUS_B B
507: where B.STATUS_CODE = T.STATUS_CODE

Line 510: update GMD_STATUS_TL T set (

506: from GMD_STATUS_B B
507: where B.STATUS_CODE = T.STATUS_CODE
508: );
509:
510: update GMD_STATUS_TL T set (
511: DESCRIPTION,
512: MEANING
513: ) = (select
514: B.DESCRIPTION,

Line 516: from GMD_STATUS_TL B

512: MEANING
513: ) = (select
514: B.DESCRIPTION,
515: B.MEANING
516: from GMD_STATUS_TL B
517: where B.STATUS_CODE = T.STATUS_CODE
518: and B.LANGUAGE = T.SOURCE_LANG)
519: where (
520: T.STATUS_CODE,

Line 525: from GMD_STATUS_TL SUBB, GMD_STATUS_TL SUBT

521: T.LANGUAGE
522: ) in (select
523: SUBT.STATUS_CODE,
524: SUBT.LANGUAGE
525: from GMD_STATUS_TL SUBB, GMD_STATUS_TL SUBT
526: where SUBB.STATUS_CODE = SUBT.STATUS_CODE
527: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
528: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
529: or SUBB.MEANING <> SUBT.MEANING

Line 532: insert into GMD_STATUS_TL (

528: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
529: or SUBB.MEANING <> SUBT.MEANING
530: ));
531:
532: insert into GMD_STATUS_TL (
533: MEANING,
534: STATUS_CODE,
535: DESCRIPTION,
536: LAST_UPDATE_DATE,

Line 554: from GMD_STATUS_TL B, FND_LANGUAGES L

550: B.CREATION_DATE,
551: B.CREATED_BY,
552: L.LANGUAGE_CODE,
553: B.SOURCE_LANG
554: from GMD_STATUS_TL B, FND_LANGUAGES L
555: where L.INSTALLED_FLAG in ('I', 'B')
556: and B.LANGUAGE = userenv('LANG')
557: and not exists
558: (select NULL

Line 559: from GMD_STATUS_TL T

555: where L.INSTALLED_FLAG in ('I', 'B')
556: and B.LANGUAGE = userenv('LANG')
557: and not exists
558: (select NULL
559: from GMD_STATUS_TL T
560: where T.STATUS_CODE = B.STATUS_CODE
561: and T.LANGUAGE = L.LANGUAGE_CODE);
562: end ADD_LANGUAGE;
563:

Line 576: UPDATE GMD_STATUS_TL SET

572: ,X_MEANING IN VARCHAR2
573: ,X_OWNER IN NUMBER
574: ) IS
575: BEGIN
576: UPDATE GMD_STATUS_TL SET
577: /* Bug 2478592 - Thomas Daniel */
578: /* Added the update to the meaning column */
579: MEANING = X_MEANING,
580: DESCRIPTION = X_DESCRIPTION,

Line 603: FROM GMD_STATUS_TL

599: ) IS
600:
601: CURSOR Cur_rowid IS
602: SELECT rowid
603: FROM GMD_STATUS_TL
604: WHERE (STATUS_CODE = X_STATUS_CODE);
605:
606: l_row_id VARCHAR2(64) ;
607: l_return_status VARCHAR2(1) ;