APPS.MTL_ITEM_REVISIONS_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 15: FROM mtl_item_revisions_b

11: CURSOR c_get_effective_revision(cp_inventory_item_id NUMBER
12: ,cp_organization_id NUMBER
13: ,cp_revision VARCHAR2) IS
14: SELECT revision_id
15: FROM mtl_item_revisions_b
16: WHERE inventory_item_id = cp_inventory_item_id
17: AND organization_id = cp_organization_id
18: AND revision < cp_revision
19: AND implementation_date IS NOT NULL

Line 23: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;

19: AND implementation_date IS NOT NULL
20: AND effectivity_date <= sysdate
21: ORDER BY effectivity_date desc;
22:
23: l_source_revision_id mtl_item_revisions_b.revision_id%TYPE;
24: l_return_status VARCHAR2(100);
25: l_error_code NUMBER;
26: l_msg_count NUMBER ;
27: l_msg_data VARCHAR2(100);

Line 66: PROCEDURE INSERT_ROW(P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE,

62: WHEN OTHERS THEN
63: NULL;
64: END copy_rev_UDA;
65:
66: PROCEDURE INSERT_ROW(P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE,
67: X_ROWID OUT NOCOPY VARCHAR2) IS
68:
69: BEGIN
70:

Line 71: INSERT INTO MTL_ITEM_REVISIONS_B (

67: X_ROWID OUT NOCOPY VARCHAR2) IS
68:
69: BEGIN
70:
71: INSERT INTO MTL_ITEM_REVISIONS_B (
72: REVISION_ID,
73: REVISION_LABEL,
74: REVISION_REASON,
75: LIFECYCLE_ID,

Line 203: PROCEDURE LOCK_ROW (P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE) IS

199: END;
200: --R12: Business Event Enhancement : Raise Event if Revision got Created successfully
201: END INSERT_ROW;
202:
203: PROCEDURE LOCK_ROW (P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE) IS
204:
205: CURSOR c_get_item_revision IS
206: SELECT
207: REVISION_LABEL,

Line 236: FROM MTL_ITEM_REVISIONS_B

232: ATTRIBUTE15,
233: REQUEST_ID,
234: REVISED_ITEM_SEQUENCE_ID,
235: OBJECT_VERSION_NUMBER
236: FROM MTL_ITEM_REVISIONS_B
237: WHERE INVENTORY_ITEM_ID = P_Item_Revision_Rec.INVENTORY_ITEM_ID
238: AND ORGANIZATION_ID = P_Item_Revision_Rec.ORGANIZATION_ID
239: AND REVISION_ID = P_Item_Revision_Rec.REVISION_ID
240: FOR UPDATE OF INVENTORY_ITEM_ID NOWAIT;

Line 338: PROCEDURE UPDATE_ROW (P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE) IS

334: END IF;
335: app_exception.raise_exception;
336: END LOCK_ROW;
337:
338: PROCEDURE UPDATE_ROW (P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE) IS
339:
340: BEGIN
341: UPDATE MTL_ITEM_REVISIONS_B
342: SET

Line 341: UPDATE MTL_ITEM_REVISIONS_B

337:
338: PROCEDURE UPDATE_ROW (P_Item_Revision_Rec IN MTL_ITEM_REVISIONS_B%ROWTYPE) IS
339:
340: BEGIN
341: UPDATE MTL_ITEM_REVISIONS_B
342: SET
343: REVISION = P_Item_Revision_Rec.REVISION,
344: REVISION_LABEL = P_Item_Revision_Rec.REVISION_LABEL,--Bug: 3017253
345: CHANGE_NOTICE = P_Item_Revision_Rec.CHANGE_NOTICE,

Line 416: FROM MTL_ITEM_REVISIONS_B B

412: -- Comment out as part of SQL Repositry fix. Bug: 4256727
413:
414: /* DELETE FROM MTL_ITEM_REVISIONS_TL T
415: WHERE NOT EXISTS(SELECT NULL
416: FROM MTL_ITEM_REVISIONS_B B
417: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
418: AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
419: AND B.REVISION_ID = T.REVISION_ID);
420: