DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_CATG_PVT dependencies on ICX_CAT_POPULATE_STATUS_PVT

Line 858: l_category_status := ICX_CAT_POPULATE_STATUS_PVT.getCategoryStatus

854:
855: FOR i in 1..l_mtl_category_id_tbl.COUNT LOOP
856: l_err_loc := 800;
857: -- First get the status of the current Category line
858: l_category_status := ICX_CAT_POPULATE_STATUS_PVT.getCategoryStatus
859: (l_end_date_active_tbl(i), l_disable_date_tbl(i), l_system_date_tbl(i));
860:
861: l_err_loc := 900;
862: IF (l_category_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE) THEN

Line 862: IF (l_category_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE) THEN

858: l_category_status := ICX_CAT_POPULATE_STATUS_PVT.getCategoryStatus
859: (l_end_date_active_tbl(i), l_disable_date_tbl(i), l_system_date_tbl(i));
860:
861: l_err_loc := 900;
862: IF (l_category_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE) THEN
863: l_err_loc := 1000;
864: -- Check for the category name uniqueness in ip
865: IF (l_prev_category_key <> l_mtl_category_id_tbl(i) OR
866: l_prev_category_name <> l_mtl_category_name_tbl(i))

Line 990: END IF; -- IF (l_category_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE) THEN

986: gTotalRowCount := gTotalRowCount + 1;
987: l_index := gDelPoCategoryIdTbl.COUNT + 1;
988: gDelPoCategoryIdTbl(l_index) := l_mtl_category_id_tbl(i);
989: END IF;
990: END IF; -- IF (l_category_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE) THEN
991:
992: l_err_loc := 1500;
993: l_prev_category_key := l_mtl_category_id_tbl(i);
994: l_prev_rt_category_id := l_rt_category_id;