APPS.ICX_POR_EXT_DIAG dependencies on ICX_POR_EXT_CLASS

Line 570: AND type = ICX_POR_EXT_CLASS.CATEGORY_TYPE

566: INTO xStatus,
567: xRtCategoryId
568: FROM icx_cat_categories_tl
569: WHERE key = to_char(pCategoryId)
570: AND type = ICX_POR_EXT_CLASS.CATEGORY_TYPE
571: AND rownum = 1;
572: EXCEPTION
573: WHEN OTHERS THEN
574: xStatus := CATEGORY_NOT_EXTRACTED;

Line 625: AND type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE

621: INTO xStatus,
622: xRtCategoryId
623: FROM icx_cat_categories_tl
624: WHERE key = pTemplateName||'_tmpl'
625: AND type = ICX_POR_EXT_CLASS.TEMPLATE_HEADER_TYPE
626: AND rownum = 1;
627: EXCEPTION
628: WHEN OTHERS THEN
629: xStatus := TEMPLATE_HEADER_NOT_EXTRACTED;