APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on MTL_CATEGORIES_TL

Line 799: l_prev_category_name mtl_categories_tl.description%TYPE := '-1';

795: l_category_status PLS_INTEGER;
796: l_rt_category_id NUMBER;
797: l_prev_category_key NUMBER := -1;
798: l_prev_rt_category_id NUMBER := -1;
799: l_prev_category_name mtl_categories_tl.description%TYPE := '-1';
800: l_index PLS_INTEGER;
801: l_category_name_is_valid BOOLEAN := FALSE;
802:
803: ----- Start of declaring columns selected in the cursor -----

Line 1057: mtl_categories_tl mctl,

1053: icat.rt_category_id rt_category_id, icat2.category_name old_category_name,
1054: nvl(mck.end_date_active, SYSDATE+1), nvl(mck.disable_date, SYSDATE+1),
1055: SYSDATE system_date
1056: FROM mtl_categories_kfv mck,
1057: mtl_categories_tl mctl,
1058: icx_cat_categories_tl icat,
1059: icx_cat_categories_tl icat2
1060: WHERE mck.category_id = P_CATEGORY_ID
1061: AND mck.structure_id = ICX_CAT_UTIL_PVT.g_structure_id

Line 1117: mtl_categories_tl mctl,

1113: icat.rt_category_id rt_category_id, icat2.category_name old_category_name,
1114: nvl(mck.end_date_active, SYSDATE+1), nvl(mck.disable_date, SYSDATE+1),
1115: SYSDATE system_date
1116: FROM mtl_categories_kfv mck,
1117: mtl_categories_tl mctl,
1118: mtl_category_set_valid_cats mcsvc,
1119: icx_cat_categories_tl icat,
1120: icx_cat_categories_tl icat2
1121: WHERE mck.category_id = P_CATEGORY_ID