DBA Data[Home] [Help]

APPS.AHL_ITEMGROUPS_APPROVAL_PVT dependencies on AHL_ITEM_GROUPS_B

Line 1621: UPDATE AHL_ITEM_GROUPS_B

1617:
1618:
1619: if l_item_group_rec.STATUS_CODE ='APPROVAL_PENDING'
1620: THEN
1621: UPDATE AHL_ITEM_GROUPS_B
1622: SET STATUS_CODE = 'DRAFT',
1623: object_version_number =l_object_version_number+1
1624: WHERE ITEM_GROUP_ID = l_object_id
1625: and object_Version_number=l_object_version_number;

Line 1627: UPDATE AHL_ITEM_GROUPS_B

1623: object_version_number =l_object_version_number+1
1624: WHERE ITEM_GROUP_ID = l_object_id
1625: and object_Version_number=l_object_version_number;
1626: /* ELSE
1627: UPDATE AHL_ITEM_GROUPS_B
1628: SET STATUS = 'COMPLETE',
1629: object_version_number =l_object_version_number+1
1630: WHERE ITEM_GROUP_ID = l_object_id
1631: and object_Version_number=l_object_version_number;