APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on ICX_CAT_CATEGORIES_V

Line 3429: FROM ICX_CAT_CATEGORIES_V

3425: l_progress := '020';
3426: BEGIN
3427: SELECT category_name
3428: INTO x_ip_category_name
3429: FROM ICX_CAT_CATEGORIES_V
3430: WHERE rt_category_id = p_ip_category_id
3431: AND language = userenv('LANG');
3432: EXCEPTION
3433: WHEN OTHERS THEN

Line 3436: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting IP ctageory_name using ICX_CAT_CATEGORIES_V view: '||SQLERRM); END IF;

3432: EXCEPTION
3433: WHEN OTHERS THEN
3434: -- If the shopping category does not exist, or other cases.
3435: l_progress := '030';
3436: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting IP ctageory_name using ICX_CAT_CATEGORIES_V view: '||SQLERRM); END IF;
3437:
3438: x_ip_catgeory_found := 'N';
3439: END;
3440: -- ECO bug 5584556: End

Line 3530: l_ip_category_name ICX_CAT_CATEGORIES_V.category_name%TYPE;

3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;
3529:
3530: l_ip_category_name ICX_CAT_CATEGORIES_V.category_name%TYPE;
3531: l_ip_catgeory_found VARCHAR2(1);
3532: BEGIN
3533: l_progress := '010';
3534: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;