APPS.MTL_ITEM_TEMPLATES_PKG dependencies on MTL_ITEM_TEMPLATES_B

Line 4: PROCEDURE INSERT_ROW(P_Item_Templates_Rec IN MTL_ITEM_TEMPLATES_B%ROWTYPE,

1: PACKAGE BODY MTL_ITEM_TEMPLATES_PKG AS
2: /* $Header: INVVTEMB.pls 120.1.12010000.5 2008/11/17 23:17:00 akbharga ship $ */
3:
4: PROCEDURE INSERT_ROW(P_Item_Templates_Rec IN MTL_ITEM_TEMPLATES_B%ROWTYPE,
5: X_ROWID OUT NOCOPY ROWID) IS
6: BEGIN
7:
8: INSERT INTO MTL_ITEM_TEMPLATES_B (

Line 8: INSERT INTO MTL_ITEM_TEMPLATES_B (

4: PROCEDURE INSERT_ROW(P_Item_Templates_Rec IN MTL_ITEM_TEMPLATES_B%ROWTYPE,
5: X_ROWID OUT NOCOPY ROWID) IS
6: BEGIN
7:
8: INSERT INTO MTL_ITEM_TEMPLATES_B (
9: TEMPLATE_ID,
10: TEMPLATE_NAME,
11: DESCRIPTION,
12: LAST_UPDATE_DATE,

Line 143: PROCEDURE LOCK_ROW (P_Item_Templates_Rec IN MTL_ITEM_TEMPLATES_B%ROWTYPE) IS

139: WHERE T.TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID
140: AND T.LANGUAGE = L.LANGUAGE_CODE);
141: END INSERT_ROW;
142:
143: PROCEDURE LOCK_ROW (P_Item_Templates_Rec IN MTL_ITEM_TEMPLATES_B%ROWTYPE) IS
144:
145: CURSOR c_get_item_templates IS
146: SELECT
147: TEMPLATE_ID,

Line 165: FROM MTL_ITEM_TEMPLATES_B

161: ATTRIBUTE13,
162: ATTRIBUTE14,
163: ATTRIBUTE15,
164: CONTEXT_ORGANIZATION_ID
165: FROM MTL_ITEM_TEMPLATES_B
166: WHERE TEMPLATE_ID = P_Item_Templates_Rec.TEMPLATE_ID;
167:
168: CURSOR c_get_templates_trans IS
169: SELECT

Line 259: PROCEDURE UPDATE_ROW (P_Item_Templates_Rec IN MTL_ITEM_Templates_B%ROWTYPE) IS

255: END IF;
256: app_exception.raise_exception;
257: END LOCK_ROW;
258:
259: PROCEDURE UPDATE_ROW (P_Item_Templates_Rec IN MTL_ITEM_Templates_B%ROWTYPE) IS
260: BEGIN
261: UPDATE MTL_ITEM_TEMPLATES_B
262: SET
263: LAST_UPDATE_DATE = P_Item_Templates_Rec.LAST_UPDATE_DATE,

Line 261: UPDATE MTL_ITEM_TEMPLATES_B

257: END LOCK_ROW;
258:
259: PROCEDURE UPDATE_ROW (P_Item_Templates_Rec IN MTL_ITEM_Templates_B%ROWTYPE) IS
260: BEGIN
261: UPDATE MTL_ITEM_TEMPLATES_B
262: SET
263: LAST_UPDATE_DATE = P_Item_Templates_Rec.LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = P_Item_Templates_Rec.LAST_UPDATED_BY,
265: CREATION_DATE = P_Item_Templates_Rec.CREATION_DATE,

Line 346: DELETE FROM MTL_ITEM_TEMPLATES_B

342: IF (SQL%NOTFOUND) THEN
343: RAISE NO_DATA_FOUND;
344: END IF;
345:
346: DELETE FROM MTL_ITEM_TEMPLATES_B
347: WHERE TEMPLATE_ID = P_Template_Id;
348:
349: IF (SQL%NOTFOUND) THEN
350: RAISE NO_DATA_FOUND;

Line 362: FROM MTL_ITEM_TEMPLATES_B B

358: PROCEDURE ADD_LANGUAGE IS
359: BEGIN
360: DELETE FROM MTL_ITEM_TEMPLATES_TL T
361: WHERE NOT EXISTS(SELECT NULL
362: FROM MTL_ITEM_TEMPLATES_B B
363: WHERE B.TEMPLATE_ID = T.TEMPLATE_ID);
364:
365: UPDATE MTL_ITEM_TEMPLATES_TL T
366: SET (TEMPLATE_NAME,DESCRIPTION) = (SELECT B.TEMPLATE_NAME,B.DESCRIPTION