APPS.MTL_ITEM_REVISIONS_SV1 dependencies on MTL_ITEM_REVISIONS

Line 1: PACKAGE BODY MTL_ITEM_REVISIONS_SV1 AS

1: PACKAGE BODY MTL_ITEM_REVISIONS_SV1 AS
2: /* $Header: POXPIIRB.pls 120.0.12000000.1 2007/01/16 23:03:56 appldev ship $ */
3:
4: /*================================================================
5:

Line 21: in mtl_item_revisions table */

17: BEGIN
18: x_progress := '010';
19:
20: /* check to see if there are x_item_revision exists
21: in mtl_item_revisions table */
22:
23: /* Bug 1833599 - Removed the organization_id check from the sql as the
24: revision is just validated against the item and then in POXPISVB.pls, it is validated against
25: the ship to org and item */

Line 31: FROM mtl_item_revisions

27: right now */
28:
29: SELECT count(*)
30: INTO x_temp
31: FROM mtl_item_revisions
32: WHERE revision = x_item_revision
33: AND inventory_item_id = x_inventory_item_id;
34:
35: IF x_temp = 0 THEN

Line 48: END MTL_ITEM_REVISIONS_SV1;

44: ('val_item_revision', x_progress, sqlcode);
45: raise;
46: END val_item_revision;
47:
48: END MTL_ITEM_REVISIONS_SV1;