APPS.GMD_QC_STATUS_PVT dependencies on GMD_QC_STATUS_TL

Line 143: insert into GMD_QC_STATUS_TL (

139: X_LAST_UPDATED_BY,
140: X_LAST_UPDATE_LOGIN
141: );
142:
143: insert into GMD_QC_STATUS_TL (
144: LAST_UPDATED_BY,
145: STATUS_CODE,
146: MEANING,
147: ENTITY_TYPE,

Line 171: from GMD_QC_STATUS_TL T

167: from FND_LANGUAGES L
168: where L.INSTALLED_FLAG in ('I', 'B')
169: and not exists
170: (select NULL
171: from GMD_QC_STATUS_TL T
172: where T.STATUS_CODE = X_STATUS_CODE
173: and T.ENTITY_TYPE = X_ENTITY_TYPE
174: and T.LANGUAGE = L.LANGUAGE_CODE);
175:

Line 273: from GMD_QC_STATUS_TL

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

Line 466: update GMD_QC_STATUS_TL set

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

Line 487: delete from GMD_QC_STATUS_TL

483: X_STATUS_CODE in NUMBER,
484: X_ENTITY_TYPE in VARCHAR2
485: ) is
486: begin
487: delete from GMD_QC_STATUS_TL
488: where STATUS_CODE = X_STATUS_CODE
489: and ENTITY_TYPE = X_ENTITY_TYPE;
490:
491: if (sql%notfound) then

Line 507: delete from GMD_QC_STATUS_TL T

503:
504: procedure ADD_LANGUAGE
505: is
506: begin
507: delete from GMD_QC_STATUS_TL T
508: where not exists
509: (select NULL
510: from GMD_QC_STATUS_B B
511: where B.STATUS_CODE = T.STATUS_CODE

Line 515: update GMD_QC_STATUS_TL T set (

511: where B.STATUS_CODE = T.STATUS_CODE
512: and B.ENTITY_TYPE = T.ENTITY_TYPE
513: );
514:
515: update GMD_QC_STATUS_TL T set (
516: MEANING,
517: DESCRIPTION
518: ) = (select
519: B.MEANING,

Line 521: from GMD_QC_STATUS_TL B

517: DESCRIPTION
518: ) = (select
519: B.MEANING,
520: B.DESCRIPTION
521: from GMD_QC_STATUS_TL B
522: where B.STATUS_CODE = T.STATUS_CODE
523: and B.ENTITY_TYPE = T.ENTITY_TYPE
524: and B.LANGUAGE = T.SOURCE_LANG)
525: where (

Line 533: from GMD_QC_STATUS_TL SUBB, GMD_QC_STATUS_TL SUBT

529: ) in (select
530: SUBT.STATUS_CODE,
531: SUBT.ENTITY_TYPE,
532: SUBT.LANGUAGE
533: from GMD_QC_STATUS_TL SUBB, GMD_QC_STATUS_TL SUBT
534: where SUBB.STATUS_CODE = SUBT.STATUS_CODE
535: and SUBB.ENTITY_TYPE = SUBT.ENTITY_TYPE
536: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
537: and (SUBB.MEANING <> SUBT.MEANING

Line 541: insert into GMD_QC_STATUS_TL (

537: and (SUBB.MEANING <> SUBT.MEANING
538: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
539: ));
540:
541: insert into GMD_QC_STATUS_TL (
542: LAST_UPDATED_BY,
543: STATUS_CODE,
544: MEANING,
545: ENTITY_TYPE,

Line 565: from GMD_QC_STATUS_TL B, FND_LANGUAGES L

561: B.LAST_UPDATE_DATE,
562: B.LAST_UPDATE_LOGIN,
563: L.LANGUAGE_CODE,
564: B.SOURCE_LANG
565: from GMD_QC_STATUS_TL B, FND_LANGUAGES L
566: where L.INSTALLED_FLAG in ('I', 'B')
567: and B.LANGUAGE = userenv('LANG')
568: and not exists
569: (select NULL

Line 570: from GMD_QC_STATUS_TL T

566: where L.INSTALLED_FLAG in ('I', 'B')
567: and B.LANGUAGE = userenv('LANG')
568: and not exists
569: (select NULL
570: from GMD_QC_STATUS_TL T
571: where T.STATUS_CODE = B.STATUS_CODE
572: and T.ENTITY_TYPE = B.ENTITY_TYPE
573: and T.LANGUAGE = L.LANGUAGE_CODE);
574: end ADD_LANGUAGE;

Line 589: UPDATE GMD_QC_STATUS_TL SET

585: ,X_MEANING IN VARCHAR2
586: ,X_USER_ID IN NUMBER
587: ) IS
588: BEGIN
589: UPDATE GMD_QC_STATUS_TL SET
590: /* Bug 2478592 - Thomas Daniel */
591: /* Added the update to the meaning column */
592: MEANING = X_MEANING,
593: DESCRIPTION = X_DESCRIPTION,

Line 619: FROM GMD_QC_STATUS_TL

615: ) IS
616:
617: CURSOR Cur_rowid IS
618: SELECT rowid
619: FROM GMD_QC_STATUS_TL
620: WHERE (STATUS_CODE = X_STATUS_CODE)
621: AND (ENTITY_TYPE = X_ENTITY_TYPE);
622:
623: l_user_id NUMBER DEFAULT 1 ;