560: -- Create an association between Default Template and Catalog Group
561: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
562: p_Template_Id is not null THEN
563:
564: INSERT INTO ego_cat_grp_templates
565: ( template_id
566: , catalog_group_id
567: , created_by
568: , creation_date
724: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
725:
726: -- check if catalog group is already associated with a default template
727: SELECT 'x' INTO v_dummy
728: FROM ego_cat_grp_templates
729: WHERE catalog_group_id = x_catalog_group_id;
730:
731: IF p_Template_Id is not null THEN
732:
730:
731: IF p_Template_Id is not null THEN
732:
733: -- update current association of catalog group with default template
734: UPDATE ego_cat_grp_templates
735: SET template_id = p_Template_Id
736: WHERE catalog_group_id = x_catalog_group_id;
737:
738: ELSE
737:
738: ELSE
739:
740: -- delete current association of catalog group with default template
741: DELETE FROM ego_cat_grp_templates
742: WHERE catalog_group_id = x_catalog_group_id;
743:
744: END IF;
745:
763: WHEN NO_DATA_FOUND THEN
764: -- There is no current association of default template to catalog group
765: IF p_Template_Id is not null THEN
766:
767: INSERT INTO ego_cat_grp_templates
768: ( template_id
769: , catalog_group_id
770: , created_by
771: , creation_date