DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on INVUPD2B

Line 442: --Added for bug 5997870. Will clear the session variable in the INVUPD2B package

438:
439: END Process_Item;
440:
441: ---------------------------------------------------------------------------
442: --Added for bug 5997870. Will clear the session variable in the INVUPD2B package
443: PROCEDURE Clear_Object_Version_Values IS
444: BEGIN
445: INVUPD2B.obj_ver_rec.inventory_item_id := NULL;
446: INVUPD2B.obj_ver_rec.org_id := NULL;

Line 445: INVUPD2B.obj_ver_rec.inventory_item_id := NULL;

441: ---------------------------------------------------------------------------
442: --Added for bug 5997870. Will clear the session variable in the INVUPD2B package
443: PROCEDURE Clear_Object_Version_Values IS
444: BEGIN
445: INVUPD2B.obj_ver_rec.inventory_item_id := NULL;
446: INVUPD2B.obj_ver_rec.org_id := NULL;
447: INVUPD2B.obj_ver_rec.Object_Version_Number := NULL;
448: END;
449:

Line 446: INVUPD2B.obj_ver_rec.org_id := NULL;

442: --Added for bug 5997870. Will clear the session variable in the INVUPD2B package
443: PROCEDURE Clear_Object_Version_Values IS
444: BEGIN
445: INVUPD2B.obj_ver_rec.inventory_item_id := NULL;
446: INVUPD2B.obj_ver_rec.org_id := NULL;
447: INVUPD2B.obj_ver_rec.Object_Version_Number := NULL;
448: END;
449:
450: ---------------------------------------------------------------------------

Line 447: INVUPD2B.obj_ver_rec.Object_Version_Number := NULL;

443: PROCEDURE Clear_Object_Version_Values IS
444: BEGIN
445: INVUPD2B.obj_ver_rec.inventory_item_id := NULL;
446: INVUPD2B.obj_ver_rec.org_id := NULL;
447: INVUPD2B.obj_ver_rec.Object_Version_Number := NULL;
448: END;
449:
450: ---------------------------------------------------------------------------
451: PROCEDURE Process_Item(

Line 1005: -- Bug 5997870.. set the value in invupd2b so that this check may be

1001: END IF;
1002: END IF;
1003: END IF;
1004:
1005: -- Bug 5997870.. set the value in invupd2b so that this check may be
1006: -- done after locking the record and not before it...
1007: IF((p_object_version_number IS NOT NULL) AND
1008: (p_object_version_number <> G_MISS_NUM)) THEN
1009: INVUPD2B.obj_ver_rec.inventory_item_id := p_inventory_item_id;

Line 1009: INVUPD2B.obj_ver_rec.inventory_item_id := p_inventory_item_id;

1005: -- Bug 5997870.. set the value in invupd2b so that this check may be
1006: -- done after locking the record and not before it...
1007: IF((p_object_version_number IS NOT NULL) AND
1008: (p_object_version_number <> G_MISS_NUM)) THEN
1009: INVUPD2B.obj_ver_rec.inventory_item_id := p_inventory_item_id;
1010: INVUPD2B.obj_ver_rec.org_id := p_organization_id;
1011: INVUPD2B.obj_ver_rec.Object_Version_Number := Nvl(p_object_version_number,1);
1012: END IF;
1013: --Code changes for bug 5997870 ends...

Line 1010: INVUPD2B.obj_ver_rec.org_id := p_organization_id;

1006: -- done after locking the record and not before it...
1007: IF((p_object_version_number IS NOT NULL) AND
1008: (p_object_version_number <> G_MISS_NUM)) THEN
1009: INVUPD2B.obj_ver_rec.inventory_item_id := p_inventory_item_id;
1010: INVUPD2B.obj_ver_rec.org_id := p_organization_id;
1011: INVUPD2B.obj_ver_rec.Object_Version_Number := Nvl(p_object_version_number,1);
1012: END IF;
1013: --Code changes for bug 5997870 ends...
1014:

Line 1011: INVUPD2B.obj_ver_rec.Object_Version_Number := Nvl(p_object_version_number,1);

1007: IF((p_object_version_number IS NOT NULL) AND
1008: (p_object_version_number <> G_MISS_NUM)) THEN
1009: INVUPD2B.obj_ver_rec.inventory_item_id := p_inventory_item_id;
1010: INVUPD2B.obj_ver_rec.org_id := p_organization_id;
1011: INVUPD2B.obj_ver_rec.Object_Version_Number := Nvl(p_object_version_number,1);
1012: END IF;
1013: --Code changes for bug 5997870 ends...
1014:
1015: --Check if record is changed before update.