DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_TEMPLATES

Line 2218: MTL_ITEM_TEMPLATES temp

2214:
2215: CURSOR C_Default_Template(cp_catalog_group_id NUMBER) IS
2216: SELECT cat_temp.TEMPLATE_ID
2217: FROM EGO_CAT_GRP_TEMPLATES cat_temp,
2218: MTL_ITEM_TEMPLATES temp
2219: WHERE cat_temp.CATALOG_GROUP_ID = cp_catalog_group_id
2220: AND cat_temp.DEFAULT_FLAG = 'Y'
2221: AND cat_temp.TEMPLATE_ID = temp.TEMPLATE_ID;
2222:

Line 2719: --INVIDTMP.fmb (MTL_ITEM_TEMPLATES.check_delete_row)

2715: ------------------------------------------------------------------------------------------
2716: --API Name : Check_Template_Cat_Associations
2717: --Description : Bug # 3326991 Added for Delete template Operation.
2718: --This procedure is used in the deletion of Item templates in the form
2719: --INVIDTMP.fmb (MTL_ITEM_TEMPLATES.check_delete_row)
2720:
2721: -- An Item Template cannot be deleted if any associations to catalog categories exist
2722:
2723: --Parameteres required : 1) p_template_id