DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_ITEM_TEMPLATES

Line 2370: MTL_ITEM_TEMPLATES temp

2366:
2367: CURSOR C_Default_Template(cp_catalog_group_id NUMBER) IS
2368: SELECT cat_temp.TEMPLATE_ID
2369: FROM EGO_CAT_GRP_TEMPLATES cat_temp,
2370: MTL_ITEM_TEMPLATES temp
2371: WHERE cat_temp.CATALOG_GROUP_ID = cp_catalog_group_id
2372: AND cat_temp.DEFAULT_FLAG = 'Y'
2373: AND cat_temp.TEMPLATE_ID = temp.TEMPLATE_ID;
2374:

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

2886: ------------------------------------------------------------------------------------------
2887: --API Name : Check_Template_Cat_Associations
2888: --Description : Bug # 3326991 Added for Delete template Operation.
2889: --This procedure is used in the deletion of Item templates in the form
2890: --INVIDTMP.fmb (MTL_ITEM_TEMPLATES.check_delete_row)
2891:
2892: -- An Item Template cannot be deleted if any associations to catalog categories exist
2893:
2894: --Parameteres required : 1) p_template_id