733:
734: update pon_auc_attributes_interface paai
735: set paai.GROUP_CODE = (
736: select lookup_code
737: from fnd_lookup_values attrGrpFlv
738: where lookup_type = l_group_lookup_type
739: --where lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
740: and meaning = paai.GROUP_NAME
741: and attrGrpFlv.LANGUAGE = userenv('LANG')
752: -- For Header Case, if the Group Name is null, default General.
753: update pon_auc_attributes_interface paai
754: set paai.GROUP_NAME = (
755: select meaning
756: from fnd_lookup_values attrGrpFlv
757: where attrGrpFlv.lookup_type = 'PON_HEADER_ATTRIBUTE_GROUPS'
758: and attrGrpFlv.lookup_code = 'GENERAL'
759: and attrGrpFlv.LANGUAGE = userenv('LANG')
760: and attrGrpFlv.view_application_id = 0