APPS.AS_CATALOG_MIGRATION dependencies on EGO_PRODUCT_CAT_SET_EXT

Line 773: from EGO_PRODUCT_CAT_SET_EXT

769: and category_set_id = c_category_set_id;
770:
771: CURSOR C_EXISTS_EXTN_ID(c_category_set_id Number, c_category_id Number) IS
772: select 1
773: from EGO_PRODUCT_CAT_SET_EXT
774: where category_set_id = c_category_set_id
775: and category_id = c_category_id;
776:
777:

Line 930: INSERT INTO EGO_PRODUCT_CAT_SET_EXT ( EXTENSION_ID, CATEGORY_SET_ID, CATEGORY_ID, ATTR_GROUP_ID,

926: FETCH C_EXISTS_EXTN_ID into l_val;
927: IF C_EXISTS_EXTN_ID%NOTFOUND
928: THEN
929: -- do the insert here
930: INSERT INTO EGO_PRODUCT_CAT_SET_EXT ( EXTENSION_ID, CATEGORY_SET_ID, CATEGORY_ID, ATTR_GROUP_ID,
931: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
932: INCLUDE_IN_FORECAST, EXPECTED_PURCHASE, EXCLUDE_USER_VIEW )
933: VALUES (EGO_EXTFWK_S.NEXTVAL, p_category_set_id, l_out_category_id, p_attr_group_id, -1, sysdate, -1, sysdate, -1, 'Y', p_expected_purchase, l_exclude_user_view);
934: ELSE

Line 935: UPDATE EGO_PRODUCT_CAT_SET_EXT

931: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
932: INCLUDE_IN_FORECAST, EXPECTED_PURCHASE, EXCLUDE_USER_VIEW )
933: VALUES (EGO_EXTFWK_S.NEXTVAL, p_category_set_id, l_out_category_id, p_attr_group_id, -1, sysdate, -1, sysdate, -1, 'Y', p_expected_purchase, l_exclude_user_view);
934: ELSE
935: UPDATE EGO_PRODUCT_CAT_SET_EXT
936: SET EXPECTED_PURCHASE = p_expected_purchase,
937: EXCLUDE_USER_VIEW = l_exclude_user_view
938: WHERE CATEGORY_SET_ID = p_category_set_id
939: AND CATEGORY_ID = l_out_category_id;

Line 1041: INSERT INTO EGO_PRODUCT_CAT_SET_EXT ( EXTENSION_ID, CATEGORY_SET_ID, CATEGORY_ID, ATTR_GROUP_ID,

1037: FETCH C_EXISTS_EXTN_ID into l_val;
1038: IF C_EXISTS_EXTN_ID%NOTFOUND
1039: THEN
1040: -- do the insert here
1041: INSERT INTO EGO_PRODUCT_CAT_SET_EXT ( EXTENSION_ID, CATEGORY_SET_ID, CATEGORY_ID, ATTR_GROUP_ID,
1042: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
1043: INCLUDE_IN_FORECAST, EXPECTED_PURCHASE, EXCLUDE_USER_VIEW )
1044: VALUES ( EGO_EXTFWK_S.NEXTVAL, p_category_set_id, l_out_legacy_category_id, p_attr_group_id, -1, sysdate, -1, sysdate, -1, 'Y', p_expected_purchase, l_exclude_user_view);
1045: ELSE

Line 1046: UPDATE EGO_PRODUCT_CAT_SET_EXT

1042: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
1043: INCLUDE_IN_FORECAST, EXPECTED_PURCHASE, EXCLUDE_USER_VIEW )
1044: VALUES ( EGO_EXTFWK_S.NEXTVAL, p_category_set_id, l_out_legacy_category_id, p_attr_group_id, -1, sysdate, -1, sysdate, -1, 'Y', p_expected_purchase, l_exclude_user_view);
1045: ELSE
1046: UPDATE EGO_PRODUCT_CAT_SET_EXT
1047: SET EXPECTED_PURCHASE = p_expected_purchase,
1048: EXCLUDE_USER_VIEW = l_exclude_user_view
1049: WHERE CATEGORY_SET_ID = p_category_set_id
1050: AND CATEGORY_ID = l_out_legacy_category_id;

Line 1370: delete from ego_product_cat_set_ext

1366: update mtl_item_categories
1367: set category_id=p_category_id
1368: where category_id=scr.category_id
1369: and category_set_id=p_category_set_id;
1370: delete from ego_product_cat_set_ext
1371: where category_id=scr.category_id and category_set_id=p_category_set_id;
1372: delete from mtl_category_set_valid_cats
1373: where category_id=scr.category_id and category_set_id=p_category_set_id;
1374: delete from mtl_categories_b where category_id=scr.category_id;

Line 1391: delete from EGO_PRODUCT_CAT_SET_EXT where category_set_id in

1387: delete from mtl_category_set_valid_cats where category_set_id in
1388: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1389: delete from mtl_item_categories where category_set_id in
1390: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1391: delete from EGO_PRODUCT_CAT_SET_EXT where category_set_id in
1392: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1393: commit;
1394: */
1395: