643: Open csr_master_attribute;
644: Fetch csr_master_attribute into l_ovn;
645: Close csr_master_attribute;
646: --
647: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
648: (
649: p_validate => false
650: ,p_txn_category_attribute_id => p_txn_category_attribute_id
651: ,p_object_version_number => l_ovn
660: --
661:
662: For child_rec in csr_child_attributes loop
663: --
664: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
665: (
666: p_validate => false
667: ,p_txn_category_attribute_id => child_rec.txn_category_attribute_id
668: ,p_object_version_number => child_rec.object_version_number
734: --
735:
736: For child_rec in csr_child_attributes(l_master_attribute) loop
737: --
738: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
739: (
740: p_validate => false
741: ,p_txn_category_attribute_id => child_rec.txn_category_attribute_id
742: ,p_object_version_number => child_rec.object_version_number
808: Open csr_master_attribute;
809: Fetch csr_master_attribute into l_ovn;
810: Close csr_master_attribute;
811: --
812: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
813: (
814: p_validate => false
815: ,p_txn_category_attribute_id => p_txn_category_attribute_id
816: ,p_object_version_number => l_ovn
825: --
826:
827: For child_rec in csr_child_attributes loop
828: --
829: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
830: (
831: p_validate => false
832: ,p_txn_category_attribute_id => child_rec.txn_category_attribute_id
833: ,p_object_version_number => child_rec.object_version_number
899: --
900:
901: For child_rec in csr_child_attributes(l_master_attribute) loop
902: --
903: pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE
904: (
905: p_validate => false
906: ,p_txn_category_attribute_id => child_rec.txn_category_attribute_id
907: ,p_object_version_number => child_rec.object_version_number
2430:
2431: Fetch csr_attr into attr_rec;
2432: Exit when csr_attr%notfound;
2433: --
2434: pqh_txn_cat_attributes_api.create_TXN_CAT_ATTRIBUTE
2435: (
2436: p_validate => false
2437: ,p_txn_category_attribute_id => l_id
2438: ,p_attribute_id => attr_rec.attribute_id