APPS.EGO_ITEM_CATALOG_PUB dependencies on EGO_CAT_GRP_TEMPLATES

Line 498: INSERT INTO ego_cat_grp_templates

494: -- Create an association between Default Template and Catalog Group
495: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
496: p_Template_Id is not null THEN
497:
498: INSERT INTO ego_cat_grp_templates
499: ( template_id
500: , catalog_group_id
501: , created_by
502: , creation_date

Line 662: FROM ego_cat_grp_templates

658: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
659:
660: -- check if catalog group is already associated with a default template
661: SELECT 'x' INTO v_dummy
662: FROM ego_cat_grp_templates
663: WHERE catalog_group_id = x_catalog_group_id;
664:
665: IF p_Template_Id is not null THEN
666:

Line 668: UPDATE ego_cat_grp_templates

664:
665: IF p_Template_Id is not null THEN
666:
667: -- update current association of catalog group with default template
668: UPDATE ego_cat_grp_templates
669: SET template_id = p_Template_Id
670: WHERE catalog_group_id = x_catalog_group_id;
671:
672: ELSE

Line 675: DELETE FROM ego_cat_grp_templates

671:
672: ELSE
673:
674: -- delete current association of catalog group with default template
675: DELETE FROM ego_cat_grp_templates
676: WHERE catalog_group_id = x_catalog_group_id;
677:
678: END IF;
679:

Line 701: INSERT INTO ego_cat_grp_templates

697: WHEN NO_DATA_FOUND THEN
698: -- There is no current association of default template to catalog group
699: IF p_Template_Id is not null THEN
700:
701: INSERT INTO ego_cat_grp_templates
702: ( template_id
703: , catalog_group_id
704: , created_by
705: , creation_date