APPS.EGO_CATG_MAP_PKG dependencies on MTL_CATEGORY_SETS

Line 240: FROM MTL_CATEGORY_SETS

236: BEGIN
237: -- getting the source catg set id by passing the source category_set_name
238: SELECT CATEGORY_SET_ID SOURCE_CATG_SET_ID
239: INTO l_source_catg_set_id
240: FROM MTL_CATEGORY_SETS
241: WHERE CATEGORY_SET_NAME = X_SOURCE_CATG_SET_NAME;
242:
243: EXCEPTION
244: WHEN no_data_found THEN

Line 255: FROM MTL_CATEGORY_SETS

251: BEGIN
252: -- getting the target catg set id by passing the target category_set_name
253: SELECT CATEGORY_SET_ID TARGET_CATG_SET_ID
254: INTO l_target_catg_set_id
255: FROM MTL_CATEGORY_SETS
256: WHERE CATEGORY_SET_NAME = X_TARGET_CATG_SET_NAME;
257:
258: EXCEPTION
259: WHEN no_data_found THEN

Line 393: FROM MTL_CATEGORY_SETS B

389:
390: -- getting the source catg set id by passing the source category_set_name
391: SELECT B.CATEGORY_SET_ID SOURCE_CATG_SET_ID
392: INTO l_source_catg_set_id
393: FROM MTL_CATEGORY_SETS B
394: WHERE B.CATEGORY_SET_NAME = X_SOURCE_CATG_SET_NAME;
395:
396: -- getting the target catg set id by passing the target category_set_name
397: SELECT CATEGORY_SET_ID TARGET_CATG_SET_ID

Line 399: FROM MTL_CATEGORY_SETS

395:
396: -- getting the target catg set id by passing the target category_set_name
397: SELECT CATEGORY_SET_ID TARGET_CATG_SET_ID
398: INTO l_target_catg_set_id
399: FROM MTL_CATEGORY_SETS
400: WHERE CATEGORY_SET_NAME = X_TARGET_CATG_SET_NAME;
401:
402: -- getting the source category id by passing the source category_name
403: BEGIN

Line 407: MTL_CATEGORY_SETS B

403: BEGIN
404: SELECT A.CATEGORY_ID SOURCE_CATG_ID
405: INTO l_source_catg_id
406: FROM MTL_CATEGORIES_B_KFV A,
407: MTL_CATEGORY_SETS B
408: WHERE B.CATEGORY_SET_ID = l_source_catg_set_id
409: AND A.STRUCTURE_ID = B.STRUCTURE_ID
410: AND A.CONCATENATED_SEGMENTS = X_SOURCE_CATG_NAME;
411: EXCEPTION

Line 425: MTL_CATEGORY_SETS B

421:
422: SELECT A.CATEGORY_ID TARGET_CATG_ID
423: INTO l_target_catg_id
424: FROM MTL_CATEGORIES_B_KFV A,
425: MTL_CATEGORY_SETS B
426: WHERE B.CATEGORY_SET_ID = l_target_catg_set_id
427: AND A.STRUCTURE_ID = B.STRUCTURE_ID
428: AND A.CONCATENATED_SEGMENTS = X_TARGET_CATG_NAME;
429: EXCEPTION