[Home] [Help]
3594:
3595: -- To get the maximum of version number
3596: Select NVl(max(VERSION_NUMBER),0)
3597: into l_version_number
3598: from ahl_item_groups_b_h
3599: where ITEM_GROUP_ID = p_ItemGroups_id;
3600:
3601:
3602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3608:
3609: Select ahl_item_associations_b_h_s.nextval
3610: into l_item_associations_h_id from dual;
3611:
3612: INSERT INTO ahl_item_groups_b_h
3613: (item_group_h_id ,
3614: item_group_id ,
3615: object_version_number,
3616: creation_date ,
3643: attribute15 )
3644:
3645: SELECT
3646:
3647: AHL_ITEM_GROUPS_B_H_S.NEXTVAL ,
3648: item_group_id ,
3649: object_version_number,
3650: creation_date ,
3651: created_by ,
3689: created_by ,
3690: description ,
3691: last_update_login )
3692: SELECT
3693: AHL_ITEM_GROUPS_B_H_S.CURRVAL ,
3694: language ,
3695: last_update_date ,
3696: last_updated_by ,
3697: source_lang ,