DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on EGO_GTIN_PVT

Line 1103: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES

1099: l_process_flag := 7;
1100: IF ( l_gpc_catalog_id = l_category_set_id) THEN
1101: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates
1102: BEGIN
1103: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1104: (p_inventory_item_id => l_inventory_item_id,
1105: p_organization_id => l_organization_id,
1106: p_update_reg => 'Y',
1107: p_commit => FND_API.G_FALSE,

Line 1215: EXECUTE IMMEDIATE 'BEGIN EGO_GTIN_PVT.PROCESS_CAT_ASSIGNMENT( :1, :2); END;' USING l_inventory_item_id, l_organization_id;

1211: IF ( l_udex_catalog_id = l_category_set_id
1212: OR l_gpc_catalog_id = l_category_set_id) THEN
1213: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates
1214: /*BEGIN
1215: EXECUTE IMMEDIATE 'BEGIN EGO_GTIN_PVT.PROCESS_CAT_ASSIGNMENT( :1, :2); END;' USING l_inventory_item_id, l_organization_id;
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: NULL;
1219: END;*/

Line 1222: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES

1218: NULL;
1219: END;*/
1220: /* Bug 5517473 - Submit for Re-Registration of GDSN attrs when GDSN/GPC category set updated */
1221: BEGIN
1222: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1223: (p_inventory_item_id => l_inventory_item_id,
1224: p_organization_id => l_organization_id,
1225: p_update_reg => 'Y',
1226: p_commit => FND_API.G_FALSE,