[Home] [Help]
43: ,X_CROSS_REFERENCE_ID OUT NOCOPY NUMBER) IS
44:
45: CURSOR C_CHECK_INSERT IS
46: SELECT 'Y'
47: FROM MTL_CROSS_REFERENCES_B
48: WHERE CROSS_REFERENCE_ID = X_CROSS_REFERENCE_ID;
49:
50: l_exists VARCHAR2(1);
51:
50: l_exists VARCHAR2(1);
51:
52: BEGIN
53:
54: INSERT INTO MTL_CROSS_REFERENCES_B (
55: SOURCE_SYSTEM_ID
56: ,START_DATE_ACTIVE
57: ,END_DATE_ACTIVE
58: ,OBJECT_VERSION_NUMBER
96: ,P_END_DATE_ACTIVE
97: ,NVL(P_OBJECT_VERSION_NUMBER,1)
98: ,P_UOM_CODE
99: ,P_REVISION_ID
100: ,MTL_CROSS_REFERENCES_B_S.NEXTVAL
101: ,NVL(P_EPC_GTIN_SERIAL,0)
102: ,P_INVENTORY_ITEM_ID
103: ,P_ORGANIZATION_ID
104: ,P_CROSS_REFERENCE_TYPE
229: ,ATTRIBUTE13
230: ,ATTRIBUTE14
231: ,ATTRIBUTE15
232: ,ATTRIBUTE_CATEGORY
233: FROM MTL_CROSS_REFERENCES_B
234: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
235: FOR UPDATE OF CROSS_REFERENCE_ID NOWAIT;
236:
237: CURSOR C_CROSS_REF_TL IS
361: ,P_LAST_UPDATED_BY IN NUMBER
362: ,P_LAST_UPDATE_LOGIN IN NUMBER
363: ,X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER) IS
364: BEGIN
365: UPDATE MTL_CROSS_REFERENCES_B
366: SET
367: SOURCE_SYSTEM_ID = P_SOURCE_SYSTEM_ID
368: ,START_DATE_ACTIVE = P_START_DATE_ACTIVE
369: ,END_DATE_ACTIVE = P_END_DATE_ACTIVE
427: IF (SQL%NOTFOUND) THEN
428: RAISE NO_DATA_FOUND;
429: END IF;
430:
431: DELETE FROM MTL_CROSS_REFERENCES_B
432: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID;
433:
434: IF (SQL%NOTFOUND) THEN
435: RAISE NO_DATA_FOUND;
440: PROCEDURE ADD_LANGUAGE IS
441: BEGIN
442: DELETE MTL_CROSS_REFERENCES_TL T
443: WHERE NOT EXISTS (SELECT NULL
444: FROM MTL_CROSS_REFERENCES_B B
445: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID);
446:
447: UPDATE MTL_CROSS_REFERENCES_TL T
448: SET (DESCRIPTION) = (SELECT B.DESCRIPTION