APPS.MTL_ITEM_STATUS_PKG dependencies on MTL_ITEM_STATUS_TL

Line 37: select ROWID from MTL_ITEM_STATUS_TL

33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is
37: select ROWID from MTL_ITEM_STATUS_TL
38: where INVENTORY_ITEM_STATUS_CODE = X_INVENTORY_ITEM_STATUS_CODE;
39: begin
40: insert into MTL_ITEM_STATUS_TL (
41: INVENTORY_ITEM_STATUS_CODE,

Line 40: insert into MTL_ITEM_STATUS_TL (

36: cursor C is
37: select ROWID from MTL_ITEM_STATUS_TL
38: where INVENTORY_ITEM_STATUS_CODE = X_INVENTORY_ITEM_STATUS_CODE;
39: begin
40: insert into MTL_ITEM_STATUS_TL (
41: INVENTORY_ITEM_STATUS_CODE,
42: DESCRIPTION,
43: DISABLE_DATE,
44: ATTRIBUTE_CATEGORY,

Line 108: from MTL_ITEM_STATUS_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from MTL_ITEM_STATUS_TL T
109: where T.INVENTORY_ITEM_STATUS_CODE = X_INVENTORY_ITEM_STATUS_CODE
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112: open c;

Line 175: from MTL_ITEM_STATUS_TL

171: PROGRAM_UPDATE_DATE,
172: INVENTORY_ITEM_STATUS_CODE_TL,
173: DESCRIPTION,
174: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
175: from MTL_ITEM_STATUS_TL
176: where INVENTORY_ITEM_STATUS_CODE = X_INVENTORY_ITEM_STATUS_CODE
177: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
178: for update of INVENTORY_ITEM_STATUS_CODE nowait;
179:

Line 283: update MTL_ITEM_STATUS_TL set

279: X_LAST_UPDATED_BY in NUMBER,
280: X_LAST_UPDATE_LOGIN in NUMBER
281: ) is
282: begin
283: update MTL_ITEM_STATUS_TL set
284: DISABLE_DATE = X_DISABLE_DATE,
285: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
286: ATTRIBUTE1 = X_ATTRIBUTE1,
287: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 323: delete from MTL_ITEM_STATUS_TL

319: procedure DELETE_ROW (
320: X_INVENTORY_ITEM_STATUS_CODE in VARCHAR2
321: ) is
322: begin
323: delete from MTL_ITEM_STATUS_TL
324: where INVENTORY_ITEM_STATUS_CODE = X_INVENTORY_ITEM_STATUS_CODE;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 335: insert into MTL_ITEM_STATUS_TL (

331:
332: procedure ADD_LANGUAGE
333: is
334: begin
335: insert into MTL_ITEM_STATUS_TL (
336: INVENTORY_ITEM_STATUS_CODE,
337: INVENTORY_ITEM_STATUS_CODE_TL,
338: DESCRIPTION,
339: CREATED_BY,

Line 357: from MTL_ITEM_STATUS_TL B, FND_LANGUAGES L

353: B.LAST_UPDATE_DATE,
354: B.LAST_UPDATE_LOGIN,
355: L.LANGUAGE_CODE,
356: B.SOURCE_LANG
357: from MTL_ITEM_STATUS_TL B, FND_LANGUAGES L
358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL

Line 362: from MTL_ITEM_STATUS_TL T

358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL
362: from MTL_ITEM_STATUS_TL T
363: where T.INVENTORY_ITEM_STATUS_CODE = B.INVENTORY_ITEM_STATUS_CODE
364: and T.LANGUAGE = L.LANGUAGE_CODE);
365: end ADD_LANGUAGE;
366: