APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORY_SETS_S

Line 206: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

202: END;
203:
204: IF l_category_set_id IS NULL THEN
205:
206: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
207: -- Assuming Master Organization Control level
208: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
209:
210: MTL_CATEGORY_SETS_PKG.INSERT_ROW (

Line 407: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

403: WHERE category_set_id = 1100000209;
404: IF l_count = 0 THEN
405: l_next_val := 1100000209;
406: ELSE
407: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
408: END IF;
409: ELSIF p_category_set_name = 'INTENDED_USE' THEN
410: -- check if set id 1100000211 is not used
411: SELECT count(*)

Line 418: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

414: WHERE category_set_id = 1100000211;
415: IF l_count = 0 THEN
416: l_next_val := 1100000211;
417: ELSE
418: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
419: END IF;
420: ELSE
421: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
422: END IF;

Line 421: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

417: ELSE
418: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
419: END IF;
420: ELSE
421: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
422: END IF;
423:
424: -- Assuming Master Organization Control level
425: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control