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;
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;