eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_MATERIAL_STATUSES_PKG dependencies on MTL_MATERIAL_STATUSES_TL

Line 125: insert into MTL_MATERIAL_STATUSES_TL (

121: X_AVAILABILITY_TYPE
122: --END INVCONV KKILLAMS
123: );
124:
125: insert into MTL_MATERIAL_STATUSES_TL (
126: LAST_UPDATE_DATE,
127: CREATED_BY,
128: CREATION_DATE,
129: LAST_UPDATE_LOGIN,

Line 151: from MTL_MATERIAL_STATUSES_TL T

147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from MTL_MATERIAL_STATUSES_TL T
152: where T.STATUS_ID = X_STATUS_ID
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 176: cursor C is select ROWID from MTL_MATERIAL_STATUSES_TL

172: X_LAST_UPDATE_DATE in DATE,
173: X_LAST_UPDATED_BY in NUMBER,
174: X_LAST_UPDATE_LOGIN in NUMBER)
175: IS
176: cursor C is select ROWID from MTL_MATERIAL_STATUSES_TL
177: where STATUS_ID = X_STATUS_ID
178: ;
179: BEGIN
180: insert into MTL_MATERIAL_STATUSES_TL (

Line 180: insert into MTL_MATERIAL_STATUSES_TL (

176: cursor C is select ROWID from MTL_MATERIAL_STATUSES_TL
177: where STATUS_ID = X_STATUS_ID
178: ;
179: BEGIN
180: insert into MTL_MATERIAL_STATUSES_TL (
181: LAST_UPDATE_DATE,
182: CREATED_BY,
183: CREATION_DATE,
184: LAST_UPDATE_LOGIN,

Line 206: from MTL_MATERIAL_STATUSES_TL T

202: from FND_LANGUAGES L
203: where L.INSTALLED_FLAG in ('I', 'B')
204: and not exists
205: (select NULL
206: from MTL_MATERIAL_STATUSES_TL T
207: where T.STATUS_ID = X_STATUS_ID
208: and T.LANGUAGE = L.LANGUAGE_CODE);
209:
210: open c;

Line 293: from MTL_MATERIAL_STATUSES_TL

289: cursor c1 is select
290: STATUS_CODE,
291: DESCRIPTION,
292: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
293: from MTL_MATERIAL_STATUSES_TL
294: where STATUS_ID = X_STATUS_ID
295: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
296: for update of STATUS_ID nowait;
297: begin

Line 469: update MTL_MATERIAL_STATUSES_TL set

465: if (sql%notfound) then
466: raise no_data_found;
467: end if;
468:
469: update MTL_MATERIAL_STATUSES_TL set
470: STATUS_CODE = X_STATUS_CODE,
471: DESCRIPTION = X_DESCRIPTION,
472: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
473: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 480: -- Setting the flag to indicate that update failed for MTL_MATERIAL_STATUSES_TL Table

476: where STATUS_ID = X_STATUS_ID
477: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
478:
479: if (sql%notfound) then
480: -- Setting the flag to indicate that update failed for MTL_MATERIAL_STATUSES_TL Table
481: X_UPDATE_FLAG := 'T';
482: raise no_data_found;
483: end if;
484: --INVCONV KKILLAMS

Line 509: delete from MTL_MATERIAL_STATUSES_TL

505: procedure DELETE_ROW (
506: X_STATUS_ID in NUMBER
507: ) is
508: begin
509: delete from MTL_MATERIAL_STATUSES_TL
510: where STATUS_ID = X_STATUS_ID;
511:
512: if (sql%notfound) then
513: raise no_data_found;

Line 532: update mtl_material_statuses_tl set

528: X_DESCRIPTION IN VARCHAR2,
529: X_STATUS_CODE IN VARCHAR2)
530: IS
531: BEGIN
532: update mtl_material_statuses_tl set
533: status_code = X_STATUS_CODE,
534: description = X_DESCRIPTION,
535: last_update_date = sysdate,
536: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 658: -- If the update failed for MTL_MATERIAL_STATUSES_TL Table then insert recoreds into that table alone

654: );
655: EXCEPTION
656: WHEN no_data_found THEN
657: -- Bugfix 2396883.
658: -- If the update failed for MTL_MATERIAL_STATUSES_TL Table then insert recoreds into that table alone
659: -- else insert records into both the tables.
660: IF X_UPDATE_FLAG = 'T' THEN
661:
662: MTL_MATERIAL_STATUSES_PKG.insert_tl_row

Line 728: delete from MTL_MATERIAL_STATUSES_TL T

724:
725: procedure ADD_LANGUAGE
726: is
727: begin
728: delete from MTL_MATERIAL_STATUSES_TL T
729: where not exists
730: (select NULL
731: from MTL_MATERIAL_STATUSES_B B
732: where B.STATUS_ID = T.STATUS_ID

Line 735: update MTL_MATERIAL_STATUSES_TL T set (

731: from MTL_MATERIAL_STATUSES_B B
732: where B.STATUS_ID = T.STATUS_ID
733: );
734:
735: update MTL_MATERIAL_STATUSES_TL T set (
736: STATUS_CODE,
737: DESCRIPTION
738: ) = (select
739: B.STATUS_CODE,

Line 741: from MTL_MATERIAL_STATUSES_TL B

737: DESCRIPTION
738: ) = (select
739: B.STATUS_CODE,
740: B.DESCRIPTION
741: from MTL_MATERIAL_STATUSES_TL B
742: where B.STATUS_ID = T.STATUS_ID
743: and B.LANGUAGE = T.SOURCE_LANG)
744: where (
745: T.STATUS_ID,

Line 750: from MTL_MATERIAL_STATUSES_TL SUBB, MTL_MATERIAL_STATUSES_TL SUBT

746: T.LANGUAGE
747: ) in (select
748: SUBT.STATUS_ID,
749: SUBT.LANGUAGE
750: from MTL_MATERIAL_STATUSES_TL SUBB, MTL_MATERIAL_STATUSES_TL SUBT
751: where SUBB.STATUS_ID = SUBT.STATUS_ID
752: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
753: and (SUBB.STATUS_CODE <> SUBT.STATUS_CODE
754: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 759: insert into MTL_MATERIAL_STATUSES_TL (

755: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
756: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
757: ));
758:
759: insert into MTL_MATERIAL_STATUSES_TL (
760: LAST_UPDATE_DATE,
761: CREATED_BY,
762: CREATION_DATE,
763: LAST_UPDATE_LOGIN,

Line 781: from MTL_MATERIAL_STATUSES_TL B, FND_LANGUAGES L

777: B.STATUS_ID,
778: B.LAST_UPDATED_BY,
779: L.LANGUAGE_CODE,
780: B.SOURCE_LANG
781: from MTL_MATERIAL_STATUSES_TL B, FND_LANGUAGES L
782: where L.INSTALLED_FLAG in ('I', 'B')
783: and B.LANGUAGE = userenv('LANG')
784: and not exists
785: (select NULL

Line 786: from MTL_MATERIAL_STATUSES_TL T

782: where L.INSTALLED_FLAG in ('I', 'B')
783: and B.LANGUAGE = userenv('LANG')
784: and not exists
785: (select NULL
786: from MTL_MATERIAL_STATUSES_TL T
787: where T.STATUS_ID = B.STATUS_ID
788: and T.LANGUAGE = L.LANGUAGE_CODE);
789: end ADD_LANGUAGE;
790: